JG_ZZ_FA_REG_ITF
JG_ZZ_FA_REG_ITF used by Fixed Assets Register Report
Details
-
Schema: FUSION
-
Object owner: JE
-
Object type: TABLE
-
Tablespace: INTERFACE
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | ||
| PROGRAM_APP_NAME | VARCHAR2 | 50 | Identifies the Application name spawning the Concurrent Request | ||
| PROGRAM_NAME | VARCHAR2 | 30 | Identifies the concurrent program | ||
| ORGANIZATION_NAME | VARCHAR2 | 60 | Yes | Name of the Operating Unit | |
| FUNCTIONAL_CURRENCY_CODE | VARCHAR2 | 15 | Yes | Functional Currency Code | |
| 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. | ||
| 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. | |
| 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 | 30 | Yes | User assigned asset number identifier | |
| DESCRIPTION | VARCHAR2 | 80 | Description | ||
| PARENT_ASSET_ID | NUMBER | Parent Asset Id | |||
| PARENT_ASSET_NUMBER | VARCHAR2 | 30 | Identifies a parent asset for subcomponents | ||
| ASSET_COST_ORIG | NUMBER | Original Asset Cost | |||
| BONUS_RATE | NUMBER | Bonus Rate | |||
| INVOICE_NUMBER | VARCHAR2 | 50 | Invoice Number | ||
| SUPPLIER_NAME | VARCHAR2 | 80 | 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 | Not currently used | ||
| 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 | 18 | Depreciation Expense | ||
| 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. |