DW_NS_bomRevision_D
This table contains information about Bill of Materials (BOM) revision that enables you to update a BOM details throughout the product lifecycle.
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. | ||||
| billofmaterials | NUMBER | 38 | 0 | Bill of Materials | DW_NS_bom_D | id | |
| createddate | TIMESTAMP | Date Created | |||||
| effectiveenddate | TIMESTAMP | Effective End Date | |||||
| effectivestartdate | TIMESTAMP | Effective Start Date | |||||
| isinactive | VARCHAR2 | 16 | Inactive | ||||
| lastmodifieddate | TIMESTAMP | Last Modified Date | |||||
| name | VARCHAR2 | 256 | Name |