API GetOrders: Porovnání verzí
Z Podpora.nextis.cz
| Řádka 402: | Řádka 402: | ||
|datetime | |datetime | ||
|Payment gateway received date | |Payment gateway received date | ||
| + | | | ||
| + | |- | ||
| + | |SubtransportID | ||
| + | |int | ||
| + | |Subtransport ID | ||
| | | | ||
|} | |} | ||
Verze z 27. 5. 2021, 15:40
Description
Method gives You overview of existing orders in system.
Exact name
API_GetOrders
Type
Standard view.
Specification
| Column | Data type | Description | Relation |
|---|---|---|---|
| ID | int | Internal system id | |
| TypeID | int | Type ID.
-1 - _NA 1 - Orderer 2 - Supplier |
|
| CustomerID | int | ID of customer from customer list (see relation) | API_GetCustomers.ID |
| OrdererID | int | ID of customer from customer list (see relation) | API_GetCustomers.ID |
| RecipientID | int | ID of customer from customer list (see relation) | API_GetCustomers.ID |
| BranchID | int | ID of branch from branch list (see relation) | API_GetBranches.ID |
| TransportID | int | ID of transport from transport list (see relation) | API_GetTransports.ID |
| CurrencyID | int | ID of currency from currency list (see relation) | API_GetCurrency.ID |
| PaymentFormID | int | Payment form ID.
-1 - _NA 1 - Cash 2 - WireTransfer 3 - CreditCard 4 - Before 5 - Voucher 6 - CashOnDelivery |
|
| ExchangeRate | decimal(18,6) | Exchange rate | |
| OrderNumber | nvarchar(25) | Order number | |
| ForeignOrderNumber | nvarchar(80) | Foreign order number | |
| Date | datetime | Date | |
| SendDate | datetime | Send date | |
| Term | datetime | Term | |
| Note | nvarchar(600) | Note | |
| CurrencyInCurrencyID | int | ID of currency from currency list (see relation) | API_GetCurrency.ID |
| StockID | int | ID of stock from stock list (see relation) | API_GetStocks.ID |
| SupplierName | nvarchar(140) | Supplier name | |
| SupplerStreet | nvarchar(100) | Suppler street | |
| SupplierCIty | nvarchar(140) | Supplier cIty | |
| SupplierZIPCode | char(10) | Supplier ZIP code | |
| SupplierCountry | nvarchar(50) | Supplier country | |
| SupplierRegion | nvarchar(30) | Supplier region | |
| SupplierState | nvarchar(50) | Supplier state | |
| SupplierCompanyRegistrationNumber | char(20) | Supplier company registration number | |
| SupplierVATNumber | char(20) | Supplier VAT number | |
| SupplierPhone | nvarchar(30) | Supplier phone | |
| SupplierFax | nvarchar(30) | Supplier fax | |
| SupplierMobilePhone | nvarchar(30) | Supplier mobile phone | |
| SupplierEmail | nvarchar(60) | Supplier email | |
| SupplierWeb | nvarchar(50) | Supplier web | |
| SupplierBankName | nvarchar(120) | Supplier bank name | |
| SupplierBankAccount | nvarchar(50) | Supplier bank account | |
| OrdererName | nvarchar(140) | Orderer name | |
| OrdererStreet | nvarchar(100) | Orderer street | |
| OrdererCity | nvarchar(140) | Orderer city | |
| OrdererZIPCode | char(10) | Orderer ZIP code | |
| OrdererCountry | nvarchar(50) | Orderer country | |
| OrdererRegion | nvarchar(30) | Orderer region | |
| OrdererState | nvarchar(50) | Orderer state | |
| OrdererCompanyRegistrationNumber | char(20) | Orderer company registration number | |
| OrdererVATNumber | char(20) | Orderer VAT number | |
| OrdererVATNumber2 | char(20) | Orderer VAT number 2 | |
| OrdererPhone | nvarchar(30) | Orderer phone | |
| OrdererFax | nvarchar(30) | Orderer fax | |
| OrdererMobilePhone | nvarchar(30) | Orderer mobile phone | |
| OrdererEmail | nvarchar(60) | Orderer email | |
| OrdererWeb | nvarchar(50) | Orderer web | |
| OrdererBankName | nvarchar(120) | Orderer bank name | |
| OrdererBankAccount | nvarchar(50) | Orderer bank account | |
| RecipientName | nvarchar(140) | Recipient name | |
| RecipientStreet | nvarchar(100) | Recipient street | |
| RecipientCity | nvarchar(140) | Recipient city | |
| RecipientZIPCode | char(10) | Recipient ZIP code | |
| RecipientCountry | nvarchar(50) | Recipient country | |
| RecipientRegion | nvarchar(30) | Recipient region | |
| RecipientState | nvarchar(50) | Recipient state | |
| RecipientCompanyRegistrationNumber | char(20) | Recipient company registration number | |
| RecipientVATNumber | char(20) | Recipient VAT number | |
| RecipientPhone | nvarchar(30) | Recipient phone | |
| RecipientFax | nvarchar(30) | Recipient fax | |
| RecipientMobilePhone | nvarchar(30) | Recipient mobile phone | |
| RecipientEmail | nvarchar(60) | Recipient email | |
| RecipientWeb | nvarchar(50) | Recipient web | |
| RecipientBankName | nvarchar(120) | Recipient bank name | |
| RecipientBankAccount | nvarchar(50) | Recipient bank account | |
| SupplierVATNumber2 | char(20) | Supplier VAT number 2 | |
| PaymentGatewayState | int | Payment gateway state
-1 - _NA 0 - Created 1 - PaymentMethodChosen 2 - Paid 3 - Authorized 4 - Canceled 5 - Timeouted 6 - Refunded 7 - PartiallyRefunded |
|
| PaymentGatewayReceivedDate | datetime | Payment gateway received date | |
| SubtransportID | int | Subtransport ID |
Example
SELECT TOP 1000 * FROM [API_GetOrders]
Notices
None.
