ProductBaseComponents Web Service
Method/productbasecomponents.asmx/GetSaleOrderRows
ProductBaseComponents Web Service > All Operations Resource Group : /productbasecomponents.asmx/GetSaleOrderRows (Method)
Description
The GetSaleOrderRows function returns all saleOrderRow records for the specified parameters.
Request (GetSaleOrderRowsSoapIn)

The request body is of type GetSaleOrderRows.

Request Body Parameters

NameDescriptionData Type
filter SaleOrderRowsFilter
ItemId Element ConversionId Element ModifiedSinceDateTime Element IsCancelledOnly Element IsDropshipmentRowsOnly Element IsParentRowOnly Element FreeStockAvailableOnly Element IsDeliveredRowsOnly Element RowsToReserveOnly Element IsRemainingRowsOnly Element SaleOrdersModifiedSinceDateTime Element RelatedProductsChildProductId Element ReservationRowId Element CustomerId Element PurchaseOrderId Element PurchaseOrderRowId Element VatId Element OrderAtSupplierId Element PromotionId Element QuantityPriceBreakId Element DiscountAgreementClassificationId Element MixedMatchId Element ScannerId Element BrandId Element Barcode Element ProductPreferredSupplierId Element ProductId Element RelatedSaleOrderRowId Element SaleOrderId Element StoreId Element Sequence filter Element Sequence GetSaleOrderRows Element

Overview

GetSaleOrderRows
Sequence
filter optional SaleOrderRowsFilter Complex Type
Sequence
StoreId xs:int
SaleOrderId xs:int
RelatedSaleOrderRowId xs:int
ProductId xs:int
ProductPreferredSupplierId xs:int
Barcode xs:long
BrandId xs:int
ScannerId xs:int
MixedMatchId xs:int
DiscountAgreementClassificationId xs:int
QuantityPriceBreakId xs:int
PromotionId xs:int
OrderAtSupplierId xs:int
VatId xs:int
PurchaseOrderRowId xs:int
PurchaseOrderId xs:int
CustomerId xs:int
ReservationRowId xs:int
RelatedProductsChildProductId xs:int
SaleOrdersModifiedSinceDateTime xs:dateTime
IsRemainingRowsOnly BooleanFilter Simple Type
RowsToReserveOnly BooleanFilter Simple Type
IsDeliveredRowsOnly BooleanFilter Simple Type
FreeStockAvailableOnly BooleanFilter Simple Type
IsParentRowOnly BooleanFilter Simple Type
IsDropshipmentRowsOnly BooleanFilter Simple Type
IsCancelledOnly BooleanFilter Simple Type
ModifiedSinceDateTime xs:dateTime
ConversionId xs:long
ItemId xs:int
Response (GetSaleOrderRowsSoapOut)

The response body is of type GetSaleOrderRowsResponse.

Response Body Parameters

NameDescriptionData Type
GetSaleOrderRowsResult ArrayOfViewSaleOrderRowInfo
FutureStockSpecificStore Element FreeStockSpecificStore Element StockSpecificStore Element TotalStockAtOtherStores Element SupplierDetailedApprovalStatus Element SupplierGeneralApprovalStatus Element ProductType Element VatCode Element DeviantInterbrancheOrdering Element ProductPreferredSupplierName Element ProductPreferredSupplierNumber Element OrderAtSupplierName Element OrderAtSupplierNumber Element ProductPreferredSupplierId Element PurchaseUnitTotalOrderedCbm Element PurchaseUnitCbmPerSingleUnit Element OrderedPurchaseUnits Element CalculatedPurchaseUnitConsumerUnits Element Plu Element OrderCode Element SaleOrderClassDescription Element SaleOrderUtmostDeliveryDate Element SaleOrderExpectedDeliveryDate Element SaleOrderClassId Element SaleOrderType Element SaleOrderStatus Element ScannerNumber Element OpenReservations Element OpenSaleOrders Element FutureStock Element FreeStock Element Stock Element VatDescription Element BrandDescription Element MainBarcode Element ProductInformation Element ProductDescription Element ProductExternalCode Element ProductNumber Element CustomerName Element CustomerNumber Element SaleOrderCreatedDateTime Element SaleOrderPrintedDateTime Element SaleOrderReferenceCode Element SaleOrderNumber Element BasePceGrossPrice Element ConversionId Element ApprovedDeliveryDays Element ApprovedAmount Element ApprovalNote Element DeliveryDays Element ReservedAmount Element DeliveredAmount Element RemainingAmount Element PriceType Element WeightedTotalNetPrice Element TotalVat Element TotalNetPrice Element TotalGrossPrice Element PceNetPrice Element PceGrossPrice Element PcePurchasePrice Element IsDropshipment Element IsParentRow Element IsSale Element IsNoDiscountOnDiscount Element IsNoDiscounts Element DiscountType Element VatRequired Element DiscountPercentage Element DiscountPrice Element MiscInfo Element Note2 Element Note1 Element IsCancelled Element QtyPerPackage Element NumberOfPackages Element DirectReservationAmount Element Amount Element Barcode Element Description Element PurchaseOrderRowId Element VatPercentage Element VatId Element OrderAtSupplierId Element PromotionId Element QuantityPriceBreakId Element DiscountAgreementClassificationId Element MixedMatchId Element ScannerId Element BrandId Element ProductId Element RelatedSaleOrderRowId Element SaleOrderId Element CompanyId Element LastModifiedDateTime Element LastModifiedByUserId Element CreatedDateTime Element CreatedByUserId Element ItemId Element Sequence ViewSaleOrderRowInfo Element Sequence GetSaleOrderRowsResult Element Sequence GetSaleOrderRowsResponse Element

