Z_AOPCPMO_FINI |
Default Table Name | Z_AOPCPMO_FINI |
Definition |
Z_AOPCPMO_FINI Columns |
ColumnName | Domain | Datatype | NULL | Definition |
MO_ID | VARCHAR2(10) | YES | ||
SCHED_RECPT_KEY | NUMBER(10, 0) | YES | ||
TRAN_TYPE | VARCHAR2(3) | YES | ||
ORDER_NO | VARCHAR2(25) | YES | ||
PRIORITY_NO | NUMBER(5, 0) | YES | ||
ORD_DTT | DATE | YES | ||
DUE_DTT | DATE | YES | ||
JOB_STATUS | VARCHAR2(1) | YES | ||
USER_DEF_REL_DTT | DATE | YES | ||
BUILD_QTY | NUMBER(22, 8) | YES | ||
BUILD_PART_KEY | NUMBER(10, 0) | YES | ||
BLD_PROJ_ID | VARCHAR2(30) | YES | ||
DFLT_UM_CD | VARCHAR2(10) | YES | ||
SCRAP_FCT_PCT_RT | NUMBER(10, 8) | YES | ||
STOCK_CD | VARCHAR2(45) | YES | ||
SCHD_METHOD | VARCHAR2(2) | YES | ||
JOB_MATL_AVAIL | VARCHAR2(1) | YES | ||
REC_ORDER_NO | NUMBER(5, 0) | YES | ||
REC_GRP_NO | NUMBER(7, 0) | YES | ||
SHOP_DTT | DATE | YES | ||
COMPLT_DTT | DATE | YES | ||
SJD_NOTES | VARCHAR2(254) | YES | ||
USER_DEF_FLD_NO | NUMBER(5, 0) | YES | ||
USER_DEF_ENT | VARCHAR2(30) | YES | ||
OPER_SEQ_NO | NUMBER(5, 0) | YES | ||
OPER_ID | VARCHAR2(15) | YES | ||
WC_ID | VARCHAR2(12) | YES | ||
SCHD_ST_DTT | DATE | YES | ||
SCHD_COMP_DTT | DATE | YES | ||
UNIT_RUN_HRS | NUMBER(14, 4) | YES | ||
SETUP_HRS | NUMBER(14, 2) | YES | ||
OPER_STATUS | VARCHAR2(1) | YES | ||
START_DTT | DATE | YES | ||
COMPLETION_DTT | DATE | YES | ||
MO_FL | VARCHAR2(1) | YES | ||
ASY_JOB | VARCHAR2(1) | YES | ||
ASY_JOB_ORD_NO | VARCHAR2(25) | YES | ||
ASY_JOB_LVL | NUMBER(5, 0) | YES | ||
ROUT_LN_DESC | VARCHAR2(60) | YES | ||
TOT_COMPL_QTY | NUMBER(22, 8) | YES | ||
OPER_RUN_METHOD | VARCHAR2(1) | YES | ||
S_WC_POOL | VARCHAR2(10) | YES |
Z_AOPCPMO_FINI Primary and Unique Keys |
Key Name | Key Type | Keys |
Z_AOPCPMO_FINI 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 |