INVT_SETTINGS |
Default Table Name | INVT_SETTINGS |
Definition |
INVT_SETTINGS Columns |
ColumnName | Domain | Datatype | NULL | Definition |
MATL_CST_FL | VARCHAR2(1) | NO | ||
DOL_APPRVL_AMT | NUMBER(17, 2) | NO | ||
MNTN_MATL_CST_FL | VARCHAR2(1) | NO | ||
S_CST_MTHD_CD![]() |
VARCHAR2(1) | YES | ||
USE_WHSE_FL | VARCHAR2(1) | NO | ||
USE_LOC_FL | VARCHAR2(1) | NO | ||
ALLOW_NEG_QTY_FL | VARCHAR2(1) | NO | ||
APPRVL_PASSWORD_CD | VARCHAR2(10) | NO | ||
INVT_RQST_APRVL_FL | VARCHAR2(1) | NO | ||
S_SER_ASSIGN_PT_CD![]() |
VARCHAR2(1) | NO | ||
S_LOT_ASSIGN_PT_CD![]() |
VARCHAR2(1) | NO | ||
ACCR_PROJ_ACCT_ID![]() |
VARCHAR2(15) | YES | ||
ACCR_NP_ACCT_ID![]() |
VARCHAR2(15) | YES | ||
VAR_PROJ_ACCT_ID | VARCHAR2(15) | YES | ||
VAR_NP_ACCT_ID | VARCHAR2(15) | YES | ||
SCRP_PROJ_ACCT_ID | VARCHAR2(15) | YES | ||
SCRP_NP_ACCT_ID | VARCHAR2(15) | YES | ||
S_INVT_RECOG_CD![]() |
VARCHAR2(1) | NO | ||
S_ROLLUP_CD | VARCHAR2(1) | NO | ||
TRN_BETW_WHSE_FL | VARCHAR2(1) | NO | ||
MODIFIED_BY | VARCHAR2(20) | NO | ||
TIME_STAMP | DATE | NO | ||
COMPANY_ID![]() |
VARCHAR2(10) | NO | ||
LOAD_ACT_COUNT_FL | VARCHAR2(1) | NO | ||
LAST_ADJ_TRN_ID | VARCHAR2(10) | YES | ||
S_INTR_PROJ_ISS_CD | VARCHAR2(1) | NO | ||
LAST_CLOSE_FY_CD | VARCHAR2(6) | YES | ||
SERIAL_LOT_FL | VARCHAR2(1) | NO | ||
S_SERIAL_UNIQUE_CD | VARCHAR2(1) | NO | ||
S_LOT_UNIQUE_CD | VARCHAR2(1) | NO | ||
LOAD_WARR_FL | VARCHAR2(1) | NO | ||
CALC_SHELF_LIFE_FL | VARCHAR2(1) | NO | ||
S_BUY_SERIAL_CD | VARCHAR2(1) | NO | ||
S_BUY_LOT_CD | VARCHAR2(1) | NO | ||
S_MAKE_SERIAL_CD | VARCHAR2(1) | NO | ||
S_MAKE_LOT_CD | VARCHAR2(1) | NO | ||
LAST_BUY_SERIAL_ID | VARCHAR2(20) | YES | ||
LAST_BUY_LOT_ID | VARCHAR2(20) | YES | ||
LAST_MK_SERIAL_ID | VARCHAR2(20) | YES | ||
LAST_MAKE_LOT_ID | VARCHAR2(20) | YES | ||
UDEF_LBL_1 | VARCHAR2(15) | NO | ||
UDEF_LBL_2 | VARCHAR2(15) | NO | ||
UDEF_LBL_3 | VARCHAR2(15) | NO | ||
UDEF_LBL_4 | VARCHAR2(15) | NO | ||
UDEF_LBL_5 | VARCHAR2(15) | NO | ||
S_DFLT_BRD_RT_CD | VARCHAR2(1) | NO | ||
S_RM_BRD_CD | VARCHAR2(1) | NO | ||
POST_EXP_VAR_FL | VARCHAR2(1) | NO | ||
RM_VAR_ACCT_ID![]() |
VARCHAR2(15) | YES | ||
RM_VAR_ORG_ID![]() |
VARCHAR2(20) | YES | ||
WIP_VAR_ACCT_ID![]() |
VARCHAR2(15) | YES | ||
WIP_VAR_ORG_ID![]() |
VARCHAR2(20) | YES | ||
WIP_RLF_ACCT_ID![]() |
VARCHAR2(15) | YES | ||
WIP_RLF_ORG_ID![]() |
VARCHAR2(20) | YES | ||
CAP_BURD_ACCT_ID | VARCHAR2(15) | YES | ||
CAP_BURD_ORG_ID | VARCHAR2(20) | YES | ||
STD_PPV_ACCT_ID![]() |
VARCHAR2(15) | YES | ||
STD_PPV_ORG_ID![]() |
VARCHAR2(20) | YES | ||
STD_MUV_ACCT_ID![]() |
VARCHAR2(15) | YES | ||
STD_MUV_ORG_ID![]() |
VARCHAR2(20) | YES | ||
STD_LEV_ACCT_ID![]() |
VARCHAR2(15) | YES | ||
STD_LEV_ORG_ID![]() |
VARCHAR2(20) | YES | ||
STD_LRV_ACCT_ID![]() |
VARCHAR2(15) | YES | ||
STD_LRV_ORG_ID![]() |
VARCHAR2(20) | YES | ||
STD_SUBC_ACCT_ID![]() |
VARCHAR2(15) | YES | ||
STD_SUBC_ORG_ID![]() |
VARCHAR2(20) | YES | ||
STD_MISC1_ACCT_ID![]() |
VARCHAR2(15) | YES | ||
STD_MISC1_ORG_ID![]() |
VARCHAR2(20) | YES | ||
STD_MISC2_ACCT_ID![]() |
VARCHAR2(15) | YES | ||
STD_MISC2_ORG_ID![]() |
VARCHAR2(20) | YES | ||
STD_TRNSF_ACCT_ID![]() |
VARCHAR2(15) | YES | ||
STD_TRNSF_ORG_ID![]() |
VARCHAR2(20) | YES | ||
SCRP_NP_ORG_ID![]() |
VARCHAR2(20) | YES | ||
SCRP_PROJ_ORG_ID![]() |
VARCHAR2(20) | YES | ||
VAR_NP_ORG_ID![]() |
VARCHAR2(20) | YES | ||
VAR_PROJ_ORG_ID![]() |
VARCHAR2(20) | YES | ||
BCK_RCMPORC_FL | VARCHAR2(1) | NO | ||
BCK_RCMMSRC_FL | VARCHAR2(1) | NO | ||
BCK_RCMINSP_FL | VARCHAR2(1) | NO | ||
BCK_RCRTRVLR_FL | VARCHAR2(1) | NO | ||
BCK_PCMRELMO_FL | VARCHAR2(1) | NO | ||
BCK_INMLOXFR_FL | VARCHAR2(1) | NO | ||
BCK_SO_FL | VARCHAR2(1) | NO | ||
BCK_RMO_FL | VARCHAR2(1) | NO | ||
BCK_IMO_FL | VARCHAR2(1) | NO | ||
BCK_INV_FL | VARCHAR2(1) | NO | ||
BCK_PO_FL | VARCHAR2(1) | NO | ||
NEED_DT_FILTER_NO | NUMBER(5, 0) | YES | ||
S_UNITS_HST_UPD_CD | VARCHAR2(1) | NO | ||
RM_CONTRA_ACCT_ID![]() |
VARCHAR2(15) | YES | ||
RM_CONTRA_ORG_ID![]() |
VARCHAR2(20) | YES | ||
ROWVERSION | NUMBER(10, 0) | YES | ||
UID_PREFIX | VARCHAR2(16) | YES | ||
S_UID_TYPE | VARCHAR2(5) | YES | ||
MOVE_EXP_BRDN_FL | VARCHAR2(1) | NO | ||
DFLT_EXP_WIP_FL | VARCHAR2(1) | NO | ||
WIP_MAT_ACCT_ID | VARCHAR2(15) | YES | ||
WIP_MAT_ORG_ID | VARCHAR2(20) | YES | ||
EXP_MAT_ACCT_ID | VARCHAR2(15) | YES | ||
EXP_MAT_ORG_ID | VARCHAR2(20) | YES | ||
EXP_RLF_ACCT_ID | VARCHAR2(15) | YES | ||
EXP_RLF_ORG_ID | VARCHAR2(20) | YES | ||
EXP_CONTRA_ACCT_ID | VARCHAR2(15) | YES | ||
EXP_CONTRA_ORG_ID | VARCHAR2(20) | YES | ||
EXP_TRN_ACCT_ID | VARCHAR2(15) | YES | ||
EXP_TRN_ORG_ID | VARCHAR2(20) | YES | ||
UID_IAC_CD | VARCHAR2(3) | YES | ||
UID_EID_CD | VARCHAR2(13) | YES | ||
ABC_BY_WHSE_FL | VARCHAR2(1) | NO | ||
DATE_FL_1 | VARCHAR2(1) | YES | ||
DATE_FL_2 | VARCHAR2(1) | YES | ||
DATE_FL_3 | VARCHAR2(1) | YES | ||
DATE_FL_4 | VARCHAR2(1) | YES | ||
DATE_FL_5 | VARCHAR2(1) | YES | ||
UDEF_LBL_6 | VARCHAR2(15) | YES | ||
DATE_FL_6 | VARCHAR2(1) | YES | ||
UDEF_LBL_7 | VARCHAR2(15) | YES | ||
DATE_FL_7 | VARCHAR2(1) | YES | ||
UDEF_LBL_8 | VARCHAR2(15) | YES | ||
DATE_FL_8 | VARCHAR2(1) | YES | ||
UDEF_LBL_9 | VARCHAR2(15) | YES | ||
DATE_FL_9 | VARCHAR2(1) | YES | ||
UDEF_LBL_10 | VARCHAR2(15) | YES | ||
DATE_FL_10 | VARCHAR2(1) | YES | ||
UDEF_LBL_11 | VARCHAR2(15) | YES | ||
DATE_FL_11 | VARCHAR2(1) | YES | ||
UDEF_LBL_12 | VARCHAR2(15) | YES | ||
DATE_FL_12 | VARCHAR2(1) | YES | ||
UDEF_LBL_13 | VARCHAR2(15) | YES | ||
DATE_FL_13 | VARCHAR2(1) | YES | ||
UDEF_LBL_14 | VARCHAR2(15) | YES | ||
DATE_FL_14 | VARCHAR2(1) | YES | ||
UDEF_LBL_15 | VARCHAR2(15) | YES | ||
DATE_FL_15 | VARCHAR2(1) | YES | ||
ALLOW_INVT_ALLOC_FL | VARCHAR2(1) | NO | ||
ALLOC_SERIAL_TRACK_FL | VARCHAR2(1) | NO | ||
ALLOC_LOT_TRACK_FL | VARCHAR2(1) | NO | ||
ALLOC_NON_TRACK_FL | VARCHAR2(1) | NO | ||
ALLOC_MO_FL | VARCHAR2(1) | NO | ||
ALLOC_MO_FIRMPL_FL | VARCHAR2(1) | NO | ||
ALLOC_SO_FL | VARCHAR2(1) | NO | ||
ALLOC_PO_FL | VARCHAR2(1) | NO | ||
ALLOC_ISS_FL | VARCHAR2(1) | NO | ||
ALLOC_ISS_PEND_FL | VARCHAR2(1) | NO | ||
ALLOC_TRF_FL | VARCHAR2(1) | NO | ||
ALLOC_TRF_PEND_FL | VARCHAR2(1) | NO | ||
ALLOW_FG_RM_FL | VARCHAR2(1) | NO | ||
ALLOW_OH_ISS_FL | VARCHAR2(1) | NO | ||
USE_VAR_BRK_FL | VARCHAR2(1) | NO | ||
S_STD_CST_SRCE_CD | VARCHAR2(1) | NO | ||
POST_PRJWIP_VAR_FL | VARCHAR2(1) | NO | ||
CALC_LEV_VAR_FL | VARCHAR2(1) | NO | ||
PW_RM_VAR_ACCT_ID![]() |
VARCHAR2(15) | YES | ||
PW_RM_VAR_ORG_ID![]() |
VARCHAR2(20) | YES | ||
PW_CONTRA_ACCT_ID![]() |
VARCHAR2(15) | YES | ||
PW_CONTRA_ORG_ID![]() |
VARCHAR2(20) | YES | ||
PW_MAT_ACCT_ID![]() |
VARCHAR2(15) | YES | ||
PW_MAT_ORG_ID![]() |
VARCHAR2(20) | YES | ||
PW_RLF_ACCT_ID![]() |
VARCHAR2(15) | YES | ||
PW_RLF_ORG_ID![]() |
VARCHAR2(20) | YES | ||
PW_VAR_ACCT_ID![]() |
VARCHAR2(15) | YES | ||
PW_VAR_ORG_ID![]() |
VARCHAR2(20) | YES | ||
AVG_MUV_ACCT_ID![]() |
VARCHAR2(15) | YES | ||
AVG_MUV_ORG_ID![]() |
VARCHAR2(20) | YES | ||
AVG_LRV_ACCT_ID![]() |
VARCHAR2(15) | YES | ||
AVG_LRV_ORG_ID![]() |
VARCHAR2(20) | YES | ||
AVG_SUBC_ACCT_ID![]() |
VARCHAR2(15) | YES | ||
AVG_SUBC_ORG_ID![]() |
VARCHAR2(20) | YES | ||
AVG_MISC1_ACCT_ID![]() |
VARCHAR2(15) | YES | ||
AVG_MISC1_ORG_ID![]() |
VARCHAR2(20) | YES | ||
AVG_MISC2_ACCT_ID![]() |
VARCHAR2(15) | YES | ||
AVG_MISC2_ORG_ID![]() |
VARCHAR2(20) | YES | ||
AVG_MUVOH_ACCT_ID![]() |
VARCHAR2(15) | YES | ||
AVG_MUVOH_ORG_ID![]() |
VARCHAR2(20) | YES | ||
AVG_SUBCOH_ACCT_ID![]() |
VARCHAR2(15) | YES | ||
AVG_SUBCOH_ORG_ID![]() |
VARCHAR2(20) | YES | ||
AVG_LABOH_ACCT_ID![]() |
VARCHAR2(15) | YES | ||
AVG_LABOH_ORG_ID![]() |
VARCHAR2(20) | YES | ||
AVG_M1OH_ACCT_ID![]() |
VARCHAR2(15) | YES | ||
AVG_M1OH_ORG_ID![]() |
VARCHAR2(20) | YES | ||
AVG_M2OH_ACCT_ID![]() |
VARCHAR2(15) | YES | ||
AVG_M2OH_ORG_ID![]() |
VARCHAR2(20) | YES | ||
AVG_PW_MUV_ACCT_ID![]() |
VARCHAR2(15) | YES | ||
AVG_PW_MUV_ORG_ID![]() |
VARCHAR2(20) | YES | ||
AVG_PW_LRV_ACCT_ID![]() |
VARCHAR2(15) | YES | ||
AVG_PW_LRV_ORG_ID![]() |
VARCHAR2(20) | YES | ||
AVG_PW_SUB_ACCT_ID![]() |
VARCHAR2(15) | YES | ||
AVG_PW_SUB_ORG_ID![]() |
VARCHAR2(20) | YES | ||
AVG_PW_M1_ACCT_ID![]() |
VARCHAR2(15) | YES | ||
AVG_PW_M1_ORG_ID![]() |
VARCHAR2(20) | YES | ||
AVG_PW_M2_ACCT_ID![]() |
VARCHAR2(15) | YES | ||
AVG_PW_M2_ORG_ID![]() |
VARCHAR2(20) | YES | ||
AVG_PW_MOH_ACCT_ID![]() |
VARCHAR2(15) | YES | ||
AVG_PW_MOH_ORG_ID![]() |
VARCHAR2(20) | YES | ||
AVG_PW_SOH_ACCT_ID![]() |
VARCHAR2(15) | YES | ||
AVG_PW_SOH_ORG_ID![]() |
VARCHAR2(20) | YES | ||
AVG_PW_LOH_ACCT_ID![]() |
VARCHAR2(15) | YES | ||
AVG_PW_LOH_ORG_ID![]() |
VARCHAR2(20) | YES | ||
AVG_PWM1OH_ACCT_ID![]() |
VARCHAR2(15) | YES | ||
AVG_PWM1OH_ORG_ID![]() |
VARCHAR2(20) | YES | ||
AVG_PWM2OH_ACCT_ID![]() |
VARCHAR2(15) | YES | ||
AVG_PWM2OH_ORG_ID![]() |
VARCHAR2(20) | YES | ||
STD_CS_CON_ACCT_ID![]() |
VARCHAR2(15) | YES | ||
STD_CS_CON_ORG_ID![]() |
VARCHAR2(20) | YES | ||
STD_CS_MAT_ACCT_ID![]() |
VARCHAR2(15) | YES | ||
STD_CS_MAT_ORG_ID![]() |
VARCHAR2(20) | YES | ||
STD_CS_RLF_ACCT_ID![]() |
VARCHAR2(15) | YES | ||
STD_CS_RLF_ORG_ID![]() |
VARCHAR2(20) | YES | ||
STD_PW_CON_ACCT_ID![]() |
VARCHAR2(15) | YES | ||
STD_PW_CON_ORG_ID![]() |
VARCHAR2(20) | YES | ||
STD_PW_MAT_ACCT_ID![]() |
VARCHAR2(15) | YES | ||
STD_PW_MAT_ORG_ID![]() |
VARCHAR2(20) | YES | ||
STD_PW_RLF_ACCT_ID![]() |
VARCHAR2(15) | YES | ||
STD_PW_RLF_ORG_ID![]() |
VARCHAR2(20) | YES | ||
STD_EXPCON_ACCT_ID![]() |
VARCHAR2(15) | YES | ||
STD_EXPCON_ORG_ID![]() |
VARCHAR2(20) | YES | ||
STD_EXPMAT_ACCT_ID![]() |
VARCHAR2(15) | YES | ||
STD_EXPMAT_ORG_ID![]() |
VARCHAR2(20) | YES | ||
STD_EXPRLF_ACCT_ID![]() |
VARCHAR2(15) | YES | ||
STD_EXPRLF_ORG_ID![]() |
VARCHAR2(20) | YES | ||
STD_MUVOH_ACCT_ID![]() |
VARCHAR2(15) | YES | ||
STD_MUVOH_ORG_ID![]() |
VARCHAR2(20) | YES | ||
STD_SUBCOH_ACCT_ID![]() |
VARCHAR2(15) | YES | ||
STD_SUBCOH_ORG_ID![]() |
VARCHAR2(20) | YES | ||
STD_LABOH_ACCT_ID![]() |
VARCHAR2(15) | YES | ||
STD_LABOH_ORG_ID![]() |
VARCHAR2(20) | YES | ||
STD_M1OH_ACCT_ID![]() |
VARCHAR2(15) | YES | ||
STD_M1OH_ORG_ID![]() |
VARCHAR2(20) | YES | ||
STD_M2OH_ACCT_ID![]() |
VARCHAR2(15) | YES | ||
STD_M2OH_ORG_ID![]() |
VARCHAR2(20) | YES | ||
STD_LEOH_ACCT_ID![]() |
VARCHAR2(15) | YES | ||
STD_LEOH_ORG_ID![]() |
VARCHAR2(20) | YES | ||
STD_PW_PPV_ACCT_ID![]() |
VARCHAR2(15) | YES | ||
STD_PW_PPV_ORG_ID![]() |
VARCHAR2(20) | YES | ||
STD_PW_MUV_ACCT_ID![]() |
VARCHAR2(15) | YES | ||
STD_PW_MUV_ORG_ID![]() |
VARCHAR2(20) | YES | ||
STD_PW_LRV_ACCT_ID![]() |
VARCHAR2(15) | YES | ||
STD_PW_LRV_ORG_ID![]() |
VARCHAR2(20) | YES | ||
STD_PW_LEV_ACCT_ID![]() |
VARCHAR2(15) | YES | ||
STD_PW_LEV_ORG_ID![]() |
VARCHAR2(20) | YES | ||
STD_PW_SBV_ACCT_ID![]() |
VARCHAR2(15) | YES | ||
STD_PW_SBV_ORG_ID![]() |
VARCHAR2(20) | YES | ||
STD_PW_M1_ACCT_ID![]() |
VARCHAR2(15) | YES | ||
STD_PW_M1_ORG_ID![]() |
VARCHAR2(20) | YES | ||
STD_PW_M2_ACCT_ID![]() |
VARCHAR2(15) | YES | ||
STD_PW_M2_ORG_ID![]() |
VARCHAR2(20) | YES | ||
STD_PW_MOH_ACCT_ID![]() |
VARCHAR2(15) | YES | ||
STD_PW_MOH_ORG_ID![]() |
VARCHAR2(20) | YES | ||
STD_PW_SOH_ACCT_ID![]() |
VARCHAR2(15) | YES | ||
STD_PW_SOH_ORG_ID![]() |
VARCHAR2(20) | YES | ||
STD_PW_LOH_ACCT_ID![]() |
VARCHAR2(15) | YES | ||
STD_PW_LOH_ORG_ID![]() |
VARCHAR2(20) | YES | ||
STD_PWM1OH_ACCT_ID![]() |
VARCHAR2(15) | YES | ||
STD_PWM1OH_ORG_ID![]() |
VARCHAR2(20) | YES | ||
STD_PWM2OH_ACCT_ID![]() |
VARCHAR2(15) | YES | ||
STD_PWM2OH_ORG_ID![]() |
VARCHAR2(20) | YES | ||
STD_PWLEOH_ACCT_ID![]() |
VARCHAR2(15) | YES | ||
STD_PWLEOH_ORG_ID![]() |
VARCHAR2(20) | YES | ||
ALLOW_CS_NC_PROJ | VARCHAR2(1) | YES | ||
UPD_LCDT_STDPHY_FL | VARCHAR2(1) | NO | ||
UPD_LCDT_TRN_FL | VARCHAR2(1) | NO | ||
COUNT_WARN_FL | VARCHAR2(1) | NO |
INVT_SETTINGS Primary and Unique Keys |
Key Name | Key Type | Keys |
PI_0157 | PrimaryKey | COMPANY_ID |
INVT_SETTINGS Foreign Keys |
Parent Relationships: |
Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype | Deferrable | Initially Deferred |
S_CST_MTHD_CD | Non-Identifying | Zero or One to Zero or More | F01140 | S_CST_MTHD_CD | NO | NO | NO | ||
S_INVT_RECOG_CD | Non-Identifying | One To Zero or More | F01150 | S_INVT_RECOG_CD | NO | NO | NO | ||
S_ASSIGN_PT_CD | Non-Identifying | One To Zero or More | F01160 | S_SER_ASSIGN_PT_CD | NO | NO | NO | ||
S_ASSIGN_PT_CD | Non-Identifying | One To Zero or More | F01170 | S_LOT_ASSIGN_PT_CD | NO | NO | NO | ||
ACCT | Non-Identifying | Zero or One to Zero or More | F01180 | ACCR_PROJ_ACCT_ID | NO | NO | NO | ||
ACCT | Non-Identifying | Zero or One to Zero or More | F01190 | ACCR_NP_ACCT_ID | NO | NO | NO | ||
ORG_ACCT | Non-Identifying | Zero or One to Zero or More | F20794 | RM_VAR_ACCT_ID, RM_VAR_ORG_ID | NO | NO | NO | ||
ORG_ACCT | Non-Identifying | Zero or One to Zero or More | F20795 | WIP_VAR_ACCT_ID, WIP_VAR_ORG_ID | NO | NO | NO | ||
ORG_ACCT | Non-Identifying | Zero or One to Zero or More | F20796 | WIP_RLF_ACCT_ID, WIP_RLF_ORG_ID | NO | NO | NO | ||
ORG_ACCT | Non-Identifying | Zero or One to Zero or More | F20798 | STD_PPV_ACCT_ID, STD_PPV_ORG_ID | NO | NO | NO | ||
ORG_ACCT | Non-Identifying | Zero or One to Zero or More | F20799 | STD_MUV_ACCT_ID, STD_MUV_ORG_ID | NO | NO | NO | ||
ORG_ACCT | Non-Identifying | Zero or One to Zero or More | F20800 | STD_LEV_ACCT_ID, STD_LEV_ORG_ID | NO | NO | NO | ||
ORG_ACCT | Non-Identifying | Zero or One to Zero or More | F20801 | STD_LRV_ACCT_ID, STD_LRV_ORG_ID | NO | NO | NO | ||
ORG_ACCT | Non-Identifying | Zero or One to Zero or More | F20802 | STD_SUBC_ACCT_ID, STD_SUBC_ORG_ID | NO | NO | NO | ||
ORG_ACCT | Non-Identifying | Zero or One to Zero or More | F20803 | STD_MISC1_ACCT_ID, STD_MISC1_ORG_ID | NO | NO | NO | ||
ORG_ACCT | Non-Identifying | Zero or One to Zero or More | F20804 | STD_MISC2_ACCT_ID, STD_MISC2_ORG_ID | NO | NO | NO | ||
ORG_ACCT | Non-Identifying | Zero or One to Zero or More | F20805 | STD_TRNSF_ACCT_ID, STD_TRNSF_ORG_ID | NO | NO | NO | ||
ORG | Non-Identifying | Zero or One to Zero or More | F20806 | SCRP_NP_ORG_ID | NO | NO | NO | ||
ORG | Non-Identifying | Zero or One to Zero or More | F20807 | SCRP_PROJ_ORG_ID | NO | NO | NO | ||
ORG | Non-Identifying | Zero or One to Zero or More | F20808 | VAR_NP_ORG_ID | NO | NO | NO | ||
ORG | Non-Identifying | Zero or One to Zero or More | F20809 | VAR_PROJ_ORG_ID | NO | NO | NO | ||
ORG_ACCT | Non-Identifying | Zero or One to Zero or More | F21458 | RM_CONTRA_ACCT_ID, RM_CONTRA_ORG_ID | NO | NO | NO | ||
ORG_ACCT | Non-Identifying | Zero or One to Zero or More | FK_INVT_SETTINGS_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_SETTINGS_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_SETTINGS_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_SETTINGS_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_SETTINGS_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_SETTINGS_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_SETTINGS_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_SETTINGS_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_SETTINGS_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_SETTINGS_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_SETTINGS_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_SETTINGS_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_SETTINGS_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_SETTINGS_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_SETTINGS_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_SETTINGS_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_SETTINGS_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_SETTINGS_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_SETTINGS_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_SETTINGS_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_SETTINGS_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_SETTINGS_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_SETTINGS_PWPW_IDX | PW_RM_VAR_ACCT_ID, PW_RM_VAR_ORG_ID | NO | NO | NO | ||
ORG_ACCT | Non-Identifying | Zero or One to Zero or More | FK_INVT_SETTINGS_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_SETTINGS_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_SETTINGS_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_SETTINGS_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_SETTINGS_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_SETTINGS_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_SETTINGS_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_SETTINGS_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_SETTINGS_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_SETTINGS_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_SETTINGS_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_SETTINGS_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_SETTINGS_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_SETTINGS_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_SETTINGS_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_SETTINGS_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_SETTINGS_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_SETTINGS_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_SETTINGS_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_SETTINGS_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_SETTINGS_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_SETTINGS_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_SETTINGS_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_SETTINGS_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_SETTINGS_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_SETTINGS_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_SETTINGS_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_SETTINGS_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_SETTINGS_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_SETTINGS_W2W2_IDX | AVG_PWM2OH_ACCT_ID, AVG_PWM2OH_ORG_ID | NO | NO | NO |
Child Relationships: |
Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype | Deferrable | Initially Deferred |