AggregateNonSaleActivity
Model
Aggregation generated from Non Sale Activity
Nullable
NonSaleActivityStringID :
number (int)
The dimensioned NonSaleActivityStringID value
Nullable
Created_TerminalStringID :
number (int)
The dimensioned Created_TerminalStringID value
Nullable
Cashier_EmployeeStringID :
number (int)
The dimensioned Cashier_EmployeeStringID value
Nullable
PaymentTypeStringID :
number (int)
The dimensioned PaymentTypeStringID value
Nullable
RemarkStringID :
number (int)
The dimensioned RemarkStringID value
Nullable
ZReportStringID :
number (int)
The dimensioned ZReportStringID value
Nullable
decimal(28, 2)
Total_Amount :
number (decimal)
Aggregation of all Amount columns for this time period
Nullable
PaymentTypeStringID_Reporting_PaymentTypeCommonName :
string
Nullable
PaymentTypeStringID_Reporting_PaymentTypeLocalizedName :
string
Nullable
PaymentTypeStringID_Reporting_CreditCardMerchantID :
string
Nullable
PaymentTypeStringID_Reporting_CreditCardTerminalID :
string
Nullable
PaymentTypeStringID_Reporting_ServiceChargeCommonName :
string
Nullable
PaymentTypeStringID_Reporting_ServiceChargeLocalizedName :
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
Cashier_EmployeeStringID_Reporting_UserName :
string
Nullable
Cashier_EmployeeStringID_EmployeeID :
string (GUID)
Nullable
Cashier_EmployeeStringID_UserID :
string (GUID)
Nullable
NonSaleActivityStringID_ActionType :
number (int)
Nullable
NonSaleActivityStringID_Reporting_NonSaleActivityCommonName :
string
Nullable
NonSaleActivityStringID_Reporting_NonSaleActivityLocalizedName :
string
Nullable
RemarkStringID_Reporting_RemarkGroupCommonName :
string
Nullable
RemarkStringID_Reporting_RemarkGroupLocalizedName :
string
Nullable
RemarkStringID_Reporting_RemarkCommonName :
string
Nullable
RemarkStringID_Reporting_RemarkLocalizedName :
string
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
{
"NonSaleActivityStringID": 321,
"Created_TerminalStringID": 321,
"Cashier_EmployeeStringID": 321,
"PaymentTypeStringID": 321,
"RemarkStringID": 321,
"ZReportStringID": 321,
"Total_Amount": 1.23,
"PaymentTypeStringID_Reporting_PaymentTypeCommonName": "string value",
"PaymentTypeStringID_Reporting_PaymentTypeLocalizedName": "string value",
"PaymentTypeStringID_Reporting_CreditCardMerchantID": "string value",
"PaymentTypeStringID_Reporting_CreditCardTerminalID": "string value",
"PaymentTypeStringID_Reporting_ServiceChargeCommonName": "string value",
"PaymentTypeStringID_Reporting_ServiceChargeLocalizedName": "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",
"Cashier_EmployeeStringID_Reporting_UserName": "string value",
"Cashier_EmployeeStringID_EmployeeID": "3f49efe7-ea42-4f21-8718-7e6ce9a33512",
"Cashier_EmployeeStringID_UserID": "3f49efe7-ea42-4f21-8718-7e6ce9a33512",
"NonSaleActivityStringID_ActionType": 321,
"NonSaleActivityStringID_Reporting_NonSaleActivityCommonName": "string value",
"NonSaleActivityStringID_Reporting_NonSaleActivityLocalizedName": "string value",
"RemarkStringID_Reporting_RemarkGroupCommonName": "string value",
"RemarkStringID_Reporting_RemarkGroupLocalizedName": "string value",
"RemarkStringID_Reporting_RemarkCommonName": "string value",
"RemarkStringID_Reporting_RemarkLocalizedName": "string value",
"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"
}