PROJ_NB_REV_SETUP |
Default Table Name | PROJ_NB_REV_SETUP |
Definition |
PROJ_NB_REV_SETUP Columns |
ColumnName | Domain | Datatype | NULL | Definition |
ROW_UID | VARCHAR2(36) | NO | ||
PROJ_ID | VARCHAR2(50) | YES | ||
REV_TYPE | VARCHAR2(50) | YES | ||
REV_ACCT_ID | VARCHAR2(20) | YES | ||
DFLT_FEE_RT | NUMBER(12, 4) | YES | ||
LAB_COST_FL | VARCHAR2(1) | YES | ||
LAB_BURD_FL | VARCHAR2(1) | YES | ||
LAB_FEE_COST_FL | VARCHAR2(1) | YES | ||
LAB_FEE_HRS_FL | VARCHAR2(1) | YES | ||
LAB_FEE_RT | NUMBER(12, 4) | YES | ||
LAB_TM_FL | VARCHAR2(1) | YES | ||
MTRL_COST_FL | VARCHAR2(1) | YES | ||
MTRL_BURD_FL | VARCHAR2(1) | YES | ||
MTRL_FEE_COST_FL | VARCHAR2(1) | YES | ||
MTRL_FEE_RT | NUMBER(12, 4) | YES | ||
SUBC_COST_FL | VARCHAR2(1) | YES | ||
SUBC_BURD_FL | VARCHAR2(1) | YES | ||
SUBC_FEE_COST_FL | VARCHAR2(1) | YES | ||
SUBC_FEE_RT | NUMBER(12, 4) | YES | ||
MSBK_COST_FL | VARCHAR2(1) | YES | ||
MSBK_BURD_FL | VARCHAR2(1) | YES | ||
MSBK_FEE_COST_FL | VARCHAR2(1) | YES | ||
MSBK_FEE_RT | NUMBER(12, 4) | YES | ||
TRVL_COST_FL | VARCHAR2(1) | YES | ||
TRVL_BURD_FL | VARCHAR2(1) | YES | ||
TRVL_FEE_COST_FL | VARCHAR2(1) | YES | ||
TRVL_FEE_RT | NUMBER(12, 4) | YES | ||
CONS_COST_FL | VARCHAR2(1) | YES | ||
CONS_BURD_FL | VARCHAR2(1) | YES | ||
CONS_FEE_COST_FL | VARCHAR2(1) | YES | ||
CONS_FEE_RT | NUMBER(12, 4) | YES | ||
ODCS_COST_FL | VARCHAR2(1) | YES | ||
ODCS_BURD_FL | VARCHAR2(1) | YES | ||
ODCS_FEE_COST_FL | VARCHAR2(1) | YES | ||
ODCS_FEE_RT | NUMBER(12, 4) | YES | ||
SUBC_HRS_COST_FL | VARCHAR2(1) | YES | ||
SUBC_HRS_BURD_FL | VARCHAR2(1) | YES | ||
SUBC_HRS_COST_FEE_FL | VARCHAR2(1) | YES | ||
SUBC_HRS_HRS_FEE_FL | VARCHAR2(1) | YES | ||
SUBC_HRS_FEE_RT | NUMBER(12, 4) | YES | ||
SUBC_HRS_TM_FL | VARCHAR2(1) | YES | ||
CONS_HRS_COST_FL | VARCHAR2(1) | YES | ||
CONS_HRS_BURD_FL | VARCHAR2(1) | YES | ||
CONS_HRS_COST_FEE_FL | VARCHAR2(1) | YES | ||
CONS_HRS_HRS_FEE_FL | VARCHAR2(1) | YES | ||
CONS_HRS_FEE_RT | NUMBER(12, 4) | YES | ||
CONS_HRS_TM_FL | VARCHAR2(1) | YES | ||
OVERRIDE_REV_AMT_FL | VARCHAR2(1) | NO | ||
OVERRIDE_REV_ADJ_FL | VARCHAR2(1) | NO | ||
ROWVERSION | NUMBER(10, 0) | NO | ||
MODIFIED_BY | VARCHAR2(50) | NO | ||
TIME_STAMP | DATE | NO |
PROJ_NB_REV_SETUP Primary and Unique Keys |
Key Name | Key Type | Keys |
IX_PROJ_NB_REV_SETUP | Index | PROJ_ID, REV_TYPE, REV_ACCT_ID |
PROJ_NB_REV_SETUP 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 |