Filters that can be applied over SalesTransaction data direct from the sales data (not using aggregate tables)
Nullable
IsTraining :
bool
Whether to filter on the "IsTraining" property. Null to perform no filtering
Nullable
IsFinalised :
bool
Whether to filter on DateTimeClosed being null or not. Null to perform no filtering
Nullable
ContainsDescriptors :
bool
Whether to filter out transactions that do/don't contain SalesTransactionDescriptors
Nullable
ContainsItemAdjustmentLinks :
bool
Whether to filter out transactions that do/don't contain SalesTransactionItemAdjustmentLinks
Nullable
ContainsCancelledPayments :
bool
Whether to filter out transactions that do/don't contain SalesTransactionPayments with IsPaymentCancelled set
Nullable
ContainsChangedPayments :
bool
Whether to filter out transactions that do/don't contain SalesTransactionPayments with IsPaymentChanged set
Nullable
ContainsTags :
bool
Whether to filter out transactions that do/don't contain SalesTransactionTags
Nullable
ContainsTipSummary :
bool
Whether to filter out transactions that do/don't contain SalesTransactionTipSummary
Nullable
ContainsPayments :
bool
Whether to filter out transactions that do/don't contain SalesTransactionPayments
Nullable
ContainsItems :
bool
Whether to filter out transactions that do/don't contain SalesTransactionItems
Nullable
ContainsItemCorrections :
bool
Whether to filter out transactions that do/don't contain SalesTransactionItemCorrections
Nullable
ContainsAuditLines :
bool
Whether to filter out transactions that do/don't contain SalesTransactionAuditLines
Nullable
SalesTransactionItemAdjustmentLinkFilter :
SalesTransactionItemAdjustmentLinkFilter
Whether to filter for a transaction containing at least one Item Adjustment Link that matches these filter conditions.
NOTE - Negations are only supported at the Top Level StringFilterCondition NegateCondition property. The individual ValueFilterCondition NegateConditions will not be assessed
Nullable
SalesTransactionItemCorrectionFilter :
SalesTransactionItemCorrectionFilter
Whether to filter for a transaction containing at least one Item Correction that matches these filter conditions.
NOTE - Negations are only supported at the Top Level StringFilterCondition NegateCondition property. The individual ValueFilterCondition NegateConditions will not be assessed
Nullable
SalesTransactionItemFilter :
SalesTransactionItemFilter
Whether to filter for a transaction containing at least one Item that matches these filter conditions.
NOTE - Negations are only supported at the Top Level StringFilterCondition NegateCondition property. The individual ValueFilterCondition NegateConditions will not be assessed
Nullable
SalesTransactionPaymentFilter :
SalesTransactionPaymentFilter
Whether to filter for a transaction containing at least one payment that matches these filter conditions.
NOTE - Negations are only supported at the Top Level StringFilterCondition NegateCondition property. The individual ValueFilterCondition NegateConditions will not be assessed
Nullable
DBGen :
RangeFilterCondition`1
Whether to filter on the "DBGen" property. The DBGen is an internal (incrementing) identifier for marking when data has been inserted/updated. Filtering will
allow the access to all the new/changed data from particular point in time.
Nullable
SalesTransactionID :
ValueFilterCondition`1
Whether to filter on the "SalesTransactionID" property
Nullable
DateTimeOpened :
RangeFilterCondition`1
Whether to filter on the "DateTimeOpened" property.
Nullable
DateTimeOpenedPart :
DateStartPartFilterCondition
Whether to filter on the "DateTimeOpened" property via DatePart
Nullable
DateTimeClosed :
RangeFilterCondition`1
Whether to filter on the "DateTimeClosed" property.
Nullable
DateTimeClosedPart :
DateStartPartFilterCondition
Whether to filter on the "DateTimeClosed" property via DatePart
Nullable
TradingDateTimeClosed :
RangeFilterCondition`1
Whether to filter on the combination of the date from TradingDate and time from "DateTimeClosed" property.
Nullable
TradingDateTimeClosedPart :
DateStartPartFilterCondition
Whether to filter on the combination of the date from TradingDate and time from "DateTimeClosed" property via DatePart
Nullable
OrderNumberOpened :
ValueFilterCondition`1
Whether to filter on the "OrderNumberOpened" property
Nullable
OrderNumberClosed :
ValueFilterCondition`1
Whether to filter on the "OrderNumberClosed" property
Nullable
Amount :
RangeFilterCondition`1
Whether to filter on the Amount field.
Nullable
Cost :
RangeFilterCondition`1
Whether to filter on the Cost field.
Nullable
Covers :
RangeFilterCondition`1
Whether to filter on the Covers field.
Nullable
ApplicationClientID :
ValueFilterCondition`1
Whether to filter on the internal ClientID that was used to submit the sale in the first place
Nullable
ApplicationClientStringIDs :
StringFilterCondition`1
Application client String ID's to Filter (or null if any are acceptable)
Whether Reporting_ values or the original values are filtered depends on the Query ReportingStrings property
Nullable
ServiceModeStringIDs :
StringFilterCondition`1
Service Mode String ID's to Filter (or null if any are acceptable)
Whether Reporting_ values or the original values are filtered depends on the Query ReportingStrings property
Nullable
Created_TerminalStringIDs :
StringFilterCondition`1
Created Terminal String ID's to Filter (or null if any are acceptable)
Whether Reporting_ values or the original values are filtered depends on the Query ReportingStrings property
Nullable
Closed_TerminalStringIDs :
StringFilterCondition`1
Closed Terminal String ID's to Filter (or null if any are acceptable)
Whether Reporting_ values or the original values are filtered depends on the Query ReportingStrings property
Nullable
EventStringIDs :
StringFilterCondition`1
Event String ID's to Filter (or null if any are acceptable)
Whether Reporting_ values or the original values are filtered depends on the Query ReportingStrings property
Nullable
CurrencyStringIDs :
StringFilterCondition`1
Currency String ID's to Filter (or null if any are acceptable)
Whether Reporting_ values or the original values are filtered depends on the Query ReportingStrings property
Nullable
TaxStringIDs :
StringFilterCondition`1
Tax String ID's to Filter (or null if any are acceptable)
Whether Reporting_ values or the original values are filtered depends on the Query ReportingStrings property
Nullable
CreatedBy_EmployeeStringIDs :
StringFilterCondition`1
Created By Employee String ID's to Filter (or null if any are acceptable)
Whether Reporting_ values or the original values are filtered depends on the Query ReportingStrings property
Nullable
ClosedBy_EmployeeStringIDs :
StringFilterCondition`1
Closed By Employee String ID's to Filter (or null if any are acceptable)
Whether Reporting_ values or the original values are filtered depends on the Query ReportingStrings property
Nullable
OwnedBy_EmployeeStringIDs :
StringFilterCondition`1
Owned By Employee String ID's to Filter (or null if any are acceptable)
Whether Reporting_ values or the original values are filtered depends on the Query ReportingStrings property
Nullable
ZReportStringIDs :
StringFilterCondition`1
ZReport String ID's to Filter (or null if any are acceptable)
Whether Reporting_ values or the original values are filtered depends on the Query ReportingStrings property
Example
{
"IsTraining": true,
"IsFinalised": true,
"ContainsDescriptors": true,
"ContainsItemAdjustmentLinks": true,
"ContainsCancelledPayments": true,
"ContainsChangedPayments": true,
"ContainsTags": true,
"ContainsTipSummary": true,
"ContainsPayments": true,
"ContainsItems": true,
"ContainsItemCorrections": true,
"ContainsAuditLines": true,
"SalesTransactionItemAdjustmentLinkFilter": {},
"SalesTransactionItemCorrectionFilter": {},
"SalesTransactionItemFilter": {},
"SalesTransactionPaymentFilter": {},
"DBGen": {},
"SalesTransactionID": {},
"DateTimeOpened": {},
"DateTimeOpenedPart": {},
"DateTimeClosed": {},
"DateTimeClosedPart": {},
"TradingDateTimeClosed": {},
"TradingDateTimeClosedPart": {},
"OrderNumberOpened": {},
"OrderNumberClosed": {},
"Amount": {},
"Cost": {},
"Covers": {},
"ApplicationClientID": {},
"ApplicationClientStringIDs": {},
"ServiceModeStringIDs": {},
"Created_TerminalStringIDs": {},
"Closed_TerminalStringIDs": {},
"EventStringIDs": {},
"CurrencyStringIDs": {},
"TaxStringIDs": {},
"CreatedBy_EmployeeStringIDs": {},
"ClosedBy_EmployeeStringIDs": {},
"OwnedBy_EmployeeStringIDs": {},
"ZReportStringIDs": {}
}