API GetOrders: Porovnání verzí

Z Podpora.nextis.cz
Přejít na: navigace, hledání
Řádka 20: Řádka 20:
 
|
 
|
 
|-
 
|-
−
|OrderID
+
|<TypeID
 
|int
 
|int
 
|
 
|
 
|
 
|
 
|-
 
|-
−
|ProductID
+
|<CustomerID
 
|int
 
|int
 
|
 
|
 
|
 
|
 
|-
 
|-
−
|UnitID
+
|<OrdererID
 
|int
 
|int
 
|
 
|
 
|
 
|
 
|-
 
|-
−
|CodeInLanguage
+
|<RecipientID
−
|nvarchar(350)
+
|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)
 
|
 
|
 
|
 
|
 
|-
 
|-
−
|NameInLanguage
+
|<SupplierCountry
−
|nvarchar(1000)
+
|nvarchar(50)
 
|
 
|
 
|
 
|
 
|-
 
|-
−
|Quantity
+
|<SupplierRegion
−
|decimal(12,4)
+
|nvarchar(30)
 
|
 
|
 
|
 
|
 
|-
 
|-
−
|DeliveredQuantity
+
|<SupplierState
−
|decimal(18,4)
+
|nvarchar(50)
 
|
 
|
 
|
 
|
 
|-
 
|-
−
|CanceledQuantity
+
|<SupplierCompanyRegistrationNumber
−
|decimal(18,4)
+
|char(20)
 
|
 
|
 
|
 
|
 
|-
 
|-
−
|PricePerPiece
+
|<SupplierVATNumber
−
|decimal(19,6)
+
|char(20)
 
|
 
|
 
|
 
|
 
|-
 
|-
−
|TotalPrice
+
|<SupplierPhone
−
|decimal(19,6)
+
|nvarchar(30)
 
|
 
|
 
|
 
|
 
|-
 
|-
−
|PricePerPieceInCurrency
+
|<SupplierFax
−
|decimal(19,6)
+
|nvarchar(30)
 
|
 
|
 
|
 
|
 
|-
 
|-
−
|TotalPriceInCurrency
+
|<SupplierMobilePhone
−
|decimal(19,6)
+
|nvarchar(30)
 
|
 
|
 
|
 
|
 
|-
 
|-
−
|Note
+
|<SupplierEmail
−
|varchar(400)
+
|nvarchar(60)
 
|
 
|
 
|
 
|
 
|-
 
|-
−
|DiscountPercent
+
|<SupplierWeb
−
|decimal(18,4)
+
|nvarchar(50)
 
|
 
|
 
|
 
|
 
|-
 
|-
−
|DiscountPrice
+
|<SupplierBankName
−
|decimal(18,4)
+
|nvarchar(120)
 
|
 
|
 
|
 
|
 
|-
 
|-
−
|PricePerPieceAfterDIscount
+
|<SupplierBankAccount
−
|decimal(18,4)
+
|nvarchar(50)
 
|
 
|
 
|
 
|
 
|-
 
|-
−
|TotalPriceAfterDiscount
+
|<OrdererName
−
|decimal(18,4)
+
|nvarchar(140)
 
|
 
|
 
|
 
|
 
|-
 
|-
−
|ItemTypeID
+
|<OrdererStreet
−
|int
+
|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)
 
|
 
|
 
|
 
|
 
|-
 
|-
−
|ItemText
+
|<RecipientEmail
−
|nvarchar(1000)
+
|nvarchar(60)
 
|
 
|
 
|
 
|
 
|-
 
|-
−
|DontOrder
+
|<RecipientWeb
−
|int
+
|nvarchar(50)
 
|
 
|
 
|
 
|
 
|-
 
|-
−
|PricePerPieceAfterDiscountInCurrency
+
|<RecipientBankName
−
|decimal(18,4)
+
|nvarchar(120)
 
|
 
|
 
|
 
|
 
|-
 
|-
−
|TotalPriceAfterDiscountInCurrency
+
|<RecipientBankAccount
−
|decimal(18,4)
+
|nvarchar(50)
 
|
 
|
 
|
 
|
 
|-
 
|-
−
|DiscountPriceInCurrency
+
|<SupplierVATNumber2
−
|decimal(18,4)
+
|char(20)
 
|
 
|
 
|
 
|

Verze z 8. 8. 2017, 09: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=494“