X_CPLAN_CPOINT |
Default Table Name | X_CPLAN_CPOINT |
Definition |
X_CPLAN_CPOINT Columns |
ColumnName | Domain | Datatype | NULL | Definition |
FY_CD![]() |
VARCHAR2(6) | NO | ||
GL_BUD_RVSN_ID![]() |
VARCHAR2(10) | NO | ||
ORG_ID![]() |
VARCHAR2(20) | NO | ||
ACCT_ID![]() |
VARCHAR2(15) | NO | ||
PD1_BUD_AMT | NUMBER(17, 2) | NO | ||
PD2_BUD_AMT | NUMBER(17, 2) | NO | ||
PD3_BUD_AMT | NUMBER(17, 2) | NO | ||
PD4_BUD_AMT | NUMBER(17, 2) | NO | ||
PD5_BUD_AMT | NUMBER(17, 2) | NO | ||
PD6_BUD_AMT | NUMBER(17, 2) | NO | ||
PD7_BUD_AMT | NUMBER(17, 2) | NO | ||
PD8_BUD_AMT | NUMBER(17, 2) | NO | ||
PD9_BUD_AMT | NUMBER(17, 2) | NO | ||
PD10_BUD_AMT | NUMBER(17, 2) | NO | ||
PD11_BUD_AMT | NUMBER(17, 2) | NO | ||
PD12_BUD_AMT | NUMBER(17, 2) | NO | ||
PD13_BUD_AMT | NUMBER(17, 2) | NO | ||
PD14_BUD_AMT | NUMBER(17, 2) | NO | ||
PD15_BUD_AMT | NUMBER(17, 2) | NO | ||
PD16_BUD_AMT | NUMBER(17, 2) | NO | ||
PD17_BUD_AMT | NUMBER(17, 2) | NO | ||
PD18_BUD_AMT | NUMBER(17, 2) | NO | ||
FILE_NAME | VARCHAR2(254) | YES |
X_CPLAN_CPOINT Primary and Unique Keys |
Key Name | Key Type | Keys |
PI_6917 | PrimaryKey | FY_CD, GL_BUD_RVSN_ID, ORG_ID, ACCT_ID |
X_CPLAN_CPOINT 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 |