Table Name |
Type |
Cardinality |
Constraint Name |
VerbPhrase |
InversePhrase |
Foreign Keys |
Is Supertype |
Deferrable |
Initially Deferred |
PROJ |
Identifying |
One To Zero or More |
F01100 |
|
|
PROJ_ID |
NO |
NO |
NO |
S_MRP_OPTION_CD |
Non-Identifying |
Zero or One to Zero or More |
F01110 |
|
|
S_MRP_OPTION_CD |
NO |
NO |
NO |
S_CST_MTHD_CD |
Non-Identifying |
One To Zero or More |
F01120 |
|
|
S_CST_MTHD_CD |
NO |
NO |
NO |
WHSE |
Non-Identifying |
Zero or One to Zero or More |
F01130 |
|
|
WHSE_ID |
NO |
NO |
NO |
NET_GRP |
Non-Identifying |
Zero or One to Zero or More |
F20810 |
|
|
NET_GRP_ID |
NO |
NO |
NO |
ORG_ACCT |
Non-Identifying |
Zero or One to Zero or More |
F20811 |
|
|
WIP_VAR_ACCT_ID, WIP_VAR_ORG_ID |
NO |
NO |
NO |
ORG_ACCT |
Non-Identifying |
Zero or One to Zero or More |
F20812 |
|
|
WIP_RLF_ACCT_ID, WIP_RLF_ORG_ID |
NO |
NO |
NO |
ORG_ACCT |
Non-Identifying |
Zero or One to Zero or More |
F20814 |
|
|
STD_PPV_ACCT_ID, STD_PPV_ORG_ID |
NO |
NO |
NO |
ORG_ACCT |
Non-Identifying |
Zero or One to Zero or More |
F20815 |
|
|
STD_MUV_ACCT_ID, STD_MUV_ORG_ID |
NO |
NO |
NO |
ORG_ACCT |
Non-Identifying |
Zero or One to Zero or More |
F20816 |
|
|
STD_LEV_ACCT_ID, STD_LEV_ORG_ID |
NO |
NO |
NO |
ORG_ACCT |
Non-Identifying |
Zero or One to Zero or More |
F20817 |
|
|
STD_LRV_ACCT_ID, STD_LRV_ORG_ID |
NO |
NO |
NO |
ORG_ACCT |
Non-Identifying |
Zero or One to Zero or More |
F20818 |
|
|
STD_SUBC_ACCT_ID, STD_SUBC_ORG_ID |
NO |
NO |
NO |
ORG_ACCT |
Non-Identifying |
Zero or One to Zero or More |
F20819 |
|
|
STD_MISC1_ACCT_ID, STD_MISC1_ORG_ID |
NO |
NO |
NO |
ORG_ACCT |
Non-Identifying |
Zero or One to Zero or More |
F20820 |
|
|
STD_MISC2_ACCT_ID, STD_MISC2_ORG_ID |
NO |
NO |
NO |
ORG_ACCT |
Non-Identifying |
Zero or One to Zero or More |
F20821 |
|
|
STD_TRNSF_ACCT_ID, STD_TRNSF_ORG_ID |
NO |
NO |
NO |
RQ_APPRVL_PROC |
Non-Identifying |
Zero or One to Zero or More |
F20829 |
|
|
COMPANY_ID, RQ_APPR_PROC_CD |
NO |
NO |
NO |
ORG_ACCT |
Non-Identifying |
Zero or One to Zero or More |
F20962 |
|
|
ALLOC_CLR_ACCT_ID, ALLOC_CLR_ORG_ID |
NO |
NO |
NO |
ORG_ACCT |
Non-Identifying |
Zero or One to Zero or More |
F21459 |
|
|
RM_CONTRA_ACCT_ID, RM_CONTRA_ORG_ID |
NO |
NO |
NO |
ORG_ACCT |
Non-Identifying |
Zero or One to Zero or More |
FK_INVT_PROJ_A1A1_IDX |
|
|
AVG_MISC1_ACCT_ID, AVG_MISC1_ORG_ID |
NO |
NO |
NO |
ORG_ACCT |
Non-Identifying |
Zero or One to Zero or More |
FK_INVT_PROJ_A2A2_IDX |
|
|
AVG_MISC2_ACCT_ID, AVG_MISC2_ORG_ID |
NO |
NO |
NO |
ORG_ACCT |
Non-Identifying |
Zero or One to Zero or More |
FK_INVT_PROJ_AAAA_IDX |
|
|
AVG_LABOH_ACCT_ID, AVG_LABOH_ORG_ID |
NO |
NO |
NO |
ORG_ACCT |
Non-Identifying |
Zero or One to Zero or More |
FK_INVT_PROJ_ABAB_IDX |
|
|
AVG_PW_SUB_ACCT_ID, AVG_PW_SUB_ORG_ID |
NO |
NO |
NO |
ORG_ACCT |
Non-Identifying |
Zero or One to Zero or More |
FK_INVT_PROJ_AHAH_IDX |
|
|
AVG_PW_SOH_ACCT_ID, AVG_PW_SOH_ORG_ID |
NO |
NO |
NO |
ORG_ACCT |
Non-Identifying |
Zero or One to Zero or More |
FK_INVT_PROJ_ALAL_IDX |
|
|
AVG_LRV_ACCT_ID, AVG_LRV_ORG_ID |
NO |
NO |
NO |
ORG_ACCT |
Non-Identifying |
Zero or One to Zero or More |
FK_INVT_PROJ_AMAM_IDX |
|
|
AVG_MUVOH_ACCT_ID, AVG_MUVOH_ORG_ID |
NO |
NO |
NO |
ORG_ACCT |
Non-Identifying |
Zero or One to Zero or More |
FK_INVT_PROJ_AOAO_IDX |
|
|
AVG_PW_MOH_ACCT_ID, AVG_PW_MOH_ORG_ID |
NO |
NO |
NO |
ORG_ACCT |
Non-Identifying |
Zero or One to Zero or More |
FK_INVT_PROJ_APAP_IDX |
|
|
AVG_PW_MUV_ACCT_ID, AVG_PW_MUV_ORG_ID |
NO |
NO |
NO |
ORG_ACCT |
Non-Identifying |
Zero or One to Zero or More |
FK_INVT_PROJ_ARAR_IDX |
|
|
AVG_PW_LOH_ACCT_ID, AVG_PW_LOH_ORG_ID |
NO |
NO |
NO |
ORG_ACCT |
Non-Identifying |
Zero or One to Zero or More |
FK_INVT_PROJ_ASAS_IDX |
|
|
AVG_SUBC_ACCT_ID, AVG_SUBC_ORG_ID |
NO |
NO |
NO |
ORG_ACCT |
Non-Identifying |
Zero or One to Zero or More |
FK_INVT_PROJ_AUAU_IDX |
|
|
AVG_SUBCOH_ACCT_ID, AVG_SUBCOH_ORG_ID |
NO |
NO |
NO |
ORG_ACCT |
Non-Identifying |
Zero or One to Zero or More |
FK_INVT_PROJ_AVAV_IDX |
|
|
AVG_MUV_ACCT_ID, AVG_MUV_ORG_ID |
NO |
NO |
NO |
ORG_ACCT |
Non-Identifying |
Zero or One to Zero or More |
FK_INVT_PROJ_AWAW_IDX |
|
|
AVG_PW_LRV_ACCT_ID, AVG_PW_LRV_ORG_ID |
NO |
NO |
NO |
ORG_ACCT |
Non-Identifying |
Zero or One to Zero or More |
FK_INVT_PROJ_M1M1_IDX |
|
|
AVG_M1OH_ACCT_ID, AVG_M1OH_ORG_ID |
NO |
NO |
NO |
ORG_ACCT |
Non-Identifying |
Zero or One to Zero or More |
FK_INVT_PROJ_M2M2_IDX |
|
|
AVG_M2OH_ACCT_ID, AVG_M2OH_ORG_ID |
NO |
NO |
NO |
ORG_ACCT |
Non-Identifying |
Zero or One to Zero or More |
FK_INVT_PROJ_P1P1_IDX |
|
|
AVG_PW_M1_ACCT_ID, AVG_PW_M1_ORG_ID |
NO |
NO |
NO |
ORG_ACCT |
Non-Identifying |
Zero or One to Zero or More |
FK_INVT_PROJ_P2P2_IDX |
|
|
AVG_PW_M2_ACCT_ID, AVG_PW_M2_ORG_ID |
NO |
NO |
NO |
ORG_ACCT |
Non-Identifying |
Zero or One to Zero or More |
FK_INVT_PROJ_PCPC_IDX |
|
|
PW_CONTRA_ACCT_ID, PW_CONTRA_ORG_ID |
NO |
NO |
NO |
ORG_ACCT |
Non-Identifying |
Zero or One to Zero or More |
FK_INVT_PROJ_PMPM_IDX |
|
|
PW_MAT_ACCT_ID, PW_MAT_ORG_ID |
NO |
NO |
NO |
ORG_ACCT |
Non-Identifying |
Zero or One to Zero or More |
FK_INVT_PROJ_PRPR_IDX |
|
|
PW_RLF_ACCT_ID, PW_RLF_ORG_ID |
NO |
NO |
NO |
ORG_ACCT |
Non-Identifying |
Zero or One to Zero or More |
FK_INVT_PROJ_PVPV_IDX |
|
|
PW_VAR_ACCT_ID, PW_VAR_ORG_ID |
NO |
NO |
NO |
ORG_ACCT |
Non-Identifying |
Zero or One to Zero or More |
FK_INVT_PROJ_S1S1_IDX |
|
|
STD_M1OH_ACCT_ID, STD_M1OH_ORG_ID |
NO |
NO |
NO |
ORG_ACCT |
Non-Identifying |
Zero or One to Zero or More |
FK_INVT_PROJ_S2S2_IDX |
|
|
STD_M2OH_ACCT_ID, STD_M2OH_ORG_ID |
NO |
NO |
NO |
ORG_ACCT |
Non-Identifying |
Zero or One to Zero or More |
FK_INVT_PROJ_SASA_IDX |
|
|
STD_LABOH_ACCT_ID, STD_LABOH_ORG_ID |
NO |
NO |
NO |
ORG_ACCT |
Non-Identifying |
Zero or One to Zero or More |
FK_INVT_PROJ_SBSB_IDX |
|
|
STD_PW_SBV_ACCT_ID, STD_PW_SBV_ORG_ID |
NO |
NO |
NO |
ORG_ACCT |
Non-Identifying |
Zero or One to Zero or More |
FK_INVT_PROJ_SCSC_IDX |
|
|
STD_CS_MAT_ACCT_ID, STD_CS_MAT_ORG_ID |
NO |
NO |
NO |
ORG_ACCT |
Non-Identifying |
Zero or One to Zero or More |
FK_INVT_PROJ_SDSD_IDX |
|
|
STD_PW_M2_ACCT_ID, STD_PW_M2_ORG_ID |
NO |
NO |
NO |
ORG_ACCT |
Non-Identifying |
Zero or One to Zero or More |
FK_INVT_PROJ_SESE_IDX |
|
|
STD_EXPCON_ACCT_ID, STD_EXPCON_ORG_ID |
NO |
NO |
NO |
ORG_ACCT |
Non-Identifying |
Zero or One to Zero or More |
FK_INVT_PROJ_SGSC_IDX |
|
|
STD_PW_LEV_ACCT_ID, STD_PW_LEV_ORG_ID |
NO |
NO |
NO |
ORG_ACCT |
Non-Identifying |
Zero or One to Zero or More |
FK_INVT_PROJ_SHSH_IDX |
|
|
STD_PW_MOH_ACCT_ID, STD_PW_MOH_ORG_ID |
NO |
NO |
NO |
ORG_ACCT |
Non-Identifying |
Zero or One to Zero or More |
FK_INVT_PROJ_SISI_IDX |
|
|
STD_PW_M1_ACCT_ID, STD_PW_M1_ORG_ID |
NO |
NO |
NO |
ORG_ACCT |
Non-Identifying |
Zero or One to Zero or More |
FK_INVT_PROJ_SLSL_IDX |
|
|
STD_EXPRLF_ACCT_ID, STD_EXPRLF_ORG_ID |
NO |
NO |
NO |
ORG_ACCT |
Non-Identifying |
Zero or One to Zero or More |
FK_INVT_PROJ_SMSM_IDX |
|
|
STD_MUVOH_ACCT_ID, STD_MUVOH_ORG_ID |
NO |
NO |
NO |
ORG_ACCT |
Non-Identifying |
Zero or One to Zero or More |
FK_INVT_PROJ_SOSA_IDX |
|
|
STD_PW_MUV_ACCT_ID, STD_PW_MUV_ORG_ID |
NO |
NO |
NO |
ORG_ACCT |
Non-Identifying |
Zero or One to Zero or More |
FK_INVT_PROJ_SOSO_IDX |
|
|
STD_LEOH_ACCT_ID, STD_LEOH_ORG_ID |
NO |
NO |
NO |
ORG_ACCT |
Non-Identifying |
Zero or One to Zero or More |
FK_INVT_PROJ_SPSP_IDX |
|
|
STD_PW_CON_ACCT_ID, STD_PW_CON_ORG_ID |
NO |
NO |
NO |
ORG_ACCT |
Non-Identifying |
Zero or One to Zero or More |
FK_INVT_PROJ_SRSC_IDX |
|
|
STD_PW_LRV_ACCT_ID, STD_PW_LRV_ORG_ID |
NO |
NO |
NO |
ORG_ACCT |
Non-Identifying |
Zero or One to Zero or More |
FK_INVT_PROJ_SRSR_IDX |
|
|
STD_PW_RLF_ACCT_ID, STD_PW_RLF_ORG_ID |
NO |
NO |
NO |
ORG_ACCT |
Non-Identifying |
Zero or One to Zero or More |
FK_INVT_PROJ_SSSS_IDX |
|
|
STD_CS_RLF_ACCT_ID, STD_CS_RLF_ORG_ID |
NO |
NO |
NO |
ORG_ACCT |
Non-Identifying |
Zero or One to Zero or More |
FK_INVT_PROJ_ST1ST1_IDX |
|
|
STD_PWM1OH_ACCT_ID, STD_PWM1OH_ORG_ID |
NO |
NO |
NO |
ORG_ACCT |
Non-Identifying |
Zero or One to Zero or More |
FK_INVT_PROJ_ST2ST2_IDX |
|
|
STD_PWM2OH_ACCT_ID, STD_PWM2OH_ORG_ID |
NO |
NO |
NO |
ORG_ACCT |
Non-Identifying |
Zero or One to Zero or More |
FK_INVT_PROJ_STLSTL_IDX |
|
|
STD_PWLEOH_ACCT_ID, STD_PWLEOH_ORG_ID |
NO |
NO |
NO |
ORG_ACCT |
Non-Identifying |
Zero or One to Zero or More |
FK_INVT_PROJ_STPSTP_IDX |
|
|
STD_PW_SOH_ACCT_ID, STD_PW_SOH_ORG_ID |
NO |
NO |
NO |
ORG_ACCT |
Non-Identifying |
Zero or One to Zero or More |
FK_INVT_PROJ_STST_IDX |
|
|
STD_CS_CON_ACCT_ID, STD_CS_CON_ORG_ID |
NO |
NO |
NO |
ORG_ACCT |
Non-Identifying |
Zero or One to Zero or More |
FK_INVT_PROJ_STWSTW_IDX |
|
|
STD_PW_LOH_ACCT_ID, STD_PW_LOH_ORG_ID |
NO |
NO |
NO |
ORG_ACCT |
Non-Identifying |
Zero or One to Zero or More |
FK_INVT_PROJ_SUSU_IDX |
|
|
STD_SUBCOH_ACCT_ID, STD_SUBCOH_ORG_ID |
NO |
NO |
NO |
ORG_ACCT |
Non-Identifying |
Zero or One to Zero or More |
FK_INVT_PROJ_SVSV_IDX |
|
|
STD_PW_PPV_ACCT_ID, STD_PW_PPV_ORG_ID |
NO |
NO |
NO |
ORG_ACCT |
Non-Identifying |
Zero or One to Zero or More |
FK_INVT_PROJ_SWSW_IDX |
|
|
STD_PW_MAT_ACCT_ID, STD_PW_MAT_ORG_ID |
NO |
NO |
NO |
ORG_ACCT |
Non-Identifying |
Zero or One to Zero or More |
FK_INVT_PROJ_SXSX_IDX |
|
|
STD_EXPMAT_ACCT_ID, STD_EXPMAT_ORG_ID |
NO |
NO |
NO |
ORG_ACCT |
Non-Identifying |
Zero or One to Zero or More |
FK_INVT_PROJ_W1W1_IDX |
|
|
AVG_PWM1OH_ACCT_ID, AVG_PWM1OH_ORG_ID |
NO |
NO |
NO |
ORG_ACCT |
Non-Identifying |
Zero or One to Zero or More |
FK_INVT_PROJ_W2W2_IDX |
|
|
AVG_PWM2OH_ACCT_ID, AVG_PWM2OH_ORG_ID |
NO |
NO |
NO |