StatisticsComponents Web Service
Method/GetStatistics600
StatisticsComponents Web Service > All Operations Resource Group : /GetStatistics600 (Method)
Description
The GetStatistics600 function returns the statistics and stock by product.
Request (GetStatistics600SoapIn)

The request body is of type GetStatistics600.

Request Body Parameters

NameDescriptionData Type
statisticsFilter StatisticsFilter
saleRowsFilter SaleRowsFilter
productsFilter ProductsFilter
deltaType DeltaType
deltaType 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 GroupBy Element Sequence GroupBy Element SeparateKnownFromUnknownPurchases Element ReceivedProductsDateTo Element ReceivedProductsDateFrom Element IsUsedLoyaltyCardsOnly Element LoyaltyCardNumber Element LoyaltyCardTypeId Element GrossProfitPercentageTo Element GrossProfitPercentageFrom Element PurchasePrice Element PurchasePriceFilter Element SalePrice Element SalePriceFilter Element SaleAmount Element SaleAmountFilter Element GrossNetRelationFilter Element IsScannedOnly Element WeekDay Element StockReferenceDate2 Element StockReferenceDate1 Element DateToPeriod2 Element DateFromPeriod2 Element Sequence statisticsFilter Element Sequence GetStatistics600 Element

Overview

GetStatistics600
Sequence
statisticsFilter optional StatisticsFilter Complex Type
Sequence
DateFromPeriod2 xs:dateTime
DateToPeriod2 xs:dateTime
StockReferenceDate1 xs:dateTime
StockReferenceDate2 xs:dateTime
WeekDay WeekDay Simple Type
IsScannedOnly BooleanFilter Simple Type
GrossNetRelationFilter ComparisonType Simple Type
SaleAmountFilter ComparisonType Simple Type
SaleAmount xs:decimal
SalePriceFilter ComparisonType Simple Type
SalePrice xs:decimal
PurchasePriceFilter ComparisonType Simple Type
PurchasePrice xs:decimal
GrossProfitPercentageFrom xs:decimal
GrossProfitPercentageTo xs:decimal
LoyaltyCardTypeId xs:int
LoyaltyCardNumber xs:long
IsUsedLoyaltyCardsOnly BooleanFilter Simple Type
ReceivedProductsDateFrom xs:dateTime
ReceivedProductsDateTo xs:dateTime
SeparateKnownFromUnknownPurchases BooleanFilter Simple Type
GroupBy optional ArrayOfGroupBy Complex Type
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
deltaType DeltaType Simple Type
Response (GetStatistics600SoapOut)

The response body is of type GetStatistics600Response.

Response Body Parameters

NameDescriptionData Type
GetStatistics600Result Statistics600Info
Statistics600RowInfo Element Sequence StatisticsRows Element HistoricalStockSupport Element Period2Support Element GroupBySupport Element DeltaType Element IsHasPeriod2 Element LocalizedInformation Element LocalizedName Element Information Element Name Element Number Element Sequence GetStatistics600Result Element Sequence GetStatistics600Response Element

Overview

GetStatistics600Response
Sequence
GetStatistics600Result optional Statistics600Info Complex Type
Sequence
Number xs:int
Name optional xs:string
Information optional xs:string
LocalizedName optional xs:string
LocalizedInformation optional xs:string
IsHasPeriod2 xs:boolean
DeltaType DeltaType Simple Type
GroupBySupport xs:boolean
Period2Support xs:boolean
HistoricalStockSupport xs:boolean
StatisticsRows optional ArrayOfStatistics600RowInfo Complex Type
Sequence
Statistics600RowInfo 0..∞ Statistics600RowInfo Complex Type
Sequence
DeltaType DeltaType Simple Type
PurchasePrice xs:decimal
TotalGrossPrice xs:decimal
SellingPriceExcl xs:decimal
SellingPriceIncl xs:decimal
Vat xs:decimal
Margin xs:decimal
Discount xs:decimal
GrossProfitPercentage xs:decimal
SellingPricePercentage xs:decimal
PurchasePricePeriod2 xs:decimal
TotalGrossPricePeriod2 xs:decimal
SellingPriceExclPeriod2 xs:decimal
SellingPriceInclPeriod2 xs:decimal
VatPeriod2 xs:decimal
MarginPeriod2 xs:decimal
DiscountPeriod2 xs:decimal
GrossProfitPercentagePeriod2 xs:decimal
SellingPricePercentagePeriod2 xs:decimal
PurchasePriceDelta xs:decimal
TotalGrossPriceDelta xs:decimal
SellingPriceExclDelta xs:decimal
SellingPriceInclDelta xs:decimal
VatDelta xs:decimal
MarginDelta xs:decimal
DiscountDelta xs:decimal
GrossProfitPercentageDelta xs:decimal
SellingPricePercentageDelta xs:decimal
Year xs:int
Month Months Simple Type
Week xs:int
Day xs:int
WeekDay DaysOfWeek Simple Type
DayPart xs:int
Hour xs:int
Store optional xs:string
Products xs:decimal
PhysicalTouches xs:int
GroupTouches xs:int
TotalTouches xs:int
Customers xs:int
ProductsPeriod2 xs:decimal
PhysicalTouchesPeriod2 xs:int
GroupTouchesPeriod2 xs:int
TotalTouchesPeriod2 xs:int
CustomersPeriod2 xs:int
ProductsDelta xs:decimal
PhysicalTouchesDelta xs:decimal
GroupTouchesDelta xs:decimal
TotalTouchesDelta xs:decimal
CustomersDelta xs:decimal
Stock xs:decimal
StockValue xs:decimal
StockPeriod2 xs:decimal
StockValuePeriod2 xs:decimal
StockDelta xs:decimal
StockValueDelta xs:decimal
CashRegisterGroupCode optional xs:string
CashRegisterGroupDescription optional xs:string
TurnOverRate xs:decimal
AveragePurchasePriceExcl xs:decimal
AverageSalePriceIncl xs:decimal
AverageSalePriceInclPeriod2 xs:decimal
AverageSalePriceInclDelta xs:decimal
See Also
All Operations Resource Group | StatisticsComponents Web Service

 

 

© 2020 All Rights Reserved.

Send comments on this topic.