Queries that can be applied over SalesTransaction data direct from the sales data (not using aggregate tables)
Nullable
SalesTransactionTags :
Inclusion
Whether to include Tags associated with this SalesTransaction
Nullable
SalesTransactionTipSummary :
Inclusion
Whether to include Tip Summaries associated with this SalesTransaction
Nullable
SalesTransactionItems :
Inclusion
Whether to include Items associated with this SalesTransaction
Nullable
SalesTransactionPayments :
Inclusion
Whether to include payments associated with this SalesTransaction
Nullable
SalesTransactionDescriptors :
Inclusion
Whether to include descriptors associated with this SalesTransaction
Nullable
SalesTransactionItemAdjustmentLinks :
Inclusion
Whether to include Item adjustments associated with this SalesTransaction
Nullable
SalesTransactionItemCorrections :
Inclusion
Whether to include corrections associated with this SalesTransaction
Nullable
SalesTransactionAuditLines :
Inclusion
Whether to include audit lines associated with this SalesTransaction
Nullable
SalesTransactionInterfaceItems :
Inclusion
Whether to include interface items associated with this SalesTransaction
Nullable
OrderBy :
SalesTransactionOrderable
[]
If specified, order the resulting data by these columns. Ordering will default to SalesTransactionID otherwise
Nullable
OrderByDirection :
OrderableDirection
If specified AND OrderBy is set, specify the direction that the OrderBy columns will use
Nullable
Limit :
number (int)
The maximum number of sales entries to return. If not specified will be set to MAX_LIMIT. If exceeding MAX_LIMIT it will be reduced to MAX_LIMIT
Nullable
From :
number (int)
0 based index to start seeking values from. If not specified NO pagination will be applied. There is no guarantee that a Query with From = 0 will be the
same a Query with From = null
ReportingStrings : bool
Entities normally have two sets of values for most common properties (primarily string properties): The original value from when it was uploaded and the "reporting" value
that may have been optionally renamed for reporting reasons.
If this is true, all the values filtered on and returned will be the renamed reporting values. If false, the values filtered on and returned wll be the original property values
Example
{
"SalesTransactionTags": {},
"SalesTransactionTipSummary": {},
"SalesTransactionItems": {},
"SalesTransactionPayments": {},
"SalesTransactionDescriptors": {},
"SalesTransactionItemAdjustmentLinks": {},
"SalesTransactionItemCorrections": {},
"SalesTransactionAuditLines": {},
"SalesTransactionInterfaceItems": {},
"OrderBy": [1],
"OrderByDirection": 1,
"Limit": 321,
"From": 321,
"ReportingStrings": true
}