AggregateTaxes
Model
Aggregation generated from finalised transactions
Nullable
ServiceModeStringID :
number (int)
The dimensioned ServiceModeStringID value
Nullable
Created_TerminalStringID :
number (int)
The dimensioned Created_TerminalStringID value
Nullable
EventStringID :
number (int)
The dimensioned EventStringID value
Nullable
TaxStringID :
number (int)
The dimensioned TaxStringID value
Nullable
CreatedBy_EmployeeStringID :
number (int)
The dimensioned CreatedBy_EmployeeStringID value
Nullable
OwnedBy_EmployeeStringID :
number (int)
The dimensioned OwnedBy_EmployeeStringID value
Nullable
TaxLevel :
number (int)
This will always be returned and is considered a Dimension
Nullable
ZReportStringID :
number (int)
The dimensioned ZReportStringID value
Nullable
decimal(28, 7)
Total_TaxSales :
number (decimal)
Aggregation of all TaxSales columns for this time period
Nullable
decimal(28, 7)
Total_IncTax :
number (decimal)
Aggregation of all IncTax columns for this time period
Nullable
decimal(28, 7)
Total_ExTax :
number (decimal)
Aggregation of all ExTax columns for this time period
Nullable
ServiceModeStringID_Reporting_ServiceModeCommonName :
string
Nullable
ServiceModeStringID_Reporting_ServiceModeLocalizedName :
string
Nullable
ServiceModeStringID_Reporting_ServiceModeCommonShortPrefix :
string
Nullable
ServiceModeStringID_Reporting_ServiceModeLocalizedShortPrefix :
string
Nullable
ServiceModeStringID_Reporting_CourseBreakCommonName :
string
Nullable
ServiceModeStringID_Reporting_CourseBreakLocalizedName :
string
Nullable
Created_TerminalStringID_Reporting_OutletGroupCommonName :
string
Nullable
Created_TerminalStringID_Reporting_OutletGroupLocalizedName :
string
Nullable
Created_TerminalStringID_Reporting_OutletCommonName :
string
Nullable
Created_TerminalStringID_Reporting_OutletLocalizedName :
string
Nullable
Created_TerminalStringID_Reporting_TerminalCommonName :
string
Nullable
Created_TerminalStringID_Reporting_TerminalLocalizedName :
string
Nullable
Created_TerminalStringID_Reporting_TerminalDisplayID :
string
Nullable
Created_TerminalStringID_OutletID :
string (GUID)
Nullable
EventStringID_Reporting_EventCommonName :
string
Nullable
EventStringID_Reporting_EventLocalizedName :
string
Nullable
TaxStringID_Reporting_TaxGroupCommonName :
string
Nullable
TaxStringID_Reporting_TaxGroupLocalizedName :
string
Nullable
TaxStringID_Reporting_TaxCommonName :
string
Nullable
TaxStringID_Reporting_TaxLocalizedName :
string
Nullable
CreatedBy_EmployeeStringID_Reporting_UserName :
string
Nullable
CreatedBy_EmployeeStringID_EmployeeID :
string (GUID)
Nullable
CreatedBy_EmployeeStringID_UserID :
string (GUID)
Nullable
OwnedBy_EmployeeStringID_Reporting_UserName :
string
Nullable
OwnedBy_EmployeeStringID_EmployeeID :
string (GUID)
Nullable
OwnedBy_EmployeeStringID_UserID :
string (GUID)
Nullable
ZReportStringID_Reporting_TradingDate :
string (ISO 8601 DateTime)
Nullable
ZReportStringID_ZReportCounter :
number (int)
Nullable
ZReportStringID_ZReportID :
string (GUID)
Nullable
DateStart :
string (ISO 8601 DateTime)
Nullable
DateStartPart :
number (int)
Nullable
Count :
number (int)
Nullable
Total_DBGen :
number (int)
Nullable
BaseCurrencyCode :
string
Nullable
decimal(18, 7)
BaseCurrencyRate :
number (decimal)
Nullable
CurrencyStringID :
number (int)
Nullable
CurrencyStringID_Reporting_CurrencyCode :
string
Nullable
CurrencyStringID_Reporting_CurrencySymbol :
string
Nullable
CurrencyStringID_Reporting_CurrencyCommonName :
string
Nullable
CurrencyStringID_Reporting_CurrencyLocalizedName :
string
Example
{
"ServiceModeStringID": 321,
"Created_TerminalStringID": 321,
"EventStringID": 321,
"TaxStringID": 321,
"CreatedBy_EmployeeStringID": 321,
"OwnedBy_EmployeeStringID": 321,
"TaxLevel": 321,
"ZReportStringID": 321,
"Total_TaxSales": 1.23,
"Total_IncTax": 1.23,
"Total_ExTax": 1.23,
"ServiceModeStringID_Reporting_ServiceModeCommonName": "string value",
"ServiceModeStringID_Reporting_ServiceModeLocalizedName": "string value",
"ServiceModeStringID_Reporting_ServiceModeCommonShortPrefix": "string value",
"ServiceModeStringID_Reporting_ServiceModeLocalizedShortPrefix": "string value",
"ServiceModeStringID_Reporting_CourseBreakCommonName": "string value",
"ServiceModeStringID_Reporting_CourseBreakLocalizedName": "string value",
"Created_TerminalStringID_Reporting_OutletGroupCommonName": "string value",
"Created_TerminalStringID_Reporting_OutletGroupLocalizedName": "string value",
"Created_TerminalStringID_Reporting_OutletCommonName": "string value",
"Created_TerminalStringID_Reporting_OutletLocalizedName": "string value",
"Created_TerminalStringID_Reporting_TerminalCommonName": "string value",
"Created_TerminalStringID_Reporting_TerminalLocalizedName": "string value",
"Created_TerminalStringID_Reporting_TerminalDisplayID": "string value",
"Created_TerminalStringID_OutletID": "3f49efe7-ea42-4f21-8718-7e6ce9a33512",
"EventStringID_Reporting_EventCommonName": "string value",
"EventStringID_Reporting_EventLocalizedName": "string value",
"TaxStringID_Reporting_TaxGroupCommonName": "string value",
"TaxStringID_Reporting_TaxGroupLocalizedName": "string value",
"TaxStringID_Reporting_TaxCommonName": "string value",
"TaxStringID_Reporting_TaxLocalizedName": "string value",
"CreatedBy_EmployeeStringID_Reporting_UserName": "string value",
"CreatedBy_EmployeeStringID_EmployeeID": "3f49efe7-ea42-4f21-8718-7e6ce9a33512",
"CreatedBy_EmployeeStringID_UserID": "3f49efe7-ea42-4f21-8718-7e6ce9a33512",
"OwnedBy_EmployeeStringID_Reporting_UserName": "string value",
"OwnedBy_EmployeeStringID_EmployeeID": "3f49efe7-ea42-4f21-8718-7e6ce9a33512",
"OwnedBy_EmployeeStringID_UserID": "3f49efe7-ea42-4f21-8718-7e6ce9a33512",
"ZReportStringID_Reporting_TradingDate": "2012-04-03T09:40:59.736Z",
"ZReportStringID_ZReportCounter": 321,
"ZReportStringID_ZReportID": "3f49efe7-ea42-4f21-8718-7e6ce9a33512",
"DateStart": "2012-04-03T09:40:59.736Z",
"DateStartPart": 321,
"Count": 321,
"Total_DBGen": 321,
"BaseCurrencyCode": "string value",
"BaseCurrencyRate": 1.23,
"CurrencyStringID": 321,
"CurrencyStringID_Reporting_CurrencyCode": "string value",
"CurrencyStringID_Reporting_CurrencySymbol": "string value",
"CurrencyStringID_Reporting_CurrencyCommonName": "string value",
"CurrencyStringID_Reporting_CurrencyLocalizedName": "string value"
}