QPROJ_TEMPLATE |
Default Table Name | QPROJ_TEMPLATE |
Definition |
QPROJ_TEMPLATE Columns |
ColumnName | Domain | Datatype | NULL | Definition |
TEMPLATE_ID![]() |
VARCHAR2(15) | NO | ||
TEMPLATE_DESC | VARCHAR2(25) | NO | ||
PROJ_ID_ROLE | VARCHAR2(15) | YES | ||
PROJ_NAME_ROLE | VARCHAR2(15) | YES | ||
PROJ_ABBRV_REQD | VARCHAR2(1) | NO | ||
PROJ_ABBRV_ROLE | VARCHAR2(15) | YES | ||
EMPL_ID_REQD | VARCHAR2(1) | NO | ||
EMPL_ID_DFLT | VARCHAR2(12) | YES | ||
EMPL_ID_ROLE | VARCHAR2(15) | YES | ||
CUST_ID_REQD | VARCHAR2(1) | NO | ||
CUST_ID_DFLT | VARCHAR2(12) | YES | ||
CUST_ID_ROLE | VARCHAR2(15) | YES | ||
PRIME_CONTR_REQD | VARCHAR2(1) | NO | ||
PRIME_CONTR_DFLT | VARCHAR2(20) | YES | ||
PRIME_CONTR_ROLE | VARCHAR2(15) | YES | ||
SUBCTR_ID_REQD | VARCHAR2(1) | NO | ||
SUBCTR_ID_DFLT | VARCHAR2(20) | YES | ||
SUBCTR_ID_ROLE | VARCHAR2(15) | YES | ||
CUST_PO_ID_REQD | VARCHAR2(1) | NO | ||
CUST_PO_ID_DFLT | VARCHAR2(20) | YES | ||
CUST_PO_ID_ROLE | VARCHAR2(15) | YES | ||
PROJ_TYPE_DC_REQD | VARCHAR2(1) | NO | ||
PROJ_TYPE_DC_DFLT | VARCHAR2(15) | YES | ||
PROJ_TYPE_DC_ROLE | VARCHAR2(15) | YES | ||
S_PROJ_RPT_DC_REQD | VARCHAR2(1) | NO | ||
S_PROJ_RPT_DC_DFLT | VARCHAR2(15) | YES | ||
S_PROJ_RPT_DC_ROLE | VARCHAR2(15) | YES | ||
ACTIVE_FL_DFLT | VARCHAR2(1) | NO | ||
ACTIVE_FL_ROLE | VARCHAR2(15) | YES | ||
ALLOW_CHARGES_DFLT | VARCHAR2(1) | NO | ||
ALLOW_CHARGES_ROLE | VARCHAR2(15) | YES | ||
ACCT_GRP_CD_REQD | VARCHAR2(1) | NO | ||
ACCT_GRP_CD_SRCE | VARCHAR2(1) | YES | ||
ACCT_GRP_CD_DFLT | VARCHAR2(3) | YES | ||
ACCT_GRP_CD_ROLE | VARCHAR2(15) | YES | ||
ORG_ID_REQD | VARCHAR2(1) | NO | ||
ORG_ID_SRCE | VARCHAR2(1) | YES | ||
ORG_ID_DFLT | VARCHAR2(20) | YES | ||
ORG_ID_ROLE | VARCHAR2(15) | YES | ||
TOP_LVL_WF_FL_DFLT | VARCHAR2(1) | NO | ||
TOP_LVL_WF_FL_ROLE | VARCHAR2(15) | YES | ||
S_REV_FORMULA_ROLE | VARCHAR2(15) | YES | ||
S_BIL_FORMULA_ROLE | VARCHAR2(15) | YES | ||
BILL_FRMT_CD_ROLE | VARCHAR2(15) | YES | ||
PROJ_MOD_ROLE | VARCHAR2(15) | YES | ||
NOTES_ROLE | VARCHAR2(15) | YES | ||
COMPANY_ID![]() |
VARCHAR2(10) | NO | ||
MODIFIED_BY | VARCHAR2(20) | NO | ||
TIME_STAMP | DATE | NO | ||
ROWVERSION | NUMBER(10, 0) | YES |
QPROJ_TEMPLATE Primary and Unique Keys |
Key Name | Key Type | Keys |
PI_7116 | PrimaryKey | TEMPLATE_ID, COMPANY_ID |
QPROJ_TEMPLATE 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 |