Overview

GetSaleOrderRowsResponse
Sequence
GetSaleOrderRowsResult optional ArrayOfViewSaleOrderRowInfo Complex Type
Sequence
ViewSaleOrderRowInfo 0..∞ ViewSaleOrderRowInfo Complex Type
Sequence
ItemId xs:int
CreatedByUserId xs:int
CreatedDateTime xs:dateTime
LastModifiedByUserId xs:int
LastModifiedDateTime xs:dateTime
CompanyId xs:int
SaleOrderId xs:int
RelatedSaleOrderRowId xs:int
ProductId xs:int
BrandId xs:int
ScannerId xs:int
MixedMatchId xs:int
DiscountAgreementClassificationId xs:int
QuantityPriceBreakId xs:int
PromotionId xs:int
OrderAtSupplierId xs:int
VatId xs:int
VatPercentage xs:decimal
PurchaseOrderRowId xs:int
Description optional xs:string
Barcode xs:long
Amount xs:decimal
DirectReservationAmount xs:decimal
NumberOfPackages xs:decimal
QtyPerPackage xs:int
IsCancelled xs:boolean
Note1 optional xs:string
Note2 optional xs:string
MiscInfo optional xs:string
DiscountPrice xs:decimal
DiscountPercentage xs:decimal
VatRequired xs:boolean
DiscountType DiscountType Simple Type
IsNoDiscounts xs:boolean
IsNoDiscountOnDiscount xs:boolean
IsSale xs:boolean
IsParentRow xs:boolean
IsDropshipment xs:boolean
PcePurchasePrice xs:decimal
PceGrossPrice xs:decimal
PceNetPrice xs:decimal
TotalGrossPrice xs:decimal
TotalNetPrice xs:decimal
TotalVat xs:decimal
WeightedTotalNetPrice xs:decimal
PriceType SalePriceType Simple Type
RemainingAmount xs:decimal
DeliveredAmount xs:decimal
ReservedAmount xs:decimal
DeliveryDays xs:int
ApprovalNote optional xs:string
ApprovedAmount xs:decimal
ApprovedDeliveryDays xs:int
ConversionId xs:long
BasePceGrossPrice xs:decimal
SaleOrderNumber xs:int
SaleOrderReferenceCode optional xs:string
SaleOrderPrintedDateTime xs:dateTime
SaleOrderCreatedDateTime xs:dateTime
CustomerNumber xs:long
CustomerName optional xs:string
ProductNumber xs:long
ProductExternalCode optional xs:string
ProductDescription optional xs:string
ProductInformation optional xs:string
MainBarcode xs:long
BrandDescription optional xs:string
VatDescription optional xs:string
Stock xs:decimal
FreeStock xs:decimal
FutureStock xs:decimal
OpenSaleOrders xs:decimal
OpenReservations xs:decimal
ScannerNumber xs:int
SaleOrderStatus SaleOrderStatus Simple Type
SaleOrderType SaleOrderType Simple Type
SaleOrderClassId xs:int
SaleOrderExpectedDeliveryDate xs:dateTime
SaleOrderUtmostDeliveryDate xs:dateTime
SaleOrderClassDescription optional xs:string
OrderCode optional xs:string
Plu xs:int
CalculatedPurchaseUnitConsumerUnits xs:decimal
OrderedPurchaseUnits xs:decimal
PurchaseUnitCbmPerSingleUnit xs:decimal
PurchaseUnitTotalOrderedCbm xs:decimal
ProductPreferredSupplierId xs:int
OrderAtSupplierNumber xs:long
OrderAtSupplierName optional xs:string
ProductPreferredSupplierNumber xs:long
ProductPreferredSupplierName optional xs:string
DeviantInterbrancheOrdering xs:boolean
VatCode optional xs:string
ProductType ProductType Simple Type
SupplierGeneralApprovalStatus SaleOrderGeneralApprovalStatus Simple Type
SupplierDetailedApprovalStatus SaleOrderSupplierApprovalStatus Simple Type
TotalStockAtOtherStores xs:decimal
StockSpecificStore xs:decimal
FreeStockSpecificStore xs:decimal
FutureStockSpecificStore xs:decimal
See Also
All Operations Resource Group | ProductBaseComponents Web Service

 

 

© 2020 All Rights Reserved.

Send comments on this topic.