CFT_RPT_HDR |
Default Table Name | CFT_RPT_HDR |
Definition |
CFT_RPT_HDR Columns |
ColumnName | Domain | Datatype | NULL | Definition |
TMPLT_CD![]() |
VARCHAR2(8) | NO | ||
ORG_ID![]() |
VARCHAR2(20) | NO | ||
CFT_FREQ_CD![]() |
VARCHAR2(15) | NO | ||
COMPANY_ID![]() |
VARCHAR2(10) | NO | ||
DISCLOSE | VARCHAR2(254) | YES | ||
CFT_HEADING_1 | VARCHAR2(16) | YES | ||
CFT_HEADING_2 | VARCHAR2(16) | YES | ||
CFT_HEADING_3 | VARCHAR2(16) | YES | ||
CFT_HEADING_4 | VARCHAR2(16) | YES | ||
CFT_HEADING_5 | VARCHAR2(16) | YES | ||
CFT_HEADING_6 | VARCHAR2(16) | YES | ||
CFT_START_1_DT | DATE | YES | ||
CFT_END_1_DT | DATE | YES | ||
CFT_END_2_DT | DATE | YES | ||
CFT_END_3_DT | DATE | YES | ||
CFT_END_4_DT | DATE | YES | ||
CFT_END_5_DT | DATE | YES | ||
CFT_END_6_DT | DATE | YES | ||
CFT_BEG_1_CASH_AMT | NUMBER(17, 2) | YES | ||
CFT_BEG_2_CASH_AMT | NUMBER(17, 2) | YES | ||
CFT_BEG_3_CASH_AMT | NUMBER(17, 2) | YES | ||
CFT_BEG_4_CASH_AMT | NUMBER(17, 2) | YES | ||
CFT_BEG_5_CASH_AMT | NUMBER(17, 2) | YES | ||
CFT_BEG_6_CASH_AMT | NUMBER(17, 2) | YES | ||
TIME_STAMP | DATE | NO | ||
ROWVERSION | NUMBER(10, 0) | YES | ||
MODIFIED_BY | VARCHAR2(20) | NO |
CFT_RPT_HDR Primary and Unique Keys |
Key Name | Key Type | Keys |
PI_7025 | PrimaryKey | TMPLT_CD, ORG_ID, CFT_FREQ_CD, COMPANY_ID |
CFT_RPT_HDR 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 |
CFT_RPT_DETL | Identifying | One To Zero or More | F21654 | NO | NO | NO |