FinancialComponents Web Service
Method/GetCashSaleRows
FinancialComponents Web Service > All Operations Resource Group : /GetCashSaleRows (Method)
Description
The GetCashSaleRows function returns all CashSaleRows.
Request (GetCashSaleRowsSoapIn)

The request body is of type GetCashSaleRows.

Request Body Parameters

NameDescriptionData Type
saleRowsFilter SaleRowsFilter
productsFilter ProductsFilter
offset xml:int
recordCount xml:int
orderBy xml:string
orderBy Element recordCount Element offset Element StandbyProductsOnly Element EslBarcode Element EslProductsOnly Element RelatedProductsType Element ShelfDisplayId Element ExternalProductsOnly Element IncludedInActiveShelfDisplay Element ShelfProductsAndLocalOnly Element GetArticlesOfCancelledSuppliers Element AtLeast1AvailableForOrderingPurchase Element AtLeast1NotCancelledPurchase Element CollectionProducts Element AreReplacedProducts Element ReplacedProducts Element PriceBlocked Element SaleArticle Element FashionProduct Element OrderMethod Element ReplacementProductId Element DisposalFeeId Element SubBrandId Element IsCalculateMargins Element IsAutoOrderOnly Element FreeStockFilter Element FreeStock Element StockFilter Element Stock Element WithImageOnly Element IsHasNote1Only Element CombinedIdentificationNumber Element IsConsignmentProductsOnly Element ProductState Element StoreTypeId Element AlternateStockStoreId Element StoreNumber Element StoreId Element Plu Element GiftCardTypeId Element IsGiftCardOnly Element ColorId Element SizeId Element SizeTypeId Element ParentProductId Element IsIgnoreCancelledProducts Element IsSmartSearch Element IsWebshopProductsOnly Element IsColorProductsOnly Element IsIncludeParentProducts Element IsParentProductsOnly Element IsProductGroup Element IsAllowMultiplePricing Element IsIncludeInStockValue Element StockModificationDateTo Element StockModificationDateFrom Element IsStockModification Element LastModifiedUntilDateTime Element LastModifiedSinceDateTime Element DiscountFilter Element VatId Element CashRegisterGroupId Element PurchaseAssortmentId Element PurchaseStoreTypeDifferentationId Element PurchaseSeasonProfileId Element PurchaseIsActiveOnly Element PurchaseUnitBarcode Element OrderCode Element IsIgnoreSupplierIdForProductsWithNoSupplier Element SupplierId Element LanguageId Element CountryId Element BarcodeText Element Barcode Element ArticleGroupId Element int Element Sequence AssortmentIds Element PreferredSupplierId Element BrandId Element ProductCategoryId Element ClassificationGroupId Element ClassificationLevel5Id Element ClassificationLevel4Id Element ClassificationLevel3Id Element ClassificationLevel2Id Element ClassificationLevel1Id Element Note1 Element Description Element SearchText Element ExternalCode Element ProductType Element ProductNumber Element ExternalProductId Element Sequence productsFilter Element ReceivedProductRowId Element IsVatFreeOnly Element WebshopOnly Element WebshopId Element AssortmentId Element IsUsedLoyaltyCardsOnly Element LoyaltyCardTypeId Element PaymentCardIdentifier Element PaymentReference Element ReturnedSaleRowId Element LoyaltyCardNumber Element TotalWeightedNetSale2 Element TotalWeightedNetSaleFilter2 Element TotalWeightedNetSale1 Element TotalWeightedNetSaleFilter1 Element TotalNetSale2 Element TotalNetSaleFilter2 Element TotalNetSale1 Element TotalNetSaleFilter1 Element TransactionNetSale2 Element TransactionNetSaleFilter2 Element TransactionNetSale1 Element TransactionNetSaleFilter1 Element CashInvoiceType Element IsMarginOutOfProductCategoryRangeOnly Element IsReturnedSaleRowsOnly Element IsExportedOnly Element IsInvoicedOnly Element IsBadProfitOnly Element IsSaleOnly Element IsHasDiscountsOnly Element DiscountReasonId Element DiscountType Element PriceDifferenceType Element ConversionId Element ReceiptNumberTo Element ReceiptNumberFrom Element ReceiptId Element TransactionNumber Element ProductListId Element FiscalInterchangeCode Element PosTerminalCategoryId Element PosTerminalId Element UserId Element SaleTypeId Element PromotionId Element MixedMatchId Element ReservationRowId Element VatId Element VatPercentage Element ProductId Element PaymentTypeId Element DebtorId Element CustomerId Element InvoiceId Element SaleId Element LastModifiedDateTimeTo Element LastModifiedDateTimeFrom Element LastModifiedDateTo Element LastModifiedDateFrom Element CreatedDateTo Element CreatedDateFrom Element IgnoreSalesBeforeDate Element TransactionDateTo Element TransactionDateFrom Element Code Element StoreId Element PreviousDateTo Element ItemIdTo Element ItemIdFrom Element Sequence saleRowsFilter Element Sequence GetCashSaleRows Element

