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

TABLE: JG.JG_ZZ_FA_REG_ITF

Object Details
Object Name: JG_ZZ_FA_REG_ITF
Object Type: TABLE
Owner: JG
FND Design Data: TableJG.JG_ZZ_FA_REG_ITF
Subobject Name:
Status: VALID


JG_ZZ_FA_REG_ITF used by Fixed Assets Register Report


Storage Details
Tablespace: TablespaceAPPS_TS_INTERFACE
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
REQUEST_ID NUMBER
Yes Request Id
ORGANIZATION_NAME VARCHAR2 (60) Yes Name of the Operating Unit
FUNCTIONAL_CURRENCY_CODE VARCHAR2 (15) Yes Functional Currency Code
LAST_UPDATE_DATE DATE
Yes Standard Who column
LAST_UPDATED_BY NUMBER
Yes Standard Who column
LAST_UPDATE_LOGIN NUMBER

Standard Who column
CREATION_DATE DATE
Yes Standard Who column
CREATED_BY NUMBER
Yes Standard Who column
MAJOR_CATEGORY VARCHAR2 (30) Yes Major Category
MINOR_CATEGORY VARCHAR2 (30)
Minor Category
DEPRN_RATE NUMBER

Depreciation Rate
STARTING_DEPRN_YEAR VARCHAR2 (4)
Starting Year of Depreciation
ASSET_HEADING VARCHAR2 (15)
Constant Text
ASSET_NUMBER VARCHAR2 (15) Yes Asset Number
DESCRIPTION VARCHAR2 (80)
Description
PARENT_ASSET_ID NUMBER

Parent Asset Id
PARENT_ASSET_NUMBER VARCHAR2 (15)
Parent Asset Number
ASSET_COST_ORIG NUMBER

Original Asset Cost
BONUS_RATE NUMBER

Bonus Rate
INVOICE_NUMBER VARCHAR2 (50)
Invoice Number
SUPPLIER_NAME VARCHAR2 (360)
Supplier Name
COST_ACCOUNT VARCHAR2 (25)
Cost Account
EXPENSE_ACCOUNT VARCHAR2 (25)
Expense Account
RESERVE_ACCOUNT VARCHAR2 (25)
Reserve Account
BONUS_DEPRN_ACCOUNT VARCHAR2 (25)
Bonus Depreciation Account
BONUS_RESERVE_ACCOUNT VARCHAR2 (25)
Bonus Reserve Account
ASSET_COST_INITIAL NUMBER

Initial Asset Cost
ASSET_COST_INCREASE NUMBER

Asset Cost Increase
ASSET_COST_DECREASE NUMBER

Asset Cost Decrease
ASSET_COST_FINAL NUMBER

Final Asset Cost
REVALUATION_INITIAL NUMBER

Initial Revaluation Cost
REVALUATION_INCREASE NUMBER

Revaluation Increase
REVALUATION_DECREASE NUMBER

Revaluation Decrease
REVALUATION_FINAL NUMBER

Final Revaluation Cost
DEPRN_RESERVE_INITIAL NUMBER

Initial Depreciation Reserve
DEPRN_RESERVE_INCREASE NUMBER

Depreciation Reserve Increase
DEPRN_RESERVE_DECREASE NUMBER

Depreciation Reserve Decrease
DEPRN_RESERVE_FINAL NUMBER

Final Depreciation Reserve
BONUS_RESERVE_INITIAL NUMBER

Initial Bonus Reserve
BONUS_RESERVE_INCREASE NUMBER

Bonus Reserve Increase
BONUS_RESERVE_DECREASE NUMBER

Bonus Reserve Decrease
BONUS_RESERVE_FINAL NUMBER

Bonus Reserve Final
NET_BOOK_VALUE_INITIAL NUMBER

Initial Net Book Value
NET_BOOK_VALUE_INCREASE NUMBER

Net Book Value Increase
NET_BOOK_VALUE_DECREASE NUMBER

Net Book Value Decrease
NET_BOOK_VALUE_FINAL NUMBER

Final Net Book Value
TRANSACTION_DATE DATE

Transaction Date
TRANSACTION_NUMBER NUMBER

Transaction Number
TRANSACTION_CODE VARCHAR2 (20)
Transaction Code
TRANSACTION_AMOUNT NUMBER

Transaction Amount
SALES_AMOUNT NUMBER

Sales Amount
COST_RETIRED NUMBER

Retired Cost
DATE_RETIRED DATE

Date Retired
DEPRN_RESERVE NUMBER

Depreciation Reserve
BONUS_RESERVE NUMBER

