AggregatePredicttileStockMovements
Model
Aggregation generated from individual item stock movements
Nullable
StockMovementStringID :
number (int)
The dimensioned StockMovementStringID value
Nullable
TerminalStringID :
number (int)
The dimensioned TerminalStringID value
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
MovementType :
number (int)
The dimensioned MovementType enum for Sale, Wastage, Transfer etc
Nullable
MovementID :
string (GUID)
The dimensioned context ID associated linked to MovementType
Nullable
decimal(28, 7)
Total_AmountAttributed :
number (decimal)
Aggregation of all AmountAttributed columns for this time period
Nullable
decimal(28, 7)
Total_CostAttributed :
number (decimal)
Aggregation of all CostAttributed columns for this time period
Nullable
decimal(28, 7)
Total_StockQtyMovement :
number (decimal)
Aggregation of all StockQtyMovement columns for this time period
Nullable
StockMovementStringID_MasterProductGroupGUID :
string (GUID)
Nullable
StockMovementStringID_ContainerUnitGUID :
string (GUID)
Nullable
StockMovementStringID_Reporting_MasterProductGroupName :
string
Nullable
StockMovementStringID_Reporting_MasterProductGroupShortName :
string
Nullable
StockMovementStringID_Reporting_ContainerUnitName :
string
Nullable
StockMovementStringID_Reporting_ContainerUnitType :
string
Nullable
StockMovementStringID_Reporting_ContainerUnitSymbol :
string
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
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
{
"StockMovementStringID": 321,
"TerminalStringID": 321,
"StocktakeID": "3f49efe7-ea42-4f21-8718-7e6ce9a33512",
"MovementType": 321,
"MovementID": "3f49efe7-ea42-4f21-8718-7e6ce9a33512",
"Total_AmountAttributed": 1.23,
"Total_CostAttributed": 1.23,
"Total_StockQtyMovement": 1.23,
"StockMovementStringID_MasterProductGroupGUID": "3f49efe7-ea42-4f21-8718-7e6ce9a33512",
"StockMovementStringID_ContainerUnitGUID": "3f49efe7-ea42-4f21-8718-7e6ce9a33512",
"StockMovementStringID_Reporting_MasterProductGroupName": "string value",
"StockMovementStringID_Reporting_MasterProductGroupShortName": "string value",
"StockMovementStringID_Reporting_ContainerUnitName": "string value",
"StockMovementStringID_Reporting_ContainerUnitType": "string value",
"StockMovementStringID_Reporting_ContainerUnitSymbol": "string value",
"TerminalStringID_Reporting_OutletGroupCommonName": "string value",
"TerminalStringID_Reporting_OutletGroupLocalizedName": "string value",
"TerminalStringID_Reporting_OutletCommonName": "string value",
"TerminalStringID_Reporting_OutletLocalizedName": "string value",
"TerminalStringID_Reporting_TerminalCommonName": "string value",
"TerminalStringID_Reporting_TerminalLocalizedName": "string value",
"TerminalStringID_Reporting_TerminalDisplayID": "string value",
"TerminalStringID_OutletID": "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"
}