1. Tables and Views for Financials
  2. FA_DEPRN_TAX_REP_T

FA_DEPRN_TAX_REP_T

FA_DEPRN_TAX_REP_T is the Depreciable Assets Tax Reports interim table.

Details

  • Schema: FUSION

  • Object owner: FA

  • Object type: TABLE

  • Tablespace: Default

Primary Key

Name Columns

FA_DEPRN_TAX_REP_T_PK

REQUEST_ID, BOOK_TYPE_CODE, STATE, ASSET_ID, MINOR_CATEGORY

Columns

Name Datatype Length Precision Not-null Comments
REQUEST_ID NUMBER 18 Yes Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row.
ASSET_ID NUMBER 18 Yes Identification number of the asset.
CATEGORY_ID NUMBER 18 Category identifier for the asset.
BOOK_TYPE_CODE VARCHAR2 30 Yes Asset book type identification code.
MINOR_CATEGORY VARCHAR2 150 Yes Minor category value for the asset type.
STATE VARCHAR2 150 Yes State value of location flexfield.
START_UNITS_ASSIGNED NUMBER Units assigned at start date used in asset tax report.
END_UNITS_ASSIGNED NUMBER Units assigned at end date used in asset tax report.
START_COST NUMBER Asset cost at depreciation start date.
END_COST NUMBER Asset cost at depreciation end date.
INCREASE_COST NUMBER Cost increase for a year used in asset tax report.
DECREASE_COST NUMBER Cost decrease for a year used in asset tax report.
THEORETICAL_NBV NUMBER Theoretical NBV calculation of the asset.
EVALUATED_NBV NUMBER Evaluated NBV calculation of the asset.
ERA_NAME_NUM VARCHAR2 30 Name of the era for the date the asset is placed in service. The Japanese era calendar scheme is a common calendar scheme used in Japan, which identifies a year by the combination of the Japanese era name and the year number within the era.
ADD_ERA_YEAR NUMBER 4 Year of the era for the date the asset is placed in service. The Japanese era calendar scheme is a common calendar scheme used in Japan, which identifies a year by the combination of the Japanese era name and the year number within the era.
ADD_MONTH NUMBER 4 Month of date placed in service.
START_LIFE NUMBER 4 Asset life at depreciation start date.
END_LIFE NUMBER 4 Asset life at depreciation end date.
THEORETICAL_RESIDUAL_RATE NUMBER Theoretical residual rate of the asset.
EVALUATED_RESIDUAL_RATE NUMBER Evaluated residual rate of the asset.
EXCEPTION_CODE VARCHAR2 30 Exception code for a tax exception in the asset tax report.
EXCEPTION_RATE NUMBER Exception rate for a tax exception in the asset tax report.
THEORETICAL_TAXABLE_COST NUMBER Taxable standard cost for theoretical NBV.
EVALUATED_TAXABLE_COST NUMBER Taxable standard cost for evaluated NBV.
ALL_REASON_CODE VARCHAR2 30 Reason code for detail report that lists all asset types. Possible values are 1 for new asset, 2 for used asset, 3 for transfer in, and 4 for other.
ALL_DESCRIPTION VARCHAR2 80 Description for detail report that lists all asset types.
ADD_DEC_FLAG VARCHAR2 1 Indicates which report is using the current record. Possible values are A for the additions report, D for the decreases report, and blank for others.
ADDDEC_REASON_CODE VARCHAR2 30 Reason code for detail report that lists additions in assets or decreases in assets. For additions, possible values are 1 for new addition, 2 for used addition, 3 for transfer in, and 4 for other. For decreases, possible values are 1 for sale, 2 for retirement, 3 for transfer out, and 4 for other.
ADDDEC_DESCRIPTION VARCHAR2 80 Description for detail report that lists the additions in assets or decreases in assets.
DEC_TYPE_CODE VARCHAR2 30 Decrease type for detail report that lists the decreases in assets. Possible values are 1 for all and 2 for partial.
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row.
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row.
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row.
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row.
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row.
OBJECT_VERSION_NUMBER NUMBER 9 Yes Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.

Indexes

Index Uniqueness Tablespace Columns
FA_DEPRN_TAX_REP_T_U1 Unique Default REQUEST_ID, BOOK_TYPE_CODE, STATE, ASSET_ID, MINOR_CATEGORY