FA_PRJTD_PURCHASE |
Default Table Name | FA_PRJTD_PURCHASE |
Definition |
FA_PRJTD_PURCHASE Columns |
ColumnName | Domain | Datatype | NULL | Definition |
PRJTD_PURCHASE_KEY![]() |
NUMBER(10, 0) | NO | ||
ASSET_ACCT_ID![]() |
VARCHAR2(15) | NO | ||
ASSET_ORG_ID![]() |
VARCHAR2(20) | NO | ||
ASSET_PROJ_ID![]() |
VARCHAR2(30) | YES | ||
FY_CD | VARCHAR2(6) | NO | ||
PD_NO | NUMBER(5, 0) | NO | ||
SUB_PD_NO | NUMBER(5, 0) | NO | ||
SHORT_DESC | VARCHAR2(30) | NO | ||
DEPR_EXP_ALC_CD![]() |
VARCHAR2(6) | YES | ||
S_DEPR_BASED_ON_CD | VARCHAR2(1) | NO | ||
B1_EST_DEPR_AMT | NUMBER(17, 2) | NO | ||
B1_DEPR_START_DT | DATE | YES | ||
B1_DEPR_MTHD_CD![]() |
VARCHAR2(6) | YES | ||
B1_PD_DEPR_AMT | NUMBER(17, 2) | NO | ||
B2_EST_DEPR_AMT | NUMBER(17, 2) | NO | ||
B2_DEPR_START_DT | DATE | YES | ||
B2_DEPR_MTHD_CD![]() |
VARCHAR2(6) | YES | ||
B2_PD_DEPR_AMT | NUMBER(17, 2) | NO | ||
B3_EST_DEPR_AMT | NUMBER(17, 2) | NO | ||
B3_DEPR_START_DT | DATE | YES | ||
B3_DEPR_MTHD_CD![]() |
VARCHAR2(6) | YES | ||
B3_PD_DEPR_AMT | NUMBER(17, 2) | NO | ||
B4_EST_DEPR_AMT | NUMBER(17, 2) | NO | ||
B4_DEPR_START_DT | DATE | YES | ||
B4_DEPR_MTHD_CD![]() |
VARCHAR2(6) | YES | ||
B4_PD_DEPR_AMT | NUMBER(17, 2) | NO | ||
B5_EST_DEPR_AMT | NUMBER(17, 2) | NO | ||
B5_DEPR_START_DT | DATE | YES | ||
B5_DEPR_MTHD_CD![]() |
VARCHAR2(6) | YES | ||
B5_PD_DEPR_AMT | NUMBER(17, 2) | NO | ||
B6_EST_DEPR_AMT | NUMBER(17, 2) | NO | ||
B6_DEPR_START_DT | DATE | YES | ||
B6_DEPR_MTHD_CD![]() |
VARCHAR2(6) | YES | ||
B6_PD_DEPR_AMT | NUMBER(17, 2) | NO | ||
B7_EST_DEPR_AMT | NUMBER(17, 2) | NO | ||
B7_DEPR_START_DT | DATE | YES | ||
B7_DEPR_MTHD_CD![]() |
VARCHAR2(6) | YES | ||
B7_PD_DEPR_AMT | NUMBER(17, 2) | NO | ||
B8_EST_DEPR_AMT | NUMBER(17, 2) | NO | ||
B8_DEPR_START_DT | DATE | YES | ||
B8_DEPR_MTHD_CD![]() |
VARCHAR2(6) | YES | ||
B8_PD_DEPR_AMT | NUMBER(17, 2) | NO | ||
B9_EST_DEPR_AMT | NUMBER(17, 2) | NO | ||
B9_DEPR_START_DT | DATE | YES | ||
B9_DEPR_MTHD_CD![]() |
VARCHAR2(6) | YES | ||
B9_PD_DEPR_AMT | NUMBER(17, 2) | NO | ||
B10_EST_DEPR_AMT | NUMBER(17, 2) | NO | ||
B10_DEPR_START_DT | DATE | YES | ||
B10_DEPR_MTHD_CD![]() |
VARCHAR2(6) | YES | ||
B10_PD_DEPR_AMT | NUMBER(17, 2) | NO | ||
UNIT_DEPR_RT_AMT | NUMBER(19, 4) | NO | ||
CUR_UNITS_USED_NO | NUMBER(22, 8) | NO | ||
MTH_LEASE_PMT_AMT | NUMBER(17, 2) | NO | ||
LEASE_PDS_REMN_NO | NUMBER(5, 0) | NO | ||
MODIFIED_BY | VARCHAR2(20) | NO | ||
TIME_STAMP | DATE | NO | ||
ROWVERSION | NUMBER(10, 0) | YES |
FA_PRJTD_PURCHASE Primary and Unique Keys |
Key Name | Key Type | Keys |
PI_6701 | PrimaryKey | PRJTD_PURCHASE_KEY |
FA_PRJTD_PURCHASE Foreign Keys |
Parent Relationships: |
Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype | Deferrable | Initially Deferred |
ORG_ACCT | Non-Identifying | One To Zero or More | F21178 | ASSET_ACCT_ID, ASSET_ORG_ID | NO | NO | NO | ||
PROJ | Non-Identifying | Zero or One to Zero or More | F21179 | ASSET_PROJ_ID | NO | NO | NO | ||
DEPR_EXP_ALLOC_CD | Non-Identifying | Zero or One to Zero or More | F21181 | DEPR_EXP_ALC_CD | NO | NO | NO | ||
DEPR_MTHD | Non-Identifying | Zero or One to Zero or More | F21182 | B1_DEPR_MTHD_CD | NO | NO | NO | ||
DEPR_MTHD | Non-Identifying | Zero or One to Zero or More | F21183 | B2_DEPR_MTHD_CD | NO | NO | NO | ||
DEPR_MTHD | Non-Identifying | Zero or One to Zero or More | F21184 | B3_DEPR_MTHD_CD | NO | NO | NO | ||
DEPR_MTHD | Non-Identifying | Zero or One to Zero or More | F21185 | B4_DEPR_MTHD_CD | NO | NO | NO | ||
DEPR_MTHD | Non-Identifying | Zero or One to Zero or More | F21186 | B5_DEPR_MTHD_CD | NO | NO | NO | ||
DEPR_MTHD | Non-Identifying | Zero or One to Zero or More | F21187 | B6_DEPR_MTHD_CD | NO | NO | NO | ||
DEPR_MTHD | Non-Identifying | Zero or One to Zero or More | F21188 | B7_DEPR_MTHD_CD | NO | NO | NO | ||
DEPR_MTHD | Non-Identifying | Zero or One to Zero or More | F21189 | B8_DEPR_MTHD_CD | NO | NO | NO | ||
DEPR_MTHD | Non-Identifying | Zero or One to Zero or More | F21190 | B9_DEPR_MTHD_CD | NO | NO | NO | ||
DEPR_MTHD | Non-Identifying | Zero or One to Zero or More | F21191 | B10_DEPR_MTHD_CD | NO | NO | NO |
Child Relationships: |
Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype | Deferrable | Initially Deferred |
FA_PRJTD_DEPR_EXP | Non-Identifying | One To Zero or More | F21286 | NO | NO | NO |