[Home] [Help] [Dependency Information]
Object Name: | JG_ZZ_FA_REG_ITF |
---|---|
Object Type: | TABLE |
Owner: | JG |
FND Design Data: | JG.JG_ZZ_FA_REG_ITF |
Subobject Name: | |
Status: | VALID |
JG_ZZ_FA_REG_ITF used by Fixed Assets Register Report
Tablespace: | APPS_TS_INTERFACE |
---|---|
PCT Free: | 10 |
PCT Used: |
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 |
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;
JG.JG_ZZ_FA_REG_ITF does not reference any database object
JG.JG_ZZ_FA_REG_ITF is referenced by following:
|
|
|