ASSET_OTH_BK_DEPR |
Default Table Name | ASSET_OTH_BK_DEPR |
Definition |
ASSET_OTH_BK_DEPR Columns |
ColumnName | Domain | Datatype | NULL | Definition |
ASSET_ID![]() |
VARCHAR2(10) | NO | ||
ITEM_NO![]() |
NUMBER(10, 0) | NO | ||
B2_DEPR_MTHD_CD | VARCHAR2(6) | YES | ||
B2_USEFUL_LIFE_NO | NUMBER(10, 0) | NO | ||
B2_AUTO_CALC_FL | VARCHAR2(1) | NO | ||
B2_SLVGE_RT | NUMBER(7, 6) | NO | ||
B2_SLVGE_VAL_AMT | NUMBER(17, 2) | NO | ||
B2_FYTD_DEPR_AMT | NUMBER(17, 2) | NO | ||
B2_PFY_DEPR_AMT | NUMBER(17, 2) | NO | ||
B2_CUR_DEPR_AMT | NUMBER(17, 2) | NO | ||
B2_ANNL_DEPR_AMT | NUMBER(17, 2) | NO | ||
B2_TOT_CST_AMT | NUMBER(17, 2) | NO | ||
B2_DEPR_START_DT | DATE | YES | ||
B2_IN_SERVICE_DT | DATE | YES | ||
B2_CUR_DEPR_YR_NO | NUMBER(5, 0) | YES | ||
B2_PDS_REMAIN_NO | NUMBER(5, 0) | YES | ||
B2_DP_DEPR_YTD_AMT | NUMBER(17, 2) | NO | ||
B3_DEPR_MTHD_CD | VARCHAR2(6) | YES | ||
B3_USEFUL_LIFE_NO | NUMBER(10, 0) | NO | ||
B3_AUTO_CALC_FL | VARCHAR2(1) | NO | ||
B3_SLVGE_RT | NUMBER(7, 6) | NO | ||
B3_SLVGE_VAL_AMT | NUMBER(17, 2) | NO | ||
B3_FYTD_DEPR_AMT | NUMBER(17, 2) | NO | ||
B3_PFY_DEPR_AMT | NUMBER(17, 2) | NO | ||
B3_CUR_DEPR_AMT | NUMBER(17, 2) | NO | ||
B3_ANNL_DEPR_AMT | NUMBER(17, 2) | NO | ||
B3_TOT_CST_AMT | NUMBER(17, 2) | NO | ||
B3_DEPR_START_DT | DATE | YES | ||
B3_IN_SERVICE_DT | DATE | YES | ||
B3_CUR_DEPR_YR_NO | NUMBER(5, 0) | YES | ||
B3_PDS_REMAIN_NO | NUMBER(5, 0) | YES | ||
B3_DP_DEPR_YTD_AMT | NUMBER(17, 2) | NO | ||
B4_DEPR_MTHD_CD | VARCHAR2(6) | YES | ||
B4_USEFUL_LIFE_NO | NUMBER(10, 0) | NO | ||
B4_AUTO_CALC_FL | VARCHAR2(1) | NO | ||
B4_SLVGE_RT | NUMBER(7, 6) | NO | ||
B4_SLVGE_VAL_AMT | NUMBER(17, 2) | NO | ||
B4_FYTD_DEPR_AMT | NUMBER(17, 2) | NO | ||
B4_PFY_DEPR_AMT | NUMBER(17, 2) | NO | ||
B4_CUR_DEPR_AMT | NUMBER(17, 2) | NO | ||
B4_ANNL_DEPR_AMT | NUMBER(17, 2) | NO | ||
B4_TOT_CST_AMT | NUMBER(17, 2) | NO | ||
B4_DEPR_START_DT | DATE | YES | ||
B4_IN_SERVICE_DT | DATE | YES | ||
B4_CUR_DEPR_YR_NO | NUMBER(5, 0) | YES | ||
B4_PDS_REMAIN_NO | NUMBER(5, 0) | YES | ||
B4_DP_DEPR_YTD_AMT | NUMBER(17, 2) | NO | ||
B5_DEPR_MTHD_CD | VARCHAR2(6) | YES | ||
B5_USEFUL_LIFE_NO | NUMBER(10, 0) | NO | ||
B5_AUTO_CALC_FL | VARCHAR2(1) | NO | ||
B5_SLVGE_RT | NUMBER(7, 6) | NO | ||
B5_SLVGE_VAL_AMT | NUMBER(17, 2) | NO | ||
B5_FYTD_DEPR_AMT | NUMBER(17, 2) | NO | ||
B5_PFY_DEPR_AMT | NUMBER(17, 2) | NO | ||
B5_CUR_DEPR_AMT | NUMBER(17, 2) | NO | ||
B5_ANNL_DEPR_AMT | NUMBER(17, 2) | NO | ||
B5_TOT_CST_AMT | NUMBER(17, 2) | NO | ||
B5_DEPR_START_DT | DATE | YES | ||
B5_IN_SERVICE_DT | DATE | YES | ||
B5_CUR_DEPR_YR_NO | NUMBER(5, 0) | YES | ||
B5_PDS_REMAIN_NO | NUMBER(5, 0) | YES | ||
B5_DP_DEPR_YTD_AMT | NUMBER(17, 2) | NO | ||
B6_DEPR_MTHD_CD | VARCHAR2(6) | YES | ||
B6_USEFUL_LIFE_NO | NUMBER(10, 0) | NO | ||
B6_AUTO_CALC_FL | VARCHAR2(1) | NO | ||
B6_SLVGE_RT | NUMBER(7, 6) | NO | ||
B6_SLVGE_VAL_AMT | NUMBER(17, 2) | NO | ||
B6_FYTD_DEPR_AMT | NUMBER(17, 2) | NO | ||
B6_PFY_DEPR_AMT | NUMBER(17, 2) | NO | ||
B6_CUR_DEPR_AMT | NUMBER(17, 2) | NO | ||
B6_ANNL_DEPR_AMT | NUMBER(17, 2) | NO | ||
B6_TOT_CST_AMT | NUMBER(17, 2) | NO | ||
B6_DEPR_START_DT | DATE | YES | ||
B6_IN_SERVICE_DT | DATE | YES | ||
B6_CUR_DEPR_YR_NO | NUMBER(5, 0) | YES | ||
B6_PDS_REMAIN_NO | NUMBER(5, 0) | YES | ||
B6_DP_DEPR_YTD_AMT | NUMBER(17, 2) | NO | ||
B7_DEPR_MTHD_CD | VARCHAR2(6) | YES | ||
B7_USEFUL_LIFE_NO | NUMBER(10, 0) | NO | ||
B7_AUTO_CALC_FL | VARCHAR2(1) | NO | ||
B7_SLVGE_RT | NUMBER(7, 6) | NO | ||
B7_SLVGE_VAL_AMT | NUMBER(17, 2) | NO | ||
B7_FYTD_DEPR_AMT | NUMBER(17, 2) | NO | ||
B7_PFY_DEPR_AMT | NUMBER(17, 2) | NO | ||
B7_CUR_DEPR_AMT | NUMBER(17, 2) | NO | ||
B7_ANNL_DEPR_AMT | NUMBER(17, 2) | NO | ||
B7_TOT_CST_AMT | NUMBER(17, 2) | NO | ||
B7_DEPR_START_DT | DATE | YES | ||
B7_IN_SERVICE_DT | DATE | YES | ||
B7_CUR_DEPR_YR_NO | NUMBER(5, 0) | YES | ||
B7_PDS_REMAIN_NO | NUMBER(5, 0) | YES | ||
B7_DP_DEPR_YTD_AMT | NUMBER(17, 2) | NO | ||
B8_DEPR_MTHD_CD | VARCHAR2(6) | YES | ||
B8_USEFUL_LIFE_NO | NUMBER(10, 0) | NO | ||
B8_AUTO_CALC_FL | VARCHAR2(1) | NO | ||
B8_SLVGE_RT | NUMBER(7, 6) | NO | ||
B8_SLVGE_VAL_AMT | NUMBER(17, 2) | NO | ||
B8_FYTD_DEPR_AMT | NUMBER(17, 2) | NO | ||
B8_PFY_DEPR_AMT | NUMBER(17, 2) | NO | ||
B8_CUR_DEPR_AMT | NUMBER(17, 2) | NO | ||
B8_ANNL_DEPR_AMT | NUMBER(17, 2) | NO | ||
B8_TOT_CST_AMT | NUMBER(17, 2) | NO | ||
B8_DEPR_START_DT | DATE | YES | ||
B8_IN_SERVICE_DT | DATE | YES | ||
B8_CUR_DEPR_YR_NO | NUMBER(5, 0) | YES | ||
B8_PDS_REMAIN_NO | NUMBER(5, 0) | YES | ||
B8_DP_DEPR_YTD_AMT | NUMBER(17, 2) | NO | ||
B9_DEPR_MTHD_CD | VARCHAR2(6) | YES | ||
B9_USEFUL_LIFE_NO | NUMBER(10, 0) | NO | ||
B9_AUTO_CALC_FL | VARCHAR2(1) | NO | ||
B9_SLVGE_RT | NUMBER(7, 6) | NO | ||
B9_SLVGE_VAL_AMT | NUMBER(17, 2) | NO | ||
B9_FYTD_DEPR_AMT | NUMBER(17, 2) | NO | ||
B9_PFY_DEPR_AMT | NUMBER(17, 2) | NO | ||
B9_CUR_DEPR_AMT | NUMBER(17, 2) | NO | ||
B9_ANNL_DEPR_AMT | NUMBER(17, 2) | NO | ||
B9_TOT_CST_AMT | NUMBER(17, 2) | NO | ||
B9_DEPR_START_DT | DATE | YES | ||
B9_IN_SERVICE_DT | DATE | YES | ||
B9_CUR_DEPR_YR_NO | NUMBER(5, 0) | YES | ||
B9_PDS_REMAIN_NO | NUMBER(5, 0) | YES | ||
B9_DP_DEPR_YTD_AMT | NUMBER(17, 2) | NO | ||
B10_DEPR_MTHD_CD | VARCHAR2(6) | YES | ||
B10_USEFUL_LIFE_NO | NUMBER(10, 0) | NO | ||
B10_AUTO_CALC_FL | VARCHAR2(1) | NO | ||
B10_SLVGE_RT | NUMBER(7, 6) | NO | ||
B10_SLVGE_VAL_AMT | NUMBER(17, 2) | NO | ||
B10_FYTD_DEPR_AMT | NUMBER(17, 2) | NO | ||
B10_PFY_DEPR_AMT | NUMBER(17, 2) | NO | ||
B10_CUR_DEPR_AMT | NUMBER(17, 2) | NO | ||
B10_ANNL_DEPR_AMT | NUMBER(17, 2) | NO | ||
B10_TOT_CST_AMT | NUMBER(17, 2) | NO | ||
B10_DEPR_START_DT | DATE | YES | ||
B10_IN_SERVICE_DT | DATE | YES | ||
B10_CUR_DEPR_YR_NO | NUMBER(5, 0) | YES | ||
B10_PDS_REMAIN_NO | NUMBER(5, 0) | YES | ||
B10DP_DEPR_YTD_AMT | NUMBER(17, 2) | NO | ||
MODIFIED_BY | VARCHAR2(20) | NO | ||
TIME_STAMP | DATE | NO | ||
COMPANY_ID![]() |
VARCHAR2(10) | NO | ||
B2_DP_DEPR_NY_AMT | NUMBER(17, 2) | YES | ||
B3_DP_DEPR_NY_AMT | NUMBER(17, 2) | YES | ||
B4_DP_DEPR_NY_AMT | NUMBER(17, 2) | YES | ||
B5_DP_DEPR_NY_AMT | NUMBER(17, 2) | YES | ||
B6_DP_DEPR_NY_AMT | NUMBER(17, 2) | YES | ||
B7_DP_DEPR_NY_AMT | NUMBER(17, 2) | YES | ||
B8_DP_DEPR_NY_AMT | NUMBER(17, 2) | YES | ||
B9_DP_DEPR_NY_AMT | NUMBER(17, 2) | YES | ||
B10_DP_DEPR_NY_AMT | NUMBER(17, 2) | YES | ||
ROWVERSION | NUMBER(10, 0) | YES |
ASSET_OTH_BK_DEPR Primary and Unique Keys |
Key Name | Key Type | Keys |
PI_0975 | PrimaryKey | ASSET_ID, ITEM_NO, COMPANY_ID |
ASSET_OTH_BK_DEPR Foreign Keys |
Parent Relationships: |
Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype | Deferrable | Initially Deferred |
ASSET | Identifying | One To Zero or More | F09849 | ASSET_ID, ITEM_NO, COMPANY_ID | NO | NO | NO |
Child Relationships: |
Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype | Deferrable | Initially Deferred |