FA_DEPRN_TAX_NBVS_REP_T
FA_DEPRN_TAX_NBVS_REP_T is used to track the previous reporting year's cost, the evaluated net book value (NBV), and the theoretical NBV to calculate this reporting year's amounts for the Depreciable Assets Tax Reports.
Details
-
Schema: FUSION
-
Object owner: FA
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
FA_DEPRN_TAX_NBVS_REP_T_PK |
DEPRN_TAX_REP_NBV_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| DEPRN_TAX_REP_NBV_ID | NUMBER | 18 | Yes | NBV identification number for the Depreciable Assets Tax Reports for Japan. | |
| ASSET_ID | NUMBER | 18 | Yes | Asset unique identifier in Oracle Fusion Assets. | |
| BOOK_TYPE_CODE | VARCHAR2 | 30 | Yes | Type code for the book to which this asset belongs. | |
| STATE | VARCHAR2 | 150 | Yes | Reporting location for asset tax report. | |
| YEAR | NUMBER | 4 | Reporting fiscal year for asset tax report. | ||
| COST | NUMBER | Yes | Asset cost on the previous year's reporting date. This amount determines whether the asset cost has increased or decreased during the reporting year. | ||
| THEORETICAL_NBV | NUMBER | Theoretical NBV on the previous year's reporting date. This amount determines this year's theoretical NBV. You must specify both the THEORETICAL_NBV and EVALUATED_NBV values, otherwise this reporting year's theoretical NBV is based on the asset cost and rate on the reporting date. | |||
| EVALUATED_NBV | NUMBER | Evaluated NBV on the previous year's reporting date. This amount determines this year's evaluated NBV. You must specify both THEORETICAL_NBV and EVALUATED_NBV values, otherwise this reporting year's evaluated NBV is based on the asset cost and rate on the reporting date. | |||
| TAX_ASSET_TYPE | VARCHAR2 | 30 | Minor category value assigned to this asset on the previous year's reporting date. | ||
| UNITS_ASSIGNED | NUMBER | Units for this location on the previous year's reporting date. | |||
| LIFE | NUMBER | 4 | Useful life of this asset on the previous year's reporting date. | ||
| MINOR_CATEGORY | VARCHAR2 | 150 | Value of the minor category segment on January 1 of the reporting year. | ||
| ACTION_FLAG | VARCHAR2 | 1 | Indicates whether to set the start cost of the current year to zero. | ||
| 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. | |
| LOAD_REQUEST_ID | NUMBER | 18 | Oracle Fusion Enterprise Resource Planning: request ID of the job that created or last updated the row. | ||
| ASSET_NUMBER | VARCHAR2 | 30 | Unique asset number. Can be either provided by user or generated by the system. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| FA_DEPRN_TAX_NBVS_REP_T_U1 | Unique | Default | DEPRN_TAX_REP_NBV_ID |
| FA_DEPRN_TAX_NBVS_REP_T_U2 | Unique | Default | ASSET_ID, BOOK_TYPE_CODE, YEAR, STATE |