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 | Components used for BOM assembly |
Criteria | All BOM components that are supposed to be planned and ordered in AGR |
Primary key | ITEM_NO, COMPONENT_ITEM_NO |
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 |
ITEM_NO | Compound item, corresponds to NO in raw.item_info | nvarchar(255) |
COMPONENT_ITEM_NO | The component item, corresponds to NO in raw.item_info | nvarchar(255) |
QUANTITY | How many pieces of the component is needed in this item | decimal(18,4) |