Overview

GetCashSaleRows
Sequence
saleRowsFilter optional SaleRowsFilter Complex Type
Sequence
ItemIdFrom xs:int
ItemIdTo xs:int
PreviousDateTo xs:dateTime
StoreId xs:int
Code optional xs:string
TransactionDateFrom xs:dateTime
TransactionDateTo xs:dateTime
IgnoreSalesBeforeDate xs:dateTime
CreatedDateFrom xs:dateTime
CreatedDateTo xs:dateTime
LastModifiedDateFrom xs:dateTime
LastModifiedDateTo xs:dateTime
LastModifiedDateTimeFrom xs:dateTime
LastModifiedDateTimeTo xs:dateTime
SaleId xs:int
InvoiceId xs:int
CustomerId xs:int
DebtorId xs:int
PaymentTypeId xs:int
ProductId xs:int
VatPercentage xs:decimal
VatId xs:int
ReservationRowId xs:int
MixedMatchId xs:int
PromotionId xs:int
SaleTypeId xs:int
UserId xs:int
PosTerminalId xs:int
PosTerminalCategoryId xs:int
FiscalInterchangeCode optional xs:string
ProductListId xs:int
TransactionNumber xs:int
ReceiptId xs:int
ReceiptNumberFrom xs:int
ReceiptNumberTo xs:int
ConversionId xs:long
PriceDifferenceType PriceDifferenceType Simple Type
DiscountType DiscountType Simple Type
DiscountReasonId xs:int
IsHasDiscountsOnly BooleanFilter Simple Type
IsSaleOnly BooleanFilter Simple Type
IsBadProfitOnly BooleanFilter Simple Type
IsInvoicedOnly xs:boolean
IsExportedOnly BooleanFilter Simple Type
IsReturnedSaleRowsOnly BooleanFilter Simple Type
IsMarginOutOfProductCategoryRangeOnly BooleanFilter Simple Type
CashInvoiceType CashInvoiceType Simple Type
TransactionNetSaleFilter1 ComparisonType Simple Type
TransactionNetSale1 xs:decimal
TransactionNetSaleFilter2 ComparisonType Simple Type
TransactionNetSale2 xs:decimal
TotalNetSaleFilter1 ComparisonType Simple Type
TotalNetSale1 xs:decimal
TotalNetSaleFilter2 ComparisonType Simple Type
TotalNetSale2 xs:decimal
TotalWeightedNetSaleFilter1 ComparisonType Simple Type
TotalWeightedNetSale1 xs:decimal
TotalWeightedNetSaleFilter2 ComparisonType Simple Type
TotalWeightedNetSale2 xs:decimal
LoyaltyCardNumber xs:long
ReturnedSaleRowId xs:int
PaymentReference optional xs:string
PaymentCardIdentifier optional xs:string
LoyaltyCardTypeId xs:int
IsUsedLoyaltyCardsOnly BooleanFilter Simple Type
AssortmentId xs:int
WebshopId xs:int
WebshopOnly BooleanFilter Simple Type
IsVatFreeOnly BooleanFilter Simple Type
ReceivedProductRowId xs:int
productsFilter optional ProductsFilter Complex Type
Sequence
ExternalProductId xs:int
ProductNumber xs:long
ProductType ProductType Simple Type
ExternalCode optional xs:string
SearchText optional xs:string
Description optional xs:string
Note1 optional xs:string
ClassificationLevel1Id xs:int
ClassificationLevel2Id xs:int
ClassificationLevel3Id xs:int
ClassificationLevel4Id xs:int
ClassificationLevel5Id xs:int
ClassificationGroupId xs:int
ProductCategoryId xs:int
BrandId xs:int
PreferredSupplierId xs:int
AssortmentIds optional ArrayOfInt Complex Type
Sequence
int 0..∞ xs:int
ArticleGroupId xs:int
Barcode xs:long
BarcodeText optional xs:string
CountryId xs:int
LanguageId xs:int
SupplierId xs:int
IsIgnoreSupplierIdForProductsWithNoSupplier xs:boolean
OrderCode optional xs:string
PurchaseUnitBarcode xs:long
PurchaseIsActiveOnly BooleanFilter Simple Type
PurchaseSeasonProfileId xs:int
PurchaseStoreTypeDifferentationId xs:int
PurchaseAssortmentId xs:int
CashRegisterGroupId xs:int
VatId xs:int
DiscountFilter DiscountFilter Simple Type
LastModifiedSinceDateTime xs:dateTime
LastModifiedUntilDateTime xs:dateTime
IsStockModification BooleanFilter Simple Type
StockModificationDateFrom xs:dateTime
StockModificationDateTo xs:dateTime
IsIncludeInStockValue BooleanFilter Simple Type
IsAllowMultiplePricing BooleanFilter Simple Type
IsProductGroup BooleanFilter Simple Type
IsParentProductsOnly BooleanFilter Simple Type
IsIncludeParentProducts BooleanFilter Simple Type
IsColorProductsOnly BooleanFilter Simple Type
IsWebshopProductsOnly BooleanFilter Simple Type
IsSmartSearch xs:boolean
IsIgnoreCancelledProducts BooleanFilter Simple Type
ParentProductId xs:int
SizeTypeId xs:int
SizeId xs:int
ColorId xs:int
IsGiftCardOnly BooleanFilter Simple Type
GiftCardTypeId xs:int
Plu xs:int
StoreId xs:int
StoreNumber xs:short
AlternateStockStoreId xs:int
StoreTypeId xs:int
ProductState SearchProductState Simple Type
IsConsignmentProductsOnly BooleanFilter Simple Type
CombinedIdentificationNumber optional xs:string
IsHasNote1Only BooleanFilter Simple Type
WithImageOnly BooleanFilter Simple Type
Stock xs:decimal
StockFilter ComparisonType Simple Type
FreeStock xs:decimal
FreeStockFilter ComparisonType Simple Type
IsAutoOrderOnly BooleanFilter Simple Type
IsCalculateMargins xs:boolean
SubBrandId xs:int
DisposalFeeId xs:int
ReplacementProductId xs:int
OrderMethod OrderMethod Simple Type
FashionProduct BooleanFilter Simple Type
SaleArticle BooleanFilter Simple Type
PriceBlocked BooleanFilter Simple Type
ReplacedProducts BooleanFilter Simple Type
AreReplacedProducts BooleanFilter Simple Type
CollectionProducts BooleanFilter Simple Type
AtLeast1NotCancelledPurchase BooleanFilter Simple Type
AtLeast1AvailableForOrderingPurchase BooleanFilter Simple Type
GetArticlesOfCancelledSuppliers BooleanFilter Simple Type
ShelfProductsAndLocalOnly BooleanFilter Simple Type
IncludedInActiveShelfDisplay BooleanFilter Simple Type
ExternalProductsOnly BooleanFilter Simple Type
ShelfDisplayId xs:int
RelatedProductsType RelatedProductsType Simple Type
EslProductsOnly BooleanFilter Simple Type
EslBarcode optional xs:string
StandbyProductsOnly BooleanFilter Simple Type
offset xs:int
recordCount xs:int
orderBy optional xs:string
Response (GetCashSaleRowsSoapOut)

