API GetBasketItems: Porovnání verzí

Z Podpora.nextis.cz
Přejít na: navigace, hledání
 
Řádka 1: Řádka 1:
−
'''API_GetBasketItems'''
+
====Description====
−
 
+
Method gives You overview of existing basket items in system.
−
          <ID, int,>
+
====Exact name====
−
          ,<DistributorID, int,>
+
<code>API_GetBasketItems</code>
−
          ,<CustomerID, int,>
+
====Type====
−
          ,<CustomerWorkshopID, int,>
+
Standard view.
−
          ,<GroupID, int,>
+
====Specification====
−
          ,<ProductID, int,>
+
{| class="wikitable"
−
          ,<StorageCardID, int,>
+
!Column
−
          ,<OrderID, int,>
+
!Data type
−
          ,<GroupCode, nvarchar(40),>
+
!Description
−
          ,<ProductCode, nvarchar(40),>
+
!Relation
−
          ,<ManufacturerCode, nvarchar(40),>
+
|-
−
          ,<SupplierCode, nvarchar(40),>
+
|ID
−
          ,<Brand, nvarchar(50),>
+
|int
−
          ,<Desription, nvarchar(250),>
+
|Internal system id
−
          ,<OrderedQuantity, decimal(18,2),>
+
|
−
          ,<PricePerPiece, decimal(18,3),>
+
|-
−
          ,<PricePerPieceWithVAT, decimal(18,3),>
+
|CustomerID
−
          ,<PurchasePricePerPiece, decimal(18,3),>
+
|int
−
          ,<PurchasePricePerPieceWithVAT, decimal(18,3),>
+
|ID of customer from customers list (see relation)
−
          ,<TotalPrice, decimal(18,3),>
+
|API_GetCustomers.ID
−
          ,<TotalPriceWithVAT, decimal(18,3),>
+
|-
−
          ,<TotalPurchasePrice, decimal(18,3),>
+
|CustomerWorkshopID
−
          ,<TotalPurchasePriceWithVAT, decimal(18,3),>
+
|int
−
          ,<DiscountInPercent, decimal(18,3),>
+
|ID of workshops from workshops list (see relation)
−
          ,<DiscountPrice, decimal(18,3),>
+
|API_GetWorkshops.ID = API_GetCustomers.WorkshopID
−
          ,<SurchargesPrice, decimal(18,2),>
+
|-
−
          ,<SurchargePriceWithVAT, decimal(18,2),>
+
|GroupID
−
          ,<PricePerPieceInCurrency, decimal(18,3),>
+
|int
−
          ,<PricePerPieceWithVATInCurrency, decimal(18,3),>
+
|ID of product groups from product groups list (see relation)
−
          ,<PurchasePricePerPieceInCurrency, decimal(18,3),>
+
|API_GetProductGroups.ID
−
          ,<PurchasePricePerPieceWithVATInCurrency, decimal(18,3),>
+
|-
−
          ,<TotalPriceInCurrency, decimal(18,3),>
+
|ProductID
−
          ,<TotalPriceWithVATInCurrency, decimal(18,3),>
+
|int
−
          ,<TotalPurchasePriceInCurrency, decimal(18,3),>
+
|ID of product from product list (see relation)
−
          ,<TotalPurchasePriceWithVATInCurrency, decimal(18,3),>
+
|API_GetProducts.ID
−
          ,<DiscountPriceInCurrency, decimal(18,3),>
+
|-
−
          ,<SurchargesPriceInCurrency, decimal(18,3),>
+
|StorageCardID
−
          ,<SurchargesPriceWithVATInCurrency, decimal(18,3),>
+
|int
−
          ,<CurrencyID, int,>
+
|ID of stock dispositions from stock dispositions list (see relation)
−
          ,<ForeignCurrencyID, int,>
+
|API_GetStockDispositions.ID
−
          ,<Note, nvarchar(50),>
+
|-
−
          ,<VATRate, decimal(18,2),>
+
|OrderID
−
          ,<HistoryInfo, nvarchar(300),>
+
|int
−
          ,<ActionPrice, int,>
+
|ID of orders from orders list (see relation)
−
          ,<ChildPricePerPieceInCurrency, decimal(18,3),>
+
|API_GetOrders.ID
−
          ,<ChildPricePerPieceWithVATInCurrency, decimal(18,3),>
+
|-
−
          ,<ChildPurchasePricePerPieceInCurrency, decimal(18,3),>
+
|GroupCode
−
          ,<ChildPurchasePricePerPieceWithVATInCurrency, decimal(18,3),>
+
|nvarchar(40)
−
          ,<ChildDiscountInCurrency, decimal(18,3),>
+
|
−
 
+
|
−
 
+
|-
−
 
+
|ProductCode
−
''Example:''
+
|nvarchar(40)
−
 
+
|
−
SELECT TOP 1000 *  
+
|
−
 
+
|-
−
FROM [API_GetBasketItems]
+
|ManufacturerCode
 +
|nvarchar(40)
 +
|
 +
|
 +
|-
 +
|SupplierCode
 +
|nvarchar(40)
 +
|
 +
|
 +
|-
 +
|Brand
 +
|nvarchar(50)
 +
|
 +
|
 +
|-
 +
|Desription
 +
|nvarchar(250)
 +
|Desription
 +
|
 +
|-
 +
|OrderedQuantity
 +
|decimal(18,2)
 +
|Ordered quantity
 +
|
 +
|-
 +
|PricePerPiece
 +
|decimal(18,3)
 +
|Price per piece
 +
|
 +
|-
 +
|PricePerPieceWithVAT
 +
|decimal(18,3)
 +
|Price per piece with VAT
 +
|
 +
|-
 +
|PurchasePricePerPiece
 +
|decimal(18,3)
 +
|Purchase price per piece
 +
|
 +
|-
 +
|PurchasePricePerPieceWithVAT
 +
|decimal(18,3)
 +
|Purchase price per piece with VAT
 +
|
 +
|-
 +
|TotalPrice
 +
|decimal(18,3)
 +
|Total price
 +
|
 +
|-
 +
|TotalPriceWithVAT
 +
|decimal(18,3)
 +
|Total price with VAT
 +
|
 +
|-
 +
|TotalPurchasePrice
 +
|decimal(18,3)
 +
|Total purchase Price
 +
|
 +
|-
 +
|TotalPurchasePriceWithVAT
 +
|decimal(18,3)
 +
|Total purchase price with VAT
 +
|
 +
|-
 +
|DiscountInPercent
 +
|decimal(18,3)
 +
|DiscountIn percent
 +
|
 +
|-
 +
|DiscountPrice
 +
|decimal(18,3)
 +
|Discount price
 +
|
 +
|-
 +
|SurchargesPrice
 +
|decimal(18,2)
 +
|Surcharges price
 +
|
 +
|-
 +
|SurchargePriceWithVAT
 +
|decimal(18,2)
 +
|Surcharge price with VAT
 +
|
 +
|-
 +
|PricePerPieceInCurrency
 +
|decimal(18,3)
 +
|Price per piece in currency
 +
|
 +
|-
 +
|PricePerPieceWithVATInCurrency
 +
|decimal(18,3)
 +
|Price per piece with VAT in currency
 +
|
 +
|-
 +
|PurchasePricePerPieceInCurrency
 +
|decimal(18,3)
 +
|Purchase price per piece in currency
 +
|
 +
|-
 +
|PurchasePricePerPieceWithVATInCurrency
 +
|decimal(18,3)
 +
|Purchase price per piece with VAT in currency
 +
|
 +
|-
 +
|TotalPriceInCurrency
 +
|decimal(18,3)
 +
|Total price in currency
 +
|
 +
|-
 +
|TotalPriceWithVATInCurrency
 +
|decimal(18,3)
 +
|Total price with VAT in currency
 +
|
 +
|-
 +
|TotalPurchasePriceInCurrency
 +
|decimal(18,3)
 +
|Total purchase price in currency
 +
|
 +
|-
 +
|TotalPurchasePriceWithVATInCurrency
 +
|decimal(18,3)
 +
|Total purchase price with VAT in currency
 +
|
 +
|-
 +
|DiscountPriceInCurrency
 +
|decimal(18,3)
 +
|Discount price in currency
 +
|
 +
|-
 +
|SurchargesPriceInCurrency
 +
|decimal(18,3)
 +
|Surcharges price in currency
 +
|
 +
|-
 +
|SurchargesPriceWithVATInCurrency
 +
|decimal(18,3)
 +
|Surcharges price with VAT in currency
 +
|
 +
|-
 +
|CurrencyID
 +
|int
 +
|ID of currency from currency list (see relation)
 +
|API_GetCurrency.ID
 +
|-
 +
|ForeignCurrencyID
 +
|int
 +
|ID of currency from currency list (see relation)
 +
|API_GetCurrency.ID
 +
|-
 +
|Note
 +
|nvarchar(50)
 +
|Note
 +
|
 +
|-
 +
|VATRate
 +
|decimal(18,2)
 +
|VAT rate
 +
|
 +
|-
 +
|HistoryInfo
 +
|nvarchar(300)
 +
|History info
 +
|
 +
|-
 +
|ActionPrice
 +
|int
 +
|Action price
 +
|
 +
|-
 +
|ChildPricePerPieceInCurrency
 +
|decimal(18,3)
 +
|Child price per piece in currency
 +
|
 +
|-
 +
|ChildPricePerPieceWithVATInCurrency
 +
|decimal(18,3)
 +
|Child price per piece with VAT in currency
 +
|
 +
|-
 +
|ChildPurchasePricePerPieceInCurrency
 +
|decimal(18,3)
 +
|Child purchase price per piece in currency
 +
|
 +
|-
 +
|ChildPurchasePricePerPieceWithVATInCurrency
 +
|decimal(18,3)
 +
|Child purchase price per piece with VAT in currency
 +
|
 +
|-
 +
|ChildDiscountInCurrency
 +
|decimal(18,3)
 +
|Child discount in currency
 +
|
 +
|}
 +
