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