Data information
The information below tells you more about the SQL table where AGR houses this data, its importance and an external link to more information about the SQL table.
Importance | If applicable |
Description | Historical consumption on BOM components and products |
Criteria | Stock transactions where BOM components are consumed into the assembly / production of the BOM product |
Primary key | PRODUCT_ITEM_NO, LOCATION_NO, DATE |
Table documentation |
Column and type
The information below breaks down the data for this SQL table into columns, descriptions and types.
Column | Functional description | Type |
PRODUCT_ITEM_NO | The item that's being sold, refers to NO in Item | nvarchar(255) |
LOCATION_NO | The location where the item is sold, corresponds to NO in raw.location | nvarchar(255) |
DATE | The actual date of the sale transaction | date |
UNIT QTY | The total quantity sold of a given item in the given location on this date. (Sum of all POS transactions/sales on this date for the item) | decimal(18,4) |