API GetOrders: Porovnání verzí

Z Podpora.nextis.cz
Přejít na: navigace, hledání
Řádka 20: Řádka 20:
 
|
 
|
 
|-
 
|-
−
|<TypeID
+
|TypeID
 
|int
 
|int
 
|
 
|
 
|
 
|
 
|-
 
|-
−
|<CustomerID
+
|CustomerID
 
|int
 
|int
 
|
 
|
 
|
 
|
 
|-
 
|-
−
|<OrdererID
+
|OrdererID
 
|int
 
|int
 
|
 
|
 
|
 
|
 
|-
 
|-
−
|<RecipientID
+
|RecipientID
 
|int
 
|int
 
|
 
|
 
|
 
|
 
|-
 
|-
−
|<BranchID
+
|BranchID
 
|int
 
|int
 
|
 
|
 
|
 
|
 
|-
 
|-
−
|<TransportID
+
|TransportID
 
|int
 
|int
 
|
 
|
 
|
 
|
 
|-
 
|-
−
|<CurrencyID
+
|CurrencyID
 
|int
 
|int
 
|
 
|
 
|
 
|
 
|-
 
|-
−
|<PaymentFormID
+
|PaymentFormID
 
|int
 
|int
 
|
 
|
 
|
 
|
 
|-
 
|-
−
|<ExchangeRate
+
|ExchangeRate
 
|decimal(18,6)
 
|decimal(18,6)
 
|
 
|
 
|
 
|
 
|-
 
|-
−
|<OrderNumber
+
|OrderNumber
 
|nvarchar(25)
 
|nvarchar(25)
 
|
 
|
 
|
 
|
 
|-
 
|-
−
|<Date
+
|Date
 
|datetime
 
|datetime
 
|
 
|
 
|
 
|
 
|-
 
|-
−
|<Term
+
|Term
 
|datetime
 
|datetime
 
|
 
|
 
|
 
|
 
|-
 
|-
−
|<Note
+
|Note
 
|nvarchar(600)
 
|nvarchar(600)
 
|
 
|
 
|
 
|
 
|-
 
|-
−
|<CurrencyInCurrencyID
+
|CurrencyInCurrencyID
 
|int
 
|int
 
|
 
|
 
|
 
|
 
|-
 
|-
−
|<StockID
+
|StockID
 
|int
 
|int
 
|
 
|
 
|
 
|
 
|-
 
|-
−
|<SupplierName
+
|SupplierName
 
|nvarchar(140)
 
|nvarchar(140)
 
|
 
|
 
|
 
|
 
|-
 
|-
−
|<SupplerStreet
+
|SupplerStreet
 
|nvarchar(100)
 
|nvarchar(100)
 
|
 
|
 
|
 
|
 
|-
 
|-
−
|<SupplierCIty
+
|SupplierCIty
 
|nvarchar(140)
 
|nvarchar(140)
 
|
 
|
 
|
 
|
 
|-
 
|-
−
|<SupplierZIPCode
+
|SupplierZIPCode
 
|char(10)
 
|char(10)
 
|
 
|
 
|
 
|
 
|-
 
|-
−
|<SupplierCountry
+
|SupplierCountry
 
|nvarchar(50)
 
|nvarchar(50)
 
|
 
|
 
|
 
|
 
|-
 
|-
−
|<SupplierRegion
+
|SupplierRegion
 
|nvarchar(30)
 
|nvarchar(30)
 
|
 
|
 
|
 
|
 
|-
 
|-
−
|<SupplierState
+
|SupplierState
 
|nvarchar(50)
 
|nvarchar(50)
 
|
 
|
 
|
 
|
 
|-
 
|-
−
|<SupplierCompanyRegistrationNumber
+
|SupplierCompanyRegistrationNumber
 
|char(20)
 
|char(20)
 
|
 
|
 
|
 
|
 
|-
 
|-
−
|<SupplierVATNumber
+
|SupplierVATNumber
 
