INVT_PROJ |
Default Table Name | INVT_PROJ |
Definition |
INVT_PROJ Columns |
ColumnName | Domain | Datatype | NULL | Definition |
PROJ_ID![]() |
VARCHAR2(30) | NO | ||
S_ROLLUP_CD | VARCHAR2(1) | NO | ||
S_CST_MTHD_CD![]() |
VARCHAR2(1) | NO | ||
NET_GRP_ID![]() |
VARCHAR2(8) | YES | ||
S_MRP_OPTION_CD![]() |
VARCHAR2(1) | YES | ||
WHSE_ID![]() |
VARCHAR2(8) | YES | ||
COMMON_INVT_FL | VARCHAR2(1) | NO | ||
MODIFIED_BY | VARCHAR2(20) | NO | ||
TIME_STAMP | DATE | NO | ||
COMPANY_ID![]() |
VARCHAR2(10) | NO | ||
RQ_APPR_PROC_CD![]() |
VARCHAR2(8) | YES | ||
S_INTR_PROJ_ISS_CD | VARCHAR2(1) | NO | ||
DFLT_RM_IN_ABBR_CD | VARCHAR2(20) | YES | ||
DFLT_FG_IN_ABBR_CD | VARCHAR2(20) | YES | ||
PLANNER_ID | VARCHAR2(12) | YES | ||
LAST_MO_ID | VARCHAR2(10) | YES | ||
S_MO_ALLOC_CD | VARCHAR2(1) | 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 | ||
ALLOC_CLR_ACCT_ID![]() |
VARCHAR2(15) | YES | ||
ALLOC_CLR_ORG_ID![]() |
VARCHAR2(20) | YES | ||
CS_INVT_ABBRV_CD | VARCHAR2(20) | YES | ||
RM_CONTRA_ACCT_ID![]() |
VARCHAR2(15) | YES | ||
RM_CONTRA_ORG_ID![]() |
VARCHAR2(20) | YES | ||
ROWVERSION | NUMBER(10, 0) | YES | ||
APPLY_STD_RT_FL | VARCHAR2(1) | NO | ||
WIP_MAT_ACCT_ID | VARCHAR2(15) | YES | ||
WIP_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_MAT_ACCT_ID | VARCHAR2(15) | YES | ||
EXP_MAT_ORG_ID | VARCHAR2(20) | YES | ||
EXP_TRN_ACCT_ID | VARCHAR2(15) | YES | ||
EXP_TRN_ORG_ID | VARCHAR2(20) | YES | ||
PROJ_CST_ROLLUP_FL | VARCHAR2(1) | NO | ||
MES_FL | VARCHAR2(1) | YES | ||
SFT_FL | VARCHAR2(1) | YES |
INVT_PROJ Primary and Unique Keys |
Key Name | Key Type | Keys |
PI_0249 | PrimaryKey | PROJ_ID |
INVT_PROJ Foreign Keys |
Parent Relationships: |
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 |
Child Relationships: |
Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype | Deferrable | Initially Deferred |
INVT_ABBRV_CD | Non-Identifying | One To Zero or More | F01090 | NO | NO | NO |