BOM_CONFIG |
Default Table Name | BOM_CONFIG |
Definition |
BOM_CONFIG Columns |
ColumnName | Domain | Datatype | NULL | Definition |
BOM_CONFIG_ID![]() |
VARCHAR2(10) | NO | ||
BOM_CONFIG_DESC | VARCHAR2(30) | NO | ||
MODIFIED_BY | VARCHAR2(20) | NO | ||
TIME_STAMP | DATE | NO | ||
COMPANY_ID | VARCHAR2(10) | NO | ||
ROWVERSION | NUMBER(10, 0) | YES |
BOM_CONFIG Primary and Unique Keys |
Key Name | Key Type | Keys |
PI_6036 | PrimaryKey | BOM_CONFIG_ID |
BOM_CONFIG Foreign Keys |
Parent Relationships: |
Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype | Deferrable | Initially Deferred |
Child Relationships: |
Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype | Deferrable | Initially Deferred |
BOM_CONFIG_PROJ | Identifying | One To Zero or More | F10119 | NO | NO | NO | |||
MFG_BOM | Non-Identifying | One To Zero or More | F10177 | NO | NO | NO | |||
END_PART_CONFIG | Non-Identifying | One To Zero or More | F10184 | NO | NO | NO | |||
SO_LN | Non-Identifying | One To Zero or More | F20644 | NO | NO | NO | |||
ROUTING_CONFIG | Identifying | One To Zero or More | F20733 | NO | NO | NO | |||
MO_HDR | Non-Identifying | Zero or One to Zero or More | F20768 | NO | NO | NO | |||
PARMS_PCPMRR | Non-Identifying | One To Zero or More | F20842 | NO | NO | NO | |||
PART_DOCUMENT | Non-Identifying | One To Zero or More | F21074 | NO | NO | NO | |||
ECN_MBOM_COMP | Non-Identifying | One To Zero or More | F21148 | NO | NO | NO | |||
ECN_MBOM_ASY | Non-Identifying | One To Zero or More | F21153 | NO | NO | NO | |||
SO_LN_COMP | Non-Identifying | One To Zero or More | F21400 | NO | NO | NO | |||
ENG_BOM | Non-Identifying | One To Zero or More | F21479 | NO | NO | NO | |||
ECN_EBOM_COMP | Non-Identifying | One To Zero or More | F21506 | NO | NO | NO | |||
ECN_EBOM_ASY | Non-Identifying | One To Zero or More | F21511 | NO | NO | NO | |||
MPS_FORECAST_RQMT | Non-Identifying | One To Zero or More | F21642 | NO | NO | NO |