API GetBasketItems
Z Podpora.nextis.cz
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.