FinancialComponents Web Service
Method/GetInvoiceSaleRows
FinancialComponents Web Service > All Operations Resource Group : /GetInvoiceSaleRows (Method)
Description
Get all available InvoiceSaleRows
Request (GetInvoiceSaleRowsSoapIn)

The request body is of type GetInvoiceSaleRows.

Request Body Parameters

NameDescriptionData Type
saleRowsFilter SaleRowsFilter
productsFilter ProductsFilter
offset xml:int
maxRecords xml:int
orderBy xml:string
orderBy Element maxRecords 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 GetInvoiceSaleRows Element

Overview

GetInvoiceSaleRows
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
maxRecords xs:int
orderBy optional xs:string
Response (GetInvoiceSaleRowsSoapOut)

The response body is of type GetInvoiceSaleRowsResponse.

Response Body Parameters

NameDescriptionData Type
GetInvoiceSaleRowsResult ArrayOfViewInvoiceSaleRowInfo
ReceivedProductRowSalesQuantity Element ReceivedProductRowStock Element MaintainStock Element FreeStock Element Stock Element LoyaltyProviderId Element ProductShelfDisplayCode Element GS1EdiBuyerPartyNumber Element ProductState Element CostCenterExportCode Element SaleOrderReferenceCode Element SaleOrderNumber Element DiscountReasonDescription Element SaleLedgerId Element PromotionVoucherCode Element PromotionVoucherDescription Element PromotionVoucherBarcode Element DebtorName Element DebtorNumber Element CustomerName Element CustomerNumber Element LoyaltyCardNumber Element ZipCode Element RowGrossProfitPercentage Element RowGrossProfitMargin Element SupplierGs1Code Element SupplierExternalCode Element SupplierName Element SupplierNumber Element FinalSupplierId Element GoodsInSupplierId Element PreferredSupplierId Element SupplierId Element IsProductGroup Element CashRegisterGroupDescription Element CashRegisterGroupId Element ProductCategoryIsDoNotSendEPlato Element ArticleGroupCode Element ProductCategoryExportCode Element ProductCategoryGs1ExportCode Element ProductCategoryGs1Code Element ProductCategoryExternalCode Element ProductCategoryDescription Element ProductCategoryCode Element PromotionDescription Element PromotionCode Element MixedMatchDescription Element BrandGs1ExportCode Element BrandGs1Code Element VatDescription Element VatCode Element ExternalProductCode Element ProductDescription Element Barcode Element OrderCode Element ProductNumber Element ReceiptNumber Element SaleTypeDescription Element SaleTypeExportCode Element SaleTypeCode Element SaleTypeId Element SaleUserId Element SaleUserLoginName Element SaleUserFullName Element PosTerminalNumber Element TransactionNumber Element GiftCardNumber Element BarcodeText Element BasePceGrossPrice Element TotalSavings Element ReceivedProductId Element PurchaseCalculated Element VatRequired Element WebshopId Element DisallowRecalculate Element CostCenterId Element AssortmentId Element ConversionId Element TransactionDateTime Element RowDisplayOrder Element TotalPrice Element PriceType Element WeightedDiscountPercentage Element WeightedDiscountPrice Element WeightedTotalNetPrice Element TotalNetPriceExVat Element TotalVat Element TotalNetPrice Element TotalGrossPrice Element PceNetPrice Element PceGrossPrice Element BackupPcePurchasePrice Element PcePurchasePrice Element ConsumerUnitToSaleUnitFactor Element Amount Element IsParentRow Element IsSale Element SerialNumber Element TrackAndTraceId Element IsNoDiscountOnDiscount Element IsNoDiscounts Element ReturnOfGoodsReasonText Element ReturnOfGoodsReasonId Element DiscountReasonId Element DiscountType Element LoyaltyWithdrawalPrice Element DiscountPercentage Element DiscountPrice Element MiscInfo Element Note4 Element Note3 Element Note2 Element Note1 Element Description Element VatPercentage Element VatId Element PromotionId Element QuantityPriceBreakId Element DiscountAgreementClassificationId Element MixedMatchId Element ReservationRowId Element LocationLevel5Id Element ProductId Element ReturnedInvoiceSaleRowId Element ReturnedSaleRowId Element RelatedSaleRowId Element InvoiceSaleId Element StoreId Element CompanyId Element LastModifiedDateTime Element LastModifiedByUserId Element CreatedDateTime Element CreatedByUserId Element ItemId Element Sequence ViewInvoiceSaleRowInfo Element Sequence GetInvoiceSaleRowsResult Element Sequence GetInvoiceSaleRowsResponse Element

Overview

