API CreateCustomer: Porovnání verzí
Skočit na navigaci
Skočit na vyhledávání
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…“ |
Bez shrnutí editace |
||
| Řádek 15: | Řádek 15: | ||
!Description | !Description | ||
!Relation | !Relation | ||
|- | |- | ||
|ShortName | |ShortName | ||
|nvarchar(30) | |nvarchar(30) | ||
| | |||
|Short name | |Short name | ||
| | | | ||
| Řádek 28: | Řádek 24: | ||
|CompanyName | |CompanyName | ||
|nvarchar(250) | |nvarchar(250) | ||
| | |||
|Company name | |Company name | ||
| | | | ||
| Řádek 33: | Řádek 30: | ||
|CompanyRegistrationNumber | |CompanyRegistrationNumber | ||
|nvarchar(20) | |nvarchar(20) | ||
| | |||
|Company registration number | |Company registration number | ||
| | | | ||
| Řádek 38: | Řádek 36: | ||
|VATNumber | |VATNumber | ||
|nvarchar(20) | |nvarchar(20) | ||
| | |||
|VAT number | |VAT number | ||
| | | | ||
| Řádek 43: | Řádek 42: | ||
|VATNumber2 | |VATNumber2 | ||
|nvarchar(15) | |nvarchar(15) | ||
| | |||
|VAT number 2 | |VAT number 2 | ||
| | | | ||
| Řádek 48: | Řádek 48: | ||
|VATPayer | |VATPayer | ||
|int | |int | ||
| | |||
|VATPayer | |VATPayer | ||
| | | | ||
| Řádek 53: | Řádek 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 | ||
| Řádek 58: | Řádek 60: | ||
|Username | |Username | ||
|nvarchar(255) | |nvarchar(255) | ||
| | |||
|Username | |Username | ||
| | | | ||
| Řádek 63: | Řádek 66: | ||
|Password | |Password | ||
|nvarchar(25) | |nvarchar(25) | ||
| | |||
|Password | |Password | ||
| | | | ||
| Řádek 68: | Řádek 72: | ||
|OrderConfirmationPassword | |OrderConfirmationPassword | ||
|nvarchar(25) | |nvarchar(25) | ||
| | |||
|Order confirmation password | |Order confirmation password | ||
| | | | ||
| Řádek 73: | Řádek 78: | ||
|Street | |Street | ||
|nvarchar(100) | |nvarchar(100) | ||
| | |||
|Street | |Street | ||
| | | | ||
| Řádek 78: | Řádek 84: | ||
|City | |City | ||
|nvarchar(80) | |nvarchar(80) | ||
| | |||
|City | |City | ||
| | | | ||
| Řádek 83: | Řádek 90: | ||
|ZIPCode | |ZIPCode | ||
|nvarchar(15) | |nvarchar(15) | ||
| | |||
|ZIP code | |ZIP code | ||
| | | | ||
| Řádek 88: | Řádek 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 | ||
| Řádek 93: | Řádek 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 | ||
| Řádek 98: | Řádek 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 | ||
| Řádek 103: | Řádek 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 | ||
| Řádek 108: | Řádek 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 | ||
| Řádek 113: | Řádek 126: | ||
|SendOrderConfirmationEmail | |SendOrderConfirmationEmail | ||
|int | |int | ||
| | |||
|Send order confirmation email | |Send order confirmation email | ||
| | | | ||
| Řádek 118: | Řádek 132: | ||
|OrderConfirmationEmail | |OrderConfirmationEmail | ||
|nvarchar(100) | |nvarchar(100) | ||
| | |||
|Order confirmation email | |Order confirmation email | ||
| | | | ||
| Řádek 123: | Řádek 138: | ||
|Email | |Email | ||
|nvarchar(100) | |nvarchar(100) | ||
| | |||
|Email | |Email | ||
| | | | ||
| Řádek 128: | Řádek 144: | ||
|EshopEmails | |EshopEmails | ||
|nvarchar(400) | |nvarchar(400) | ||
| | |||
|Eshop emails | |Eshop emails | ||
| | | | ||
| Řádek 133: | Řádek 150: | ||
|IsBuyer | |IsBuyer | ||
|int | |int | ||
| | |||
|Is buyer | |Is buyer | ||
| | | | ||
| Řádek 138: | Řádek 156: | ||
|IsSupplier | |IsSupplier | ||
|int | |int | ||
| | |||
|Is supplier | |Is supplier | ||
| | | | ||
| Řádek 143: | Řádek 162: | ||
|Region | |Region | ||
|nvarchar(30) | |nvarchar(30) | ||
| | |||
|Region | |Region | ||
| | | | ||
| Řádek 148: | Řádek 168: | ||
|Country | |Country | ||
|nvarchar(50) | |nvarchar(50) | ||
| | |||
|Country | |Country | ||
| | | | ||
| Řádek 153: | Řádek 174: | ||
|IsCompetition | |IsCompetition | ||
|int | |int | ||
| | |||
|Is competition | |Is competition | ||
| | | | ||
| Řádek 158: | Řádek 180: | ||
|FileMarkText | |FileMarkText | ||
|nvarchar(200) | |nvarchar(200) | ||
| | |||
|File mark text | |File mark text | ||
| | | | ||
| Řádek 163: | Řádek 186: | ||
|IsWSInvoicesExportAllowed | |IsWSInvoicesExportAllowed | ||
|bit | |bit | ||
| | |||
|Is WS invoices export allowed | |Is WS invoices export allowed | ||
| | | | ||
| Řádek 168: | Řádek 192: | ||
|IsWSDeliveryNotesExportAllowed | |IsWSDeliveryNotesExportAllowed | ||
|bit | |bit | ||
| | |||
|Is WS delivery notes export Allowed | |Is WS delivery notes export Allowed | ||
| | | | ||
| Řádek 173: | Řádek 198: | ||
|IsWSImportOrdersAllowed | |IsWSImportOrdersAllowed | ||
|bit | |bit | ||
| | |||
|Is WS import orders Allowed | |Is WS import orders Allowed | ||
| | | | ||
| Řádek 178: | Řádek 204: | ||
|StoreBackOrder | |StoreBackOrder | ||
|int | |int | ||
| | |||
|Store backorder | |Store backorder | ||
| | | | ||
| Řádek 183: | Řádek 210: | ||
|IsSupplierIndividualOrders | |IsSupplierIndividualOrders | ||
|int | |int | ||
| | |||
|Is supplier individual orders | |Is supplier individual orders | ||
| | | | ||
| Řádek 188: | Řádek 216: | ||
|IsSupplierShortcut | |IsSupplierShortcut | ||
|nvarchar(10) | |nvarchar(10) | ||
| | |||
|Is supplier shortcut | |Is supplier shortcut | ||
| | | | ||
| Řádek 193: | Řádek 222: | ||
|Note | |Note | ||
|nvarchar(500) | |nvarchar(500) | ||
| | |||
|Note | |Note | ||
| | | | ||
| Řádek 198: | Řádek 228: | ||
|Note2 | |Note2 | ||
|nvarchar(500) | |nvarchar(500) | ||
| | |||
|Note 2 | |Note 2 | ||
| | | | ||
| Řádek 203: | Řádek 234: | ||
|GlobalPricing | |GlobalPricing | ||
|int | |int | ||
| | |||
|Global pricing | |Global pricing | ||
| | | | ||
| Řádek 208: | Řádek 240: | ||
|OrderGroup | |OrderGroup | ||
|nvarchar(10) | |nvarchar(10) | ||
| | |||
|Order group | |Order group | ||
| | | | ||
| Řádek 213: | Řádek 246: | ||
|GPSLatitude | |GPSLatitude | ||
|nvarchar(20) | |nvarchar(20) | ||
| | |||
|GPS latitude | |GPS latitude | ||
| | | | ||
| Řádek 218: | Řádek 252: | ||
|GPSLongitude | |GPSLongitude | ||
|nvarchar(20) | |nvarchar(20) | ||
| | |||
|GPS longitude | |GPS longitude | ||
| | | | ||
| Řádek 223: | Řádek 258: | ||
|ParentID | |ParentID | ||
|int | |int | ||
| | |||
|ParentID | |ParentID | ||
| | | | ||
Verze z 3. 8. 2017, 07: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.