OPERATION |
Default Table Name | OPERATION |
Definition |
OPERATION Columns |
ColumnName | Domain | Datatype | NULL | Definition |
OP_ID![]() |
VARCHAR2(12) | NO | ||
OP_DESC | VARCHAR2(60) | NO | ||
S_OP_USAGE_CD | VARCHAR2(1) | NO | ||
QC_FL | VARCHAR2(1) | NO | ||
SFC_FL | VARCHAR2(1) | NO | ||
RU_PROC_TYPE_CD![]() |
VARCHAR2(6) | YES | ||
OP_TYPE_CD![]() |
VARCHAR2(6) | YES | ||
DFLT_WC_ID![]() |
VARCHAR2(12) | YES | ||
ORG_ID![]() |
VARCHAR2(20) | YES | ||
ORG_ABBRV_CD | VARCHAR2(6) | NO | ||
DFLT_RUN_HRS | NUMBER(14, 4) | NO | ||
S_RUN_TYPE | VARCHAR2(1) | NO | ||
ITEM_KEY![]() |
NUMBER(10, 0) | YES | ||
ITEM_ID | VARCHAR2(50) | YES | ||
ITEM_RVSN_ID | VARCHAR2(10) | YES | ||
KEY_RSRCE_ID![]() |
VARCHAR2(12) | YES | ||
LN_CHG_TYPE![]() |
VARCHAR2(6) | YES | ||
LAST_UNIT_CST | NUMBER(14, 4) | NO | ||
VEND_LT_DAYS_NO | NUMBER(5, 0) | NO | ||
INT_LT_DAYS_NO | NUMBER(5, 0) | NO | ||
S_NOTES_LOAD_CD | VARCHAR2(1) | NO | ||
PC_SPRVR_ID![]() |
VARCHAR2(12) | YES | ||
MODIFIED_BY | VARCHAR2(20) | NO | ||
TIME_STAMP | DATE | NO | ||
COMPANY_ID![]() |
VARCHAR2(10) | NO | ||
ROWVERSION | NUMBER(10, 0) | YES | ||
GENL_LAB_CAT_CD | VARCHAR2(6) | YES | ||
MES_FL | VARCHAR2(1) | YES | ||
DIRECT_ACCT_ID | VARCHAR2(15) | YES | ||
WIP_ACCT_ID | VARCHAR2(15) | YES | ||
COMMON_INV_ACCT_ID | VARCHAR2(15) | YES |
OPERATION Primary and Unique Keys |
Key Name | Key Type | Keys |
PI_6476 | PrimaryKey | OP_ID |
OPERATION Foreign Keys |
Parent Relationships: |
Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype | Deferrable | Initially Deferred |
RU_PROC_TYPE | Non-Identifying | Zero or One to Zero or More | F20697 | RU_PROC_TYPE_CD | NO | NO | NO | ||
OP_TYPE | Non-Identifying | Zero or One to Zero or More | F20708 | OP_TYPE_CD | NO | NO | NO | ||
WORKCENTER | Non-Identifying | Zero or One to Zero or More | F20709 | DFLT_WC_ID | NO | NO | NO | ||
ORG | Non-Identifying | Zero or One to Zero or More | F20710 | ORG_ID | NO | NO | NO | ||
ITEM | Non-Identifying | Zero or One to Zero or More | F20711 | ITEM_KEY | NO | NO | NO | ||
KEY_RSRCE | Non-Identifying | Zero or One to Zero or More | F20712 | KEY_RSRCE_ID | NO | NO | NO | ||
LN_CHG_TYPE | Non-Identifying | Zero or One to Zero or More | F20713 | LN_CHG_TYPE, COMPANY_ID | NO | NO | NO | ||
PC_SUPERVISOR | Non-Identifying | Zero or One to Zero or More | F20714 | PC_SPRVR_ID | NO | NO | NO |
Child Relationships: |
Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype | Deferrable | Initially Deferred |
OPERATION_RATES | Identifying | One To Zero or More | F20715 | NO | NO | NO | |||
OPERATION_EQUIP | Identifying | One To Zero or More | F20717 | NO | NO | NO | |||
OPERATION_LAB | Identifying | One To Zero or More | F20719 | NO | NO | NO | |||
OPERATION_TEXT | Identifying | One To Zero or More | F20721 | NO | NO | NO | |||
OPERATION_NOTES | Identifying | One To Zero or More | F20722 | NO | NO | NO | |||
OPERATION_VEND | Identifying | One To Zero or More | F20724 | NO | NO | NO | |||
ROUTING_LN | Non-Identifying | One To Zero or More | F20727 | NO | NO | NO | |||
MO_ROUTING | Non-Identifying | One To Zero or More | F20779 | NO | NO | NO | |||
OP_PROJ | Non-Identifying | One To Zero or More | FK_OP_PROJ_IDX_01 | NO | NO | NO | |||
OPERATION_ACCT_DFLT | Identifying | One To Zero or More | FK_OPERATION_ACCT_DFLT_OP_IDX | NO | NO | NO |