MO_HDR |
Default Table Name | MO_HDR |
Definition |
MO_HDR Columns |
ColumnName | Domain | Datatype | NULL | Definition |
MO_ID![]() |
VARCHAR2(10) | NO | ||
S_MO_TYPE_CD | VARCHAR2(1) | NO | ||
S_MO_STATUS_CD | VARCHAR2(1) | NO | ||
PLANNER_ID![]() |
VARCHAR2(12) | NO | ||
WHSE_ID![]() |
VARCHAR2(8) | NO | ||
PC_SPRVR_ID![]() |
VARCHAR2(12) | YES | ||
BUILD_PART_ID | VARCHAR2(50) | NO | ||
BUILD_PART_RVSN_ID | VARCHAR2(10) | NO | ||
BUILD_PART_KEY![]() |
NUMBER(10, 0) | NO | ||
BOM_CONFIG_ID![]() |
VARCHAR2(10) | YES | ||
EFF_DT | DATE | NO | ||
ROUT_NO | NUMBER(5, 0) | NO | ||
BUILD_QTY | NUMBER(22, 8) | NO | ||
ASY_ISS_QTY | NUMBER(22, 8) | NO | ||
COMPLTD_QTY | NUMBER(22, 8) | NO | ||
EXPL_LVLS_NO | NUMBER(5, 0) | NO | ||
BLD_INVT_ABBRV_CD![]() |
VARCHAR2(20) | NO | ||
BLD_PROJ_ID![]() |
VARCHAR2(30) | NO | ||
BLD_PROJ_ABBRV_CD | VARCHAR2(6) | YES | ||
SASY_INVT_ABBRV_CD![]() |
VARCHAR2(20) | NO | ||
RM_INVT_ABBRV_CD![]() |
VARCHAR2(20) | NO | ||
CS_INVT_ABBRV_CD![]() |
VARCHAR2(20) | YES | ||
ORD_DT | DATE | NO | ||
NEED_DT | DATE | NO | ||
DUE_DT | DATE | NO | ||
COMPLT_DT | DATE | YES | ||
PLND_REL_DT | DATE | YES | ||
REL_DT | DATE | YES | ||
PLND_SHOP_DT | DATE | YES | ||
SHOP_DT | DATE | YES | ||
ISSUE_FL | VARCHAR2(1) | NO | ||
SUBCT_FL | VARCHAR2(1) | NO | ||
ALLOW_TIMESHEET_FL | VARCHAR2(1) | NO | ||
ALLOW_ISSUE_FL | VARCHAR2(1) | NO | ||
ALLOW_SUBCT_FL | VARCHAR2(1) | NO | ||
PRINT_PL_FL | VARCHAR2(1) | NO | ||
PRINT_ASY_SHEET_FL | VARCHAR2(1) | NO | ||
PRINT_TRVLR_FL | VARCHAR2(1) | NO | ||
PRINT_AB_CONFIG_FL | VARCHAR2(1) | NO | ||
PRINT_COMP_LBL_FL | VARCHAR2(1) | NO | ||
PL_PRNTD_FL | VARCHAR2(1) | NO | ||
ASY_SHEET_PRNTD_FL | VARCHAR2(1) | NO | ||
TRVLR_PRNTD_FL | VARCHAR2(1) | NO | ||
AB_CONFIG_PRNTD_FL | VARCHAR2(1) | NO | ||
COMP_LBL_PRNTD_FL | VARCHAR2(1) | NO | ||
MO_NOTES | VARCHAR2(254) | NO | ||
MO_EXPDT_NOTES | VARCHAR2(254) | NO | ||
ORG_ID![]() |
VARCHAR2(20) | YES | ||
ORG_ABBRV_CD | VARCHAR2(6) | YES | ||
LL_MATL_CST_AMT | NUMBER(17, 2) | NO | ||
LL_MAT_BRD_CST_AMT | NUMBER(17, 2) | NO | ||
LL_LAB_CST_AMT | NUMBER(17, 2) | NO | ||
LL_LAB_BRD_CST_AMT | NUMBER(17, 2) | NO | ||
LL_SUBCT_CST_AMT | NUMBER(17, 2) | NO | ||
LL_SUB_BRD_CST_AMT | NUMBER(17, 2) | NO | ||
LL_MISC1_CST_AMT | NUMBER(17, 2) | NO | ||
LL_MS1_BRD_CST_AMT | NUMBER(17, 2) | NO | ||
LL_MISC2_CST_AMT | NUMBER(17, 2) | NO | ||
LL_MS2_BRD_CST_AMT | NUMBER(17, 2) | NO | ||
LL_LABOR_HRS | NUMBER(14, 2) | NO | ||
LL_SUBCT_HRS | NUMBER(14, 2) | NO | ||
RL_MATL_CST_AMT | NUMBER(17, 2) | NO | ||
RL_MAT_BRD_CST_AMT | NUMBER(17, 2) | NO | ||
RL_LAB_CST_AMT | NUMBER(17, 2) | NO | ||
RL_LAB_BRD_CST_AMT | NUMBER(17, 2) | NO | ||
RL_SUBCT_CST_AMT | NUMBER(17, 2) | NO | ||
RL_SUB_BRD_CST_AMT | NUMBER(17, 2) | NO | ||
RL_MISC1_CST_AMT | NUMBER(17, 2) | NO | ||
RL_MS1_BRD_CST_AMT | NUMBER(17, 2) | NO | ||
RL_MISC2_CST_AMT | NUMBER(17, 2) | NO | ||
RL_MS2_BRD_CST_AMT | NUMBER(17, 2) | NO | ||
PR_MATL_CST_AMT | NUMBER(17, 2) | NO | ||
PR_MAT_BRD_CST_AMT | NUMBER(17, 2) | NO | ||
PR_LAB_CST_AMT | NUMBER(17, 2) | NO | ||
PR_LAB_BRD_CST_AMT | NUMBER(17, 2) | NO | ||
PR_SUBCT_CST_AMT | NUMBER(17, 2) | NO | ||
PR_SUB_BRD_CST_AMT | NUMBER(17, 2) | NO | ||
PR_MISC1_CST_AMT | NUMBER(17, 2) | NO | ||
PR_MS1_BRD_CST_AMT | NUMBER(17, 2) | NO | ||
PR_MISC2_CST_AMT | NUMBER(17, 2) | NO | ||
PR_MS2_BRD_CST_AMT | NUMBER(17, 2) | NO | ||
RES_ID | VARCHAR2(10) | YES | ||
MO_ENTR_DTT | DATE | YES | ||
MO_ENTR_USER_ID | VARCHAR2(20) | YES | ||
MO_LAST_CHNG_DTT | DATE | YES | ||
MO_CHNG_USER_ID | VARCHAR2(20) | YES | ||
ORDER_REF_ID | VARCHAR2(10) | YES | ||
ORDER_REF_RLSE_NO | NUMBER(5, 0) | YES | ||
ORDER_REF_LN_KEY | NUMBER(10, 0) | YES | ||
S_ORD_REF_TYPE_CD | VARCHAR2(1) | YES | ||
WIP_MATL_ACCT_ID | VARCHAR2(15) | YES | ||
WIP_MATL_ORG_ID | VARCHAR2(20) | YES | ||
WIP_LAB_ACCT_ID | VARCHAR2(15) | YES | ||
WIP_LAB_ORG_ID | VARCHAR2(20) | YES | ||
WIP_SUBCTR_ACCT_ID | VARCHAR2(15) | YES | ||
WIP_SUBCTR_ORG_ID | VARCHAR2(20) | YES | ||
WIP_MISC_1_ACCT_ID | VARCHAR2(15) | YES | ||
WIP_MISC_1_ORG_ID | VARCHAR2(20) | YES | ||
WIP_MISC_2_ACCT_ID | VARCHAR2(15) | YES | ||
WIP_MISC_2_ORG_ID | VARCHAR2(20) | YES | ||
SERIAL_REQD_FL | VARCHAR2(1) | NO | ||
LOT_REQD_FL | VARCHAR2(1) | NO | ||
USE_CS_FL | VARCHAR2(1) | NO | ||
AUTO_ASSGN_COMP_FL | VARCHAR2(1) | NO | ||
MODIFIED_BY | VARCHAR2(20) | NO | ||
TIME_STAMP | DATE | NO | ||
COMPANY_ID | VARCHAR2(10) | NO | ||
WIP_VAR_AMT | NUMBER(19, 4) | NO | ||
VAR_FY_CD | VARCHAR2(6) | YES | ||
USER_RVSN_FLD | VARCHAR2(10) | YES | ||
ROWVERSION | NUMBER(10, 0) | YES | ||
ASSY_JOB_FL | VARCHAR2(1) | YES | ||
PRIORITY_NO | NUMBER(5, 0) | YES | ||
MES_FL | VARCHAR2(1) | YES | ||
SFT_FL | VARCHAR2(1) | YES | ||
SCHED_CHNG_DTT | DATE | YES | ||
COMPL_PCT_RT | NUMBER(10, 8) | YES | ||
STD_CHNG_DTT | DATE | YES | ||
STATUS_CHNG_DTT | DATE | YES | ||
END_UNIT_ID | VARCHAR2(30) | YES | ||
DISCR_ID | VARCHAR2(40) | YES | ||
DISCR_LN_NO | NUMBER(5, 0) | YES | ||
FY_CLOSED_FL | VARCHAR2(1) | YES | ||
FROM_MES_FL | VARCHAR2(1) | YES | ||
SENT_MES_FL | VARCHAR2(1) | YES | ||
USE_INV_ABBREV_PEG_FL | VARCHAR2(1) | YES | ||
OPER_BOM_FL | VARCHAR2(1) | YES | ||
RL_CHG_HRS | NUMBER(14, 2) | YES | ||
LINE_APPROVE_FL | VARCHAR2(1) | YES | ||
INACTIVE_DT | DATE | YES | ||
S_DATE_EDIT_CD | VARCHAR2(1) | YES | ||
TE_START_DT | DATE | YES | ||
TE_END_DT | DATE | YES | ||
DATE1_DT | DATE | YES | ||
DATE2_DT | DATE | YES | ||
DATE3_DT | DATE | YES | ||
CODE1_CD | VARCHAR2(20) | YES | ||
CODE2_CD | VARCHAR2(20) | YES | ||
CODE3_CD | VARCHAR2(20) | YES | ||
UDT01_LINK_FL | VARCHAR2(1) | YES | ||
UDT09_LINK_FL | VARCHAR2(2) | YES | ||
UDT07_LINK_FL | VARCHAR2(2) | YES | ||
UDT07_REQUIRED_FL | VARCHAR2(2) | YES | ||
INTERIM_FL | VARCHAR2(2) | YES | ||
INTERIM_EMPL_ID | VARCHAR2(20) | YES | ||
INTERIM_DTT | DATE | YES | ||
TE_DATES_MODIFIED_FL | VARCHAR2(1) | YES | ||
TE_UDT02_ABBRV_ID | VARCHAR2(6) | YES |
MO_HDR Primary and Unique Keys |
Key Name | Key Type | Keys |
PI_6508 | PrimaryKey | MO_ID |
MO_HDR Foreign Keys |
Parent Relationships: |
Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype | Deferrable | Initially Deferred |
PLANNER | Non-Identifying | One To Zero or More | F20765 | PLANNER_ID | NO | NO | NO | ||
PC_SUPERVISOR | Non-Identifying | Zero or One to Zero or More | F20766 | PC_SPRVR_ID | NO | NO | NO | ||
PART | Non-Identifying | One To Zero or More | F20767 | BUILD_PART_KEY | NO | NO | NO | ||
BOM_CONFIG | Non-Identifying | Zero or One to Zero or More | F20768 | BOM_CONFIG_ID | NO | NO | NO | ||
WHSE | Non-Identifying | One To Zero or More | F20769 | WHSE_ID | NO | NO | NO | ||
INVT_ABBRV_CD | Non-Identifying | One To Zero or More | F20770 | BLD_INVT_ABBRV_CD | NO | NO | NO | ||
PROJ | Non-Identifying | One To Zero or More | F20771 | BLD_PROJ_ID | NO | NO | NO | ||
INVT_ABBRV_CD | Non-Identifying | One To Zero or More | F20772 | SASY_INVT_ABBRV_CD | NO | NO | NO | ||
INVT_ABBRV_CD | Non-Identifying | One To Zero or More | F20773 | RM_INVT_ABBRV_CD | NO | NO | NO | ||
INVT_ABBRV_CD | Non-Identifying | Zero or One to Zero or More | F20774 | CS_INVT_ABBRV_CD | NO | NO | NO | ||
ORG | Non-Identifying | Zero or One to Zero or More | F20775 | ORG_ID | NO | NO | NO |
Child Relationships: |
Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype | Deferrable | Initially Deferred |
MO_ALLOCATIONS | Identifying | One To Zero or More | F20776 | NO | NO | NO | |||
MO_ROUTING | Identifying | One To Zero or More | F20778 | NO | NO | NO | |||
MO_RQMT | Identifying | One To Zero or More | F20782 | NO | NO | NO | |||
MO_SERIAL_LOT | Identifying | One To Zero or More | F20787 | NO | NO | NO | |||
MO_HDR_CST | Identifying | One To Zero or More | F20822 | NO | NO | NO | |||
MO_HDR_TEXT | Identifying | One To Zero or More | F20824 | NO | NO | NO | |||
TS_LN_MO | Non-Identifying | One To Zero or More | F20826 | NO | NO | NO | |||
MO_DOCUMENT | Identifying | One To Zero or More | F21658 | NO | NO | NO |