Z_PJPCOMPR_AGGCEIL |
Default Table Name | Z_PJPCOMPR_AGGCEIL |
Definition |
Z_PJPCOMPR_AGGCEIL Columns |
ColumnName | Domain | Datatype | NULL | Definition |
PROJ_ID | VARCHAR2(30) | YES | ||
REV_PROJ_ID | VARCHAR2(30) | YES | ||
ACCT_ID | VARCHAR2(15) | YES | ||
ORG_ID | VARCHAR2(20) | YES | ||
S_REV_FORMULA_CD | VARCHAR2(8) | YES | ||
REV_ADJ_AMT | NUMBER(17, 2) | YES | ||
CONTR_LOSS_VAL_AMT | NUMBER(17, 2) | YES | ||
CEIL_V_FEE_RBA_CD | VARCHAR2(1) | YES | ||
CEIL_V_CST_RBA_CD | VARCHAR2(1) | YES | ||
CEIL_V_TOT_RBA_CD | VARCHAR2(1) | YES | ||
CEIL_F_FEE_RBA_CD | VARCHAR2(1) | YES | ||
CEIL_F_CST_RBA_CD | VARCHAR2(1) | YES | ||
CEIL_F_TOT_RBA_CD | VARCHAR2(1) | YES | ||
PROJ_V_FEE_AMT | NUMBER(17, 2) | YES | ||
PROJ_V_CST_AMT | NUMBER(17, 2) | YES | ||
PROJ_V_TOT_AMT | NUMBER(17, 2) | YES | ||
PROJ_F_FEE_AMT | NUMBER(17, 2) | YES | ||
PROJ_F_CST_AMT | NUMBER(17, 2) | YES | ||
PROJ_F_TOT_AMT | NUMBER(17, 2) | YES | ||
FEE_ON_DIR_AMT | NUMBER(17, 2) | YES | ||
FEE_ON_HRS_AMT | NUMBER(17, 2) | YES | ||
FEE_BURD_ACT_AMT | NUMBER(17, 2) | YES | ||
FEE_BURD_TGT_AMT | NUMBER(17, 2) | YES | ||
TOT_ACT_AL_EXP_AMT | NUMBER(17, 2) | YES | ||
TOT_TGT_AL_EXP_AMT | NUMBER(17, 2) | YES | ||
TOT_REV_ACT_AMT | NUMBER(17, 2) | YES | ||
TOT_REV_TGT_AMT | NUMBER(17, 2) | YES | ||
REALLOC_ACT_AMT | NUMBER(17, 2) | YES | ||
REALLOC_TGT_AMT | NUMBER(17, 2) | YES | ||
OVER_ACT_FEE_AMT | NUMBER(17, 2) | YES | ||
OVER_TGT_FEE_AMT | NUMBER(17, 2) | YES | ||
YTD_REV_ADJ_AMT | NUMBER(17, 2) | YES | ||
OVER_TGT_CST_AMT | NUMBER(17, 2) | YES | ||
OVER_ACT_CST_AMT | NUMBER(17, 2) | YES | ||
DOVR_ACT_TOT_AMT | NUMBER(17, 2) | YES | ||
DOVR_TGT_TOT_AMT | NUMBER(17, 2) | YES | ||
DCUR_OVRACTTOT_AMT | NUMBER(17, 2) | YES | ||
DCUR_OVRTGTTOT_AMT | NUMBER(17, 2) | YES | ||
DCUR_OVRACTCST_AMT | NUMBER(17, 2) | YES | ||
DCUR_OVRTGTCST_AMT | NUMBER(17, 2) | YES | ||
DCUR_OVRACTFEE_AMT | NUMBER(17, 2) | YES | ||
DCUR_OVRTGTFEE_AMT | NUMBER(17, 2) | YES | ||
DTOT_OVRACTCST_AMT | NUMBER(17, 2) | YES | ||
DTOT_OVRTGTCST_AMT | NUMBER(17, 2) | YES | ||
DTOT_OVRACTFEE_AMT | NUMBER(17, 2) | YES | ||
DTOT_OVRTGTFEE_AMT | NUMBER(17, 2) | YES | ||
DPY_AL_AMT | NUMBER(17, 2) | YES | ||
DPY_OVR_CST_AMT | NUMBER(17, 2) | YES | ||
DPY_FEE_ON_DIR_AMT | NUMBER(17, 2) | YES | ||
DPY_FEE_ON_HRS_AMT | NUMBER(17, 2) | YES | ||
DPY_FEE_BURD_AMT | NUMBER(17, 2) | YES | ||
DPY_OVR_FEE_AMT | NUMBER(17, 2) | YES | ||
DPY_TOT_REV_AMT | NUMBER(17, 2) | YES | ||
DPY_REAL_AMT | NUMBER(17, 2) | YES | ||
DPY_REV_ADJ_AMT | NUMBER(17, 2) | YES | ||
DPY_OVR_TOT_AMT | NUMBER(17, 2) | YES | ||
DTOT_OVRPYCST_AMT | NUMBER(17, 2) | YES | ||
DTOT_OVRPYFEE_AMT | NUMBER(17, 2) | YES | ||
DISC_ACT_AMT | NUMBER(17, 2) | YES | ||
DISC_TGT_AMT | NUMBER(17, 2) | YES | ||
PY_DISC_AMT | NUMBER(17, 2) | YES | ||
LLR_DISC_ACT_AMT | NUMBER(17, 2) | YES | ||
LLR_DISC_TGT_AMT | NUMBER(17, 2) | YES | ||
LLR_PY_DISC_AMT | NUMBER(17, 2) | YES | ||
TOT_REV_TMLAB_AMT | NUMBER(17, 2) | YES | ||
TOT_REV_TM_LAB_AMT | NUMBER(17, 2) | YES | ||
COM_ACT_AL_AMT | NUMBER(17, 2) | YES | ||
COM_TGT_AL_AMT | NUMBER(17, 2) | YES | ||
PY_COM_AL_AMT | NUMBER(17, 2) | YES | ||
LLR_ACT_AL_BUR_AMT | NUMBER(17, 2) | YES | ||
LLR_TGT_AL_BUR_AMT | NUMBER(17, 2) | YES | ||
LLR_PY_AL_BURD_AMT | NUMBER(17, 2) | YES |
Z_PJPCOMPR_AGGCEIL Primary and Unique Keys |
Key Name | Key Type | Keys |
Z_PJPCOMPR_AGGCEIL Foreign Keys |
Parent Relationships: |
Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype | Deferrable | Initially Deferred |
Child Relationships: |
Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype | Deferrable | Initially Deferred |