API GetOrders

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
CustomerID	int
OrdererID	int
RecipientID	int
BranchID	int
TransportID	int
CurrencyID	int
PaymentFormID	int
ExchangeRate	decimal(18,6)
OrderNumber	nvarchar(25)
Date	datetime
Term	datetime
Note	nvarchar(600)
CurrencyInCurrencyID	int
StockID	int
SupplierName	nvarchar(140)
SupplerStreet	nvarchar(100)
SupplierCIty	nvarchar(140)
SupplierZIPCode	char(10)
SupplierCountry	nvarchar(50)
SupplierRegion	nvarchar(30)
SupplierState	nvarchar(50)
SupplierCompanyRegistrationNumber	char(20)
SupplierVATNumber	char(20)
SupplierPhone	nvarchar(30)
SupplierFax	nvarchar(30)
SupplierMobilePhone	nvarchar(30)
SupplierEmail	nvarchar(60)
SupplierWeb	nvarchar(50)
SupplierBankName	nvarchar(120)
SupplierBankAccount	nvarchar(50)
OrdererName	nvarchar(140)
OrdererStreet	nvarchar(100)
OrdererCity	nvarchar(140)
OrdererZIPCode	char(10)
OrdererCountry	nvarchar(50)
OrdererRegion	nvarchar(30)
OrdererState	nvarchar(50)
OrdererCompanyRegistrationNumber	char(20)
OrdererVATNumber	char(20)
OrdererVATNumber2	char(20)
OrdererPhone	nvarchar(30)
OrdererFax	nvarchar(30)
OrdererMobilePhone	nvarchar(30)
OrdererEmail	nvarchar(60)
OrdererWeb	nvarchar(50)
OrdererBankName	nvarchar(120)
OrdererBankAccount	nvarchar(50)
RecipientName	nvarchar(140)
RecipientStreet	nvarchar(100)
RecipientCity	nvarchar(140)
RecipientZIPCode	char(10)
RecipientCountry	nvarchar(50)
RecipientRegion	nvarchar(30)
RecipientState	nvarchar(50)
RecipientCompanyRegistrationNumber	char(20)
RecipientVATNumber	char(20)
RecipientPhone	nvarchar(30)
RecipientFax	nvarchar(30)
RecipientMobilePhone	nvarchar(30)
RecipientEmail	nvarchar(60)
RecipientWeb	nvarchar(50)
RecipientBankName	nvarchar(120)
RecipientBankAccount	nvarchar(50)
SupplierVATNumber2	char(20)

Example

SELECT TOP 1000 * FROM [API_GetOrders]

Notices

None.