API CreateCustomer: Porovnání verzí
Skočit na navigaci
Skočit na vyhledávání
Bez shrnutí editace |
Bez shrnutí editace |
||
| Řádek 16: | Řádek 16: | ||
!Relation | !Relation | ||
|- | |- | ||
|ShortName | |@ShortName | ||
|nvarchar(30) | |nvarchar(30) | ||
| | | | ||
| Řádek 22: | Řádek 22: | ||
| | | | ||
|- | |- | ||
|CompanyName | |@CompanyName | ||
|nvarchar(250) | |nvarchar(250) | ||
| | | | ||
| Řádek 28: | Řádek 28: | ||
| | | | ||
|- | |- | ||
|CompanyRegistrationNumber | |@CompanyRegistrationNumber | ||
|nvarchar(20) | |nvarchar(20) | ||
| | | | ||
| Řádek 34: | Řádek 34: | ||
| | | | ||
|- | |- | ||
|VATNumber | |@VATNumber | ||
|nvarchar(20) | |nvarchar(20) | ||
| | | | ||
| Řádek 40: | Řádek 40: | ||
| | | | ||
|- | |- | ||
|VATNumber2 | |@VATNumber2 | ||
|nvarchar(15) | |nvarchar(15) | ||
| | | | ||
| Řádek 46: | Řádek 46: | ||
| | | | ||
|- | |- | ||
|VATPayer | |@VATPayer | ||
|int | |int | ||
| | | | ||
| Řádek 52: | Řádek 52: | ||
| | | | ||
|- | |- | ||
|TransportID | |@TransportID | ||
|int | |int | ||
| | | | ||
| Řádek 58: | Řádek 58: | ||
|API_GetTransports.ID | |API_GetTransports.ID | ||
|- | |- | ||
|Username | |@Username | ||
|nvarchar(255) | |nvarchar(255) | ||
| | | | ||
| Řádek 64: | Řádek 64: | ||
| | | | ||
|- | |- | ||
|Password | |@Password | ||
|nvarchar(25) | |nvarchar(25) | ||
| | | | ||
| Řádek 70: | Řádek 70: | ||
| | | | ||
|- | |- | ||
|OrderConfirmationPassword | |@OrderConfirmationPassword | ||
|nvarchar(25) | |nvarchar(25) | ||
| | | | ||
| Řádek 76: | Řádek 76: | ||
| | | | ||
|- | |- | ||
|Street | |@Street | ||
|nvarchar(100) | |nvarchar(100) | ||
| | | | ||
| Řádek 82: | Řádek 82: | ||
| | | | ||
|- | |- | ||
|City | |@City | ||
|nvarchar(80) | |nvarchar(80) | ||
| | | | ||
| Řádek 88: | Řádek 88: | ||
| | | | ||
|- | |- | ||
|ZIPCode | |@ZIPCode | ||
|nvarchar(15) | |nvarchar(15) | ||
| | | | ||
| Řádek 94: | Řádek 94: | ||
| | | | ||
|- | |- | ||
|State | |@State | ||
|int | |int | ||
| | | | ||
| Řádek 100: | Řádek 100: | ||
|API_GetCountry.ID | |API_GetCountry.ID | ||
|- | |- | ||
|BranchID | |@BranchID | ||
|int | |int | ||
| | | | ||
| Řádek 106: | Řádek 106: | ||
|API_GetBranches.ID | |API_GetBranches.ID | ||
|- | |- | ||
|WorkshopID | |@WorkshopID | ||
|int | |int | ||
| | | | ||
| Řádek 112: | Řádek 112: | ||
|API_GetWorkshops.ID | |API_GetWorkshops.ID | ||
|- | |- | ||
|StockID | |@StockID | ||
|int | |int | ||
| | | | ||
| Řádek 118: | Řádek 118: | ||
|API_GetStocks.ID | |API_GetStocks.ID | ||
|- | |- | ||
|CurrencyID | |@CurrencyID | ||
|int | |int | ||
| | | | ||
| Řádek 124: | Řádek 124: | ||
|API_GetCurrency.ID | |API_GetCurrency.ID | ||
|- | |- | ||
|SendOrderConfirmationEmail | |@SendOrderConfirmationEmail | ||
|int | |int | ||
| | | | ||
| Řádek 130: | Řádek 130: | ||
| | | | ||
|- | |- | ||
|OrderConfirmationEmail | |@OrderConfirmationEmail | ||
|nvarchar(100) | |nvarchar(100) | ||
| | | | ||
| Řádek 136: | Řádek 136: | ||
| | | | ||
|- | |- | ||
|Email | |@Email | ||
|nvarchar(100) | |nvarchar(100) | ||
| | | | ||
| Řádek 142: | Řádek 142: | ||
| | | | ||
|- | |- | ||
|EshopEmails | |@EshopEmails | ||
|nvarchar(400) | |nvarchar(400) | ||
| | | | ||
| Řádek 148: | Řádek 148: | ||
| | | | ||
|- | |- | ||
|IsBuyer | |@IsBuyer | ||
|int | |int | ||
| | | | ||
| Řádek 154: | Řádek 154: | ||
| | | | ||
|- | |- | ||
|IsSupplier | |@IsSupplier | ||
|int | |int | ||
| | | | ||
| Řádek 160: | Řádek 160: | ||
| | | | ||
|- | |- | ||
|Region | |@Region | ||
|nvarchar(30) | |nvarchar(30) | ||
| | | | ||
| Řádek 166: | Řádek 166: | ||
| | | | ||
|- | |- | ||
|Country | |@Country | ||
|nvarchar(50) | |nvarchar(50) | ||
| | | | ||
| Řádek 172: | Řádek 172: | ||
| | | | ||
|- | |- | ||
|IsCompetition | |@IsCompetition | ||
|int | |int | ||
| | | | ||
| Řádek 178: | Řádek 178: | ||
| | | | ||
|- | |- | ||
|FileMarkText | |@FileMarkText | ||
|nvarchar(200) | |nvarchar(200) | ||
| | | | ||
| Řádek 184: | Řádek 184: | ||
| | | | ||
|- | |- | ||
|IsWSInvoicesExportAllowed | |@IsWSInvoicesExportAllowed | ||
|bit | |bit | ||
| | | | ||
| Řádek 190: | Řádek 190: | ||
| | | | ||
|- | |- | ||
|IsWSDeliveryNotesExportAllowed | |@IsWSDeliveryNotesExportAllowed | ||
|bit | |bit | ||
| | | | ||
| Řádek 196: | Řádek 196: | ||
| | | | ||
|- | |- | ||
|IsWSImportOrdersAllowed | |@IsWSImportOrdersAllowed | ||
|bit | |bit | ||
| | | | ||
| Řádek 202: | Řádek 202: | ||
| | | | ||
|- | |- | ||
|StoreBackOrder | |@StoreBackOrder | ||
|int | |int | ||
| | | | ||
| Řádek 208: | Řádek 208: | ||
| | | | ||
|- | |- | ||
|IsSupplierIndividualOrders | |@IsSupplierIndividualOrders | ||
|int | |int | ||
| | | | ||
| Řádek 214: | Řádek 214: | ||
| | | | ||
|- | |- | ||
|IsSupplierShortcut | |@IsSupplierShortcut | ||
|nvarchar(10) | |nvarchar(10) | ||
| | | | ||
| Řádek 220: | Řádek 220: | ||
| | | | ||
|- | |- | ||
|Note | |@Note | ||
|nvarchar(500) | |nvarchar(500) | ||
| | | | ||
| Řádek 226: | Řádek 226: | ||
| | | | ||
|- | |- | ||
|Note2 | |@Note2 | ||
|nvarchar(500) | |nvarchar(500) | ||
| | | | ||
| Řádek 232: | Řádek 232: | ||
| | | | ||
|- | |- | ||
|GlobalPricing | |@GlobalPricing | ||
|int | |int | ||
| | | | ||
| Řádek 238: | Řádek 238: | ||
| | | | ||
|- | |- | ||
|OrderGroup | |@OrderGroup | ||
|nvarchar(10) | |nvarchar(10) | ||
| | | | ||
| Řádek 244: | Řádek 244: | ||
| | | | ||
|- | |- | ||
|GPSLatitude | |@GPSLatitude | ||
|nvarchar(20) | |nvarchar(20) | ||
| | | | ||
| Řádek 250: | Řádek 250: | ||
| | | | ||
|- | |- | ||
|GPSLongitude | |@GPSLongitude | ||
|nvarchar(20) | |nvarchar(20) | ||
| | | | ||
| Řádek 256: | Řádek 256: | ||
| | | | ||
|- | |- | ||
|ParentID | |@ParentID | ||
|int | |int | ||
| | | | ||
Verze z 3. 8. 2017, 07:25
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.