AggregatePaymentDeclarations
Model
Aggregation generated from all payments
Nullable
PaymentTypeStringID :
number (int)
The dimensioned PaymentTypeStringID
Nullable
Created_TerminalStringID :
number (int)
The dimensioned Created_TerminalStringID
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_AmountDeclared :
number (decimal)
Aggregation of all Amount Declared columns for this time period
Nullable
decimal(28, 2)
Total_QtyDeclared :
number (decimal)
Aggregation of all Qty Declared (count) columns for this time period
Nullable
decimal(28, 2)
Total_AmountDeclaredVariance :
number (decimal)
Aggregation of all Amount Declared Variance 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
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
{
"PaymentTypeStringID": 321,
"Created_TerminalStringID": 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_AmountDeclared": 1.23,
"Total_QtyDeclared": 1.23,
"Total_AmountDeclaredVariance": 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",
"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"
}