FY |
Default Table Name | FY |
Definition |
FY Columns |
ColumnName | Domain | Datatype | NULL | Definition |
FY_CD![]() |
VARCHAR2(6) | NO | ||
FY_SEQ_NO | NUMBER(5, 0) | NO | ||
S_STATUS_CD | VARCHAR2(1) | NO | ||
FY_DESC | VARCHAR2(30) | NO | ||
MODIFIED_BY | VARCHAR2(20) | NO | ||
TIME_STAMP | DATE | NO | ||
S_CLOSE_ACT_TGT_CD | VARCHAR2(1) | YES | ||
ROWVERSION | NUMBER(10, 0) | YES |
FY Primary and Unique Keys |
Key Name | Key Type | Keys |
PI_0044 | PrimaryKey | FY_CD |
FY 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 |
ACCTING_PD | Identifying | One To Zero or More | F00030 | NO | NO | NO | |||
POOL_ALLOC | Identifying | One To Zero or More | F02780 | NO | NO | NO | |||
GL_BUD_RVSN | Identifying | One To Zero or More | F05550 | NO | NO | NO | |||
FS_SUM | Identifying | One To Zero or More | F08137 | NO | NO | NO | |||
PROJ_BUD_RVSN | Identifying | One To Zero or More | F08215 | NO | NO | NO | |||
REF_SUM | Identifying | One To Zero or More | F08280 | NO | NO | NO | |||
GL_POST_SUM | Non-Identifying | One To Zero or More | F09360 | NO | NO | NO | |||
LAB_HS | Non-Identifying | One To Zero or More | F09365 | NO | NO | NO | |||
PY_UNITS_PRICING | Non-Identifying | One To Zero or More | F09568 | NO | NO | NO | |||
PY_PROJ_LAB_HS | Non-Identifying | One To Zero or More | F09570 | NO | NO | NO | |||
PLAN_RATING_BY_GRD | Identifying | One To Zero or More | F09926 | NO | NO | NO | |||
NASA_FY | Identifying | One To Zero or More | F10018 | NO | NO | NO | |||
CONS_XFR_HS | Identifying | One To Zero or More | F20748 | NO | NO | NO | |||
MO_HDR_CST | Identifying | One To Zero or More | F20823 | NO | NO | NO |