|char(20)
 
|char(20)
 
|
 
|
 
|
 
|
 
|-
 
|-
−
|<SupplierPhone
+
|SupplierPhone
 
|nvarchar(30)
 
|nvarchar(30)
 
|
 
|
 
|
 
|
 
|-
 
|-
−
|<SupplierFax
+
|SupplierFax
 
|nvarchar(30)
 
|nvarchar(30)
 
|
 
|
 
|
 
|
 
|-
 
|-
−
|<SupplierMobilePhone
+
|SupplierMobilePhone
 
|nvarchar(30)
 
|nvarchar(30)
 
|
 
|
 
|
 
|
 
|-
 
|-
−
|<SupplierEmail
+
|SupplierEmail
 
|nvarchar(60)
 
|nvarchar(60)
 
|
 
|
 
|
 
|
 
|-
 
|-
−
|<SupplierWeb
+
|SupplierWeb
 
|nvarchar(50)
 
|nvarchar(50)
 
|
 
|
 
|
 
|
 
|-
 
|-
−
|<SupplierBankName
+
|SupplierBankName
 
|nvarchar(120)
 
|nvarchar(120)
 
|
 
|
 
|
 
|
 
|-
 
|-
−
|<SupplierBankAccount
+
|SupplierBankAccount
 
|nvarchar(50)
 
|nvarchar(50)
 
|
 
|
 
|
 
|
 
|-
 
|-
−
|<OrdererName
+
|OrdererName
 
|nvarchar(140)
 
|nvarchar(140)
 
|
 
|
 
|
 
|
 
|-
 
|-
−
|<OrdererStreet
+
|OrdererStreet
 
|nvarchar(100)
 
|nvarchar(100)
 
|
 
|
 
|
 
|
 
|-
 
|-
−
|<OrdererCity
+
|OrdererCity
 
|nvarchar(140)
 
|nvarchar(140)
 
|
 
|
 
|
 
|
 
|-
 
|-
−
|<OrdererZIPCode
+
|OrdererZIPCode
 
|char(10)
 
|char(10)
 
|
 
|
 
|
 
|
 
|-
 
|-
−
|<OrdererCountry
+
|OrdererCountry
 
|nvarchar(50)
 
|nvarchar(50)
 
|
 
|
 
|
 
|
 
|-
 
|-
−
|<OrdererRegion
+
|OrdererRegion
 
|nvarchar(30)
 
|nvarchar(30)
 
|
 
|
 
|
 
|
 
|-
 
|-
−
|<OrdererState
+
|OrdererState
 
|nvarchar(50)
 
|nvarchar(50)
 
|
 
|
 
|
 
|
 
|-
 
|-
−
|<OrdererCompanyRegistrationNumber
+
|OrdererCompanyRegistrationNumber
 
|char(20)
 
|char(20)
 
|
 
|
 
|
 
|
 
|-
 
|-
−
|<OrdererVATNumber
+
|OrdererVATNumber
 
|char(20)
 
|char(20)
 
|
 
|
 
|
 
|
 
|-
 
|-
−
|<OrdererVATNumber2
+
|OrdererVATNumber2
 
|char(20)
 
|char(20)
 
|
 
|
 
|
 
|
 
|-
 
|-
−
|<OrdererPhone
+
|OrdererPhone
 
|nvarchar(30)
 
|nvarchar(30)
 
|
 
|
 
|
 
|
 
|-
 
|-
−
|<OrdererFax
+
|OrdererFax
 
|nvarchar(30)
 
|nvarchar(30)
 
|
 
|
 
|
 
|
 
|-
 
|-
−
|<OrdererMobilePhone
+
|OrdererMobilePhone
 
|nvarchar(30)
 
|nvarchar(30)
 
|
 
|
 
|
 
|
 
|-
 
|-
−
|<OrdererEmail
+
|OrdererEmail
 
