Nullable

StocktakeID : string (GUID)

The dimensioned Stocktake ID that this movement is assigned to (or null if the movement hasn't yet been assigned a stocktake)

Nullable

StocktakeCounter : number (int)

The dimensioned StocktakeCounter that this movement is assigned to (or null if the movement hasn't yet been assigned a stocktake)

Nullable

MovementType : number (int)

The dimensioned MovementType enum for Sale, Wastage, Transfer etc

Nullable decimal(28, 7)

Total_FIFOCostSalesAttributed : number (decimal)

Aggregation of all FIFOCostSalesAttributed columns for this time period

Nullable decimal(28, 7)

Total_FIFOCostAttributed : number (decimal)

Aggregation of all FIFOCostAttributed columns for this time period

Nullable decimal(28, 7)

Total_LastCostSalesAttributed : number (decimal)

Aggregation of all LastCostSalesAttributed columns for this time period

Nullable decimal(28, 7)

Total_LastCostAttributed : number (decimal)

Aggregation of all LastCostAttributed columns for this time period

Nullable decimal(28, 7)

Total_FIFOCostSalesEstimated : number (decimal)

Aggregation of all FIFOCostSalesEstimated columns for this time period

Nullable decimal(28, 7)

Total_FIFOCostEstimated : number (decimal)

Aggregation of all FIFOCostEstimated columns for this time period

Nullable decimal(28, 7)

Total_ActualCost : number (decimal)

Aggregation of all ActualCost columns for this time period

Nullable

Count_FIFOCostSalesEstimated : number (int)

Count of the number of records that contain estimated FIFO sales for this time period

Nullable

Count_FIFOCostEstimated : number (int)

Count of the number of records that contain estimated FIFO costs for this time period

Nullable decimal(28, 7)

Total_StockQtyMovement : number (decimal)

Aggregation of all StockQtyMovement columns for this time period

Nullable

StockItemStringID : number (int)

The dimensioned StockItemStringID value

Nullable

StockItemStringID_ItemType : number (int)

Nullable

StockItemStringID_ItemReferenceID : string (GUID)

Nullable

StockItemStringID_SalesModifierID : string (GUID)

Nullable

StockItemStringID_PortionUOMConversionFactor : number (decimal)

Nullable

StockItemStringID_PortionSize : number (decimal)

Nullable

StockItemStringID_QtyProducedPerRecipe : number (decimal)

Nullable

StockItemStringID_Reporting_ItemCommonName : string

Nullable

StockItemStringID_Reporting_ItemLocalizedName : string

Nullable

StockItemStringID_Reporting_SaleModifierCommonName : string

Nullable

StockItemStringID_Reporting_SaleModifierLocalizedName : string

Nullable

StockItemStringID_Reporting_SaleModifierPrefixCommonName : string

Nullable

StockItemStringID_Reporting_SaleModifierPrefixLocalizedName : string

Nullable

StockItemStringID_Reporting_SupplierProductCode : string

Nullable

StockItemStringID_Reporting_SupplierProductName : string

Nullable

StockItemStringID_Reporting_PLU : string

Nullable

StockItemStringID_Reporting_PortionUOMCommonName : string

Nullable

StockItemStringID_Reporting_PortionUOMLocalizedName : string

Nullable

StockItemStringID_Reporting_PortionUOMSuffixCommonName : string

Nullable

StockItemStringID_Reporting_PortionUOMSuffixLocalizedName : string

Nullable

Stock_GroupStringID : number (int)

The dimensioned Stock_GroupStringID value

Nullable

Stock_GroupStringID_GroupStringType : number (int)

Nullable

Stock_GroupStringID_Reporting_GroupCommonName : string

Nullable

Stock_GroupStringID_Reporting_GroupLocalizedName : string

Nullable

Stock_GroupStringID_Reporting_MainGroupCommonName : string

Nullable

Stock_GroupStringID_Reporting_MainGroupLocalizedName : string

Nullable

TerminalStringID : number (int)

The dimensioned TerminalStringID value

Nullable

TerminalStringID_Reporting_OutletGroupCommonName : string

Nullable

TerminalStringID_Reporting_OutletGroupLocalizedName : string

Nullable

TerminalStringID_Reporting_OutletCommonName : string

Nullable

TerminalStringID_Reporting_OutletLocalizedName : string

Nullable

TerminalStringID_Reporting_TerminalCommonName : string

Nullable

TerminalStringID_Reporting_TerminalLocalizedName : string

Nullable

TerminalStringID_Reporting_TerminalDisplayID : string

Nullable

TerminalStringID_OutletID : string (GUID)

Nullable

PhysicalStockLocationStringID : number (int)

The dimensioned PhysicalStockLocationStringID value

Nullable

PhysicalStockLocationStringID_PhysicalStockLocationID : string (GUID)

Nullable

PhysicalStockLocationStringID_Reporting_PhysicalStockLocationCommonOuterGroupingName : string

Nullable

PhysicalStockLocationStringID_Reporting_PhysicalStockLocationLocalizedOuterGroupingName : string

Nullable

PhysicalStockLocationStringID_Reporting_PhysicalStockLocationCommonName : string

Nullable

PhysicalStockLocationStringID_Reporting_PhysicalStockLocationLocalizedName : string

Nullable

Sale_GroupStringID : number (int)

The dimensioned Sale_GroupStringID value

Nullable

Sale_GroupStringID_GroupStringType : number (int)

Nullable

Sale_GroupStringID_Reporting_GroupCommonName : string

Nullable

Sale_GroupStringID_Reporting_GroupLocalizedName : string

Nullable

Sale_GroupStringID_Reporting_MainGroupCommonName : string

Nullable

Sale_GroupStringID_Reporting_MainGroupLocalizedName : string

Nullable

Sale_SalesTransactionItemStringID : number (int)

Dimensioned value for Sale_SalesTransactionItemStringID

Nullable

Sale_SalesTransactionItemStringID_ItemType : number (int)

Nullable

Sale_SalesTransactionItemStringID_ItemReferenceID : string (GUID)

Nullable

Sale_SalesTransactionItemStringID_RecipeID : string (GUID)

Nullable

Sale_SalesTransactionItemStringID_Reporting_ItemCommonName : string

Nullable

Sale_SalesTransactionItemStringID_Reporting_ItemLocalizedName : string

Nullable

Sale_SalesTransactionItemStringID_Reporting_SaleModifierCommonName : string

Nullable

Sale_SalesTransactionItemStringID_Reporting_SaleModifierLocalizedName : string

Nullable

Sale_SalesTransactionItemStringID_Reporting_SaleModifierPrefixCommonName : string

Nullable

Sale_SalesTransactionItemStringID_Reporting_SaleModifierPrefixLocalizedName : string

Nullable

Sale_SalesTransactionItemStringID_Reporting_VariantCommonName : string

Nullable

Sale_SalesTransactionItemStringID_Reporting_VariantLocalizedName : string

Nullable

Sale_SalesTransactionItemStringID_Reporting_VariantPostfixCommonName : string

Nullable

Sale_SalesTransactionItemStringID_Reporting_VariantPostfixLocalizedName : string

Nullable

Sale_SalesTransactionItemStringID_Reporting_PLU : string

Nullable

Sale_ServiceModeStringID : number (int)

Dimensioned value for Sale_ServiceModeStringID

Nullable

Sale_ServiceModeStringID_Reporting_ServiceModeCommonName : string

Nullable

Sale_ServiceModeStringID_Reporting_ServiceModeLocalizedName : string

Nullable

Sale_ServiceModeStringID_Reporting_ServiceModeCommonShortPrefix : string

Nullable

Sale_ServiceModeStringID_Reporting_ServiceModeLocalizedShortPrefix : string

Nullable

Sale_ServiceModeStringID_Reporting_CourseBreakCommonName : string

Nullable

Sale_ServiceModeStringID_Reporting_CourseBreakLocalizedName : string

Nullable

Sale_EventStringID : number (int)

The dimensioned Sale_EventStringID value

Nullable

Sale_EventStringID_Reporting_EventCommonName : string

Nullable

Sale_EventStringID_Reporting_EventLocalizedName : string

Nullable

Sale_Cost_CostCenterStringID : number (int)

Dimensioned value for Sale_Cost_CostCenterStringID

Nullable

Sale_Cost_CostCenterStringID_Reporting_CostCenterCommonName : string

Nullable

Sale_Cost_CostCenterStringID_Reporting_CostCenterLocalizedName : string

Nullable

Sale_Revenue_CostCenterStringID : number (int)

Dimensioned value for Sale_Revenue_CostCenterStringID

Nullable

Sale_Revenue_CostCenterStringID_Reporting_CostCenterCommonName : string

Nullable

Sale_Revenue_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