API GetBasketItems: Porovnání verzí

Verze z 24. 7. 2017, 13:59

API_GetBasketItems

          <ID, int,>
          ,<DistributorID, int,>
          ,<CustomerID, int,>
          ,<CustomerWorkshopID, int,>
          ,<GroupID, int,>
          ,<ProductID, int,>
          ,<StorageCardID, int,>
          ,<OrderID, int,>
          ,<GroupCode, nvarchar(40),>
          ,<ProductCode, nvarchar(40),>
          ,<ManufacturerCode, nvarchar(40),>
          ,<SupplierCode, nvarchar(40),>
          ,<Brand, nvarchar(50),>
          ,<Desription, nvarchar(250),>
          ,<OrderedQuantity, decimal(18,2),>
          ,<PricePerPiece, decimal(18,3),>
          ,<PricePerPieceWithVAT, decimal(18,3),>
          ,<PurchasePricePerPiece, decimal(18,3),>
          ,<PurchasePricePerPieceWithVAT, decimal(18,3),>
          ,<TotalPrice, decimal(18,3),>
          ,<TotalPriceWithVAT, decimal(18,3),>
          ,<TotalPurchasePrice, decimal(18,3),>
          ,<TotalPurchasePriceWithVAT, decimal(18,3),>
          ,<DiscountInPercent, decimal(18,3),>
          ,<DiscountPrice, decimal(18,3),>
          ,<SurchargesPrice, decimal(18,2),>
          ,<SurchargePriceWithVAT, decimal(18,2),>
          ,<PricePerPieceInCurrency, decimal(18,3),>
          ,<PricePerPieceWithVATInCurrency, decimal(18,3),>
          ,<PurchasePricePerPieceInCurrency, decimal(18,3),>
          ,<PurchasePricePerPieceWithVATInCurrency, decimal(18,3),>
          ,<TotalPriceInCurrency, decimal(18,3),>
          ,<TotalPriceWithVATInCurrency, decimal(18,3),>
          ,<TotalPurchasePriceInCurrency, decimal(18,3),>
          ,<TotalPurchasePriceWithVATInCurrency, decimal(18,3),>
          ,<DiscountPriceInCurrency, decimal(18,3),>
          ,<SurchargesPriceInCurrency, decimal(18,3),>
          ,<SurchargesPriceWithVATInCurrency, decimal(18,3),>
          ,<CurrencyID, int,>
          ,<ForeignCurrencyID, int,>
          ,<Note, nvarchar(50),>
          ,<VATRate, decimal(18,2),>
          ,<HistoryInfo, nvarchar(300),>
          ,<ActionPrice, int,>
          ,<ChildPricePerPieceInCurrency, decimal(18,3),>
          ,<ChildPricePerPieceWithVATInCurrency, decimal(18,3),>
          ,<ChildPurchasePricePerPieceInCurrency, decimal(18,3),>
          ,<ChildPurchasePricePerPieceWithVATInCurrency, decimal(18,3),>
          ,<ChildDiscountInCurrency, decimal(18,3),>

Example:

SELECT TOP 1000 *

FROM [API_GetBasketItems]