Nullable

SalesTransactionItemStringID : number (int)

The dimensioned Sale's SalesTransactionItemStringID value

Nullable

ServiceModeStringID : number (int)

The dimensioned ServiceModeStringID value

Nullable

PriceLevelStringID : number (int)

The dimensioned PriceLevelStringID value

Nullable

Created_TerminalStringID : number (int)

The dimensioned Created_TerminalStringID value

Nullable

CreatedBy_EmployeeStringID : number (int)

The dimensioned CreatedBy_EmployeeStringID value

Nullable

OwnedBy_EmployeeStringID : number (int)

The dimensioned OwnedBy_EmployeeStringID value

Nullable

EventStringID : number (int)

The dimensioned EventStringID value

Nullable

TaxStringID : number (int)

The dimensioned TaxStringID value

Nullable

Revenue_CostCenterStringID : number (int)

The dimensioned Revenue_CostCenterStringID value

Nullable

Cost_CostCenterStringID : number (int)

The dimensioned Cost_CostCenterStringID value

Nullable

ZReportStringID : number (int)

The dimensioned ZReportStringID value

Nullable

Adjustment_SalesTransactionItemStringID : number (int)

The dimensioned Adjsutment's SalesTransactionItemStringID value

Nullable

AdjustmentRevenue_CostCenterStringID : number (int)

The dimensioned Adjsutment's Revenue_CostCenterStringID value

Nullable decimal(28, 2)

Total_Adjustment_Amount : number (decimal)

Aggregation of all Amount columns for this time period

Nullable decimal(28, 7)

Total_Adjustment_IncTax1 : number (decimal)

Aggregation of all IncTax1 columns for this time period

Nullable decimal(28, 7)

Total_Adjustment_IncTax2 : number (decimal)

Aggregation of all IncTax2 columns for this time period

Nullable decimal(28, 7)

Total_Adjustment_IncTax3 : number (decimal)

Aggregation of all IncTax3 columns for this time period

Nullable decimal(28, 7)

Total_Adjustment_IncTax4 : number (decimal)

Aggregation of all IncTax4 columns for this time period

Nullable decimal(28, 7)

Total_Adjustment_ExTax1 : number (decimal)

Aggregation of all ExTax1 columns for this time period

Nullable decimal(28, 7)

Total_Adjustment_ExTax2 : number (decimal)

Aggregation of all ExTax2 columns for this time period

Nullable decimal(28, 7)

Total_Adjustment_ExTax3 : number (decimal)

Aggregation of all ExTax3 columns for this time period

Nullable decimal(28, 7)

Total_Adjustment_ExTax4 : number (decimal)

Aggregation of all ExTax4 columns for this time period

Nullable

SalesTransactionItemStringID_ItemType : number (int)

Nullable

SalesTransactionItemStringID_ItemReferenceID : string (GUID)

Nullable

SalesTransactionItemStringID_RecipeID : string (GUID)

Nullable

SalesTransactionItemStringID_Reporting_ItemCommonName : string

Nullable

SalesTransactionItemStringID_Reporting_ItemLocalizedName : string

Nullable

SalesTransactionItemStringID_Reporting_SaleModifierCommonName : string

Nullable

SalesTransactionItemStringID_Reporting_SaleModifierLocalizedName : string

Nullable

SalesTransactionItemStringID_Reporting_SaleModifierPrefixCommonName : string

Nullable

SalesTransactionItemStringID_Reporting_SaleModifierPrefixLocalizedName : string

Nullable

SalesTransactionItemStringID_Reporting_VariantCommonName : string

Nullable

SalesTransactionItemStringID_Reporting_VariantLocalizedName : string

Nullable

SalesTransactionItemStringID_Reporting_VariantPostfixCommonName : string

Nullable

SalesTransactionItemStringID_Reporting_VariantPostfixLocalizedName : string

Nullable

SalesTransactionItemStringID_Reporting_PLU : string

Nullable

GroupStringID_Reporting_GroupCommonName : string

Nullable

GroupStringID_Reporting_GroupLocalizedName : string

Nullable

GroupStringID_Reporting_MainGroupCommonName : string

Nullable

GroupStringID_Reporting_MainGroupLocalizedName : string