|nvarchar(60)
 
|nvarchar(60)
 
|
 
|
 
|
 
|
 
|-
 
|-
−
|<OrdererWeb
+
|OrdererWeb
 
|nvarchar(50)
 
|nvarchar(50)
 
|
 
|
 
|
 
|
 
|-
 
|-
−
|<OrdererBankName
+
|OrdererBankName
 
|nvarchar(120)
 
|nvarchar(120)
 
|
 
|
 
|
 
|
 
|-
 
|-
−
|<OrdererBankAccount
+
|OrdererBankAccount
 
|nvarchar(50)
 
|nvarchar(50)
 
|
 
|
 
|
 
|
 
|-
 
|-
−
|<RecipientName
+
|RecipientName
 
|nvarchar(140)
 
|nvarchar(140)
 
|
 
|
 
|
 
|
 
|-
 
|-
−
|<RecipientStreet
+
|RecipientStreet
 
|nvarchar(100)
 
|nvarchar(100)
 
|
 
|
 
|
 
|
 
|-
 
|-
−
|<RecipientCity
+
|RecipientCity
 
|nvarchar(140)
 
|nvarchar(140)
 
|
 
|
 
|
 
|
 
|-
 
|-
−
|<RecipientZIPCode
+
|RecipientZIPCode
 
|char(10)
 
|char(10)
 
|
 
|
 
|
 
|
 
|-
 
|-
−
|<RecipientCountry
+
|RecipientCountry
 
|nvarchar(50)
 
|nvarchar(50)
 
|
 
|
 
|
 
|
 
|-
 
|-
−
|<RecipientRegion
+
|RecipientRegion
 
|nvarchar(30)
 
|nvarchar(30)
 
|
 
|
 
|
 
|
 
|-
 
|-
−
|<RecipientState
+
|RecipientState
 
|nvarchar(50)
 
|nvarchar(50)
 
|
 
|
 
|
 
|
 
|-
 
|-
−
|<RecipientCompanyRegistrationNumber
+
|RecipientCompanyRegistrationNumber
 
|char(20)
 
|char(20)
 
|
 
|
 
|
 
|
 
|-
 
|-
−
|<RecipientVATNumber
+
|RecipientVATNumber
 
|char(20)
 
|char(20)
 
|
 
|
 
|
 
|
 
|-
 
|-
−
|<RecipientPhone
+
|RecipientPhone
 
|nvarchar(30)
 
|nvarchar(30)
 
|
 
|
 
|
 
|
 
|-
 
|-
−
|<RecipientFax
+
|RecipientFax
 
|nvarchar(30)
 
|nvarchar(30)
 
|
 
|
 
|
 
|
 
|-
 
|-
−
|<RecipientMobilePhone
+
|RecipientMobilePhone
 
|nvarchar(30)
 
|nvarchar(30)
 
|
 
|
 
|
 
|
 
|-
 
|-
−
|<RecipientEmail
+
|RecipientEmail
 
|nvarchar(60)
 
|nvarchar(60)
 
|
 
|
 
|
 
|
 
|-
 
|-
−
|<RecipientWeb
+
|RecipientWeb
 
|nvarchar(50)
 
|nvarchar(50)
 
|
 
|
 
|
 
|
 
|-
 
|-
−
|<RecipientBankName
+
|RecipientBankName
 
|nvarchar(120)
 
|nvarchar(120)
 
|
 
|
 
|
 
|
 
|-
 
|-
−
|<RecipientBankAccount
+
|RecipientBankAccount
 
|nvarchar(50)
 
|nvarchar(50)
 
|
 
|
 
|
 
|
 
|-
 
|-
−
|<SupplierVATNumber2
+
|SupplierVATNumber2
 
|char(20)
 
|char(20)
 
|
 
|

Verze z 8. 8. 2017, 10:06

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.

Citováno z „https://podpora.nextis.cz/index.php?title=API_GetOrders&oldid=495“