DW_NS_bom_D

This table contains information about Bill of Materials (BOM) that lists the quantities of raw materials, assemblies, sub-components, and parts needed to manufacture a product.

Details

Module:

Key Columns

id

Columns

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.
availableforallassemblies	VARCHAR2	16			Available For All Assemblies
availableforalllocations	VARCHAR2	16			Available For All Locations
createddate	TIMESTAMP				Date Created
includechildren	VARCHAR2	16			Include Children
isinactive	VARCHAR2	16			Inactive
name	VARCHAR2	999			Name
usecomponentyield	VARCHAR2	16			Use Component Yield
usedonassembly	VARCHAR2	16			Used On Assembly