API GetCustomers: Porovnání verzí
Z Podpora.nextis.cz
| Řádka 49: | Řádka 49: | ||
|TransportID | |TransportID | ||
|int | |int | ||
| − | | | + | |ID of transport from transport list (see relation) |
| − | | | + | |API_GetTransports.ID |
|- | |- | ||
|Username | |Username | ||
| Řádka 64: | Řádka 64: | ||
|OrderConfirmationPassword | |OrderConfirmationPassword | ||
|nvarchar(25) | |nvarchar(25) | ||
| − | | | + | |Order confirmation password |
| | | | ||
|- | |- | ||
| Řádka 84: | Řádka 84: | ||
|State | |State | ||
|int | |int | ||
| − | | | + | |ID of country from country list (see relation) |
| − | | | + | |API_GetCountry.ID |
|- | |- | ||
|BranchID | |BranchID | ||
|int | |int | ||
| − | | | + | |ID of branche from branch list (see relation) |
| − | | | + | |API_GetBranches.ID |
|- | |- | ||
|WorkshopID | |WorkshopID | ||
|int | |int | ||
| − | | | + | |ID of workshop from workshop list (see relation) |
| − | | | + | |API_GetWorkshops.ID |
|- | |- | ||
|StockID | |StockID | ||
|int | |int | ||
| − | | | + | |ID of stock from stock list (see relation) |
| − | | | + | |API_GetStocks.ID |
|- | |- | ||
|CurrencyID | |CurrencyID | ||
|int | |int | ||
| − | | | + | |ID of currency from currency list (see relation) |
| − | | | + | |API_GetCurrency.ID |
|- | |- | ||
|SendOrderConfirmationEmail | |SendOrderConfirmationEmail | ||
Verze z 26. 7. 2017, 12:22
Description
Method gives You overview of existing customers in system.
Exact name
API_GetCustomers
Type
Standard view.
Specification
| Column | Data type | Description | Relation |
|---|---|---|---|
| ID | int | Internal system id | |
| 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
SELECT TOP 1000 * FROM [API_GetCustomers]
Notices
None.
