API CreateCustomer: Porovnání verzí
Z Podpora.nextis.cz
(Založena nová stránka s textem „==== Description ==== Method allows You to create new customer in system. ==== Exact name ==== <code>API_CreateCustomer</code> ==== Type ==== Standard ex…“) |
|||
| Řádka 15: | Řádka 15: | ||
!Description | !Description | ||
!Relation | !Relation | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
|- | |- | ||
|ShortName | |ShortName | ||
|nvarchar(30) | |nvarchar(30) | ||
| + | | | ||
|Short name | |Short name | ||
| | | | ||
| Řádka 28: | Řádka 24: | ||
|CompanyName | |CompanyName | ||
|nvarchar(250) | |nvarchar(250) | ||
| + | | | ||
|Company name | |Company name | ||
| | | | ||
| Řádka 33: | Řádka 30: | ||
|CompanyRegistrationNumber | |CompanyRegistrationNumber | ||
|nvarchar(20) | |nvarchar(20) | ||
| + | | | ||
|Company registration number | |Company registration number | ||
| | | | ||
| Řádka 38: | Řádka 36: | ||
|VATNumber | |VATNumber | ||
|nvarchar(20) | |nvarchar(20) | ||
| + | | | ||
|VAT number | |VAT number | ||
| | | | ||
| Řádka 43: | Řádka 42: | ||
|VATNumber2 | |VATNumber2 | ||
|nvarchar(15) | |nvarchar(15) | ||
| + | | | ||
|VAT number 2 | |VAT number 2 | ||
| | | | ||
| Řádka 48: | Řádka 48: | ||
|VATPayer | |VATPayer | ||
|int | |int | ||
| + | | | ||
|VATPayer | |VATPayer | ||
| | | | ||
| Řádka 53: | Řádka 54: | ||
|TransportID | |TransportID | ||
|int | |int | ||
| + | | | ||
|ID of transport from transport list (see relation) | |ID of transport from transport list (see relation) | ||
|API_GetTransports.ID | |API_GetTransports.ID | ||
| Řádka 58: | Řádka 60: | ||
|Username | |Username | ||
|nvarchar(255) | |nvarchar(255) | ||
| + | | | ||
|Username | |Username | ||
| | | | ||
| Řádka 63: | Řádka 66: | ||
|Password | |Password | ||
|nvarchar(25) | |nvarchar(25) | ||
| + | | | ||
|Password | |Password | ||
| | | | ||
| Řádka 68: | Řádka 72: | ||
|OrderConfirmationPassword | |OrderConfirmationPassword | ||
|nvarchar(25) | |nvarchar(25) | ||
| + | | | ||
|Order confirmation password | |Order confirmation password | ||
| | | | ||
| Řádka 73: | Řádka 78: | ||
|Street | |Street | ||
|nvarchar(100) | |nvarchar(100) | ||
| + | | | ||
|Street | |Street | ||
| | | | ||
| Řádka 78: | Řádka 84: | ||
|City | |City | ||
|nvarchar(80) | |nvarchar(80) | ||
| + | | | ||
|City | |City | ||
| | | | ||
| Řádka 83: | Řádka 90: | ||
|ZIPCode | |ZIPCode | ||
|nvarchar(15) | |nvarchar(15) | ||
| + | | | ||
|ZIP code | |ZIP code | ||
| | | | ||
| Řádka 88: | Řádka 96: | ||
|State | |State | ||
|int | |int | ||
| + | | | ||
|ID of country from country list (see relation) | |ID of country from country list (see relation) | ||
|API_GetCountry.ID | |API_GetCountry.ID | ||
| Řádka 93: | Řádka 102: | ||
|BranchID | |BranchID | ||
|int | |int | ||
| + | | | ||
|ID of branche from branch list (see relation) | |ID of branche from branch list (see relation) | ||
|API_GetBranches.ID | |API_GetBranches.ID | ||
| Řádka 98: | Řádka 108: | ||
|WorkshopID | |WorkshopID | ||
|int | |int | ||
| + | | | ||
|ID of workshop from workshop list (see relation) | |ID of workshop from workshop list (see relation) | ||
|API_GetWorkshops.ID | |API_GetWorkshops.ID | ||
| Řádka 103: | Řádka 114: | ||
|StockID | |StockID | ||
|int | |int | ||
| + | | | ||
|ID of stock from stock list (see relation) | |ID of stock from stock list (see relation) | ||
|API_GetStocks.ID | |API_GetStocks.ID | ||
| Řádka 108: | Řádka 120: | ||
|CurrencyID | |CurrencyID | ||
|int | |int | ||
| + | | | ||
|ID of currency from currency list (see relation) | |ID of currency from currency list (see relation) | ||
|API_GetCurrency.ID | |API_GetCurrency.ID | ||
| Řádka 113: | Řádka 126: | ||
|SendOrderConfirmationEmail | |SendOrderConfirmationEmail | ||
|int | |int | ||
| + | | | ||
|Send order confirmation email | |Send order confirmation email | ||
| | | | ||
| Řádka 118: | Řádka 132: | ||
|OrderConfirmationEmail | |OrderConfirmationEmail | ||
|nvarchar(100) | |nvarchar(100) | ||
| + | | | ||
|Order confirmation email | |Order confirmation email | ||
| | | | ||
| Řádka 123: | Řádka 138: | ||
|Email | |Email | ||
|nvarchar(100) | |nvarchar(100) | ||
| + | | | ||
|Email | |Email | ||
| | | | ||
| Řádka 128: | Řádka 144: | ||
|EshopEmails | |EshopEmails | ||
|nvarchar(400) | |nvarchar(400) | ||
| + | | | ||
|Eshop emails | |Eshop emails | ||
| | | | ||
| Řádka 133: | Řádka 150: | ||
|IsBuyer | |IsBuyer | ||
|int | |int | ||
| + | | | ||
|Is buyer | |Is buyer | ||
| | | | ||
| Řádka 138: | Řádka 156: | ||
|IsSupplier | |IsSupplier | ||
|int | |int | ||
| + | | | ||
|Is supplier | |Is supplier | ||
| | | | ||
| Řádka 143: | Řádka 162: | ||
|Region | |Region | ||
|nvarchar(30) | |nvarchar(30) | ||
| + | | | ||
|Region | |Region | ||
| | | | ||
| Řádka 148: | Řádka 168: | ||
|Country | |Country | ||
|nvarchar(50) | |nvarchar(50) | ||
| + | | | ||
|Country | |Country | ||
| | | | ||
| Řádka 153: | Řádka 174: | ||
|IsCompetition | |IsCompetition | ||
|int | |int | ||
| + | | | ||
|Is competition | |Is competition | ||
| | | | ||
| Řádka 158: | Řádka 180: | ||
|FileMarkText | |FileMarkText | ||
|nvarchar(200) | |nvarchar(200) | ||
| + | | | ||
|File mark text | |File mark text | ||
| | | | ||
| Řádka 163: | Řádka 186: | ||
|IsWSInvoicesExportAllowed | |IsWSInvoicesExportAllowed | ||
|bit | |bit | ||
| + | | | ||
|Is WS invoices export allowed | |Is WS invoices export allowed | ||
| | | | ||
| Řádka 168: | Řádka 192: | ||
|IsWSDeliveryNotesExportAllowed | |IsWSDeliveryNotesExportAllowed | ||
|bit | |bit | ||
| + | | | ||
|Is WS delivery notes export Allowed | |Is WS delivery notes export Allowed | ||
| | | | ||
| Řádka 173: | Řádka 198: | ||
|IsWSImportOrdersAllowed | |IsWSImportOrdersAllowed | ||
|bit | |bit | ||
| + | | | ||
|Is WS import orders Allowed | |Is WS import orders Allowed | ||
| | | | ||
| Řádka 178: | Řádka 204: | ||
|StoreBackOrder | |StoreBackOrder | ||
|int | |int | ||
| + | | | ||
|Store backorder | |Store backorder | ||
| | | | ||
| Řádka 183: | Řádka 210: | ||
|IsSupplierIndividualOrders | |IsSupplierIndividualOrders | ||
|int | |int | ||
| + | | | ||
|Is supplier individual orders | |Is supplier individual orders | ||
| | | | ||
| Řádka 188: | Řádka 216: | ||
|IsSupplierShortcut | |IsSupplierShortcut | ||
|nvarchar(10) | |nvarchar(10) | ||
| + | | | ||
|Is supplier shortcut | |Is supplier shortcut | ||
| | | | ||
| Řádka 193: | Řádka 222: | ||
|Note | |Note | ||
|nvarchar(500) | |nvarchar(500) | ||
| + | | | ||
|Note | |Note | ||
| | | | ||
| Řádka 198: | Řádka 228: | ||
|Note2 | |Note2 | ||
|nvarchar(500) | |nvarchar(500) | ||
| + | | | ||
|Note 2 | |Note 2 | ||
| | | | ||
| Řádka 203: | Řádka 234: | ||
|GlobalPricing | |GlobalPricing | ||
|int | |int | ||
| + | | | ||
|Global pricing | |Global pricing | ||
| | | | ||
| Řádka 208: | Řádka 240: | ||
|OrderGroup | |OrderGroup | ||
|nvarchar(10) | |nvarchar(10) | ||
| + | | | ||
|Order group | |Order group | ||
| | | | ||
| Řádka 213: | Řádka 246: | ||
|GPSLatitude | |GPSLatitude | ||
|nvarchar(20) | |nvarchar(20) | ||
| + | | | ||
|GPS latitude | |GPS latitude | ||
| | | | ||
| Řádka 218: | Řádka 252: | ||
|GPSLongitude | |GPSLongitude | ||
|nvarchar(20) | |nvarchar(20) | ||
| + | | | ||
|GPS longitude | |GPS longitude | ||
| | | | ||
| Řádka 223: | Řádka 258: | ||
|ParentID | |ParentID | ||
|int | |int | ||
| + | | | ||
|ParentID | |ParentID | ||
| | | | ||
Verze z 3. 8. 2017, 08:22
Description
Method allows You to create new customer in system.
Exact name
API_CreateCustomer
Type
Standard executable stored procedure.
Specification
| Parameter | Data type | Value range | Description | Relation |
|---|---|---|---|---|
| ShortName | nvarchar(30) | Short name | ||
| CompanyName | nvarchar(250) | Company name | ||
| CompanyRegistrationNumber | nvarchar(20) | Company registration number | ||
| VATNumber | nvarchar(20) | VAT number | ||
| VATNumber2 | nvarchar(15) | VAT number 2 | ||
| VATPayer | int | VATPayer | ||
| TransportID | int | ID of transport from transport list (see relation) | API_GetTransports.ID | |
| Username | nvarchar(255) | Username | ||
| Password | nvarchar(25) | Password | ||
| OrderConfirmationPassword | nvarchar(25) | Order confirmation password | ||
| Street | nvarchar(100) | Street | ||
| City | nvarchar(80) | City | ||
| ZIPCode | nvarchar(15) | ZIP code | ||
| State | int | ID of country from country list (see relation) | API_GetCountry.ID | |
| BranchID | int | ID of branche from branch list (see relation) | API_GetBranches.ID | |
| WorkshopID | int | ID of workshop from workshop list (see relation) | API_GetWorkshops.ID | |
| StockID | int | ID of stock from stock list (see relation) | API_GetStocks.ID | |
| CurrencyID | int | ID of currency from currency list (see relation) | API_GetCurrency.ID | |
| SendOrderConfirmationEmail | int | Send order confirmation email | ||
| OrderConfirmationEmail | nvarchar(100) | Order confirmation email | ||
| nvarchar(100) | ||||
| EshopEmails | nvarchar(400) | Eshop emails | ||
| IsBuyer | int | Is buyer | ||
| IsSupplier | int | Is supplier | ||
| Region | nvarchar(30) | Region | ||
| Country | nvarchar(50) | Country | ||
| IsCompetition | int | Is competition | ||
| FileMarkText | nvarchar(200) | File mark text | ||
| IsWSInvoicesExportAllowed | bit | Is WS invoices export allowed | ||
| IsWSDeliveryNotesExportAllowed | bit | Is WS delivery notes export Allowed | ||
| IsWSImportOrdersAllowed | bit | Is WS import orders Allowed | ||
| StoreBackOrder | int | Store backorder | ||
| IsSupplierIndividualOrders | int | Is supplier individual orders | ||
| IsSupplierShortcut | nvarchar(10) | Is supplier shortcut | ||
| Note | nvarchar(500) | Note | ||
| Note2 | nvarchar(500) | Note 2 | ||
| GlobalPricing | int | Global pricing | ||
| OrderGroup | nvarchar(10) | Order group | ||
| GPSLatitude | nvarchar(20) | GPS latitude | ||
| GPSLongitude | nvarchar(20) | GPS longitude | ||
| ParentID | int | ParentID |
Example
EXEC [API_CreateCustomer] @WorkshopID = 1 ,@Name = 'Name'
Notices
None.
