Nullable

CorrectionTypeStringID : number (int)

The dimensioned CorrectionTypeStringID value

Nullable

SalesTransactionItemStringID : number (int)

The dimensioned SalesTransactionItemStringID value

Nullable

ServiceModeStringID : number (int)

The dimensioned ServiceModeStringID value

Nullable

CorrectedBy_TerminalStringID : number (int)

The dimensioned CorrectedBy_TerminalStringID value

Nullable

CorrectedBy_EmployeeStringID : number (int)

The dimensioned CorrectedBy_EmployeeStringID value

Nullable

EventStringID : number (int)

The dimensioned EventStringID value

Nullable

Revenue_CostCenterStringID : number (int)

The dimensioned Revenue_CostCenterStringID value

Nullable

RemarkStringID : number (int)

The dimensioned RemarkStringID value

Nullable

ZReportStringID : number (int)

The dimensioned ZReportStringID value

Nullable decimal(28, 2)

Total_AmountDifference : number (decimal)

Aggregation of all Amount difference columns for this time period

Nullable decimal(28, 2)

Total_PriceDifference : number (decimal)

Aggregation of all price difference columns for this time period

Nullable decimal(28, 7)

Total_StockQtyDifference : number (decimal)

Aggregation of all stock qty difference columns for this time period

Nullable decimal(28, 2)

Total_SaleQtyDifference : number (decimal)

Aggregation of all sale qty difference 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

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

CorrectedBy_TerminalStringID_Reporting_OutletGroupCommonName : string

Nullable

CorrectedBy_TerminalStringID_Reporting_OutletGroupLocalizedName : string

Nullable

CorrectedBy_TerminalStringID_Reporting_OutletCommonName : string

Nullable

CorrectedBy_TerminalStringID_Reporting_OutletLocalizedName : string

Nullable

CorrectedBy_TerminalStringID_Reporting_TerminalCommonName : string

Nullable

CorrectedBy_TerminalStringID_Reporting_TerminalLocalizedName : string

Nullable

CorrectedBy_TerminalStringID_Reporting_TerminalDisplayID : string

Nullable

CorrectedBy_TerminalStringID_OutletID : string (GUID)

Nullable

CorrectedBy_EmployeeStringID_Reporting_UserName : string

Nullable

CorrectedBy_EmployeeStringID_EmployeeID : string (GUID)

Nullable

CorrectedBy_EmployeeStringID_UserID : string (GUID)

Nullable

EventStringID_Reporting_EventCommonName : string

Nullable

EventStringID_Reporting_EventLocalizedName : string

Nullable

Revenue_CostCenterStringID_Reporting_CostCenterCommonName : string

Nullable

Revenue_CostCenterStringID_Reporting_CostCenterLocalizedName : string

Nullable

CorrectionTypeStringID_CorrectionTypeBaseType : number (int)

Nullable

CorrectionTypeStringID_Reporting_CorrectionTypeCommonName : string

Nullable

CorrectionTypeStringID_Reporting_CorrectionTypeLocalizedName : 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