====Example====
 +
<syntaxhighlight lang="sql">
 +
SELECT TOP 1000 * FROM [API_GetBasketItems]
 +
</syntaxhighlight>
 +
====Notices====
 +
None.

Aktuální verze z 26. 7. 2017, 10:54

Description

Method gives You overview of existing basket items in system.

Exact name

API_GetBasketItems

Type

Standard view.

Specification

Column Data type Description Relation
ID int Internal system id
CustomerID int ID of customer from customers list (see relation) API_GetCustomers.ID
CustomerWorkshopID int ID of workshops from workshops list (see relation) API_GetWorkshops.ID = API_GetCustomers.WorkshopID
GroupID int ID of product groups from product groups list (see relation) API_GetProductGroups.ID
ProductID int ID of product from product list (see relation) API_GetProducts.ID
StorageCardID int ID of stock dispositions from stock dispositions list (see relation) API_GetStockDispositions.ID
OrderID int ID of orders from orders list (see relation) API_GetOrders.ID
GroupCode nvarchar(40)
ProductCode nvarchar(40)
ManufacturerCode nvarchar(40)
SupplierCode nvarchar(40)
Brand nvarchar(50)
Desription nvarchar(250) Desription
OrderedQuantity decimal(18,2) Ordered quantity
PricePerPiece decimal(18,3) Price per piece
PricePerPieceWithVAT decimal(18,3) Price per piece with VAT
PurchasePricePerPiece decimal(18,3) Purchase price per piece
PurchasePricePerPieceWithVAT decimal(18,3) Purchase price per piece with VAT
TotalPrice decimal(18,3) Total price
TotalPriceWithVAT decimal(18,3) Total price with VAT
TotalPurchasePrice decimal(18,3) Total purchase Price
TotalPurchasePriceWithVAT decimal(18,3) Total purchase price with VAT
DiscountInPercent decimal(18,3) DiscountIn percent
DiscountPrice decimal(18,3) Discount price
SurchargesPrice decimal(18,2) Surcharges price
SurchargePriceWithVAT decimal(18,2) Surcharge price with VAT
PricePerPieceInCurrency decimal(18,3) Price per piece in currency
PricePerPieceWithVATInCurrency decimal(18,3) Price per piece with VAT in currency
PurchasePricePerPieceInCurrency decimal(18,3) Purchase price per piece in currency
PurchasePricePerPieceWithVATInCurrency decimal(18,3) Purchase price per piece with VAT in currency
TotalPriceInCurrency decimal(18,3) Total price in currency
TotalPriceWithVATInCurrency decimal(18,3) Total price with VAT in currency
TotalPurchasePriceInCurrency decimal(18,3) Total purchase price in currency
TotalPurchasePriceWithVATInCurrency decimal(18,3) Total purchase price with VAT in currency
DiscountPriceInCurrency decimal(18,3) Discount price in currency
SurchargesPriceInCurrency decimal(18,3) Surcharges price in currency
SurchargesPriceWithVATInCurrency decimal(18,3) Surcharges price with VAT in currency
CurrencyID int ID of currency from currency list (see relation) API_GetCurrency.ID
ForeignCurrencyID int ID of currency from currency list (see relation) API_GetCurrency.ID
Note nvarchar(50) Note
VATRate decimal(18,2) VAT rate
HistoryInfo nvarchar(300) History info
ActionPrice int Action price
ChildPricePerPieceInCurrency decimal(18,3) Child price per piece in currency
ChildPricePerPieceWithVATInCurrency decimal(18,3) Child price per piece with VAT in currency
ChildPurchasePricePerPieceInCurrency decimal(18,3) Child purchase price per piece in currency
ChildPurchasePricePerPieceWithVATInCurrency decimal(18,3) Child purchase price per piece with VAT in currency
ChildDiscountInCurrency decimal(18,3) Child discount in currency

Example

SELECT TOP 1000 * FROM [API_GetBasketItems]

Notices

None.

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