MO_ROUTING |
Default Table Name | MO_ROUTING |
Definition |
MO_ROUTING Columns |
ColumnName | Domain | Datatype | NULL | Definition |
MO_ID![]() |
VARCHAR2(10) | NO | ||
MO_ROUT_LN_KEY![]() |
NUMBER(5, 0) | NO | ||
ROUT_LN_KEY | NUMBER(5, 0) | YES | ||
MO_OPER_SEQ_NO | NUMBER(5, 0) | NO | ||
MO_OPER_ALT_NO | NUMBER(5, 0) | NO | ||
MO_OPER_STEP_NO | NUMBER(5, 0) | NO | ||
OP_ID![]() |
VARCHAR2(12) | NO | ||
ROUT_LN_DESC | VARCHAR2(60) | NO | ||
WC_ID![]() |
VARCHAR2(12) | YES | ||
QC_REQD_FL | VARCHAR2(1) | NO | ||
SFC_REQD_FL | VARCHAR2(1) | NO | ||
S_RUN_TYPE | VARCHAR2(1) | NO | ||
UNIT_RUN_HRS | NUMBER(14, 4) | NO | ||
SETUP_HRS | NUMBER(14, 2) | NO | ||
S_OP_USAGE_CD | VARCHAR2(1) | NO | ||
S_OVERLAP_TYPE_CD | VARCHAR2(1) | NO | ||
OVERLAP_QTY | NUMBER(22, 8) | NO | ||
PLND_START_DT | DATE | YES | ||
START_DT | DATE | YES | ||
NEED_DT | DATE | YES | ||
DUE_DT | DATE | YES | ||
COMPLETION_DT | DATE | YES | ||
RQ_ID![]() |
VARCHAR2(10) | YES | ||
RQ_LN_KEY![]() |
NUMBER(10, 0) | YES | ||
TOT_COMPL_QTY | NUMBER(22, 8) | NO | ||
TOT_ACCPT_QTY | NUMBER(22, 8) | NO | ||
TOT_REJ_QTY | NUMBER(22, 8) | NO | ||
TOT_MRB_QTY | NUMBER(22, 8) | NO | ||
LABOR_HRS | NUMBER(14, 2) | NO | ||
SUBCT_HRS | NUMBER(14, 2) | NO | ||
SUBCT_CST_AMT | NUMBER(17, 2) | NO | ||
UDEF_DESC_1 | VARCHAR2(30) | YES | ||
UDEF_DESC_2 | VARCHAR2(30) | YES | ||
UDEF_DESC_3 | VARCHAR2(30) | YES | ||
MODIFIED_BY | VARCHAR2(20) | NO | ||
TIME_STAMP | DATE | NO | ||
ROWVERSION | NUMBER(10, 0) | YES | ||
COMPL_PCT_RT | NUMBER(10, 8) | YES | ||
ROUTING_CHNG_DTT | DATE | YES | ||
SCHED_CHNG_DTT | DATE | YES |
MO_ROUTING Primary and Unique Keys |
Key Name | Key Type | Keys |
PI_6510 | PrimaryKey | MO_ID, MO_ROUT_LN_KEY |
MO_ROUTING 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 | F20778 | MO_ID | NO | NO | NO | ||
OPERATION | Non-Identifying | One To Zero or More | F20779 | OP_ID | NO | NO | NO | ||
WORKCENTER | Non-Identifying | Zero or One to Zero or More | F20780 | WC_ID | NO | NO | NO | ||
RQ_LN | Non-Identifying | Zero or One to Zero or More | F20781 | RQ_ID, RQ_LN_KEY | NO | NO | NO |
Child Relationships: |
Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype | Deferrable | Initially Deferred |
MO_ROUT_LN_NOTES | Identifying | One To Zero or More | F20833 | NO | NO | NO | |||
MO_ROUT_LN_COMPL | Identifying | One To Zero or More | F20834 | NO | NO | NO | |||
MO_ROUT_LN_INSP | Identifying | One To Zero or More | F20836 | NO | NO | NO | |||
MO_ROUTING_COMP | Identifying | One To Zero or More | FK_MO_ROUTING_COMP_IDX_01 | NO | NO | NO |