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(14, 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 |
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 |
Child Relationships: |
Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype | Deferrable | Initially Deferred |