The response body is of type GetCashSaleRowsResponse.

Response Body Parameters

NameDescriptionData Type
GetCashSaleRowsResult ArrayOfViewCashSaleRowInfo
ReceivedProductRowSalesQuantity Element ReceivedProductRowStock Element MaintainStock Element FreeStock Element Stock Element LoyaltyProviderId Element ProductShelfDisplayCode Element GS1EdiBuyerPartyNumber Element ProductState Element CostCenterExportCode Element DiscountReasonDescription Element SaleLedgerId Element PromotionVoucherCode Element PromotionVoucherDescription Element PromotionVoucherBarcode Element LoyaltyCardNumber Element ZipCode Element InvoicePaymentNote Element InvoicePaymentId Element PrePaymentNote Element PrePaymentNumber Element PrePaymentId Element CustomerName Element CustomerNumber Element CashRegisterGroupId Element TransactionTotalNetPrice Element TransactionTotalGrossPrice Element SupplierGs1Code Element SupplierExternalCode Element SupplierName Element SupplierNumber Element FinalSupplierId Element ReceivedProductSupplierId Element PreferredSupplierId Element SupplierId Element IsProductGroup Element ProductCategoryIsDoNotSendEPlato Element ArticleGroupCode Element ProductCategoryExportCode Element BrandGs1ExportCode Element BrandGs1Code Element ProductCategoryGs1ExportCode Element ProductCategoryGs1Code Element ProductCategoryExternalCode Element ProductCategoryDescription Element ProductCategoryCode Element TransactionTime Element TransactionDate Element PromotionDescription Element PromotionCode Element MixedMatchDescription Element ReceiptNumber Element SaleTypeDescription Element SaleTypeId Element SaleTypeExportCode Element SaleTypeCode Element SaleUserId Element SaleUserLoginName Element SaleUserFullName Element PosTerminalId Element PosTerminalNumber Element TransactionNumber Element ExternalProductCode Element ProductNote4 Element ProductNote3 Element ProductNote2 Element ProductNote1 Element ProductDescription Element MainBarcode Element OrderCode Element ProductNumber Element VatCode Element PceGrossPrice Element RowGrossProfitPercentage Element RowGrossProfitMargin Element GiftCardNumber Element BarcodeText Element BasePceGrossPrice Element TotalSavings Element LoyaltyWithdrawalPrice Element TotalVat Element PurchaseCalculated Element VatRequired Element WebshopId Element CostCenterId Element AssortmentId Element ConversionId Element IsSale Element TransactionDateTime Element WeightedTotalNetPrice Element TotalNetPrice Element IsNoDiscountOnDiscount Element TotalPrice Element ReceivedProductId Element SerialNumber Element TrackAndTraceId Element ReturnOfGoodsReasonText Element ReturnOfGoodsReasonId Element DiscountReasonId Element DiscountType Element DiscountPercentage Element DiscountPrice Element IsNoDiscounts Element TotalGrossPrice Element ConsumerUnitToSaleUnitFactor Element Amount Element PromotionId Element MixedMatchId Element ReservationRowId Element VatPercentage Element VatId Element BackupPcePurchasePrice Element PcePurchasePrice Element Note4 Element Note3 Element Note2 Element Note1 Element Description Element ParentSaleRowId Element ReturnedInvoiceSaleRowId Element ReturnedSaleRowId Element LocationLevel5Id Element ProductId Element CashSaleId Element StoreId Element CompanyId Element LastModifiedDateTime Element LastModifiedByUserId Element CreatedDateTime Element CreatedByUserId Element ItemId Element Sequence ViewCashSaleRowInfo Element Sequence GetCashSaleRowsResult Element Sequence GetCashSaleRowsResponse Element

