eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

TABLE: FA.FA_DEPRN_TAX_REP_NBVS

Object Details

Object Name:	FA_DEPRN_TAX_REP_NBVS
Object Type:	TABLE
Owner:	FA
FND Design Data:	OFA.FA_DEPRN_TAX_REP_NBVS
Subobject Name:
Status:	VALID

This table is used to track the previous reporting year's cost, evaluated NBV, and theoretical NBV to calculate this reporting year's amounts for the Depreciable Assets Tax Reports.
When the table column contains the previous year's evaluated NBV and theoretical NBV, the system calculates the evaluated and theoretical NBVs for the reported year based on these values. After running the report, the system inserts the reported cost and the calculated evaluated and theoretical NBVs into the table for following year's reporting.
When the table does not contain the previous year's evaluated NBV and theoretical NBV, the system calculates the evaluated and theoretical NBV for the reported year based on the cost. After running the report, the system inserts only the cost into the table, and keeps the evaluated and theoretical NBVs NULL.
Converting from a Legacy System Using this Table

If you are converting from a legacy system, you can use this table to import the asset cost, evaluated NBV, and theoretical NBV. These values are then used to calculate the evaluated and theoretical NBVs, and also to report increases and decreases for the reported year.
Importing Cost, Evaluated NBV and Theoretical NBV as of the previous reported year: The system calculates the evaluated and theoretical NBVs for the reported year based on the previous year's NBVs (Method A). Asset increases and decreases are calculated using the imported cost.
Importing only the cost as of the previous reported year: The system calculates the evaluated and theoretical NBVs for the reported year based on the asset cost (Method B). Asset increases and decreases are calculated using the imported cost.
Not Importing: The system calculates the evaluated and theoretical NBVs for the reported year based on the asset cost (Method B). Asset increases and decreases are calculated using historical data. You should import all the transaction history data for the previous 12 months into the system.
How the Evaluated and Theoretical NBV are Calculated
Method A

For assets acquired during the reported year:
Evaluated NBV = Cost * (1 - r/2)
Theoretical NBV = Cost * (1 - r*(13-m)/12)
For assets acquired before the reported year:
Evaluated NBV = [Previous year's evaluated NBV] * (1-r)
Theoretical NBV = [Previous year's theoretical NBV] * (1-r)
Method B
Evaluated NBV = [Current Cost] *(1-r/2)*(1-r)n-1
Theoretical NBV = [Current Cost] *(1- r*(13-m)/12)*(1-r)n-1

Key:
r : Adjusted Rate
m: Acquisition Month
n: Reporting Year - Acquisition Year

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
FA_DEPRN_TAX_REP_NBVS_U1	NORMAL	UNIQUE	APPS_TS_INTERFACE	DEPRN_TAX_REP_NBV_ID
FA_DEPRN_TAX_REP_NBVS_U2	NORMAL	UNIQUE	APPS_TS_INTERFACE	ASSET_ID BOOK_TYPE_CODE STATE YEAR

Columns

Name	Datatype	Length	Mandatory	Comments
DEPRN_TAX_REP_NBV_ID	NUMBER	(15)	Yes	Japanese Depreciable Assets Tax Reports' NBV identification Number
ASSET_ID	NUMBER	(15)	Yes	Unique identifier of the asset in Oracle Assets
BOOK_TYPE_CODE	VARCHAR2	(15)	Yes	Book type code to which this asset belongs
STATE	VARCHAR2	(150)	Yes	Reported location
YEAR	NUMBER		Yes	Reported fiscal year
COST	NUMBER		Yes	Asset cost as of the previous year's reporting date. When you run the report, the system will use this amount to decide if this asset cost has increased or decreased during the reported year.
THEORETICAL_NBV	NUMBER			The theoretical NBV as of the previous year's reporting date. This is the base amount the system uses to calculate this year's theoretical NBV. You must specify both the THEORETICAL_NBV and EVALUATED_NBV values when you provide these amounts. If you do not provide these amounts, the system calculates this reported year's theoretical NBV based on the asset cost and rate as of the reporting date.
EVALUATED_NBV	NUMBER			The evaluated NBV as of the previous year's reporting date. This is the base amount the system uses to calculate this year's evaluated NBV. You must specify both THEORETICAL_NBV and EVALUATED_NBV when you provide these amounts. If you do not provide these amounts, the system calculates this reported year's evaluated NBV based on the asset cost and rate as of the reporting date.
TAX_ASSET_TYPE	VARCHAR2	(15)		Minor category value assigned for this asset as of the previous year's reporting date
UNITS_ASSIGNED	NUMBER			Units for this location as of the previous year's reporting date
LIFE	NUMBER			Useful life of this asset as of the previous year's reporting date
CREATED_BY	NUMBER	(15)	Yes	Standard Who column
CREATION_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who column
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who column
MINOR_CATEGORY	VARCHAR2	(30)		The value of the Minor Category Segment on January 01 of the reporting year.
ACTION_FLAG	VARCHAR2	(1)		Action flag used in Japanese Depreciable Assets Tax Report program.

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT DEPRN_TAX_REP_NBV_ID
,      ASSET_ID
,      BOOK_TYPE_CODE
,      STATE
,      YEAR
,      COST
,      THEORETICAL_NBV
,      EVALUATED_NBV
,      TAX_ASSET_TYPE
,      UNITS_ASSIGNED
,      LIFE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      MINOR_CATEGORY
,      ACTION_FLAG
FROM FA.FA_DEPRN_TAX_REP_NBVS;

Dependencies

[top of page]

FA.FA_DEPRN_TAX_REP_NBVS does not reference any database object

FA.FA_DEPRN_TAX_REP_NBVS is referenced by following:

FA: FA_DEPRN_TAX_REP_NBVS#