ROUTING_LN |
Default Table Name | ROUTING_LN |
Definition |
ROUTING_LN Columns |
ColumnName | Domain | Datatype | NULL | Definition |
PART_KEY![]() |
NUMBER(10, 0) | NO | ||
ROUT_NO![]() |
NUMBER(5, 0) | NO | ||
ROUT_LN_KEY![]() |
NUMBER(5, 0) | NO | ||
PART_ID | VARCHAR2(50) | NO | ||
PART_RVSN_ID | VARCHAR2(10) | NO | ||
ROUT_OPER_SEQ_NO | NUMBER(5, 0) | NO | ||
ROUT_OPER_ALT_NO | NUMBER(5, 0) | NO | ||
ROUT_OPER_STEP_NO | NUMBER(5, 0) | NO | ||
S_OP_USAGE_CD | VARCHAR2(1) | NO | ||
ROUT_EFF_START_DT | DATE | NO | ||
ROUT_EFF_END_DT | DATE | YES | ||
OP_ID![]() |
VARCHAR2(12) | NO | ||
ROUT_LN_DESC | VARCHAR2(60) | NO | ||
WC_ID![]() |
VARCHAR2(12) | YES | ||
RU_PROC_TYPE_CD![]() |
VARCHAR2(6) | YES | ||
QC_FL | VARCHAR2(1) | NO | ||
SFC_FL | VARCHAR2(1) | NO | ||
S_RATE_SOURCE_CD | VARCHAR2(1) | NO | ||
S_STEP_TYPE_CD | VARCHAR2(1) | NO | ||
S_OVERLAP_TYPE_CD | VARCHAR2(1) | NO | ||
OVERLAP_QTY | NUMBER(22, 8) | NO | ||
KEY_RSRCE_ID![]() |
VARCHAR2(12) | YES | ||
KEY_RSRCE_FIXD_QTY | NUMBER(22, 8) | NO | ||
KEY_RSRCE_UNIT_QTY | NUMBER(22, 8) | NO | ||
S_RUN_TYPE | VARCHAR2(1) | NO | ||
UNIT_RUN_HRS | NUMBER(14, 4) | NO | ||
SETUP_HRS | NUMBER(14, 2) | NO | ||
MOVE_HRS | NUMBER(14, 2) | NO | ||
QUEUE_HRS | NUMBER(14, 2) | NO | ||
OVR_RUN_HRLY_AMT | NUMBER(19, 4) | NO | ||
OVR_SETUP_HRLY_AMT | NUMBER(19, 4) | NO | ||
OVR_BURDEN_RT | NUMBER(5, 4) | NO | ||
OVR_UNIT_CST_AMT | NUMBER(25, 10) | NO | ||
OVR_FIXED_CST_AMT | NUMBER(17, 2) | NO | ||
ROUT_REL_FL | VARCHAR2(1) | NO | ||
ORG_ID![]() |
VARCHAR2(20) | YES | ||
ORG_ABBRV_CD | VARCHAR2(6) | NO | ||
UDEF_DESC_1 | VARCHAR2(30) | NO | ||
UDEF_DESC_2 | VARCHAR2(30) | NO | ||
UDEF_DESC_3 | VARCHAR2(30) | NO | ||
ROUT_ENTR_DTT | DATE | NO | ||
ROUT_ENTR_USER_ID | VARCHAR2(20) | NO | ||
ROUT_CHNG_DTT | DATE | YES | ||
ROUT_CHNG_USER_ID | VARCHAR2(20) | YES | ||
ROUT_REL_DTT | DATE | YES | ||
ROUT_REL_USER_ID | VARCHAR2(20) | YES | ||
MODIFIED_BY | VARCHAR2(20) | NO | ||
TIME_STAMP | DATE | NO | ||
ROWVERSION | NUMBER(10, 0) | YES | ||
COMPANY_ID | VARCHAR2(10) | YES |
ROUTING_LN Primary and Unique Keys |
Key Name | Key Type | Keys |
PI_6484 | PrimaryKey | PART_KEY, ROUT_NO, ROUT_LN_KEY |
ROUTING_LN Foreign Keys |
Parent Relationships: |
Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype | Deferrable | Initially Deferred |
ROUTING_HDR | Identifying | One To Zero or More | F20726 | PART_KEY, ROUT_NO | NO | NO | NO | ||
OPERATION | Non-Identifying | One To Zero or More | F20727 | OP_ID | NO | NO | NO | ||
WORKCENTER | Non-Identifying | Zero or One to Zero or More | F20728 | WC_ID | NO | NO | NO | ||
RU_PROC_TYPE | Non-Identifying | Zero or One to Zero or More | F20729 | RU_PROC_TYPE_CD | NO | NO | NO | ||
KEY_RSRCE | Non-Identifying | Zero or One to Zero or More | F20730 | KEY_RSRCE_ID | NO | NO | NO | ||
ORG | Non-Identifying | Zero or One to Zero or More | F20731 | ORG_ID | NO | NO | NO |
Child Relationships: |
Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype | Deferrable | Initially Deferred |
ROUTING_LN_NOTES | Identifying | One To Zero or More | F20734 | NO | NO | NO | |||
ROUTING_LN_EQUIP | Identifying | One To Zero or More | F20735 | NO | NO | NO | |||
ROUTING_LN_LAB | Identifying | One To Zero or More | F20737 | NO | NO | NO | |||
ROUTING_LN_TEXT | Identifying | One To Zero or More | F20739 | NO | NO | NO | |||
ECN_PART_ROUTING | Non-Identifying | One To Zero or More | F21117 | NO | NO | NO | |||
ROUTING_LN_DOC | Identifying | One To Zero or More | F21155 | NO | NO | NO | |||
ROUTING_LN_COMP | Identifying | One To Zero or More | FK_ROUTING_LN_COMP_01 | NO | NO | NO |