Nullable

PriceLevelStringID_Reporting_PriceLevelCommonName : string

Nullable

PriceLevelStringID_Reporting_PriceLevelLocalizedName : string

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

CreatedBy_EmployeeStringID_Reporting_UserName : string

Nullable

CreatedBy_EmployeeStringID_UserID : string (GUID)

Nullable

CreatedBy_EmployeeStringID_EmployeeID : string (GUID)

Nullable

EventStringID_Reporting_EventCommonName : string

Nullable

EventStringID_Reporting_EventLocalizedName : string

Nullable

OwnedBy_EmployeeStringID_Reporting_UserName : string

Nullable

OwnedBy_EmployeeStringID_UserID : string (GUID)

Nullable

OwnedBy_EmployeeStringID_EmployeeID : string (GUID)

Nullable

TaxStringID_Reporting_TaxGroupCommonName : string

Nullable

TaxStringID_Reporting_TaxGroupLocalizedName : string

Nullable

TaxStringID_Reporting_Tax1CommonName : string

Nullable

TaxStringID_Reporting_Tax1LocalizedName : string

Nullable decimal(18, 3)

TaxStringID_Reporting_Tax1Rate : number (decimal)

Nullable

TaxStringID_Reporting_Tax2CommonName : string

Nullable

TaxStringID_Reporting_Tax2LocalizedName : string

Nullable decimal(18, 3)

TaxStringID_Reporting_Tax2Rate : number (decimal)

Nullable

TaxStringID_Reporting_Tax3CommonName : string

Nullable

TaxStringID_Reporting_Tax3LocalizedName : string

Nullable decimal(18, 3)

TaxStringID_Reporting_Tax3Rate : number (decimal)

Nullable

TaxStringID_Reporting_Tax4CommonName : string

Nullable

TaxStringID_Reporting_Tax4LocalizedName : string

Nullable decimal(18, 3)

TaxStringID_Reporting_Tax4Rate : number (decimal)

Nullable

Revenue_CostCenterStringID_Reporting_CostCenterCommonName : string

Nullable

Revenue_CostCenterStringID_Reporting_CostCenterLocalizedName : string

Nullable

Cost_CostCenterStringID_Reporting_CostCenterCommonName : string

Nullable

Cost_CostCenterStringID_Reporting_CostCenterLocalizedName : string

Nullable

ZReportStringID_Reporting_TradingDate : string (ISO 8601 DateTime)

Nullable

ZReportStringID_ZReportCounter : number (int)

Nullable

ZReportStringID_ZReportID : string (GUID)

Nullable

Adjustment_SalesTransactionItemStringID_ItemType : number (int)

Nullable

Adjustment_SalesTransactionItemStringID_ItemReferenceID : string (GUID)

Nullable

Adjustment_SalesTransactionItemStringID_RecipeID : string (GUID)

Nullable

Adjustment_SalesTransactionItemStringID_Reporting_ItemCommonName : string

Nullable

Adjustment_SalesTransactionItemStringID_Reporting_ItemLocalizedName : string

Nullable

Adjustment_SalesTransactionItemStringID_Reporting_SaleModifierCommonName : string

Nullable

Adjustment_SalesTransactionItemStringID_Reporting_SaleModifierLocalizedName : string

Nullable

Adjustment_SalesTransactionItemStringID_Reporting_SaleModifierPrefixCommonName : string

Nullable

Adjustment_SalesTransactionItemStringID_Reporting_SaleModifierPrefixLocalizedName : string

Nullable

Adjustment_SalesTransactionItemStringID_Reporting_VariantCommonName : string

Nullable

Adjustment_SalesTransactionItemStringID_Reporting_VariantLocalizedName : string

Nullable

Adjustment_SalesTransactionItemStringID_Reporting_VariantPostfixCommonName : string

Nullable

Adjustment_SalesTransactionItemStringID_Reporting_VariantPostfixLocalizedName : string

Nullable

Adjustment_SalesTransactionItemStringID_Reporting_PLU : string

Nullable

AdjustmentRevenue_CostCenterStringID_Reporting_CostCenterCommonName : string

Nullable

AdjustmentRevenue_CostCenterStringID_Reporting_CostCenterLocalizedName : string

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