http://retail3000.net/Retail3000Webservice/WebserviceStatisticsComponents
ExtendedStatisticsFilter Complex Type
http://retail3000.net/Retail3000Webservice/WebserviceStatisticsComponents : ExtendedStatisticsFilter Complex Type
Namespace http://retail3000.net/Retail3000Webservice/WebserviceStatisticsComponents
Diagram
ExcelExport_AverageRow Element ExcelExport_TotalsRow Element ExcelExport_AutoFit Element ExcelExport_ColumnSelectionId Element ExcelExport_ExcelTemplateId 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 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 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 GroupBy Element DeltaType Element StatisticsNumber Element Sequence ExtendedStatisticsFilter Complex Type
Overview
ExtendedStatisticsFilter
Sequence
StatisticsNumber xs:int
DeltaType DeltaType Simple Type
GroupBy GroupBy Simple Type
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
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
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
ExcelExport_ExcelTemplateId xs:int
ExcelExport_ColumnSelectionId xs:int
ExcelExport_AutoFit xs:boolean
ExcelExport_TotalsRow xs:boolean
ExcelExport_AverageRow xs:boolean
Source
<xs:complexType name="ExtendedStatisticsFilter" xmlns:xs="http://www.w3.org/2001/XMLSchema">
  <xs:sequence>
    <xs:element minOccurs="1" maxOccurs="1" name="StatisticsNumber" type="xs:int" />
    <xs:element minOccurs="1" maxOccurs="1" name="DeltaType" type="tns:DeltaType" />
    <xs:element minOccurs="1" maxOccurs="1" name="GroupBy" type="tns:GroupBy" />
    <xs:element minOccurs="0" maxOccurs="1" name="ProductsFilter" type="tns:ProductsFilter" />
    <xs:element minOccurs="0" maxOccurs="1" name="SaleRowsFilter" type="tns:SaleRowsFilter" />
    <xs:element minOccurs="0" maxOccurs="1" name="StatisticsFilter" type="tns:StatisticsFilter" />
    <xs:element minOccurs="1" maxOccurs="1" name="ExcelExport_ExcelTemplateId" type="xs:int" />
    <xs:element minOccurs="1" maxOccurs="1" name="ExcelExport_ColumnSelectionId" type="xs:int" />
    <xs:element minOccurs="1" maxOccurs="1" name="ExcelExport_AutoFit" type="xs:boolean" />
    <xs:element minOccurs="1" maxOccurs="1" name="ExcelExport_TotalsRow" type="xs:boolean" />
    <xs:element minOccurs="1" maxOccurs="1" name="ExcelExport_AverageRow" type="xs:boolean" />
  </xs:sequence>
</xs:complexType>
See Also
http://retail3000.net/Retail3000Webservice/WebserviceStatisticsComponents

 

 

© 2020 All Rights Reserved.

Send comments on this topic.