Bonus Reserve
NET_BOOK_VALUE NUMBER

Net Book Value
GAIN_LOSS NUMBER

Gain/Loss
HEADER VARCHAR2 (110)
Rxi Report Heading
DATE_PLACED_IN_SERVICE DATE

Date Placed in Service
INITIAL_HEADING VARCHAR2 (15)
Initial Heading
VARIATION_HEADING VARCHAR2 (15)
Variation Heading
FINAL_HEADING VARCHAR2 (132)
Final Heading
ASSET_VARIATION NUMBER

Asset Variation
REVAL_VARIATION NUMBER

Revaluation Variation
DEPRN_VARIATION NUMBER

Depreciation Variation
BONUS_VARIATION NUMBER

Bonus Variation
NETBO_VARIATION NUMBER

Net Book Value Variation
REVALUATION_TOTAL NUMBER

Total Revaluation
DEPRECIATION_METHOD VARCHAR2 (12)
Depreciation Method
LIFE_IN_MONTHS NUMBER

Life in Months
LIFE_IN_YEARS NUMBER

Life in Years
PRORATE_CONVENTION VARCHAR2 (10)
Prorate Convention
TAG_NUMBER VARCHAR2 (15)
Tag Number
SERIAL_NUMBER VARCHAR2 (35)
Serial Number
ASSET_KEY_FLEXFIELD VARCHAR2 (35)
Asset Flexfield Description
YTD_DEPRN NUMBER (15)
Depreciation Expense
Query Text

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


SELECT REQUEST_ID
,      ORGANIZATION_NAME
,      FUNCTIONAL_CURRENCY_CODE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATION_DATE
,      CREATED_BY
,      MAJOR_CATEGORY
,      MINOR_CATEGORY
,      DEPRN_RATE
,      STARTING_DEPRN_YEAR
,      ASSET_HEADING
,      ASSET_NUMBER
,      DESCRIPTION
,      PARENT_ASSET_ID
,      PARENT_ASSET_NUMBER
,      ASSET_COST_ORIG
,      BONUS_RATE
,      INVOICE_NUMBER
,      SUPPLIER_NAME
,      COST_ACCOUNT
,      EXPENSE_ACCOUNT
,      RESERVE_ACCOUNT
,      BONUS_DEPRN_ACCOUNT
,      BONUS_RESERVE_ACCOUNT
,      ASSET_COST_INITIAL
,      ASSET_COST_INCREASE
,      ASSET_COST_DECREASE
,      ASSET_COST_FINAL
,      REVALUATION_INITIAL
,      REVALUATION_INCREASE
,      REVALUATION_DECREASE
,      REVALUATION_FINAL
,      DEPRN_RESERVE_INITIAL
,      DEPRN_RESERVE_INCREASE
,      DEPRN_RESERVE_DECREASE
,      DEPRN_RESERVE_FINAL
,      BONUS_RESERVE_INITIAL
,      BONUS_RESERVE_INCREASE
,      BONUS_RESERVE_DECREASE
,      BONUS_RESERVE_FINAL
,      NET_BOOK_VALUE_INITIAL
,      NET_BOOK_VALUE_INCREASE
,      NET_BOOK_VALUE_DECREASE
,      NET_BOOK_VALUE_FINAL
,      TRANSACTION_DATE
,      TRANSACTION_NUMBER
,      TRANSACTION_CODE
,      TRANSACTION_AMOUNT
,      SALES_AMOUNT
,      COST_RETIRED
,      DATE_RETIRED
,      DEPRN_RESERVE
,      BONUS_RESERVE
,      NET_BOOK_VALUE
,      GAIN_LOSS
,      HEADER
,      DATE_PLACED_IN_SERVICE
,      INITIAL_HEADING
,      VARIATION_HEADING
,      FINAL_HEADING
,      ASSET_VARIATION
,      REVAL_VARIATION
,      DEPRN_VARIATION
,      BONUS_VARIATION
,      NETBO_VARIATION
,      REVALUATION_TOTAL
,      DEPRECIATION_METHOD
,      LIFE_IN_MONTHS
,      LIFE_IN_YEARS
,      PRORATE_CONVENTION
,      TAG_NUMBER
,      SERIAL_NUMBER
,      ASSET_KEY_FLEXFIELD
,      YTD_DEPRN
FROM JG.JG_ZZ_FA_REG_ITF;

Dependencies

[top of page]

JG.JG_ZZ_FA_REG_ITF does not reference any database object

JG.JG_ZZ_FA_REG_ITF is referenced by following:

SchemaAPPS
SynonymJG_ZZ_FA_REG_ITF