AggregatePayments
Model
Aggregation generated from all payments
Nullable
ServiceModeStringID :
number (int)
The dimensioned ServiceModeStringID
Nullable
PaymentTypeStringID :
number (int)
The dimensioned PaymentTypeStringID
Nullable
Foreign_CurrencyStringID :
number (int)
The dimensioned Foreign_CurrencyStringID
Nullable
Created_TerminalStringID :
number (int)
The dimensioned Created_TerminalStringID
Nullable
Cashier_EmployeeStringID :
number (int)
The dimensioned Cashier_EmployeeStringID
Nullable
OwnedBy_EmployeeStringID :
number (int)
The dimensioned OwnedBy_EmployeeStringID value
Nullable
EventStringID :
number (int)
The dimensioned EventStringID value
Nullable
Revenue_CostCenterStringID :
number (int)
The dimensioned Revenue_CostCenterStringID
Nullable
ZReportStringID :
number (int)
The dimensioned ZReportStringID value
Nullable
decimal(28, 2)
Total_AmountPaid :
number (decimal)
Aggregation of all AmountPaid columns for this time period
Nullable
decimal(28, 2)
Total_AmountChange :
number (decimal)
Aggregation of all AmountChange columns for this time period
Nullable
decimal(28, 2)
Total_AmountCashOut :
number (decimal)
Aggregation of all AmountCashout columns for this time period
Nullable
decimal(28, 2)
Total_AmountTip :
number (decimal)
Aggregation of all AmountTip columns for this time period
Nullable
decimal(28, 2)
Total_AmountServiceCharge :
number (decimal)
Aggregation of all AmountServiceCharge columns for this time period
Nullable
decimal(28, 2)
Total_AmountSurcharge :
number (decimal)
Aggregation of all AmountSurcharge columns for this time period
Nullable
decimal(28, 2)
Total_AmountRounded :
number (decimal)
Aggregation of all AmountRounded columns for this time period
Nullable
decimal(28, 2)
Total_ForeignCurrencyTendered :
number (decimal)
Aggregation of all ForeignCurrencyTendered columns for this time period
Nullable
decimal(28, 2)
Total_ForeignCurrencyChange :
number (decimal)
Aggregation of all ForeignCurrencyChange 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
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
Foreign_CurrencyStringID_Reporting_CurrencyCode :
string
Nullable
Foreign_CurrencyStringID_Reporting_CurrencySymbol :
string
Nullable
Foreign_CurrencyStringID_Reporting_CurrencyCommonName :
string
Nullable
Foreign_CurrencyStringID_Reporting_CurrencyLocalizedName :
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
EventStringID_Reporting_EventCommonName :
string
Nullable
EventStringID_Reporting_EventLocalizedName :
string
Nullable
OwnedBy_EmployeeStringID_Reporting_UserName :
string
Nullable
OwnedBy_EmployeeStringID_EmployeeID :
string (GUID)
Nullable
OwnedBy_EmployeeStringID_UserID :
string (GUID)
Nullable
Revenue_CostCenterStringID_Reporting_CostCenterCommonName :
string
Nullable
Revenue_CostCenterStringID_Reporting_CostCenterLocalizedName :
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
{
"ServiceModeStringID": 321,
"PaymentTypeStringID": 321,
"Foreign_CurrencyStringID": 321,
"Created_TerminalStringID": 321,
"Cashier_EmployeeStringID": 321,
"OwnedBy_EmployeeStringID": 321,
"EventStringID": 321,
"Revenue_CostCenterStringID": 321,
"ZReportStringID": 321,
"Total_AmountPaid": 1.23,
"Total_AmountChange": 1.23,
"Total_AmountCashOut": 1.23,
"Total_AmountTip": 1.23,
"Total_AmountServiceCharge": 1.23,
"Total_AmountSurcharge": 1.23,
"Total_AmountRounded": 1.23,
"Total_ForeignCurrencyTendered": 1.23,
"Total_ForeignCurrencyChange": 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",
"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",
"Foreign_CurrencyStringID_Reporting_CurrencyCode": "string value",
"Foreign_CurrencyStringID_Reporting_CurrencySymbol": "string value",
"Foreign_CurrencyStringID_Reporting_CurrencyCommonName": "string value",
"Foreign_CurrencyStringID_Reporting_CurrencyLocalizedName": "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",
"EventStringID_Reporting_EventCommonName": "string value",
"EventStringID_Reporting_EventLocalizedName": "string value",
"OwnedBy_EmployeeStringID_Reporting_UserName": "string value",
"OwnedBy_EmployeeStringID_EmployeeID": "3f49efe7-ea42-4f21-8718-7e6ce9a33512",
"OwnedBy_EmployeeStringID_UserID": "3f49efe7-ea42-4f21-8718-7e6ce9a33512",
"Revenue_CostCenterStringID_Reporting_CostCenterCommonName": "string value",
"Revenue_CostCenterStringID_Reporting_CostCenterLocalizedName": "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"
}