[Home] [Help] [Dependency Information]
Object Name: | JG_ZZ_FA_REG_ITF# |
---|---|
Object Type: | VIEW |
Owner: | JG |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
REQUEST_ID | NUMBER | Yes | ||
ORGANIZATION_NAME | VARCHAR2 | (60) | Yes | |
FUNCTIONAL_CURRENCY_CODE | VARCHAR2 | (15) | Yes | |
LAST_UPDATE_DATE | DATE | Yes | ||
LAST_UPDATED_BY | NUMBER | Yes | ||
LAST_UPDATE_LOGIN | NUMBER | |||
CREATION_DATE | DATE | Yes | ||
CREATED_BY | NUMBER | Yes | ||
MAJOR_CATEGORY | VARCHAR2 | (30) | Yes | |
MINOR_CATEGORY | VARCHAR2 | (30) | ||
DEPRN_RATE | NUMBER | |||
STARTING_DEPRN_YEAR | VARCHAR2 | (4) | ||
ASSET_HEADING | VARCHAR2 | (15) | ||
ASSET_NUMBER | VARCHAR2 | (15) | Yes | |
DESCRIPTION | VARCHAR2 | (80) | ||
PARENT_ASSET_ID | NUMBER | |||
PARENT_ASSET_NUMBER | VARCHAR2 | (15) | ||
ASSET_COST_ORIG | NUMBER | |||
BONUS_RATE | NUMBER | |||
INVOICE_NUMBER | VARCHAR2 | (50) | ||
SUPPLIER_NAME | VARCHAR2 | (360) | ||
COST_ACCOUNT | VARCHAR2 | (25) | ||
EXPENSE_ACCOUNT | VARCHAR2 | (25) | ||
RESERVE_ACCOUNT | VARCHAR2 | (25) | ||
BONUS_DEPRN_ACCOUNT | VARCHAR2 | (25) | ||
BONUS_RESERVE_ACCOUNT | VARCHAR2 | (25) | ||
ASSET_COST_INITIAL | NUMBER | |||
ASSET_COST_INCREASE | NUMBER | |||
ASSET_COST_DECREASE | NUMBER | |||
ASSET_COST_FINAL | NUMBER | |||
REVALUATION_INITIAL | NUMBER | |||
REVALUATION_INCREASE | NUMBER | |||
REVALUATION_DECREASE | NUMBER | |||
REVALUATION_FINAL | NUMBER | |||
DEPRN_RESERVE_INITIAL | NUMBER | |||
DEPRN_RESERVE_INCREASE | NUMBER | |||
DEPRN_RESERVE_DECREASE | NUMBER | |||
DEPRN_RESERVE_FINAL | NUMBER | |||
BONUS_RESERVE_INITIAL | NUMBER | |||
BONUS_RESERVE_INCREASE | NUMBER | |||
BONUS_RESERVE_DECREASE | NUMBER | |||
BONUS_RESERVE_FINAL | NUMBER | |||
NET_BOOK_VALUE_INITIAL | NUMBER | |||
NET_BOOK_VALUE_INCREASE | NUMBER | |||
NET_BOOK_VALUE_DECREASE | NUMBER | |||
NET_BOOK_VALUE_FINAL | NUMBER | |||
TRANSACTION_DATE | DATE | |||
TRANSACTION_NUMBER | NUMBER | |||
TRANSACTION_CODE | VARCHAR2 | (20) | ||
TRANSACTION_AMOUNT | NUMBER | |||
SALES_AMOUNT | NUMBER | |||
COST_RETIRED | NUMBER | |||
DATE_RETIRED | DATE | |||
DEPRN_RESERVE | NUMBER | |||
BONUS_RESERVE | NUMBER | |||
NET_BOOK_VALUE | NUMBER | |||
GAIN_LOSS | NUMBER | |||
HEADER | VARCHAR2 | (110) | ||
DATE_PLACED_IN_SERVICE | DATE | |||
INITIAL_HEADING | VARCHAR2 | (15) | ||
VARIATION_HEADING | VARCHAR2 | (15) | ||
FINAL_HEADING | VARCHAR2 | (132) | ||
ASSET_VARIATION | NUMBER | |||
REVAL_VARIATION | NUMBER | |||
DEPRN_VARIATION | NUMBER | |||
BONUS_VARIATION | NUMBER | |||
NETBO_VARIATION | NUMBER | |||
REVALUATION_TOTAL | NUMBER | |||
DEPRECIATION_METHOD | VARCHAR2 | (12) | ||
LIFE_IN_MONTHS | NUMBER | |||
LIFE_IN_YEARS | NUMBER | |||
PRORATE_CONVENTION | VARCHAR2 | (10) | ||
TAG_NUMBER | VARCHAR2 | (15) | ||
SERIAL_NUMBER | VARCHAR2 | (35) | ||
ASSET_KEY_FLEXFIELD | VARCHAR2 | (35) | ||
YTD_DEPRN | NUMBER | (15) |
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#;
|
|
|