MO_RQMT |
Default Table Name | MO_RQMT |
Definition |
MO_RQMT Columns |
ColumnName | Domain | Datatype | NULL | Definition |
MO_ID![]() |
VARCHAR2(10) | NO | ||
RQMT_LN_KEY![]() |
NUMBER(10, 0) | NO | ||
PHNTM_COMP_FL | VARCHAR2(1) | NO | ||
COMP_LN_NO | NUMBER(5, 0) | NO | ||
COMP_FIND_ID | VARCHAR2(4) | NO | ||
BOM_LN_KEY | NUMBER(10, 0) | YES | ||
COMP_PART_KEY![]() |
NUMBER(10, 0) | NO | ||
COMP_PART_ID | VARCHAR2(50) | NO | ||
COMP_PART_RVSN_ID | VARCHAR2(10) | NO | ||
S_QTY_TYP_CD | VARCHAR2(1) | NO | ||
COMP_REL_FL | VARCHAR2(1) | NO | ||
S_COMP_TYP_CD | VARCHAR2(1) | NO | ||
INVT_ABBRV_CD![]() |
VARCHAR2(20) | YES | ||
REQD_QTY | NUMBER(22, 8) | NO | ||
INV_RESVD_QTY | NUMBER(22, 8) | NO | ||
TO_ISSUE_QTY | NUMBER(22, 8) | NO | ||
ISSUED_QTY | NUMBER(22, 8) | NO | ||
BKFLSH_WHSE_ID![]() |
VARCHAR2(8) | YES | ||
BKFLSH_INVT_LOC_ID![]() |
VARCHAR2(15) | YES | ||
WC_ID![]() |
VARCHAR2(12) | YES | ||
AUTO_LOAD_FL | VARCHAR2(1) | NO | ||
NEED_DT | DATE | NO | ||
RES_ID | VARCHAR2(10) | YES | ||
WHSE_ID![]() |
VARCHAR2(8) | NO | ||
RES_LN_KEY | NUMBER(5, 0) | NO | ||
INVT_RQMT_FL | VARCHAR2(1) | NO | ||
MODIFIED_BY | VARCHAR2(20) | NO | ||
TIME_STAMP | DATE | NO | ||
STOP_EXPL_FL | VARCHAR2(1) | NO | ||
ROWVERSION | NUMBER(10, 0) | YES | ||
ORIG_PART_KEY | NUMBER(10, 0) | YES | ||
ORIG_PART_ID | VARCHAR2(50) | YES | ||
ORIG_PART_RVSN_ID | VARCHAR2(10) | YES | ||
REF_LN_NO | NUMBER(5, 0) | YES | ||
ORIG_LN_KEY | NUMBER(10, 0) | YES | ||
ASY_PART_KEY | NUMBER(10, 0) | YES |
MO_RQMT Primary and Unique Keys |
Key Name | Key Type | Keys |
PI_6511 | PrimaryKey | MO_ID, RQMT_LN_KEY |
MO_RQMT Foreign Keys |
Parent Relationships: |
Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype | Deferrable | Initially Deferred |
MO_HDR | Identifying | One To Zero or More | F20782 | MO_ID | NO | NO | NO | ||
PART | Non-Identifying | One To Zero or More | F20783 | COMP_PART_KEY | NO | NO | NO | ||
INVT_ABBRV_CD | Non-Identifying | Zero or One to Zero or More | F20784 | INVT_ABBRV_CD | NO | NO | NO | ||
WHSE_LOC | Non-Identifying | Zero or One to Zero or More | F20785 | BKFLSH_WHSE_ID, BKFLSH_INVT_LOC_ID | NO | NO | NO | ||
WORKCENTER | Non-Identifying | Zero or One to Zero or More | F20786 | WC_ID | NO | NO | NO | ||
WHSE | Non-Identifying | One To Zero or More | F20840 | WHSE_ID | NO | NO | NO |
Child Relationships: |
Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype | Deferrable | Initially Deferred |
MO_RQMT_NT | Identifying | One To Zero or More | FK_MO_RQMT_NT_MORQ_IDX | NO | NO | NO | |||
MO_RQMT_ROUTING | Identifying | One To Zero or More | FK_MO_RQMT_ROUTING_IDX_01 | NO | NO | NO |