DW_NS_BomRevisionComponent_D
This table contains information about all the assemblies, sub-components used in a particular BOM revision.
Details
Module:
Key Columns
id
Columns
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| id | NUMBER | 38 | 0 | True | |||
| SOURCE_RECORD_ID | VARCHAR2 | 128 | This column is for Oracle Internal use only. This is source record id column. | ||||
| bomquantity | NUMBER | BoM Quantity | |||||
| bomrevision | NUMBER | 38 | 0 | Bill of Materials Revision | DW_NS_bomRevision_D | id | |
| componentyield | NUMBER | Component Yield | |||||
| isoutsourcingcharge | VARCHAR2 | 16 | Is Outsourcing charge | ||||
| item | NUMBER | 38 | 0 | Item | DW_NS_item_D | id | |
| itemsource | VARCHAR2 | 64 | Item Source | DW_NS_ItemSource_D | key | ||
| quantity | NUMBER | Quantity | |||||
| units | NUMBER | 38 | 0 | Units | DW_NS_unitsTypeUom_D | internalid |