Overview

GetCashSaleRowsResponse
Sequence
GetCashSaleRowsResult optional ArrayOfViewCashSaleRowInfo Complex Type
Sequence
ViewCashSaleRowInfo 0..∞ ViewCashSaleRowInfo Complex Type
Sequence
ItemId xs:int
CreatedByUserId xs:int
CreatedDateTime xs:dateTime
LastModifiedByUserId xs:int
LastModifiedDateTime xs:dateTime
CompanyId xs:int
StoreId xs:int
CashSaleId xs:int
ProductId xs:int
LocationLevel5Id xs:int
ReturnedSaleRowId xs:int
ReturnedInvoiceSaleRowId xs:int
ParentSaleRowId xs:int
Description optional xs:string
Note1 optional xs:string
Note2 optional xs:string
Note3 optional xs:string
Note4 optional xs:string
PcePurchasePrice xs:decimal
BackupPcePurchasePrice xs:decimal
VatId xs:int
VatPercentage xs:decimal
ReservationRowId xs:int
MixedMatchId xs:int
PromotionId xs:int
Amount xs:decimal
ConsumerUnitToSaleUnitFactor xs:decimal
TotalGrossPrice xs:decimal
IsNoDiscounts xs:boolean
DiscountPrice xs:decimal
DiscountPercentage xs:decimal
DiscountType DiscountType Simple Type
DiscountReasonId xs:int
ReturnOfGoodsReasonId xs:int
ReturnOfGoodsReasonText optional xs:string
TrackAndTraceId optional xs:string
SerialNumber optional xs:string
ReceivedProductId xs:int
TotalPrice xs:decimal
IsNoDiscountOnDiscount xs:boolean
TotalNetPrice xs:decimal
WeightedTotalNetPrice xs:decimal
TransactionDateTime xs:dateTime
IsSale xs:boolean
ConversionId xs:long
AssortmentId xs:int
CostCenterId xs:int
WebshopId xs:int
VatRequired xs:boolean
PurchaseCalculated xs:boolean
TotalVat xs:decimal
LoyaltyWithdrawalPrice xs:decimal
TotalSavings xs:decimal
BasePceGrossPrice xs:decimal
BarcodeText optional xs:string
GiftCardNumber optional xs:string
RowGrossProfitMargin xs:decimal
RowGrossProfitPercentage xs:decimal
PceGrossPrice xs:decimal
VatCode optional xs:string
ProductNumber xs:long
OrderCode optional xs:string
MainBarcode xs:long
ProductDescription optional xs:string
ProductNote1 optional xs:string
ProductNote2 optional xs:string
ProductNote3 optional xs:string
ProductNote4 optional xs:string
ExternalProductCode optional xs:string
TransactionNumber xs:int
PosTerminalNumber xs:int
PosTerminalId xs:int
SaleUserFullName optional xs:string
SaleUserLoginName optional xs:string
SaleUserId xs:int
SaleTypeCode optional xs:string
SaleTypeExportCode optional xs:string
SaleTypeId xs:int
SaleTypeDescription optional xs:string
ReceiptNumber xs:int
MixedMatchDescription optional xs:string
PromotionCode optional xs:string
PromotionDescription optional xs:string
TransactionDate xs:dateTime
TransactionTime xs:dateTime
ProductCategoryCode optional xs:string
ProductCategoryDescription optional xs:string
ProductCategoryExternalCode optional xs:string
ProductCategoryGs1Code xs:int
ProductCategoryGs1ExportCode xs:int
BrandGs1Code xs:long
BrandGs1ExportCode xs:long
ProductCategoryExportCode optional xs:string
ArticleGroupCode optional xs:string
ProductCategoryIsDoNotSendEPlato xs:boolean
IsProductGroup xs:boolean
SupplierId xs:int
PreferredSupplierId xs:int
ReceivedProductSupplierId xs:int
FinalSupplierId xs:int
SupplierNumber xs:long
SupplierName optional xs:string
SupplierExternalCode optional xs:string
SupplierGs1Code xs:long
TransactionTotalGrossPrice xs:decimal
TransactionTotalNetPrice xs:decimal
CashRegisterGroupId xs:int
CustomerNumber xs:long
CustomerName optional xs:string
PrePaymentId xs:int
PrePaymentNumber xs:int
PrePaymentNote optional xs:string
InvoicePaymentId xs:int
InvoicePaymentNote optional xs:string
ZipCode optional xs:string
LoyaltyCardNumber xs:long
PromotionVoucherBarcode xs:long
PromotionVoucherDescription optional xs:string
PromotionVoucherCode optional xs:string
SaleLedgerId xs:int
DiscountReasonDescription optional xs:string
CostCenterExportCode optional xs:string
ProductState ProductState Simple Type
GS1EdiBuyerPartyNumber xs:long
ProductShelfDisplayCode optional xs:string
LoyaltyProviderId xs:int
Stock xs:decimal
FreeStock xs:decimal
MaintainStock xs:boolean
ReceivedProductRowStock xs:decimal
ReceivedProductRowSalesQuantity xs:decimal
See Also
All Operations Resource Group | FinancialComponents Web Service

 

 

© 2020 All Rights Reserved.

Send comments on this topic.