API CreateCustomer: Porovnání verzí
Z Podpora.nextis.cz
| Řádka 265: | Řádka 265: | ||
==== Example ==== | ==== Example ==== | ||
<syntaxhighlight lang="sql"> | <syntaxhighlight lang="sql"> | ||
| − | EXEC [API_CreateCustomer] @WorkshopID = 1 ,@ | + | EXEC [API_CreateCustomer] @ShortName= 'ShortName' ,@CompanyName= 'CompanyName' ,@CompanyRegistrationNumber= 'CompanyRegistrationNumber' ,@VATNumber= 'VATNumber' ,@VATNumber2= 'VATNumber2' ,@VATPayer= 1 ,@TransportID= 1 ,@Username= 'Username' ,@Password= 'Password' ,@OrderConfirmationPassword= 'OrderConfirmationPassword' ,@Street= 'Street' ,@City= 'City' ,@ZIPCode= 'ZIPCode' ,@State= 15797 ,@BranchID= 1 ,@WorkshopID= 1 ,@StockID= 1 ,@CurrencyID= 144 ,@SendOrderConfirmationEmail= 0 ,@OrderConfirmationEmail= 'OrderConfirmationEmail' ,@Email= 'Email' ,@EshopEmails= 'EshopEmails' ,@IsBuyer= 0 ,@IsSupplier= 0 ,@Region= 'Region' ,@Country= 'Country' ,@IsCompetition= 0 ,@FileMarkText= 'FileMarkText' ,@IsWSInvoicesExportAllowed= 0 ,@IsWSDeliveryNotesExportAllowed= 0 ,@IsWSImportOrdersAllowed= 0 ,@StoreBackOrder= 0 ,@IsSupplierIndividualOrders= 0 ,@IsSupplierShortcut= 'IsSupplierShortcut' ,@Note= 'Note' ,@Note2= 'Note2' ,@GlobalPricing= 0 ,@OrderGroup= 'OrderGroup' ,@GPSLatitude= 'GPSLatitude' ,@GPSLongitude= 'GPSLongitude' ,@ParentID= -1 |
</syntaxhighlight> | </syntaxhighlight> | ||
==== Notices ==== | ==== Notices ==== | ||
None. | None. | ||
Verze z 3. 8. 2017, 10:04
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] @ShortName= 'ShortName' ,@CompanyName= 'CompanyName' ,@CompanyRegistrationNumber= 'CompanyRegistrationNumber' ,@VATNumber= 'VATNumber' ,@VATNumber2= 'VATNumber2' ,@VATPayer= 1 ,@TransportID= 1 ,@Username= 'Username' ,@Password= 'Password' ,@OrderConfirmationPassword= 'OrderConfirmationPassword' ,@Street= 'Street' ,@City= 'City' ,@ZIPCode= 'ZIPCode' ,@State= 15797 ,@BranchID= 1 ,@WorkshopID= 1 ,@StockID= 1 ,@CurrencyID= 144 ,@SendOrderConfirmationEmail= 0 ,@OrderConfirmationEmail= 'OrderConfirmationEmail' ,@Email= 'Email' ,@EshopEmails= 'EshopEmails' ,@IsBuyer= 0 ,@IsSupplier= 0 ,@Region= 'Region' ,@Country= 'Country' ,@IsCompetition= 0 ,@FileMarkText= 'FileMarkText' ,@IsWSInvoicesExportAllowed= 0 ,@IsWSDeliveryNotesExportAllowed= 0 ,@IsWSImportOrdersAllowed= 0 ,@StoreBackOrder= 0 ,@IsSupplierIndividualOrders= 0 ,@IsSupplierShortcut= 'IsSupplierShortcut' ,@Note= 'Note' ,@Note2= 'Note2' ,@GlobalPricing= 0 ,@OrderGroup= 'OrderGroup' ,@GPSLatitude= 'GPSLatitude' ,@GPSLongitude= 'GPSLongitude' ,@ParentID= -1
Notices
None.