GetInvoiceSaleRowsResponse
Sequence
GetInvoiceSaleRowsResult optional ArrayOfViewInvoiceSaleRowInfo Complex Type
Sequence
ViewInvoiceSaleRowInfo 0..∞ ViewInvoiceSaleRowInfo Complex Type
Sequence
ItemId xs:int
CreatedByUserId xs:int
CreatedDateTime xs:dateTime
LastModifiedByUserId xs:int
LastModifiedDateTime xs:dateTime
CompanyId xs:int
StoreId xs:int
InvoiceSaleId xs:int
RelatedSaleRowId xs:int
ReturnedSaleRowId xs:int
ReturnedInvoiceSaleRowId xs:int
ProductId xs:int
LocationLevel5Id xs:int
ReservationRowId xs:int
MixedMatchId xs:int
DiscountAgreementClassificationId xs:int
QuantityPriceBreakId xs:int
PromotionId xs:int
VatId xs:int
VatPercentage xs:decimal
Description optional xs:string
Note1 optional xs:string
Note2 optional xs:string
Note3 optional xs:string
Note4 optional xs:string
MiscInfo optional xs:string
DiscountPrice xs:decimal
DiscountPercentage xs:decimal
LoyaltyWithdrawalPrice xs:decimal
DiscountType DiscountType Simple Type
DiscountReasonId xs:int
ReturnOfGoodsReasonId xs:int
ReturnOfGoodsReasonText optional xs:string
IsNoDiscounts xs:boolean
IsNoDiscountOnDiscount xs:boolean
TrackAndTraceId optional xs:string
SerialNumber optional xs:string
IsSale xs:boolean
IsParentRow xs:boolean
Amount xs:decimal
ConsumerUnitToSaleUnitFactor xs:decimal
PcePurchasePrice xs:decimal
BackupPcePurchasePrice xs:decimal
PceGrossPrice xs:decimal
PceNetPrice xs:decimal
TotalGrossPrice xs:decimal
TotalNetPrice xs:decimal
TotalVat xs:decimal
TotalNetPriceExVat xs:decimal
WeightedTotalNetPrice xs:decimal
WeightedDiscountPrice xs:decimal
WeightedDiscountPercentage xs:decimal
PriceType SalePriceType Simple Type
TotalPrice xs:decimal
RowDisplayOrder xs:short
TransactionDateTime xs:dateTime
ConversionId xs:long
AssortmentId xs:int
CostCenterId xs:int
DisallowRecalculate xs:boolean
WebshopId xs:int
VatRequired xs:boolean
PurchaseCalculated xs:boolean
ReceivedProductId xs:int
TotalSavings xs:decimal
BasePceGrossPrice xs:decimal
BarcodeText optional xs:string
GiftCardNumber optional xs:string
TransactionNumber xs:int
PosTerminalNumber xs:int
SaleUserFullName optional xs:string
SaleUserLoginName optional xs:string
SaleUserId xs:int
SaleTypeId xs:int
SaleTypeCode optional xs:string
SaleTypeExportCode optional xs:string
SaleTypeDescription optional xs:string
ReceiptNumber xs:int
ProductNumber xs:long
OrderCode optional xs:string
Barcode xs:long
ProductDescription optional xs:string
ExternalProductCode optional xs:string
VatCode optional xs:string
VatDescription optional xs:string
BrandGs1Code xs:long
BrandGs1ExportCode xs:long
MixedMatchDescription optional xs:string
PromotionCode optional xs:string
PromotionDescription optional xs:string
ProductCategoryCode optional xs:string
ProductCategoryDescription optional xs:string
ProductCategoryExternalCode optional xs:string
ProductCategoryGs1Code xs:int
ProductCategoryGs1ExportCode xs:int
ProductCategoryExportCode optional xs:string
ArticleGroupCode optional xs:string
ProductCategoryIsDoNotSendEPlato xs:boolean
CashRegisterGroupId xs:int
CashRegisterGroupDescription optional xs:string
IsProductGroup xs:boolean
SupplierId xs:int
PreferredSupplierId xs:int
GoodsInSupplierId xs:int
FinalSupplierId xs:int
SupplierNumber xs:long
SupplierName optional xs:string
SupplierExternalCode optional xs:string
SupplierGs1Code xs:long
RowGrossProfitMargin xs:decimal
RowGrossProfitPercentage xs:decimal
ZipCode optional xs:string
LoyaltyCardNumber xs:long
CustomerNumber xs:long
CustomerName optional xs:string
DebtorNumber xs:long
DebtorName optional xs:string
PromotionVoucherBarcode xs:long
PromotionVoucherDescription optional xs:string
PromotionVoucherCode optional xs:string
SaleLedgerId xs:int
DiscountReasonDescription optional xs:string
SaleOrderNumber xs:int
SaleOrderReferenceCode 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.