| Assets - FA_METHODS | Depreciation method information |
|---|---|
| Column Name | Descritpion |
| METHOD_ID | Unique identification number for a depreciation method |
| NAME | Full name of the depreciation method |
| LAST_UPDATE_DATE | Standard Who column |
| LAST_UPDATED_BY | Standard Who column |
| CREATED_BY | Standard Who column |
| CREATION_DATE | Standard Who column |
| LAST_UPDATE_LOGIN | Standard Who column |
| ATTRIBUTE1 | Descriptive flexfield segment |
| ATTRIBUTE2 | Descriptive flexfield segment |
| METHOD_CODE | Short name for the method |
| ATTRIBUTE3 | Descriptive flexfield segment |
| ATTRIBUTE4 | Descriptive flexfield segment |
| ATTRIBUTE5 | Descriptive flexfield segment |
| ATTRIBUTE6 | Descriptive flexfield segment |
| ATTRIBUTE7 | Descriptive flexfield segment |
| ATTRIBUTE8 | Descriptive flexfield segment |
| ATTRIBUTE9 | Descriptive flexfield segment |
| ATTRIBUTE10 | Descriptive flexfield segment |
| ATTRIBUTE11 | Descriptive flexfield segment |
| ATTRIBUTE12 | Descriptive flexfield segment |
| LIFE_IN_MONTHS | Life of an asset that uses this depreciation method. Used only for life-based depreciation methods |
| ATTRIBUTE13 | Descriptive flexfield segment |
| ATTRIBUTE14 | Descriptive flexfield segment |
| ATTRIBUTE15 | Descriptive flexfield segment |
| ATTRIBUTE_CATEGORY_CODE | Descriptive flexfield structure defining column |
| EXCLUDE_SALVAGE_VALUE_FLAG | Indicates whether to exclude the salvage value from the depreciable basis. |
| DEPRECIATE_LASTYEAR_FLAG | Indicates whether the asset is to be depreciated in the last year of its life |
| DEPRN_BASIS_FORMULA | Formula used to base depreciation basis |
| DEPRN_BASIS_RULE_ID | Depreciable Basis Rule ID |
| STL_METHOD_FLAG | Indicates a Straight Line Method definition |
| POLISH_ADJ_CALC_BASIS_FLAG | Specifies whether a negative adjustment on an asset using a Polish depreciation basis rule should be subject to special depreciation basis rules |
| GUARANTEE_RATE_METHOD_FLAG | Indicates whether method is guarantee rate method |
| RATE_SOURCE_RULE | Identifies the depreciation rate source. Either CALCULATED, FLAT, PRODUCTION, or TABLE |
| DEPRN_BASIS_RULE | Indicates whether depreciation is based on cost or net book value |
| PRORATE_PERIODS_PER_YEAR | Number of prorate periods for table-based methods |
| Assets - FA_PERIOD_MAPS | Static information about period mapping; used by the Budget-To-Actual Report |
|---|---|
| Column Name | Descritpion |
| QUARTER | Identifies the quarter |
| LAST_UPDATED_BY | Standard Who column |
| LAST_UPDATE_DATE | Standard Who column |
| LAST_UPDATE_LOGIN | Standard Who column |
| QTR_FIRST_PERIOD | First period in the current quarter |
| QTR_LAST_PERIOD | Current open period in the quarter |
| YEAR_FIRST_PERIOD | First period in the fiscal year -- always 1 |
| YEAR_LAST_PERIOD | Current open period in the fiscal year |
| CREATED_BY | Standard Who column |
| CREATION_DATE | Standard Who column |
| Assets - FA_RATES | Annual depreciation rates for life-based depreciation methods |
|---|---|
| Column Name | Descritpion |
| METHOD_ID | Depreciation method identification number |
| LAST_UPDATE_LOGIN | Standard Who column |
| CREATED_BY | Standard Who column |
| CREATION_DATE | Standard Who column |
| YEAR | Fiscal year of asset life |
| PERIOD_PLACED_IN_SERVICE | Period number from the prorate calendar in which the asset was placed in service |
| RATE | Depreciation rate |
| LAST_UPDATED_BY | Standard Who column |
| LAST_UPDATE_DATE | Standard Who column |
| Assets - FA_RETIREMENTS | Information about asset retirements and reinstatements |
|---|---|
| Column Name | Descritpion |
| RETIREMENT_ID | Retirement identification number |
| LAST_UPDATED_BY | Standard Who column |
| TERMINAL_GAIN_LOSS | Indicates whether or not to recognize gain and loss if the last member asset is retired from a group asset |
| RESERVE_RETIRED | Retired accumulated depreciation |
| RETIREMENT_PRORATE_CONVENTION | Prorate convention of the retirement |
| RECAPTURE_AMOUNT | Recaptured accumulated depreciation |
| EOFY_RESERVE | Accumulated depreciation retired at the the end of prior fiscal year |
| TRANSACTION_HEADER_ID_OUT | Identification number of the asset transaction which made the row obsolete |
| IMPAIR_RESERVE_RETIRED | Impairment reserve retired |
| UNITS | Number of units retired |
| COST_OF_REMOVAL | Cost of removing the asset |
| NBV_RETIRED | Net book value retired |
| GAIN_LOSS_AMOUNT | Gain or loss from the retirement |
| PROCEEDS_OF_SALE | Proceeds from the sale of the asset |
| GAIN_LOSS_TYPE_CODE | Whether the retirement resulted in a gain or a loss |
| RETIREMENT_TYPE_CODE | Retirement type |
| BOOK_TYPE_CODE | Book name |
| ITC_RECAPTURED | Investment tax credit recaptured |
| ITC_RECAPTURE_ID | Investment tax credit recapture identification number |
| REFERENCE_NUM | Reference number |
| SOLD_TO | Name of the party to whom the asset was sold |
| TRADE_IN_ASSET_ID | Asset identification number of the new asset for which this asset was traded in |
| STL_METHOD_CODE | Straight line method for retirement reporting of 1250 property in a tax book. |
| STL_LIFE_IN_MONTHS | Straight line life for retirement |
| STL_DEPRN_AMOUNT | Straight line depreciation amount for reporting of 1250 property in a tax book. |
| CREATED_BY | Standard Who column |
| CREATION_DATE | Standard Who column |
| ASSET_ID | Asset identification number |
| LAST_UPDATE_LOGIN | Standard Who column |
| ATTRIBUTE1 | Descriptive flexfield segment |
| ATTRIBUTE2 | Descriptive flexfield segment |
| ATTRIBUTE3 | Descriptive flexfield segment |
| ATTRIBUTE4 | Descriptive flexfield segment |
| TRANSACTION_HEADER_ID_IN | Identification number of the asset transaction which created the row |
| ATTRIBUTE5 | Descriptive flexfield segment |
| ATTRIBUTE6 | Descriptive flexfield segment |
| ATTRIBUTE7 | Descriptive flexfield segment |
| ATTRIBUTE8 | Descriptive flexfield segment |
| ATTRIBUTE9 | Descriptive flexfield segment |
| DATE_RETIRED | Date on which the retirement occurred |
| ATTRIBUTE10 | Descriptive flexfield segment |
| ATTRIBUTE11 | Descriptive flexfield segment |
| ATTRIBUTE12 | Descriptive flexfield segment |
| ATTRIBUTE13 | Descriptive flexfield segment |
| ATTRIBUTE14 | Descriptive flexfield segment |
| DATE_EFFECTIVE | System date when the retirement transaction was entered |
| ATTRIBUTE15 | Descriptive flexfield segment |
| ATTRIBUTE_CATEGORY_CODE | Descriptive flexfield structure defining column |
| REVAL_RESERVE_RETIRED | Revaluation reserve retired |
| UNREVALUED_COST_RETIRED | Cost retired without any regard to any revaluations |
| COST_RETIRED | Cost retired |
| BONUS_RESERVE_RETIRED | Bonus depreciation reserve retired |
| STATUS | Status of the retirement |
| RECOGNIZE_GAIN_LOSS | Indicates whether or not to recognize gain and loss |
| REDUCTION_RATE | Default reduction rate if this record is for a group asset. Otherwise, the reduction rate used for the transaction |
| LAST_UPDATE_DATE | Standard Who column |
| RECAPTURE_RESERVE_FLAG | Indicates whether or not reserve for a group asset can exceed its recoverable cost |
| LIMIT_PROCEEDS_FLAG | Indicates whether or not the net proceeds amount for a retiring asset is limited to the asset's retiring recoverable cost |
| Assets - FA_SYSTEM_CONTROLS | System-wide controls that affect all assets |
|---|---|
| Column Name | Descritpion |
| COMPANY_NAME | Identifies the name of your company that will appear on all Oracle Assets reports |
| CREATION_DATE | Standard Who column |
| LAST_UPDATE_DATE | Standard Who column |
| LAST_UPDATED_BY | Standard Who column |
| LAST_MASS_ADDITIONS | Identifies the most recent concurrent request for the mass additions create process |
| LAST_MASS_ADDITIONS_POST | Identifies the most recent concurrent request for the mass addition post process |
| LAST_UPDATE_LOGIN | Standard Who column |
| ATTRIBUTE1 | Descriptive flexfield segment |
| ATTRIBUTE2 | Descriptive flexfield segment |
| DATE_PLACED_IN_SERVICE | Earliest allowed date placed in service |
| ATTRIBUTE3 | Descriptive flexfield segment |
| ATTRIBUTE4 | Descriptive flexfield segment |
| ATTRIBUTE5 | Descriptive flexfield segment |
| ATTRIBUTE6 | Descriptive flexfield segment |
| ATTRIBUTE7 | Descriptive flexfield segment |
| INITIAL_ASSET_ID | Asset identification number at which Oracle Assets begins automatic asset numbering |
| ATTRIBUTE8 | Descriptive flexfield segment |
| ATTRIBUTE9 | Descriptive flexfield segment |
| ATTRIBUTE10 | Descriptive flexfield segment |
| ATTRIBUTE11 | Descriptive flexfield segment |
| ATTRIBUTE12 | Descriptive flexfield segment |
| GL_APPLICATION_ID | Application identification number for general ledger |
| ATTRIBUTE13 | Descriptive flexfield segment |
| ATTRIBUTE14 | Descriptive flexfield segment |
| ATTRIBUTE15 | Descriptive flexfield segment |
| ATTRIBUTE_CATEGORY_CODE | Descriptive flexfield structure defining column |
| FA_APPLICATION_ID | Application identification number for Oracle Assets |
| GROUP_FLEX_STRUCTURE | Reserved for system use. Do not use. |
| SUPER_GROUP_FLEX_STRUCTURE | Reserved for system use. Do not use. |
| LOCATION_FLEX_STRUCTURE | Structure used for location flexfield |
| CUA_INHERITANCE_FLAG | Reserved for system use. Do not use. |
| USE_CUSTOM_ASSET_NUMBERS_FLAG | Indicates if system is using a custom asset numbering scheme. |
| CATEGORY_FLEX_STRUCTURE | Structure used for the asset category flexfield |
| ASSET_KEY_FLEX_STRUCTURE | Structure used for the asset key flexfield |
| CREATED_BY | Standard Who column |
| Assets - FA_TRANSACTION_HEADERS | Information about all transactions performed within Oracle Assets |
|---|---|
| Column Name | Descritpion |
| TRANSACTION_HEADER_ID | Unique transaction identification number |
| INVOICE_TRANSACTION_ID | Invoice transaction identification number |
| SOURCE_TRANSACTION_HEADER_ID | Transaction header identification number for corresponding transaction in the associated corporate book for a mass copied transaction |
| MASS_REFERENCE_ID | Identifies concurrent request that invoked the transaction if it is part of a mass transaction |
| LAST_UPDATE_LOGIN | Standard Who column |
| TRANSACTION_SUBTYPE | Further detail of transaction type |
| ATTRIBUTE1 | Descriptive flexfield segment |
| ATTRIBUTE2 | Descriptive flexfield segment |
| BOOK_TYPE_CODE | Name of book in which the transaction occurred |
| ATTRIBUTE3 | Descriptive flexfield segment |
| ATTRIBUTE4 | Descriptive flexfield segment |
| ATTRIBUTE5 | Descriptive flexfield segment |
| ATTRIBUTE6 | Descriptive flexfield segment |
| ATTRIBUTE7 | Descriptive flexfield segment |
| ASSET_ID | Asset in book affected by the transaction |
| ATTRIBUTE8 | Descriptive flexfield segment |
| ATTRIBUTE9 | Descriptive flexfield segment |
| ATTRIBUTE10 | Descriptive flexfield segment |
| ATTRIBUTE11 | Descriptive flexfield segment |
| ATTRIBUTE12 | Descriptive flexfield segment |
| TRANSACTION_TYPE_CODE | Identifies the type of transaction |
| ATTRIBUTE13 | Descriptive flexfield segment |
| ATTRIBUTE14 | Descriptive flexfield segment |
| ATTRIBUTE15 | Descriptive flexfield segment |
| ATTRIBUTE_CATEGORY_CODE | Descriptive flexfield structure defining column |
| TRANSACTION_KEY | General class of transaction; 'R' for retirements; 'UA' for unplanned depreciation amortized from current period; 'UE' for unplanned depreciation expensed |
| TRANSACTION_DATE_ENTERED | Date on which the transaction occurred |
| AMORTIZATION_START_DATE | Amortization start date |
| CALLING_INTERFACE | Interface that created this transaction |
| DATE_EFFECTIVE | Date on which the transaction was entered into Oracle Assets |
| MASS_TRANSACTION_ID | Identifies the mass transaction that invoked the transaction if it is part of a mass transaction |
| MEMBER_TRANSACTION_HEADER_ID | Identification number of the member asset ttransaction, which spawned this transaction for the group asset. |
| LAST_UPDATE_DATE | Standard Who column |
| TRX_REFERENCE_ID | Identification number of the transaction reference which links transactions on multiple assets. |
| EVENT_ID | Event internal identifier |
| LAST_UPDATED_BY | Standard Who column |
| TRANSACTION_NAME | Description of the transaction |
| Assets - FA_TRANSFER_DETAILS | Information that defines the historic relationship between active FA_BOOKS and FA_DISTRIBUTION_HISTORY rows |
|---|---|
| Column Name | Descritpion |
| TRANSFER_HEADER_ID | Transaction header identification number for a transfer |
| DISTRIBUTION_ID | Distribution identification number involved in the transfer |
| BOOK_HEADER_ID | Transaction header identification number for the books record that was active when the transfer occurred |
| Assets - FA_PRICE_INDEXES | General price index information |
|---|---|
| Column Name | Descritpion |
| PRICE_INDEX_ID | Unique price index identification number |
| ATTRIBUTE2 | Descriptive flexfield segment |
| ATTRIBUTE3 | Descriptive flexfield segment |
| ATTRIBUTE4 | Descriptive flexfield segment |
| ATTRIBUTE5 | Descriptive flexfield segment |
| ATTRIBUTE6 | Descriptive flexfield segment |
| PRICE_INDEX_NAME | Name of the price index |
| ATTRIBUTE7 | Descriptive flexfield segment |
| ATTRIBUTE8 | Descriptive flexfield segment |
| ATTRIBUTE9 | Descriptive flexfield segment |
| ATTRIBUTE10 | Descriptive flexfield segment |
| ATTRIBUTE11 | Descriptive flexfield segment |
| LAST_UPDATE_DATE | Standard Who column |
| ATTRIBUTE12 | Descriptive flexfield segment |
| ATTRIBUTE13 | Descriptive flexfield segment |
| ATTRIBUTE14 | Descriptive flexfield segment |
| ATTRIBUTE15 | Descriptive flexfield segment |
| ATTRIBUTE_CATEGORY_CODE | Descriptive flexfield structure defining column |
| LAST_UPDATED_BY | Standard Who column |
| LAST_UPDATE_LOGIN | Standard Who column |
| CREATED_BY | Standard Who column |
| CREATION_DATE | Standard Who column |
| ATTRIBUTE1 | Descriptive flexfield segment |
| Assets - FA_PRICE_INDEX_VALUES | Price index values of each price index |
|---|---|
| Column Name | Descritpion |
| PRICE_INDEX_ID | Price index identification number |
| ATTRIBUTE3 | Descriptive flexfield segment |
| ATTRIBUTE4 | Descriptive flexfield segment |
| ATTRIBUTE5 | Descriptive flexfield segment |
| ATTRIBUTE6 | Descriptive flexfield segment |
| ATTRIBUTE7 | Descriptive flexfield segment |
| PRICE_INDEX_VALUE | Value of the index |
| ATTRIBUTE8 | Descriptive flexfield segment |
| ATTRIBUTE9 | Descriptive flexfield segment |
| ATTRIBUTE10 | Descriptive flexfield segment |
| ATTRIBUTE11 | Descriptive flexfield segment |
| ATTRIBUTE12 | Descriptive flexfield segment |
| FROM_DATE | First date that the price index value applies |
| ATTRIBUTE13 | Descriptive flexfield segment |
| ATTRIBUTE14 | Descriptive flexfield segment |
| ATTRIBUTE15 | Descriptive flexfield segment |
| ATTRIBUTE_CATEGORY_CODE | Descriptive flexfield structure defining column |
| TO_DATE | Last date that the price index value applies |
| ATTRIBUTE1 | Descriptive flexfield segment |
| ATTRIBUTE2 | Descriptive flexfield segment |
| Assets - FA_RESERVE_LEDGER | Temporary storage area for the reserve ledger reports |
|---|---|
| Column Name | Descritpion |
| LIFE | Asset life for a life-based method |
| RATE | Adjusted rate for a flat-rate method |
| CAPACITY | Capacity for a units of production asset |
| COST | Asset cost |
| DEPRN_AMOUNT | Depreciation amount |
| ASSET_ID | Asset identification number |
| YTD_DEPRN | Year-to-date depreciation amount |
| PERCENT | Percent of the asset cost allocated to the distribution line |
| TRANSACTION_TYPE | Identifies the type of transaction which made the distribution line obsolete |
| DEPRN_RESERVE | Life-to-date depreciation amount |
| PERIOD_COUNTER | Period for which report is run |
| DATE_EFFECTIVE | System date row was created |
| DEPRN_RESERVE_ACCT | Account segment for depreciation reserve |
| RESERVE_ACCT | Accumulated depreciation account |
| DISTRIBUTION_ID | Distribution ID for this row |
| DH_CCID | Accounting Flexfield identification number for the depreciation expense account |
| DATE_PLACED_IN_SERVICE | Date the asset was placed in service |
| METHOD_CODE | Depreciation method |
| Assets - FA_PERIODIC_PRODUCTION | Production information for units of production assets entered manually or uploaded from FA_PRODUCTION_INTERFACE |
|---|---|
| Column Name | Descritpion |
| PRODUCTION | Production amount for asset during date range |
| USED_FLAG | YES if the depreciation program has used this amount to calculate depreciation for the asset |
| CREATION_DATE | Standard Who column |
| CREATED_BY | Standard Who column |
| LAST_UPDATE_DATE | Standard Who column |
| ASSET_ID | Asset identification number |
| LAST_UPDATED_BY | Standard Who column |
| LAST_UPDATE_LOGIN | Standard Who column |
| ATTRIBUTE1 | Descriptive flexfield segment |
| ATTRIBUTE2 | Descriptive flexfield segment |
| ATTRIBUTE3 | Descriptive flexfield segment |
| ATTRIBUTE4 | Descriptive flexfield segment |
| ATTRIBUTE5 | Descriptive flexfield segment |
| ATTRIBUTE6 | Descriptive flexfield segment |
| ATTRIBUTE7 | Descriptive flexfield segment |
| ATTRIBUTE8 | Descriptive flexfield segment |
| BOOK_TYPE_CODE | Corporate book name |
| ATTRIBUTE9 | Descriptive flexfield segment |
| ATTRIBUTE10 | Descriptive flexfield segment |
| ATTRIBUTE11 | Descriptive flexfield segment |
| ATTRIBUTE12 | Descriptive flexfield segment |
| ATTRIBUTE13 | Descriptive flexfield segment |
| ATTRIBUTE14 | Descriptive flexfield segment |
| ATTRIBUTE15 | Descriptive flexfield segment |
| ATTRIBUTE_CATEGORY_CODE | Descriptive flexfield structure defining column |
| START_DATE | First date of range |
| END_DATE | Last date of range |
| Assets - FA_PRODUCTION_INTERFACE | Production information to be uploaded into Oracle Assets |
|---|---|
| Column Name | Descritpion |
| ASSET_NUMBER | Asset number |
| PRODUCTION | Production amount for asset during date range |
| START_DATE | First date of range |
| END_DATE | Last date of range |
| Assets - FA_RETIREMENTS_V | |
|---|---|
| Column Name | Descritpion |
| RET_ROWID | |
| RETIREMENT_ID | |
| BOOK_TYPE_CODE | |
| ASSET_ID | |
| TRANSACTION_HEADER_ID_IN | |
| DATE_RETIRED | |
| DATE_EFFECTIVE | |
| COST_RETIRED | |
| STATUS | |
| LAST_UPDATE_DATE | |
| LAST_UPDATED_BY | |
| RETIREMENT_PRORATE_CONVENTION | |
| TRANSACTION_HEADER_ID_OUT | |
| UNITS | |
| COST_OF_REMOVAL | |
| NBV_RETIRED | |
| GAIN_LOSS_AMOUNT | |
| PROCEEDS_OF_SALE | |
| GAIN_LOSS_TYPE_CODE | |
| RETIREMENT_TYPE_CODE | |
| ITC_RECAPTURED | |
| ITC_RECAPTURE_ID | |
| REFERENCE_NUM | |
| SOLD_TO | |
| TRADE_IN_ASSET_ID | |
| STL_METHOD_CODE | |
| STL_LIFE_IN_MONTHS | |
| STL_DEPRN_AMOUNT | |
| CREATED_BY | |
| CREATION_DATE | |
| LAST_UPDATE_LOGIN | |
| RET_ATTRIBUTE1 | |
| RET_ATTRIBUTE2 | |
| RET_ATTRIBUTE3 | |
| RET_ATTRIBUTE4 | |
| RET_ATTRIBUTE5 | |
| RET_ATTRIBUTE6 | |
| RET_ATTRIBUTE7 | |
| RET_ATTRIBUTE8 | |
| RET_ATTRIBUTE9 | |
| RET_ATTRIBUTE10 | |
| RET_ATTRIBUTE11 | |
| RET_ATTRIBUTE12 | |
| RET_ATTRIBUTE13 | |
| RET_ATTRIBUTE14 | |
| RET_ATTRIBUTE15 | |
| RET_ATTRIBUTE_CATEGORY_CODE | |
| REVAL_RESERVE_RETIRED | |
| UNREVALUED_COST_RETIRED | |
| ASSET_NUMBER | |
| COST | |
| CURRENT_UNITS | |
| TRADE_IN_ASSET_NUMBER | |
| TRADE_IN_ASSET_DESC | |
| TRANSACTION_NAME | |
| ATTRIBUTE1 | |
| ATTRIBUTE2 | |
| ATTRIBUTE3 | |
| ATTRIBUTE4 | |
| ATTRIBUTE5 | |
| ATTRIBUTE6 | |
| ATTRIBUTE7 | |
| ATTRIBUTE8 | |
| ATTRIBUTE9 | |
| ATTRIBUTE10 | |
| ATTRIBUTE11 | |
| ATTRIBUTE12 | |
| ATTRIBUTE13 | |
| ATTRIBUTE14 | |
| ATTRIBUTE15 | |
| ATTRIBUTE_CATEGORY_CODE | |
| CURRENT_FISCAL_YEAR | |
| FISCAL_YEAR_NAME | |
| FY_START_DATE | |
| FY_END_DATE |
| Assets - FA_PLSQL_DEBUG | For debugging purposes in plsql. |
|---|---|
| Column Name | Descritpion |
| PROCESS_ID | Process ID |
| PACKAGE | Package name |
| FUNCTION | Function name |
| VARIABLE | Variable name |
| VAL_NUM | Value of number type |
| VAL_DATE | Value of date type |
| VAL_CHAR | Value of character type |
| COMMENTS | Comments |
| Assets - FA_RX_REPORTS | Stores Report eXchange report definitions |
|---|---|
| Column Name | Descritpion |
| CONCURRENT_PROGRAM_ID | ID of the concurrent program which runs the report |
| CONCURRENT_PROGRAM_NAME | Name of the concurrent program which runs the report |
| INTERFACE_TABLE | Interface table the report uses |
| CONCURRENT_PROGRAM_FLAG | Flag to determine whether report uses a concurrent program |
| REPORT_ID | Unique identification number for the report |
| SELECT_PROGRAM_NAME | Name of the report |
| RESPONSIBILITY_ID | Responsibility ID for which reports are displayed |
| WHERE_CLAUSE_API | The name of the API to be used to retrieve an additional where clause for selection from interface tables |
| PURGE_API | The name of the API to be used to purge the interface table and any underlying tables. |
| VERSION_NUMBER | Version number of the report |
| LAST_UPDATE_DATE | Standard Who column |
| LAST_UPDATED_BY | Standard Who column |
| LAST_UPDATE_LOGIN | Standard Who column |
| CREATED_BY | Standard Who column |
| CREATION_DATE | Standard Who column |
| APPLICATION_ID | Application ID for which the reports are displayed |
| Assets - FA_RX_REP_COLUMNS_B | Stores attribute definitions for Report eXchange report attributes (base MLS table) |
|---|---|
| Column Name | Descritpion |
| DISPLAY_LENGTH | Display length of the column in the report |
| DISPLAY_FORMAT | Display format of the column in this report |
| ATTRIBUTE_SET | Attribute set attached to this column in the report |
| DISPLAY_STATUS | Display status of column in the report |
| LAST_UPDATE_DATE | Standard Who column |
| REPORT_ID | Unique ID for the report |
| LAST_UPDATE_LOGIN | Standard Who column |
| LAST_UPDATED_BY | Standard Who column |
| CREATED_BY | Standard Who column |
| CREATION_DATE | Standard Who column |
| ATTRIBUTE_NAME | The name of the attribute as it appears to the user in the RX client's download window |
| BREAK | Determines whether report should break on this column |
| ATTRIBUTE_COUNTER | Attribute counter |
| BREAK_GROUP_LEVEL | Determines the level at which this column breaks. |
| CURRENCY_COLUMN | Name of column which holds the currency code for this column |
| PRECISION | Precision used to format number value |
| COLUMN_NAME | The name of the interface table column in which this attributes' values are stored |
| MINIMUM_ACCOUNTABLE_UNIT | Minimum Accountable Unit used to format number value |
| UNITS | Units used to display number value |
| FORMAT_MASK | Format mask for date and number columns |
| ORDERING | Ordering of columns |
| Assets - FA_RX_REP_PARAMETERS | Stores parameter definitions for Report eXchange reports |
|---|---|
| Column Name | Descritpion |
| MAX_LENGTH | Maximum length of the parameter |
| DATATYPE | Datatype of the parameter |
| PARAMETER_COUNTER | Ordering of the parameter |
| COLUMN_NAME | Name of the interface table column in which this attributes' values are stored |
| LAST_UPDATE_DATE | Standard Who column |
| REPORT_ID | Unique ID of the report |
| LAST_UPDATE_LOGIN | Standard Who column |
| LAST_UPDATED_BY | Standard Who column |
| CREATED_BY | Standard Who column |
| CREATION_DATE | Standard Who column |
| RELATIONAL_OP | Relational operator |
| LOV_ID | ID of LOV attached to this parameter of the report |
| NAME | Parameter name, as it appears in the RX client |
| REQUIRED | Determines if parameter is required |
| Assets - FA_PROJECT_REP_ITF | Interface table for Report eXchange reports |
|---|---|
| Column Name | Descritpion |
| REQUEST_ID | Concurrent request ID |
| FISCAL_YEAR | Fiscal year of the asset |
| SUM1 | Sum 1 |
| SUM2 | Sum 2 |
| SUM3 | Sum 3 |
| SUM4 | Sum 4 |
| CREATED_BY | Standard Who column |
| CREATION_DATE | Standard Who column |
| LAST_UPDATED_BY | Standard Who column |
| LAST_UPDATE_DATE | Standard Who column |
| LAST_UPDATE_LOGIN | Standard Who column |
| COMPANY | Company of the asset |
| COST_CENTER | Cost center of the asset |
| ACCOUNT | Account of the asset |
| ASSET_NUMBER | User assigned asset number |
| DESCRIPTION | Description of the asset |
| TAG_NUMBER | Tag number of the asset |
| SERIAL_NUMBER | Serial number of the asset |
| PERIOD_NAME | Period name of the asset |
| Assets - FA_PROPTAX_REP_ITF | Interface table for Report eXchange reports |
|---|---|
| Column Name | Descritpion |
| REQUEST_ID | Concurrent request ID |
| DESCRIPTION | - Retrofitted |
| SEGMENT5 | Account segment |
| UNITS | Number of units of the asset |
| SEGMENT6 | Account segment |
| ORIGINAL_COST | Original cost of the asset |
| SEGMENT7 | Account segment |
| LAST_UPDATE_DATE | Standard Who column |
| LAST_UPDATED_BY | Standard Who column |
| CREATED_BY | Standard Who column |
| CREATION_DATE | Standard Who column |
| LAST_UPDATE_LOGIN | Standard Who column |
| INVENTORIAL | Indicates whether the asset should be included in physical inventory |
| BOOK_TYPE_CODE | Book name |
| TAG_NUMBER | Tag number of the asset |
| SERIAL_NUMBER | Serial number of the asset |
| ASSET_KEY | Asset key flexfield combination |
| LOCATION | Location name |
| COST_CENTER | Cost center of the asset |
| STATE | State name of asset |
| ASSET_CATEGORY | Identifies the asset category |
| COMPANY | Company name of the asset |
| PROPERTY_TYPE | Property type of the asset |
| ASSET_COST_ACCT | Asset Cost account of the asset |
| SEGMENT1 | Account segment |
| YEAR | Year of the asset |
| SEGMENT2 | Account segment |
| DATE_PLACED_IN_SERVICE | Date asset was placed in service |
| SEGMENT3 | Account segment |
| ASSET_NUMBER | User assigned asset number |
| SEGMENT4 | Account segment |
| Assets - FA_RECLASS_REP_ITF | Interface table for Report eXchange reports |
|---|---|
| Column Name | Descritpion |
| REQUEST_ID | Concurrent request ID |
| FROM_CATEGORY | Original category of the asset |
| TO_CATEGORY | New category of the asset |
| ASSET_NUMBER | User assigned asset number |
| DESCRIPTION | Description of the asset |
| TAG_NUMBER | Tag number of the asset |
| SERIAL_NUMBER | Serial number of the asset |
| ASSET_KEY | Asset key flexfield combination |
| COST | Cost of the asset |
| RESERVE | Reserve of the asset |
| COMPANY | Company of the asset |
| TRANSACTION_HEADER_ID | Transaction header ID of the asset |
| CREATED_BY | Standard Who column |
| CREATION_DATE | Standard Who column |
| LAST_UPDATED_BY | Standard Who column |
| LAST_UPDATE_DATE | Standard Who column |
| LAST_UPDATE_LOGIN | Standard Who column |
| INVENTORIAL | Indicates whether the asset should be included in physical inventory |
| COST_CENTER | Cost center of the asset |
| EXPENSE_ACCT | Expense account of the asset |
| PERIOD_NAME | Period name of the asset |
| FROM_COST_ACCT | Original cost account of the asset |
| TO_COST_ACCT | New cost account of the asset |
| FROM_RESERVE_ACCT | Original reserve account of the asset |
| TO_RESERVE_ACCT | New reserve account of the asset |
| Assets - FA_RETIRE_REP_ITF | Interface table for Report eXchange reports |
|---|---|
| Column Name | Descritpion |
| REQUEST_ID | Concurrent request ID |
| RESERVE_ACCT | Reserve account of the asset |
| SPECIFIED_CATEGORY_SEG | Specified Category Segment |
| SPECIFIED_CAT_SEG_DESC | Specified Category Description |
| ASSET_NUMBER | User assigned asset number |
| GROUP_ASSET_NUMBER | Group Asset number for any associated group asset at the time of retirement. |
| DESCRIPTION | Description of the asset |
| SERIAL_NUMBER | Serial number of the asset |
| TAG_NUMBER | Tag number of the asset |
| ASSET_KEY | Asset key flexfield combination |
| DATE_RETIRED | Date asset was retired |
| UNITS_RETIRED | Number of units of asset retired |
| TRANSACTION_HEADER_ID | Transaction header ID of the asset |
| EMPLOYEE_NAME | Name of the employee who owns the asset |
| COST_RETIRED | Cost of the asset when retired |
| NBV_RETIRED | Net book value of the asset when retired |
| PROCEEDS_OF_SALE | Proceeds of sale of the asset |
| GAIN_LOSS_AMOUNT | Gain / Loss amount of the asset |
| REMOVAL_COST | Removal cost of the asset |
| ITC_CAPTURED | The investment tax credit capture amount |
| FLAG | Flag |
| DATE_PLACED_IN_SERVICE | Date the asset was placed in service |
| CREATED_BY | Standard Who column |
| CREATION_DATE | Standard Who column |
| EMPLOYEE_NUMBER | Employee number of the person who owns the asset |
| LAST_UPDATED_BY | - Retrofitted |
| LAST_UPDATE_DATE | Standard Who column |
| LAST_UPDATE_LOGIN | Standard Who column |
| INVENTORIAL | Indicates whether the asset should be placed in physical inventory |
| SET_OF_BOOKS_ID | Set of Books ID |
| COMPANY | Company of the asset |
| FUNCTIONAL_CURRENCY_CODE | Functional Currency Code |
| ORGANIZATION_NAME | Organaization Name |
| COST_CENTER | Cost center of the asset |
| BOOK_TYPE_CODE | Book Type Code |
| PERIOD_NAME | Period Name specified by parameter |
| EXPENSE_ACCT | Expense account of the asset |
| PERIOD_NAME_TO | Period Name To specified by parameter |
| ACCOUNT_DESCRIPTION | Natural Account Description |
| LOCATION | Location of the asset |
| COST_CENTER_DESCRIPTION | Cost Center Description |
| DEPRN_RESERVE | Depreciation Reserve Amount |
| CATEGORY | Category of the asset |
| MAJOR_CATEGORY | Major Category Segment |
| MAJOR_CATEGORY_DESC | Major Category Description |
| COST_ACCT | Cost account of the asset |
| MINOR_CATEGORY | Minor Category Segment |
| MINOR_CATEGORY_DESC | Minor Category Description |
| Assets - FA_TRANSFER_REP_ITF | Interface table for Report eXchange reports |
|---|---|
| Column Name | Descritpion |
| REQUEST_ID | Concurrent request ID |
| TO_EXPENSE_ACCT | Expense account to which asset is transferred |
| FROM_COMPANY | Company from which asset is transferred |
| FROM_COST_CENTER | Cost center from which asset was transferred |
| FROM_EXPENSE_ACCT | Expense account from which asset was transferred |
| COST_ACCT | Cost account of the asset |
| RESERVE_ACCT | Reserve account of the asset |
| YTD_DEPRN | Year-to-date depreciation of the asset |
| RESERVE | Reserve of the asset |
| TRANSACTION_HEADER_ID | Transaction header ID of the asset |
| MASS_TRANSFER_ID | Mass transfer ID of the asset |
| ASSET_NUMBER | User assigned asset number |
| TO_LOCATION | Location to which asset was transferred |
| TO_EMPLOYEE_NAME | Name of the employee to which asset was transferred |
| TO_EMPLOYEE_NUMBER | Employee number of the employee to which the asset was transferred |
| FROM_LOCATION | Location from which the asset was transferred |
| FROM_EMPLOYEE_NAME | Name of the employee from which the asset was transferred |
| FROM_EMPLOYEE_NUMBER | Employee number of the employee from which the asset was transferred |
| TRANSACTION_DATE | Date of the mass transfer transaction |
| COST_TRANSFERRED | Cost of asset transferred |
| RESERVE_TRANSFERRED | Reserve of asset transferred |
| UNITS_TRANSFERRED | Units of asset transferred |
| DESCRIPTION | Description of the asset |
| CREATED_BY | Standard Who column |
| CREATION_DATE | Standard Who column |
| LAST_UPDATED_BY | Standard Who column |
| LAST_UPDATE_DATE | Standard Who column |
| LAST_UPDATE_LOGIN | Standard Who column |
| INVENTORIAL | Indicates whether the asset should be included in physical inventory |
| SERIAL_NUMBER | Serial number of the asset |
| ASSET_TYPE | Indicates whether the asset is CIP, capitalized, expensed, or group. |
| TAG_NUMBER | Tag number of the asset |
| ASSET_KEY | Asset key flexfield combination |
| TO_COMPANY | Company to which asset is transferred |
| TO_COST_CENTER | Cost center to which asset is transferred |
| Assets - FA_WHATIF_ITF | Interface table for What-If Depreciation Analysis Report |
|---|---|
| Column Name | Descritpion |
| REQUEST_ID | Concurrent request identifier for the what-if calculation |
| EXPENSE_ACCT | Depreciation expense account |
| CATEGORY | Concatenated segments of category to run hypothetical depreciation analysis |
| LOCATION | The asset location |
| UNITS | The number of units for the asset |
| EMPLOYEE_NAME | Name of the employee |
| EMPLOYEE_NUMBER | Number of the employee |
| ASSET_KEY | Asset key for the asset |
| CURRENT_COST | Cost of the asset |
| CURRENT_PRORATE_CONV | Depreciation prorate convention |
| CURRENT_METHOD | Depreciation method for the asset |
| CURRENT_LIFE | Life of the asset in months |
| BOOK_TYPE_CODE | Name of book |
| CURRENT_BASIC_RATE | The base rate used to calculate depreciation amounts for flat rate methods |
| CURRENT_ADJUSTED_RATE | Actual rate used to calculate depreciation for flat rate methods |
| CURRENT_SALVAGE_VALUE | Asset salvage value |
| CURRENT_BONUS_RULE | Bonus Rule for the Asset |
| DEPRECIATION | Depreciation amount using current depreciation parameters |
| ACCUMULATED_DEPRN | Depreciation reserve user enters to run hypothetical depreciation analysis |
| NEW_DEPRECIATION | Depreciation amount using new depreciation parameters |
| BONUS_DEPRECIATION | Bonus depreciation amount using current bonus rule |
| NEW_BONUS_DEPRECIATION | Bonus depreciation amount using new bonus rule |
| CREATED_BY | Standard Who column |
| CREATION_DATE | Standard Who column |
| LAST_UPDATE_DATE | Standard Who column |
| LAST_UPDATED_BY | Standard Who column |
| ASSET_ID | Asset identification number |
| LAST_UPDATE_LOGIN | Standard Who column |
| PERIOD_NUM | Fiscal year period number |
| CURRENCY_CODE | Set of Books Currency |
| ASSET_NUMBER | The user assigned asset number |
| DESCRIPTION | The description of the asset |
| TAG_NUMBER | The tag number of the asset |
| SERIAL_NUMBER | The serial number of the asset |
| PERIOD_NAME | Depreciation period name |
| FISCAL_YEAR | Fiscal year |
| DATE_PLACED_IN_SERVICE | Date placed in service to run hypothetical depreciation analysis |
| Assets - FA_RX_LOV | Stores information about creating the LOV's for RX reports. |
|---|---|
| Column Name | Descritpion |
| LOV_ID | LOV ID |
| LAST_UPDATE_LOGIN | Standard Who column |
| LOV_NAME | Name of LOV |
| VALUE_SET_ID | Value Set ID |
| SELECT_STATEMENT | Select statement used to validate LOV |
| VALIDATE_FLAG | Validation Flag |
| LAST_UPDATE_DATE | Standard Who column |
| LAST_UPDATED_BY | Standard Who column |
| CREATED_BY | Standard Who column |
| CREATION_DATE | Standard Who column |
| Assets - FA_RX_ATTRSETS_B | Stores attribute set information for RX reports (base MLS table) |
|---|---|
| Column Name | Descritpion |
| REPORT_ID | Unique ID of the report |
| PRINT_PARAMETERS | Print parameters |
| PRINT_PAGE_BREAK_COLS | Display columns in the first break group level at header |
| GROUP_DISPLAY_TYPE | Formatting option for break columns |
| DEFAULT_DATE_FORMAT | Default date format for the attribute set |
| DEFAULT_DATE_TIME_FORMAT | Default date time format for the attribute set |
| DEFAULT_NUMERIC_CHARACTERS | Default numeric characters for the attribute set |
| ATTRIBUTE_SET | Attribute set value |
| PAGE_WIDTH | Page width of generated report. |
| PUBLIC_FLAG | Public flag (Y or N) |
| PAGE_HEIGHT | Page height of generated report. |
| SYSTEM_FLAG | System flag |
| PRINT_SOB_FLAG | Print organization name |
| LAST_UPDATE_DATE | Standard Who column |
| PRINT_FUNC_CURR_FLAG | Print functional currency |
| LAST_UPDATED_BY | Standard Who column |
| PRINT_TITLE | Print report title |
| CREATED_BY | Standard Who column |
| PRINT_SUBMISSION_DATE | Print submission date |
| CREATION_DATE | Standard Who column |
| PRINT_CURRENT_PAGE | Print current page number |
| LAST_UPDATE_LOGIN | Standard Who column |
| PRINT_TOTAL_PAGES | Print total number of pages |
| Assets - FA_WARRANTIES | Warranty information |
|---|---|
| Column Name | Descritpion |
| WARRANTY_ID | System-generated warranty identification number |
| CURRENCY_CODE | Currency of the warranty |
| ATTRIBUTE1 | Descriptive flexfield segment |
| ATTRIBUTE2 | Descriptive flexfield segment |
| ATTRIBUTE3 | Descriptive flexfield segment |
| ATTRIBUTE4 | Descriptive flexfield segment |
| ATTRIBUTE5 | Descriptive flexfield segment |
| ATTRIBUTE6 | Descriptive flexfield segment |
| ATTRIBUTE7 | Descriptive flexfield segment |
| ATTRIBUTE8 | Descriptive flexfield segment |
| WARRANTY_NUMBER | User assigned warranty number |
| ATTRIBUTE9 | Descriptive flexfield segment |
| ATTRIBUTE10 | Descriptive flexfield segment |
| ATTRIBUTE11 | Descriptive flexfield segment |
| ATTRIBUTE12 | Descriptive flexfield segment |
| ATTRIBUTE13 | Descriptive flexfield segment |
| ATTRIBUTE14 | Descriptive flexfield segment |
| ATTRIBUTE15 | Descriptive flexfield segment |
| ATTRIBUTE16 | Descriptive flexfield segment |
| ATTRIBUTE17 | Descriptive flexfield segment |
| ATTRIBUTE18 | Descriptive flexfield segment |
| DESCRIPTION | Description of the warranty |
| ATTRIBUTE19 | Descriptive flexfield segment |
| ATTRIBUTE20 | Descriptive flexfield segment |
| ATTRIBUTE21 | Descriptive flexfield segment |
| ATTRIBUTE22 | Descriptive flexfield segment |
| ATTRIBUTE23 | Descriptive flexfield segment |
| ATTRIBUTE24 | Descriptive flexfield segment |
| ATTRIBUTE25 | Descriptive flexfield segment |
| ATTRIBUTE26 | Descriptive flexfield segment |
| ATTRIBUTE27 | Descriptive flexfield segment |
| ATTRIBUTE28 | Descriptive flexfield segment |
| COST | Cost of the warranty |
| ATTRIBUTE_CATEGORY_CODE | Descriptive flexfield segment |
| ATTRIBUTE29 | Descriptive flexfield segment |
| ATTRIBUTE30 | Descriptive flexfield segment |
| LAST_UPDATE_DATE | Standard Who column |
| LAST_UPDATED_BY | Standard Who column |
| CREATED_BY | Standard Who column |
| CREATION_DATE | Standard Who column |
| LAST_UPDATE_LOGIN | Standard Who column |
| START_DATE | Start date for the warranty |
| END_DATE | End date for the warranty |
| RENEW_FLAG | Indicates whether the warranty is renewable |
| PO_VENDOR_ID | Supplier identification number |
| EMPLOYEE_ID | Employee identification number |
| Assets - FA_MC_MASS_RATES | Exchange rate information for mass additions process |
|---|---|
| Column Name | Descritpion |
| SET_OF_BOOKS_ID | Reporting set of books identification number for GL sets of books |
| LAST_UPDATE_LOGIN | Standard Who column |
| MASS_ADDITION_ID | Unique identification number of the mass addition |
| PARENT_MASS_ADDITION_ID | Identifies the mass addition into which you merged this mass addition |
| FIXED_ASSETS_COST | Cost of the asset, in the primary functional currency, in Oracle Assets |
| EXCHANGE_RATE | Exchange rate used to convert the cost of the asset to the reporting currency |
| CREATED_BY | Standard Who column |
| CREATION_DATE | Standard Who column |
| LAST_UPDATED_BY | Standard Who column |
| LAST_UPDATE_DATE | Standard Who column |
| Assets - FA_MC_RETIREMENTS | Currency and financial information about retirements in each reporting book |
|---|---|
| Column Name | Descritpion |
| SET_OF_BOOKS_ID | Reporting set of books identification number for GL sets of books |
| PROCEEDS_OF_SALE | Proceeds from the sale of the asset |
| STL_METHOD_CODE | Straight line method for retirement reporting of 1250 property in a tax book |
| STL_LIFE_IN_MONTHS | Straight line life for retirement |
| ITC_RECAPTURED | Investment tax credit recaptured |
| CREATED_BY | Standard Who column |
| CREATION_DATE | Standard Who column |
| STL_DEPRN_AMOUNT | Straight line depreciation amount for reporting of 1250 property in a tax book. |
| ATTRIBUTE1 | Descriptive flexfield segment |
| ATTRIBUTE2 | Descriptive flexfield segment |
| LAST_UPDATE_LOGIN | Standard Who column |
| ATTRIBUTE3 | Descriptive flexfield segment |
| ATTRIBUTE4 | Descriptive flexfield segment |
| REVAL_RESERVE_RETIRED | Revaluation reserve retired |
| ATTRIBUTE5 | Descriptive flexfield segment |
| ATTRIBUTE6 | Descriptive flexfield segment |
| UNREVALUED_COST_RETIRED | Cost retired without any regard to any revaluations |
| ATTRIBUTE7 | Descriptive flexfield segment |
| ATTRIBUTE8 | Descriptive flexfield segment |
| BONUS_RESERVE_RETIRED | Bonus depreciation reserve retired |
| ATTRIBUTE9 | Descriptive flexfield segment |
| ATTRIBUTE10 | Descriptive flexfield segment |
| ATTRIBUTE11 | Descriptive flexfield segment |
| ATTRIBUTE12 | Descriptive flexfield segment |
| ATTRIBUTE13 | Descriptive flexfield segment |
| ATTRIBUTE14 | Descriptive flexfield segment |
| ATTRIBUTE15 | Descriptive flexfield segment |
| ATTRIBUTE_CATEGORY_CODE | Descriptive flexfield structure defining column |
| RETIREMENT_ID | Retirement identification number |
| RECOGNIZE_GAIN_LOSS | Indicates whether or not to recognize gain and loss |
| REDUCTION_RATE | Default reduction rate if this record is for a group asset. Otherwise, the reduction rate used for the transaction |
| RECAPTURE_RESERVE_FLAG | Indicates whether or not reserve for a group asset can exceed its recoverable cost |
| LIMIT_PROCEEDS_FLAG | Indicates whether or not the net proceeds amount for a retiring asset is limited to the asset's retiring recoverable cost |
| TERMINAL_GAIN_LOSS | Indicates whether or not to recognize gain and loss if the last member asset is retired from a group asset |
| RESERVE_RETIRED | Retired accumulated depreciation |
| RECAPTURE_AMOUNT | Recaptured accumulated depreciation |
| EOFY_RESERVE | Accumulated depreciation retired at the the end of prior fiscal year |
| IMPAIR_RESERVE_RETIRED | Impairment reserve retired |
| CONVERTED_FLAG | Indicates whether amounts for this row have been converted to the reporting currency |
| COST_RETIRED | Cost retired |
| BOOK_TYPE_CODE | Book name |
| ASSET_ID | Asset identification number |
| STATUS | Status of the retirement |
| TRANSACTION_HEADER_ID_IN | Identification number of the asset transaction which created the row |
| TRANSACTION_HEADER_ID_OUT | Identification number of the asset transaction which made the row obsolete |
| LAST_UPDATE_DATE | Standard Who column |
| DATE_RETIRED | Date on which the retirement occurred |
| DATE_EFFECTIVE | System date when the retirement transaction was entered |
| LAST_UPDATED_BY | Standard Who column |
| RETIREMENT_PRORATE_CONVENTION | Prorate convention of the retirement |
| UNITS | Number of units retired |
| COST_OF_REMOVAL | Cost of removing the asset |
| GAIN_LOSS_TYPE_CODE | Whether the retirement resulted in a gain or a loss |
| RETIREMENT_TYPE_CODE | Retirement type |
| NBV_RETIRED | Net book value retired |
| ITC_RECAPTURE_ID | Investment tax credit recapture identification number |
| REFERENCE_NUM | Reference number |
| GAIN_LOSS_AMOUNT | Gain or loss from the retirement |
| SOLD_TO | Name of the party to whom the asset was sold |
| TRADE_IN_ASSET_ID | Asset identification number of the new asset for which this asset was traded in |
| Assets - FA_RX_DYNAMIC_COLUMNS | Stores information about dynamic columns for RX reports |
|---|---|
| Column Name | Descritpion |
| REQUEST_ID | Request ID |
| LAST_UPDATED_BY | Standard Who column |
| CREATION_DATE | Standard Who column |
| CREATED_BY | Standard Who column |
| LAST_UPDATE_LOGIN | Standard Who column |
| ATTRIBUTE_NAME | The name of the attribute as it appears to the user in the RX client's download window |
| COLUMN_NAME | The name of the interface table column in which this attributes' values are stored |
| ORDERING | Ordering of columns |
| BREAK | Determines whether report should break on this column |
| DISPLAY_LENGTH | Display length of column |
| DISPLAY_FORMAT | Display format of column |
| DISPLAY_STATUS | Display status of column |
| LAST_UPDATE_DATE | Standard Who column |
| Assets - FA_SHORT_TAX_RESERVES | Stores accumulated depreciation amounts for assets added in short tax years in their tax books |
|---|---|
| Column Name | Descritpion |
| ASSET_NUMBER | User assigned asset number |
| TAX_BOOK | Tax book name |
| YTD_DEPRN | Year-to-date depreciation expense |
| DEPRN_RESERVE | Total depreciation taken since beginning of asset's life |
| DATE_PLACED_IN_SERVICE | Date the asset was placed in service |
| PRORATE_CONVENTION_CODE | Prorate convention |
| DEPRN_METHOD_CODE | Name of the depreciation method for the asset |
| LIFE_IN_MONTHS | Life of the asset in total months |
| ORIGINAL_DEPRN_START_DATE | Date short tax year asset began depreciating in the acquired company's books |
| Assets - FA_RX_ATTRSETS_TL | Stores Attribute Set information for RX reports (translated MLS table) |
|---|---|
| Column Name | Descritpion |
| REPORT_ID | Unique ID of the Report |
| CREATED_BY | Standard Who column |
| CREATION_DATE | Standard Who column |
| ATTRIBUTE_SET | Attribute set value |
| LANGUAGE | Indicates the defined language of the row's translated columns |
| SOURCE_LANG | Indicates the actual language of the row's translated columns |
| REPORT_TITLE | Report title name |
| USER_ATTRIBUTE_SET | User viewable attribute set name |
| LAST_UPDATE_DATE | Standard Who column |
| LAST_UPDATE_LOGIN | Standard Who column |
| LAST_UPDATED_BY | Standard Who column |
| Assets - FA_RX_REP_COLUMNS_TL | Stores attribute definitions for Report eXchange report attributes (translated MLS table) |
|---|---|
| Column Name | Descritpion |
| REPORT_ID | Unique ID of the Report |
| CREATED_BY | Standard Who column |
| CREATION_DATE | Standard Who column |
| ATTRIBUTE_SET | Attribute set value |
| COLUMN_NAME | The name of the interface table column in which this attributes' values are stored |
| LANGUAGE | Indicates the defined language of the row's translated columns |
| SOURCE_LANG | Indicates the actual language of the row's translated columns |
| ATTRIBUTE_NAME | The name of the attribute as it appears to the user in the RX client's download window |
| LAST_UPDATE_DATE | Standard Who column |
| LAST_UPDATE_LOGIN | Standard Who column |
| LAST_UPDATED_BY | Standard Who column |
| Assets - FA_RX_SUMMARY_TL | Stores summary definitions for Report eXchange report attributes (base MLS table) |
|---|---|
| Column Name | Descritpion |
| REPORT_ID | Unique ID of the Report |
| LAST_UPDATE_DATE | Standard Who column |
| LAST_UPDATE_LOGIN | Standard Who column |
| LAST_UPDATED_BY | Standard Who column |
| CREATED_BY | Standard Who column |
| CREATION_DATE | Standard Who column |
| LANGUAGE | Indicates the defined language of the row's translated columns |
| SOURCE_LANG | Indicates the actual language of the row's translated columns |
| ATTRIBUTE_SET | Attribute set value |
| COLUMN_NAME | The name of the interface table column in which this attributes' values are stored |
| PRINT_LEVEL | The break group level at which this summary value is printed |
| RESET_LEVEL | The break group level at which this summary value is reset |
| COMPUTE_LEVEL | The break group level at which this summary value is computed |
| SUMMARY_FUNCTION | The function used to summarize |
| SUMMARY_PROMPT | The prompt used when printing the summary value |
| DISPLAY_STATUS | Flag to indicate whether this value is printed |
| Assets - FA_RX_MULTIFORMAT_REPS | Stores information about Multiple format reports for use with RXi |
|---|---|
| Column Name | Descritpion |
| REQUEST_ID | Unique Request ID of the multiple format report |
| LAST_UPDATE_LOGIN | Standard Who column |
| CREATION_DATE | Standard Who column |
| CREATED_BY | Standard Who column |
| SUB_REPORT_ID | Unique Report ID of one format of a multiple format report |
| SUB_ATTRIBUTE_SET | Attribute set to use for one format of a multiple format report |
| SUB_REQUEST_ID | Request ID of one format of a multiple format report |
| GROUP_ID | Grouping number, used to group together formats within a multiple format report |
| SEQ_NUMBER | Sequence in which the formats should be printed |
| COMPLEX_FLAG | Flag to indicate that formats should be grouped together |
| LAST_UPDATE_DATE | Standard Who column |
| LAST_UPDATED_BY | Standard Who column |
| Assets - FA_RX_SECURITY | Stores security assignments for Report eXchange Attribute sets |
|---|---|
| Column Name | Descritpion |
| REPORT_ID | Unique Report ID |
| ATTRIBUTE_SET | Attribute Set name |
| RESPONSIBILITY_ID | Assigned Responsibility ID |
| LAST_UPDATE_DATE | Standard Who Column |
| LAST_UPDATED_BY | Standard Who Column |
| LAST_UPDATE_LOGIN | Standard Who Column |
| CREATION_DATE | Standard Who Column |
| CREATED_BY | Standard Who Column |
| Assets - FA_PROJ_INTERIM | Stores depreciation projections |
|---|---|
| Column Name | Descritpion |
| FISCAL_YEAR | Fiscal year |
| CODE_COMBINATION_ID | General Ledger depreciation expense account |
| DEPRECIATION | Depreciation expense amount projected for this period |
| BOOK_TYPE_CODE | Depreciation book |
| ASSET_ID | Asset identification number |
| PERIOD_NAME | Depreciation period |
| PERIOD_INDEX | Index of how many periods into the projection this period is |
| Assets - FA_PARALLEL_WORKERS | Used to control concurrent execution of post mass additions program. |
|---|---|
| Column Name | Descritpion |
| PROGRAM | Program name. |
| NEW_GROUP_ASSET_ID | New group asset identifier |
| PROCESS_ORDER | Internal identifier indicating the order in which transactions should be processed |
| REQUEST_ID | Internal identifier for the parent request ID of the posting program. |
| PROCESS_STATUS | Internal status of the transaction |
| WORKER_NUMBER | Concurrent (parallel) worker number. |
| START_TIME | Date/time worker started. |
| CONC_REQ_NUM | Concurrent request that this worker is running. |
| ASSET_ID | Internal asset identifier |
| ASSET_NUMBER | Asset number |
| ASSET_TYPE | Indicates whether the asset is CIP, capitalized, or expensed |
| ASSET_CATEGORY_ID | Identifies the category to which the asset belongs |
| PARENT_ASSET_ID | Internal asset identifier of the parent asset |
| BOOK_TYPE_CODE | Asset book |
| TRANSACTION_DATE_ENTERED | Date on which the transaction occurred |
| CORP_TRANSACTION_HEADER_ID | Internal corporate transaction identifier |
| TAX_TRANSACTION_HEADER_ID | Internal tax transaction identifier |
| TRANSACTION_TYPE_CODE | Identifies the type of transaction |
| OLD_GROUP_ASSET_ID | Old group asset identifier |
| Assets - FA_SUPER_GROUP_RULES | Defines the depreciation rules to be followed when depreciating asset groups that are members of the super group. |
|---|---|
| Column Name | Descritpion |
| SUPER_GROUP_ID | Super group identifier |
| CREATED_BY | Standard WHO column. |
| LAST_UPDATED_BY | Standard WHO column. |
| LAST_UPDATE_LOGIN | Standard WHO column. |
| LAST_UPDATE_DATE | Standard WHO column. |
| ATTRIBUTE1 | Descriptive flexfield segment |
| ATTRIBUTE2 | Descriptive flexfield segment |
| ATTRIBUTE3 | Descriptive flexfield segment |
| ATTRIBUTE4 | Descriptive flexfield segment |
| ATTRIBUTE5 | Descriptive flexfield segment |
| ATTRIBUTE6 | Descriptive flexfield segment |
| ATTRIBUTE7 | Descriptive flexfield segment |
| ATTRIBUTE8 | Descriptive flexfield segment |
| BOOK_TYPE_CODE | Book identifier. |
| ATTRIBUTE9 | Descriptive flexfield segment |
| ATTRIBUTE10 | Descriptive flexfield segment |
| ATTRIBUTE11 | Descriptive flexfield segment |
| ATTRIBUTE12 | Descriptive flexfield segment |
| ATTRIBUTE13 | Descriptive flexfield segment |
| ATTRIBUTE14 | Descriptive flexfield segment |
| ATTRIBUTE15 | Descriptive flexfield segment |
| ATTRIBUTE_CATEGORY | Descriptive flexfield structure defining column |
| START_PERIOD_COUNTER | Identifies the period when the super group becomes effective. |
| END_PERIOD_COUNTER | Identifies the period when the super group becomes ineffective. |
| ADJUSTMENT_REQUIRED_FLAG | Indicates if the super group rules change is being processed. |
| USED_FLAG | Indicates whether the super group is in use |
| DATE_EFFECTIVE | Date when the rates etc. became effective. |
| DEPRN_METHOD_CODE | Depreciation method to be used when depreciating group assets in the super group. |
| BASIC_RATE | Depreciation rate to be used when depreciating group assets in the super group. |
| ADJUSTED_RATE | Adjusted depreciation rate to be used when depreciating group assets in the super group. |
| PERCENT_SALVAGE_VALUE | Estimated net salvage of the super group expressed as a percentage of total investment. |
| DATE_INEFFECTIVE | Date after which the rates etc. were no longer effective. |
| CREATION_DATE | Standard WHO column. |
| Assets - FA_SUPER_GROUPS | Contains super group definitions - flexfield and general descriptive information. |
|---|---|
| Column Name | Descritpion |
| SUPER_GROUP_ID | Super group identifier. |
| CONCATENATED_SEGMENTS | Concatenated key flexfield |
| DESCRIPTION | Super group description |
| ENABLED_FLAG | Enabled flag. Required by AOL. |
| SUMMARY_FLAG | Summary flag. Required by AOL. |
| START_DATE_ACTIVE | Active start date |
| END_DATE_ACTIVE | Active end date |
| CREATED_BY | Standard WHO column. |
| CREATION_DATE | Standard WHO column. |
| LAST_UPDATED_BY | Standard WHO column. |
| LAST_UPDATE_DATE | Standard WHO column. |
| ID_FLEX_NUM | Key flexfield structure number. |
| LAST_UPDATE_LOGIN | Standard WHO column. |
| SUPER_GROUP_NAME | Unique identification number for a super group |
| SEGMENT1 | Key flexfield segment |
| SEGMENT2 | Key flexfield segment |
| SEGMENT3 | Key flexfield segment |
| SEGMENT4 | Key flexfield segment |
| SEGMENT5 | Key flexfield segment |
| SEGMENT6 | Key flexfield segment |
| SEGMENT7 | Key flexfield segment |
| Assets - FA_TAX_INTERFACE | Tax Book Interface table |
|---|---|
| Column Name | Descritpion |
| BOOK_TYPE_CODE | Tax Book Name |
| TAX_REQUEST_ID | Concurrent request id of the Tax Book Upload program that processed the record |
| SHORT_FISCAL_YEAR_FLAG | Flag to determine whether asset should be set up as a short tax year asset |
| CONVERSION_DATE | Date short tax asset added to the acquiring company |
| ORIGINAL_DEPRN_START_DATE | Original depreciation start date |
| AMORTIZE_NBV_FLAG | Determines whether to amortize NBV over remaining useful life |
| AMORTIZATION_START_DATE | Date to start amortizing the NBV for an asset if the amortize_nbv_flag is set to Y |
| FULLY_RSVD_REVALS_COUNTER | Number of times an asset has been revalued as fully reserved |
| REVAL_AMORTIZATION_BASIS | Revaluation reserve used in calculating amortization of the revaluation reserve |
| REVAL_CEILING | Upper limit for revaluing asset cost |
| REVAL_RESERVE | For a period in which this asset was revalued: change in net book value due to revaluation of asset cost and sometimes also revaluation of depreciation reserve. For all other periods: revaluation reserve amount after depreciation run |
| ADJUSTED_RATE | Actual rate used to calculate depreciation for flat-rate methods |
| UNREVALUED_COST | Cost without regard to any revaluations |
| YTD_REVAL_DEPRN_EXPENSE | Year-to-date depreciation expense due to revaluation. Oracle assets does not create journal entries for this amount. It is for reporting purposes only. |
| TRANSACTION_NAME | Description of the transaction |
| ATTRIBUTE1 | Descriptive flexfield segment |
| ATTRIBUTE2 | Descriptive flexfield segment |
| ATTRIBUTE3 | Descriptive flexfield segment |
| ATTRIBUTE4 | Descriptive flexfield segment |
| ATTRIBUTE5 | Descriptive flexfield segment |
| ATTRIBUTE6 | Descriptive flexfield segment |
| ATTRIBUTE7 | Descriptive flexfield segment |
| BASIC_RATE | Base rate used to calculate depreciation for flat-rate methods |
| ATTRIBUTE8 | Descriptive flexfield segment |
| ATTRIBUTE9 | Descriptive flexfield segment |
| ATTRIBUTE10 | Descriptive flexfield segment |
| ATTRIBUTE11 | Descriptive flexfield segment |
| ATTRIBUTE12 | Descriptive flexfield segment |
| ATTRIBUTE13 | Descriptive flexfield segment |
| ATTRIBUTE14 | Descriptive flexfield segment |
| ATTRIBUTE15 | Descriptive flexfield segment |
| ATTRIBUTE_CATEGORY_CODE | Descriptive flexfield structure defining column |
| GLOBAL_ATTRIBUTE1 | Reserved for country specific functionality |
| BONUS_RULE | Identifies the bonus rule to use in calculating depreciation for flat-rate methods |
| GLOBAL_ATTRIBUTE2 | Reserved for country specific functionality |
| GLOBAL_ATTRIBUTE3 | Reserved for country specific functionality |
| GLOBAL_ATTRIBUTE4 | Reserved for country specific functionality |
| GLOBAL_ATTRIBUTE5 | Reserved for country specific functionality |
| GLOBAL_ATTRIBUTE6 | Reserved for country specific functionality |
| GLOBAL_ATTRIBUTE7 | Reserved for country specific functionality |
| GLOBAL_ATTRIBUTE8 | Reserved for country specific functionality |
| GLOBAL_ATTRIBUTE9 | Reserved for country specific functionality |
| GLOBAL_ATTRIBUTE10 | Reserved for country specific functionality |
| GLOBAL_ATTRIBUTE11 | Reserved for country specific functionality |
| CEILING_NAME | Identifies a depreciation ceiling to use in calculating depreciation |
| GLOBAL_ATTRIBUTE12 | Reserved for country specific functionality |
| GLOBAL_ATTRIBUTE13 | Reserved for country specific functionality |
| GLOBAL_ATTRIBUTE14 | Reserved for country specific functionality |
| GLOBAL_ATTRIBUTE15 | Reserved for country specific functionality |
| GLOBAL_ATTRIBUTE16 | Reserved for country specific functionality |
| GLOBAL_ATTRIBUTE17 | Reserved for country specific functionality |
| GLOBAL_ATTRIBUTE18 | Reserved for country specific functionality |
| GLOBAL_ATTRIBUTE19 | Reserved for country specific functionality |
| GLOBAL_ATTRIBUTE20 | Reserved for country specific functionality |
| GLOBAL_ATTRIBUTE_CATEGORY | Reserved for country specific functionality |
| COST | Current cost of the asset |
| CREATED_BY | Standard Who column |
| CREATION_DATE | Standard Who column |
| LAST_UPDATED_BY | Standard Who column |
| LAST_UPDATE_DATE | Standard Who column |
| LAST_UPDATE_LOGIN | Standard Who column |
| GROUP_ASSET_ID | Identifies the associated group asset for group member assets |
| ASSET_ID | Internal use only |
| ASSET_TYPE | Internal use only |
| WORKER_ID | Internal identifier for parallel processing |
| NBV_AT_SWITCH | The net book value of an asset at the date the original rate was switched to the revised rate. |
| DATE_PLACED_IN_SERVICE | Date the asset was placed in service |
| PERIOD_FULL_RESERVE | The period in which the asset became fully reserved. |
| PERIOD_EXTD_DEPRN | The first period for which the asset begins extended depreciation. |
| PRIOR_DEPRN_LIMIT_TYPE | The depreciation limit type for the asset immediately before it began extended depreciation. |
| PRIOR_DEPRN_LIMIT_AMOUNT | The depreciation limit amount for the asset immediately before it began extended depreciation. |
| PRIOR_DEPRN_LIMIT | The depreciation limit as a percentage of cost for the asset immediately before it began extended depreciation. |
| PRIOR_DEPRN_METHOD | The depreciation method for the asset immediately before it began extended depreciation. |
| PRIOR_BASIC_RATE | The basic rate of the asset immediately before it began extended depreciation. |
| PRIOR_ADJUSTED_RATE | The adjusted rate of the asset immediately before it began extended depreciation. |
| PRIOR_LIFE_IN_MONTHS | The life in months for the asset immediately before it began extended depreciation. |
| DEPRECIATE_FLAG | Indicates whether the asset is depreciating |
| ASSET_NUMBER | Asset Number |
| DEPRN_METHOD_CODE | Name of the depreciation method for the asset |
| DEPRN_RESERVE | The amount of depreciation reserve |
| ITC_AMOUNT_ID | ITC rate identification number |
| LIFE_IN_MONTHS | Life of the asset in total months |
| ORIGINAL_COST | Original cost of the asset |
| PRODUCTION_CAPACITY | Capacity of a units of production asset |
| PRORATE_CONVENTION_CODE | Depreciation prorate convention |
| SALVAGE_VALUE | Asset salvage value |
| YTD_DEPRN | Year to date depreciation |
| POSTING_STATUS | Tax Upload Status: POST, POSTED, or user defined |
| Assets - FA_TAX_REPORT | FA_TAX_REPORT is temporary storage table for TAX PREFERENCE REPORT. |
|---|---|
| Column Name | Descritpion |
| ASSET_ACCOUNT | Account segment value |
| COMP_CODE | Company code |
| ASSET_ID | Asset id |
| FED_YTD_DEPRN | Federal book year to date depreciation |
| CORP_YTD_DEPRN | Corporate book year to date depreciation |
| REQUEST_ID | Concurrent request id |
| CREATED_BY | Standard Who column |
| CREATION_DATE | Standard Who column |
| DEPRN_METHOD | Depreciation method |
| LAST_UPDATED_BY | Standard Who column |
| LAST_UPDATE_DATE | Standard Who column |
| LAST_UPDATE_LOGIN | Standard Who column |
| Assets - FA_TRX_REFERENCES | Information about inter-asset transactions performed within Oracle Assets |
|---|---|
| Column Name | Descritpion |
| TRX_REFERENCE_ID | Unique transaction reference identification number |
| MEMBER_ASSET_ID | Group member asset on which the transaction occurred |
| MEMBER_TRANSACTION_HEADER_ID | Identifies the group member transaction |
| SRC_AMORTIZATION_START_DATE | Amortization start date for the source asset transaction |
| DEST_AMORTIZATION_START_DATE | Amortization start date for the destination asset transaction |
| RESERVE_TRANSFER_AMOUNT | Reserve amount transferred between assets |
| SRC_EXPENSE_AMOUNT | Amount entered for catchup depreciation expense on the source asset transaction |
| DEST_EXPENSE_AMOUNT | Amount entered for catchup depreciation expense on the destination asset transaction |
| SRC_EOFY_RESERVE | Amount entered for the prior fiscal year's reserve for the source asset |
| DEST_EOFY_RESERVE | Amount entered for the prior fiscal year's reserve for the destination asset |
| CREATION_DATE | Standard Who column |
| TRANSACTION_TYPE | Indicates type of transaction |
| CREATED_BY | Standard Who column |
| LAST_UPDATE_DATE | Standard Who column |
| LAST_UPDATED_BY | Standard Who column |
| LAST_UPDATE_LOGIN | Standard Who column |
| EVENT_ID | Invoice transaction internal identifier |
| INVOICE_TRANSACTION_ID | Invoice transaction internal identifier |
| SRC_TRANSACTION_SUBTYPE | Further detail of the transaction type for source asset |
| DEST_TRANSACTION_SUBTYPE | Further detail of the transaction type for destination asset |
| BOOK_TYPE_CODE | Name of the book in which the transactions occurred |
| SRC_ASSET_ID | Source asset on which the transaction occurred |
| SRC_TRANSACTION_HEADER_ID | Identifies the source transaction |
| DEST_ASSET_ID | Destination asset on which the transaction occurred |
| DEST_TRANSACTION_HEADER_ID | Identifies the destination transaction |
| Assets - FA_XLA_EXT_HEADERS_B_GT | |
|---|---|
| Column Name | Descritpion |
| EVENT_ID | |
| PROCEEDS_OF_SALE_GAIN_ACCT | |
| PROCEEDS_OF_SALE_LOSS_ACCT | |
| REVAL_RSV_RETIRED_GAIN_ACCT | |
| REVAL_RSV_RETIRED_LOSS_ACCT | |
| DEPRN_ADJUSTMENT_ACCT | |
| DEFAULT_CCID | |
| BOOK_TYPE_CODE | |
| BOOK_DESCRIPTION | |
| AP_INTERCOMPANY_ACCT | |
| AR_INTERCOMPANY_ACCT | |
| COST_OF_REMOVAL_CLEARING_ACCT | |
| ORG_ID | |
| BOOK_CONTROLS_ATTR1 | |
| BOOK_CONTROLS_ATTR2 | |
| BOOK_CONTROLS_ATTR3 | |
| BOOK_CONTROLS_ATTR4 | |
| BOOK_CONTROLS_ATTR5 | |
| BOOK_CONTROLS_ATTR6 | |
| BOOK_CONTROLS_ATTR7 | |
| BOOK_CONTROLS_ATTR8 | |
| BOOK_CONTROLS_ATTR9 | |
| COST_OF_REMOVAL_GAIN_ACCT | |
| BOOK_CONTROLS_ATTR10 | |
| BOOK_CONTROLS_ATTR11 | |
| BOOK_CONTROLS_ATTR12 | |
| BOOK_CONTROLS_ATTR13 | |
| BOOK_CONTROLS_ATTR14 | |
| BOOK_CONTROLS_ATTR15 | |
| PERIOD_NAME | |
| PERIOD_CLOSE_DATE | |
| PERIOD_COUNTER | |
| BOOK_CONTROLS_GLOBAL_ATTR1 | |
| COST_OF_REMOVAL_LOSS_ACCT | |
| BOOK_CONTROLS_GLOBAL_ATTR2 | |
| BOOK_CONTROLS_GLOBAL_ATTR3 | |
| BOOK_CONTROLS_GLOBAL_ATTR4 | |
| BOOK_CONTROLS_GLOBAL_ATTR5 | |
| BOOK_CONTROLS_GLOBAL_ATTR6 | |
| BOOK_CONTROLS_GLOBAL_ATTR7 | |
| BOOK_CONTROLS_GLOBAL_ATTR8 | |
| BOOK_CONTROLS_GLOBAL_ATTR9 | |
| BOOK_CONTROLS_GLOBAL_ATTR10 | |
| BOOK_CONTROLS_GLOBAL_ATTR11 | |
| DEFERRED_DEPRN_EXPENSE_ACCT | |
| BOOK_CONTROLS_GLOBAL_ATTR12 | |
| BOOK_CONTROLS_GLOBAL_ATTR13 | |
| BOOK_CONTROLS_GLOBAL_ATTR14 | |
| BOOK_CONTROLS_GLOBAL_ATTR15 | |
| BOOK_CONTROLS_GLOBAL_ATTR16 | |
| BOOK_CONTROLS_GLOBAL_ATTR17 | |
| BOOK_CONTROLS_GLOBAL_ATTR18 | |
| BOOK_CONTROLS_GLOBAL_ATTR19 | |
| BOOK_CONTROLS_GLOBAL_ATTR20 | |
| TRANSFER_TO_GL_FLAG | |
| DEFERRED_DEPRN_RESERVE_ACCT | |
| REVERSAL_FLAG | |
| ACCOUNTING_DATE | |
| SORP_ENABLED_FLAG | |
| NBV_RETIRED_GAIN_ACCT | |
| NBV_RETIRED_LOSS_ACCT | |
| PROCEEDS_OF_SALE_CLEARING_ACCT |
| Assets - FA_XLA_EXT_LINES_STG_GT | |
|---|---|
| Column Name | Descritpion |
| EVENT_ID | |
| PROPERTY_TYPE | |
| CAT_ATTR3 | |
| CAT_ATTR4 | |
| CAT_ATTR5 | |
| CAT_ATTR6 | |
| CAT_ATTR7 | |
| CAT_ATTR8 | |
| CAT_ATTR9 | |
| CAT_ATTR10 | |
| CAT_ATTR11 | |
| CAT_ATTR12 | |
| PROPERTY_CLASS | |
| CAT_ATTR13 | |
| CAT_ATTR14 | |
| CAT_ATTR15 | |
| BONUS_DEPRN_EXPENSE_ACCT | |
| DEPRN_EXPENSE_ACCT | |
| ASSET_COST_ACCT | |
| ASSET_CLEARING_ACCT | |
| CIP_COST_ACCT | |
| CIP_CLEARING_ACCT | |
| BONUS_RESERVE_ACCT | |
| MANUFACTURER_NAME | |
| DEPRN_RESERVE_ACCT | |
| REVAL_AMORT_ACCT | |
| REVAL_RESERVE_ACCT | |
| UNPLAN_EXPENSE_ACCT | |
| ALT_COST_ACCT | |
| WRITE_OFF_ACCT | |
| BONUS_RESERVE_ACCT_CCID | |
| ASSET_COST_ACCOUNT_CCID | |
| ASSET_CLEARING_ACCOUNT_CCID | |
| CIP_COST_ACCOUNT_CCID | |
| CURRENT_UNITS | |
| CIP_CLEARING_ACCOUNT_CCID | |
| RESERVE_ACCOUNT_CCID | |
| REVAL_AMORT_ACCOUNT_CCID | |
| REVAL_RESERVE_ACCOUNT_CCID | |
| DEPRN_EXPENSE_ACCOUNT_CCID | |
| BONUS_EXPENSE_ACCOUNT_CCID | |
| UNPLAN_EXPENSE_ACCOUNT_CCID | |
| ALT_COST_ACCOUNT_CCID | |
| WRITE_OFF_ACCOUNT_CCID | |
| CAT_BOOKS_ATTR1 | |
| NEW_USED | |
| CAT_BOOKS_ATTR2 | |
| CAT_BOOKS_ATTR3 | |
| CAT_BOOKS_ATTR4 | |
| CAT_BOOKS_ATTR5 | |
| CAT_BOOKS_ATTR6 | |
| CAT_BOOKS_ATTR7 | |
| CAT_BOOKS_ATTR8 | |
| CAT_BOOKS_ATTR9 | |
| CAT_BOOKS_ATTR10 | |
| CAT_BOOKS_ATTR11 | |
| INVENTORIAL | |
| CAT_BOOKS_ATTR12 | |
| CAT_BOOKS_ATTR13 | |
| CAT_BOOKS_ATTR14 | |
| CAT_BOOKS_ATTR15 | |
| EXPENSE_ACCOUNT_CCID | |
| UNITS_ASSIGNED | |
| EMPLOYEE_ID | |
| LEASE_NUMBER | |
| LEASE_ID | |
| LESSOR_SITE_ID | |
| IN_USE | |
| LEASES_ATTR1 | |
| LEASES_ATTR2 | |
| LEASES_ATTR3 | |
| LEASES_ATTR4 | |
| LEASES_ATTR5 | |
| LEASES_ATTR6 | |
| LEASES_ATTR7 | |
| LEASES_ATTR8 | |
| LEASES_ATTR9 | |
| LEASES_ATTR10 | |
| ASSET_CAT_ATTR_CAT_CODE | |
| LEASES_ATTR11 | |
| LEASES_ATTR12 | |
| LEASES_ATTR13 | |
| LEASES_ATTR14 | |
| LEASES_ATTR15 | |
| LOCATION_ID | |
| LOCATION_KEY_SEGMENT1 | |
| LOCATION_KEY_SEGMENT2 | |
| LOCATION_KEY_SEGMENT3 | |
| LOCATION_KEY_SEGMENT4 | |
| ASSET_CAT_ATTR1 | |
| LOCATION_KEY_SEGMENT5 | |
| LOCATION_KEY_SEGMENT6 | |
| LOCATION_KEY_SEGMENT7 | |
| LOCATIONS_ATTR1 | |
| LOCATIONS_ATTR2 | |
| LOCATIONS_ATTR3 | |
| LOCATIONS_ATTR4 | |
| LOCATIONS_ATTR5 | |
| LOCATIONS_ATTR6 | |
| LOCATIONS_ATTR7 | |
| ASSET_CAT_ATTR2 | |
| LOCATIONS_ATTR8 | |
| LOCATIONS_ATTR9 | |
| LOCATIONS_ATTR10 | |
| LOCATIONS_ATTR11 | |
| LOCATIONS_ATTR12 | |
| LOCATIONS_ATTR13 | |
| LOCATIONS_ATTR14 | |
| LOCATIONS_ATTR15 | |
| BONUS_RESERVE_RETIRED | |
| COST_RETIRED | |
| LINE_NUMBER | |
| ASSET_CAT_ATTR3 | |
| NBV_RETIRED | |
| GAIN_LOSS_AMOUNT | |
| PROCEEDS_OF_SALE_AMOUNT | |
| COST_OF_REMOVAL_AMOUNT | |
| REVAL_RESERVE_RETIRED_AMOUNT | |
| UNREVALUED_COST_RETIRED | |
| RETIREMENT_TYPE | |
| RETIREMENTS_ATTR1 | |
| RETIREMENTS_ATTR2 | |
| RETIREMENTS_ATTR3 | |
| ASSET_CAT_ATTR4 | |
| RETIREMENTS_ATTR4 | |
| RETIREMENTS_ATTR5 | |
| RETIREMENTS_ATTR6 | |
| RETIREMENTS_ATTR7 | |
| RETIREMENTS_ATTR8 | |
| RETIREMENTS_ATTR9 | |
| RETIREMENTS_ATTR10 | |
| RETIREMENTS_ATTR11 | |
| RETIREMENTS_ATTR12 | |
| RETIREMENTS_ATTR13 | |
| ASSET_CAT_ATTR5 | |
| RETIREMENTS_ATTR14 | |
| RETIREMENTS_ATTR15 | |
| TRANSACTION_HEADER_ID | |
| TRANSACTION_TYPE_CODE | |
| TRANSACTION_SUBTYPE | |
| TRANSACTION_KEY | |
| TRANSACTION_NAME | |
| SOURCE_TRANSACTION_HEADER_ID | |
| CALLING_INTERFACE | |
| AMORTIZATION_START_DATE | |
| ASSET_CAT_ATTR6 | |
| TRANSACTIONS_ATTR1 | |
| TRANSACTIONS_ATTR2 | |
| TRANSACTIONS_ATTR3 | |
| TRANSACTIONS_ATTR4 | |
| TRANSACTIONS_ATTR5 | |
| TRANSACTIONS_ATTR6 | |
| TRANSACTIONS_ATTR7 | |
| TRANSACTIONS_ATTR8 | |
| TRANSACTIONS_ATTR9 | |
| TRANSACTIONS_ATTR10 | |
| ASSET_CAT_ATTR7 | |
| TRANSACTIONS_ATTR11 | |
| TRANSACTIONS_ATTR12 | |
| TRANSACTIONS_ATTR13 | |
| TRANSACTIONS_ATTR14 | |
| TRANSACTIONS_ATTR15 | |
| VENDOR_NAME | |
| PROJECT_NUMBER | |
| ASSET_KEY_CCID | |
| ASSET_KEY_SEGMENT1 | |
| ASSET_KEY_SEGMENT2 | |
| ASSET_CAT_ATTR8 | |
| ASSET_KEY_SEGMENT3 | |
| ASSET_KEY_SEGMENT4 | |
| ASSET_KEY_SEGMENT5 | |
| ASSET_KEY_SEGMENT6 | |
| ASSET_KEY_SEGMENT7 | |
| ASSET_KEY_SEGMENT8 | |
| ASSET_KEY_SEGMENT9 | |
| ASSET_KEY_SEGMENT10 | |
| SUPER_GROUP_ID | |
| METHOD_CODE | |
| ASSET_CAT_ATTR9 | |
| DEPRN_BASIS_RULE_ID | |
| PRORATE_CONVENTION_CODE | |
| PRORATE_DATE | |
| BONUS_RULE | |
| PRODUCTION | |
| REFERENCE_NUM | |
| SOLD_TO | |
| TRADE_IN_ASSET_ID | |
| ASSET_CAT_GLOBAL_ATTR1 | |
| ASSET_CAT_GLOBAL_ATTR2 | |
| ASSET_CAT_ATTR10 | |
| CAT_GLOBAL_ATTR1 | |
| CAT_GLOBAL_ATTR2 | |
| CAT_GLOBAL_ATTR3 | |
| CAT_GLOBAL_ATTR4 | |
| CAT_GLOBAL_ATTR5 | |
| CAT_GLOBAL_ATTR6 | |
| CAT_GLOBAL_ATTR7 | |
| CAT_GLOBAL_ATTR8 | |
| CAT_GLOBAL_ATTR9 | |
| CAT_GLOBAL_ATTR10 | |
| ASSET_CAT_ATTR11 | |
| CAT_GLOBAL_ATTR11 | |
| CAT_GLOBAL_ATTR12 | |
| CAT_GLOBAL_ATTR13 | |
| CAT_GLOBAL_ATTR14 | |
| CAT_GLOBAL_ATTR15 | |
| CAT_GLOBAL_ATTR16 | |
| CURRENCY_CODE | |
| GENERATED_CCID | |
| GENERATED_OFFSET_CCID | |
| LEDGER_ID | |
| ASSET_CAT_ATTR12 | |
| DISTRIBUTION_TYPE_CODE | |
| TRANSACTION_REFERENCE_ID | |
| ADJUSTMENT_TYPE | |
| DEPRN_RUN_ID | |
| BOOK_TYPE_CODE | |
| ENTITY_CODE | |
| EVENT_CLASS_CODE | |
| EVENT_TYPE_CODE | |
| MEMBER_TRANSACTION_HEADER_ID | |
| CAPITAL_ADJ_ACCOUNT_CCID | |
| ASSET_NUMBER | |
| ASSET_CAT_ATTR13 | |
| GENERAL_FUND_ACCOUNT_CCID | |
| IMPAIR_RESERVE_ACCOUNT_CCID | |
| IMPAIR_EXPENSE_ACCOUNT_CCID | |
| IMPAIR_EXPENSE_ACCT | |
| IMPAIR_RESERVE_ACCT | |
| CAPITAL_ADJ_ACCT | |
| GENERAL_FUND_ACCT | |
| REVAL_LOSS_ACCT | |
| REVAL_LOSS_ACCOUNT_CCID | |
| ASSET_CAT_ATTR14 | |
| ASSET_CAT_ATTR15 | |
| ASSET_CAT_ATTR16 | |
| ASSET_CAT_ATTR17 | |
| ASSET_CAT_ATTR18 | |
| ASSET_CAT_ATTR19 | |
| ASSET_CAT_ATTR20 | |
| ASSET_CAT_ATTR21 | |
| ASSET_CAT_ATTR22 | |
| ASSET_ID | |
| ASSET_CAT_ATTR23 | |
| ASSET_CAT_ATTR24 | |
| ASSET_CAT_ATTR25 | |
| ASSET_CAT_ATTR26 | |
| ASSET_CAT_ATTR27 | |
| ASSET_CAT_ATTR28 | |
| ASSET_CAT_ATTR29 | |
| ASSET_CAT_ATTR30 | |
| DISTRIBUTION_ID | |
| ENTERED_AMOUNT | |
| OWNED_LEASED | |
| SOURCE_TYPE_CODE | |
| DEPRN_OVERRIDE_FLAG | |
| ADJUSTMENT_LINE_ID | |
| SOURCE_DEST_CODE | |
| SOURCE_LINE_ID | |
| ASSET_INVOICE_ID | |
| PAYABLES_CCID | |
| PO_VENDOR_ID | |
| PO_NUMBER | |
| INVOICE_NUMBER | |
| TAG_NUMBER | |
| INVOICE_DATE | |
| PROJECT_ID | |
| TASK_ID | |
| PROJECT_ASSET_LINE_ID | |
| AP_DISTRIBUTION_LINE_NUMBER | |
| FEEDER_SYSTEM_NAME | |
| ASSET_INVOICES_ATTR1 | |
| ASSET_INVOICES_ATTR2 | |
| ASSET_INVOICES_ATTR3 | |
| ASSET_INVOICES_ATTR4 | |
| SERIAL_NUMBER | |
| ASSET_INVOICES_ATTR5 | |
| ASSET_INVOICES_ATTR6 | |
| ASSET_INVOICES_ATTR7 | |
| ASSET_INVOICES_ATTR8 | |
| ASSET_INVOICES_ATTR9 | |
| ASSET_INVOICES_ATTR10 | |
| ASSET_INVOICES_ATTR11 | |
| ASSET_INVOICES_ATTR12 | |
| ASSET_INVOICES_ATTR13 | |
| ASSET_INVOICES_ATTR14 | |
| MODEL_NUMBER | |
| ASSET_INVOICES_ATTR15 | |
| DATE_PLACED_IN_SERVICE | |
| CONVERSION_DATE | |
| SHORT_FISCAL_YEAR_FLAG | |
| COST | |
| GROUP_ASSET_ID | |
| PRODUCTION_CAPACITY | |
| TRACKING_METHOD | |
| DRY_HOLE_FLAG | |
| CAT_FLEXFIELD_SEGMENT1 | |
| ASSET_TYPE | |
| CAT_FLEXFIELD_SEGMENT2 | |
| CAT_FLEXFIELD_SEGMENT3 | |
| CAT_FLEXFIELD_SEGMENT4 | |
| CAT_FLEXFIELD_SEGMENT5 | |
| CAT_FLEXFIELD_SEGMENT6 | |
| CAT_FLEXFIELD_SEGMENT7 | |
| CAT_ID | |
| CAT_TYPE | |
| CAT_ATTR1 | |
| CAT_ATTR2 |
| Assets - FA_TRANSACTION_INTERFACE | Interface table for uploading transactions to Assets |
|---|---|
| Column Name | Descritpion |
| TRANSACTION_INTERFACE_ID | Interface table for uploading transactions to Assets |
| COMMENTS | Comments for this transaction |
| CONCURRENT_REQUEST_ID | Concurrent request identification number which posted the transaction |
| CREATED_BY | Standard Who column |
| CREATION_DATE | Standard Who column |
| LAST_UPDATED_BY | Standard Who column |
| LAST_UPDATE_DATE | Standard Who column |
| LAST_UPDATE_LOGIN | Standard Who column |
| TRANSACTION_DATE | Date on which the transaction occurred |
| TRANSACTION_TYPE_CODE | Identitifies the type of transaction |
| POSTING_STATUS | Status of the transaction |
| BOOK_TYPE_CODE | Book name |
| ASSET_KEY_PROJECT_VALUE | Segment value for the project segment on the asset key flexfield |
| ASSET_KEY_HIERARCHY_VALUE | Segment value for the hierarchy segment on the asset key flexfield |
| ASSET_KEY_NEW_HIERARCHY_VALUE | New segment value for the hierarchy segment on the asset key flexfield |
| REFERENCE_NUMBER | User assigned reference number |
| Assets - FA_WORKER_JOBS | This table is used for internal processesing only |
|---|---|
| Column Name | Descritpion |
| REQUEST_ID | Concurrent request identifier |
| START_RANGE | Start record identifier |
| END_RANGE | End record identifier |
| WORKER_NUM | Worker number |
| STATUS | Concurrent request status |
| Assets - FA_MC_ITF_IMPAIRMENTS | FA_MC_ITF_IMPAIRMENTS is the MRC version of FA_ITF_IMPAIRMENTS. |
|---|---|
| Column Name | Descritpion |
| SET_OF_BOOKS_ID | Reporting set of books identification number for General Ledger sets of books |
| IMPAIRMENT_AMOUNT | Periodic Impairment amount |
| YTD_IMPAIRMENT | Year-to-date Impairment amount |
| IMPAIRMENT_RESERVE | Life-to-date Impairment amount |
| GOODWILL_ASSET_FLAG | Indicate whether a asset is goodwill asset or not |
| DEPRN_RUN_DATE | System date when depreciation was run |
| DEPRN_AMOUNT | Depreciation expense for this depreciation period |
| YTD_DEPRN | Year-to-date depreciation expense |
| DEPRN_RESERVE | Total depreciation taken since beginning of asset life |
| ADJUSTED_COST | Depreciable basis |
| BONUS_RATE | Bonus rate used to calculate depreciation |
| REQUEST_ID | Unique identification number of a impairment process concurrent request |
| LTD_PRODUCTION | Life-to-date production for a units of production asset |
| PERIOD_COUNTER | Depreciation period |
| PRODUCTION | Current period production for a units of production asset |
| REVAL_AMORTIZATION | Amount of revaluation reserve amortized during this period |
| REVAL_AMORTIZATION_BASIS | Revaluation reserve used in calculating amortization of revaluation reserve |
| REVAL_DEPRN_EXPENSE | Portion of depreciation expense due to revaluation of the asset cost |
| REVAL_RESERVE | Revaluation reserve amount after depreciation run |
| YTD_PRODUCTION | Year-to-date production for a units of production asset |
| YTD_REVAL_DEPRN_EXPENSE | Year-to-date depreciation expense due to revaluation |
| PRIOR_FY_EXPENSE | Depreciation expense due to prior fiscal years |
| IMPAIRMENT_ID | Unique identification number of a impairment |
| BONUS_DEPRN_AMOUNT | Bonus depreciation expense for this depreciation period |
| BONUS_YTD_DEPRN | Bonus year-to-date depreciation expense |
| BONUS_DEPRN_RESERVE | Total bonus depreciation taken since the beginning of asset life |
| PRIOR_FY_BONUS_EXPENSE | Bonus Depreciation expense due to prior fiscal years |
| DEPRN_OVERRIDE_FLAG | Override status |
| SYSTEM_DEPRN_AMOUNT | System calculated Depreciation Amount |
| SYSTEM_BONUS_DEPRN_AMOUNT | System calculated Bonus Depreciation Amount |
| DEPRN_ADJUSTMENT_AMOUNT | Depreciation adjustment amount |
| BONUS_DEPRN_ADJUSTMENT_AMOUNT | Bonus depreciation adjustment amount |
| REVAL_RESERVE_ADJ_AMOUNT | Change in revaluation reserve amount due to an impairment transaction |
| COST | Asset cost |
| BOOK_TYPE_CODE | Book Name |
| PERIOD_OF_ADDITION_FLAG | Indicate whether an asset is in period of addition or not |
| CURRENT_UNITS | Current number of units for the asset |
| CATEGORY_ID | Identifies category to which the asset belongs |
| IMPAIRMENT_DATE | Impairment date |
| WORKER_ID | Worker identification number for parallel processing |
| PROCESS_ORDER | Identifies when to process this record for parallel processing |
| CREATION_DATE | Standard Who column |
| CREATED_BY | Standard Who column |
| LAST_UPDATE_DATE | Standard Who column |
| LAST_UPDATED_BY | Standard Who column |
| ASSET_ID | Asset identification number |
| LAST_UPDATE_LOGIN | Standard Who column |
| RATE_ADJUSTMENT_FACTOR | Percent of remaining depreciation after a revaluation or an amortized change, or 1 |
| FORMULA_FACTOR | Factor used to adjust the depreciation rate for formula-based NBV-based assets |
| EOFY_RESERVE | Accumulated depreciation at the end of the previous fiscal year |
| IMPAIR_CLASS | Impairment classification type |
| REASON | Reason description |
| IMPAIR_LOSS_ACCT | Loss account to which the impairment loss must be booked |
| SPLIT_IMPAIR_FLAG | Indicates whether the impairment is split or not. A value of Y indicates that the impairment is split. Any other value indicates that the impairment is not split |
| SPLIT1_IMPAIR_CLASS | Split 1 impairment classification type |
| SPLIT1_REASON | Split 1 Reason description |
| SPLIT1_LOSS_AMOUNT | Split 1 Loss Amount calculated internally from Split 1 Percentage |
| SPLIT1_REVAL_RESERVE | Amount of Revaluation Reserve adjusted by Split 1 |
| SPLIT1_PERCENT | Split 1 Percentage |
| SPLIT1_LOSS_ACCT | Split 1 Loss Account to which the impairment loss must be booked |
| SPLIT1_PROCESS_ORDER | The order in which Split 1 was processed |
| SPLIT2_IMPAIR_CLASS | Split 2 impairment classification type |
| SPLIT2_REASON | Split 2 Reason description |
| SPLIT2_LOSS_AMOUNT | Split 2 Loss Amount calculated internally from Split 2 Percentage |
| SPLIT2_REVAL_RESERVE | Amount of Revaluation Reserve adjusted by Split 2 |
| SPLIT2_PERCENT | Split 2 Percentage |
| CASH_GENERATING_UNIT_ID | Unique identification number of c cash generating unit |
| SPLIT2_LOSS_ACCT | Split 2 Loss Account to which the impairment loss must be booked |
| SPLIT2_PROCESS_ORDER | The order in which Split 2 was processed |
| SPLIT3_IMPAIR_CLASS | Split 3 impairment classification type |
| SPLIT3_REASON | Split 3 Reason description |
| SPLIT3_LOSS_AMOUNT | Split 3 Loss Amount calculated internally from Split 3 Percentage |
| SPLIT3_REVAL_RESERVE | Amount of Revaluation Reserve adjusted by Split 3 |
| SPLIT3_PERCENT | Split 3 Percentage |
| SPLIT3_LOSS_ACCT | Split 3 Loss Account to which the impairment loss must be booked |
| SPLIT3_PROCESS_ORDER | The order in which Split 3 was processed |
| CAPITAL_ADJUSTMENT | The value of Capital Adjustment after considering impairment effect |
| GENERAL_FUND | The value of General Fund after considering impairment effect |
| REVERSED_IMP_AMT | The amount of impairment loss amount attributed to I&E account reversed |
| REVERSED_IMP_AMT_S1 | The amount of Split 1 impairment loss amount attributed to I&E account reversed |
| REVERSED_IMP_AMT_S2 | The amount of Split 2 impairment loss amount attributed to I&E account reversed |
| REVERSED_IMP_AMT_S3 | The amount of Split 3 impairment loss amount attributed to I&E account reversed |
| REVERSED_DEPRN_IMPACT | The amount of depreciation impact attributed to I&E account reversed |
| REVERSED_DEPRN_IMPACT_S1 | The amount of Split 1 depreciation impact attributed to I&E account reversed |
| REVERSED_DEPRN_IMPACT_S2 | The amount of Split 2 depreciation impact attributed to I&E account reversed |
| REVERSED_DEPRN_IMPACT_S3 | The amount of Split 3 depreciation impact attributed to I&E account reversed |
| REVERSED_REVAL_AMT | The amount of impairment loss amount attributed to Revaluation Reserve account reversed |
| NET_BOOK_VALUE | Net book value of an asset |
| REVERSED_REVAL_AMT_S1 | The amount of Split 1 impairment loss amount attributed to Revaluation Reserve account reversed |
| REVERSED_REVAL_AMT_S2 | The amount of Split 2 impairment loss amount attributed to Revaluation Reserve account reversed |
| REVERSED_REVAL_AMT_S3 | The amount of Split 3 impairment loss amount attributed to Revaluation Reserve account reversed |
| REVERSED_REVAL_IMPACT | The amount of depreciation impact attributed to Revaluation Reserve account reversed |
| REVERSED_REVAL_IMPACT_S1 | The amount of Split 1 depreciation impact attributed to Revaluation Reserve account reversed |
| REVERSED_REVAL_IMPACT_S2 | The amount of Split 2 depreciation impact attributed to Revaluation Reserve account reversed |
| REVERSED_REVAL_IMPACT_S3 | The amount of Split 3 depreciation impact attributed to Revaluation Reserve account reversed |
| ALLOWED_DEPRN_LIMIT_AMOUNT | Asset Depreciation limit |
| NET_SELLING_PRICE | Fair value of the cash generating or Asset less cost to sell |
| VALUE_IN_USE | Present value of future cash flows expected of an asset or cash generating unit |
| Assets - FA_MC_IMPAIRMENTS | FA_MC_IMPAIRMENTS is the MRC version of FA_IMPAIRMENTS. |
|---|---|
| Column Name | Descritpion |
| SET_OF_BOOKS_ID | Reporting set of books identification number for General Ledger sets of books |
| NET_BOOK_VALUE | Net book value of an impairment |
| NET_SELLING_PRICE | Fair value of the cash-generating or Asset less cost to sell |
| VALUE_IN_USE | Present value of future cash flows expected of an asset or cash-generating unit |
| GOODWILL_ASSET_ID | Goodwill asset identification number |
| GOODWILL_AMOUNT | Goodwill Amount |
| USER_DATE | User provided date |
| IMPAIRMENT_DATE | Impairment date |
| PERIOD_COUNTER_IMPAIRED | Period Counter of impairment transaction |
| IMPAIRMENT_AMOUNT | Impairment loss amount |
| DATE_INEFFECTIVE | Date which the row became ineffective |
| IMPAIRMENT_ID | Unique identification number of a impairment |
| CREATION_DATE | Standard Who column |
| CREATED_BY | Standard Who column |
| LAST_UPDATE_DATE | Standard Who column |
| LAST_UPDATED_BY | Standard Who column |
| LAST_UPDATE_LOGIN | Standard Who column |
| IMPAIR_CLASS | Impairment classification type |
| REASON | Reason description |
| IMPAIR_LOSS_ACCT | Loss account to which the impairment loss must be booked |
| SPLIT_IMPAIR_FLAG | Indicates whether the impairment is split or not. A value of Y indicates that the impairment is split. Any other value indicates that the impairment is not split |
| SPLIT1_IMPAIR_CLASS | Split 1 impairment classification type |
| SPLIT1_REASON | Split 1 Reason description |
| SPLIT1_PERCENT | Split 1 Percentage |
| SPLIT1_LOSS_ACCT | Split 1 Loss Account to which the impairment loss must be booked |
| SPLIT2_IMPAIR_CLASS | Split 2 impairment classification type |
| SPLIT2_REASON | Split 2 Reason description |
| SPLIT2_PERCENT | Split 2 Percentage |
| IMPAIRMENT_NAME | Name of impairment |
| SPLIT2_LOSS_ACCT | Split 2 Loss Account to which the impairment loss must be booked |
| SPLIT3_IMPAIR_CLASS | Split 3 impairment classification type |
| SPLIT3_REASON | Split 3 Reason description |
| SPLIT3_PERCENT | Split 3 Percentage |
| SPLIT3_LOSS_ACCT | Split 3 Loss Account to which the impairment loss must be booked |
| DESCRIPTION | Description |
| REQUEST_ID | Unique identification number of a impairment process concurrent request |
| STATUS | Status of impairment process |
| BOOK_TYPE_CODE | Book Name |
| CASH_GENERATING_UNIT_ID | Unique identification number of c cash generating unit |
| ASSET_ID | Asset identification number |
| Assets - FA_XLA_EXT_LINES_TL_GT | |
|---|---|
| Column Name | Descritpion |
| EVENT_ID | |
| TRANSACTION_HEADER_ID | |
| BOOK_TYPE_CODE | |
| LINE_NUMBER | |
| LANGUAGE | |
| ASSET_DESCRIPTION | |
| CAT_DESCRIPTION | |
| LEDGER_ID | |
| ASSET_ID | |
| DEPRN_RUN_ID | |
| PERIOD_COUNTER |
| Assets - FA_XLA_EXT_LINES_B_GT | |
|---|---|
| Column Name | Descritpion |
| EVENT_ID | |
| ASSET_TYPE | |
| CAT_FLEXFIELD_SEGMENT6 | |
| CAT_FLEXFIELD_SEGMENT7 | |
| CAT_ID | |
| CAT_TYPE | |
| CAT_ATTR1 | |
| CAT_ATTR2 | |
| CAT_ATTR3 | |
| CAT_ATTR4 | |
| CAT_ATTR5 | |
| CAT_ATTR6 | |
| PROPERTY_TYPE | |
| CAT_ATTR7 | |
| CAT_ATTR8 | |
| CAT_ATTR9 | |
| CAT_ATTR10 | |
| CAT_ATTR11 | |
| CAT_ATTR12 | |
| CAT_ATTR13 | |
| CAT_ATTR14 | |
| CAT_ATTR15 | |
| BONUS_DEPRN_EXPENSE_ACCT | |
| PROPERTY_CLASS | |
| DEPRN_EXPENSE_ACCT | |
| ASSET_COST_ACCT | |
| ASSET_CLEARING_ACCT | |
| CIP_COST_ACCT | |
| CIP_CLEARING_ACCT | |
| BONUS_RESERVE_ACCT | |
| DEPRN_RESERVE_ACCT | |
| REVAL_AMORT_ACCT | |
| REVAL_RESERVE_ACCT | |
| UNPLAN_EXPENSE_ACCT | |
| MANUFACTURER_NAME | |
| ALT_COST_ACCT | |
| WRITE_OFF_ACCT | |
| BONUS_RESERVE_ACCT_CCID | |
| ASSET_COST_ACCOUNT_CCID | |
| ASSET_CLEARING_ACCOUNT_CCID | |
| CIP_COST_ACCOUNT_CCID | |
| CIP_CLEARING_ACCOUNT_CCID | |
| RESERVE_ACCOUNT_CCID | |
| REVAL_AMORT_ACCOUNT_CCID | |
| REVAL_RESERVE_ACCOUNT_CCID | |
| CURRENT_UNITS | |
| DEPRN_EXPENSE_ACCOUNT_CCID | |
| BONUS_EXPENSE_ACCOUNT_CCID | |
| UNPLAN_EXPENSE_ACCOUNT_CCID | |
| ALT_COST_ACCOUNT_CCID | |
| WRITE_OFF_ACCOUNT_CCID | |
| CAT_BOOKS_ATTR1 | |
| CAT_BOOKS_ATTR2 | |
| CAT_BOOKS_ATTR3 | |
| CAT_BOOKS_ATTR4 | |
| CAT_BOOKS_ATTR5 | |
| NEW_USED | |
| CAT_BOOKS_ATTR6 | |
| CAT_BOOKS_ATTR7 | |
| CAT_BOOKS_ATTR8 | |
| CAT_BOOKS_ATTR9 | |
| CAT_BOOKS_ATTR10 | |
| CAT_BOOKS_ATTR11 | |
| CAT_BOOKS_ATTR12 | |
| CAT_BOOKS_ATTR13 | |
| CAT_BOOKS_ATTR14 | |
| CAT_BOOKS_ATTR15 | |
| INVENTORIAL | |
| EXPENSE_ACCOUNT_CCID | |
| UNITS_ASSIGNED | |
| EMPLOYEE_ID | |
| LEASE_NUMBER | |
| LEASE_ID | |
| LESSOR_SITE_ID | |
| LEASES_ATTR1 | |
| LEASES_ATTR2 | |
| LEASES_ATTR3 | |
| LEASES_ATTR4 | |
| IN_USE | |
| LEASES_ATTR5 | |
| LEASES_ATTR6 | |
| LEASES_ATTR7 | |
| LEASES_ATTR8 | |
| LEASES_ATTR9 | |
| LEASES_ATTR10 | |
| LEASES_ATTR11 | |
| LEASES_ATTR12 | |
| LEASES_ATTR13 | |
| LEASES_ATTR14 | |
| ASSET_CAT_ATTR_CAT_CODE | |
| LEASES_ATTR15 | |
| LOCATION_ID | |
| LOCATION_KEY_SEGMENT1 | |
| LOCATION_KEY_SEGMENT2 | |
| LOCATION_KEY_SEGMENT3 | |
| LOCATION_KEY_SEGMENT4 | |
| LOCATION_KEY_SEGMENT5 | |
| LOCATION_KEY_SEGMENT6 | |
| LOCATION_KEY_SEGMENT7 | |
| LOCATIONS_ATTR1 | |
| ASSET_CAT_ATTR1 | |
| LOCATIONS_ATTR2 | |
| LOCATIONS_ATTR3 | |
| LOCATIONS_ATTR4 | |
| LOCATIONS_ATTR5 | |
| LOCATIONS_ATTR6 | |
| LOCATIONS_ATTR7 | |
| LOCATIONS_ATTR8 | |
| LOCATIONS_ATTR9 | |
| LOCATIONS_ATTR10 | |
| LOCATIONS_ATTR11 | |
| LINE_NUMBER | |
| ASSET_CAT_ATTR2 | |
| LOCATIONS_ATTR12 | |
| LOCATIONS_ATTR13 | |
| LOCATIONS_ATTR14 | |
| LOCATIONS_ATTR15 | |
| BONUS_RESERVE_RETIRED | |
| COST_RETIRED | |
| NBV_RETIRED | |
| GAIN_LOSS_AMOUNT | |
| PROCEEDS_OF_SALE_AMOUNT | |
| COST_OF_REMOVAL_AMOUNT | |
| ASSET_CAT_ATTR3 | |
| REVAL_RESERVE_RETIRED_AMOUNT | |
| UNREVALUED_COST_RETIRED | |
| RETIREMENT_TYPE | |
| RETIREMENTS_ATTR1 | |
| RETIREMENTS_ATTR2 | |
| RETIREMENTS_ATTR3 | |
| RETIREMENTS_ATTR4 | |
| RETIREMENTS_ATTR5 | |
| RETIREMENTS_ATTR6 | |
| RETIREMENTS_ATTR7 | |
| ASSET_CAT_ATTR4 | |
| RETIREMENTS_ATTR8 | |
| RETIREMENTS_ATTR9 | |
| RETIREMENTS_ATTR10 | |
| RETIREMENTS_ATTR11 | |
| RETIREMENTS_ATTR12 | |
| RETIREMENTS_ATTR13 | |
| RETIREMENTS_ATTR14 | |
| RETIREMENTS_ATTR15 | |
| TRANSACTION_HEADER_ID | |
| TRANSACTION_TYPE_CODE | |
| ASSET_CAT_ATTR5 | |
| TRANSACTION_SUBTYPE | |
| TRANSACTION_KEY | |
| TRANSACTION_NAME | |
| SOURCE_TRANSACTION_HEADER_ID | |
| CALLING_INTERFACE | |
| AMORTIZATION_START_DATE | |
| TRANSACTIONS_ATTR1 | |
| TRANSACTIONS_ATTR2 | |
| TRANSACTIONS_ATTR3 | |
| TRANSACTIONS_ATTR4 | |
| ASSET_CAT_ATTR6 | |
| TRANSACTIONS_ATTR5 | |
| TRANSACTIONS_ATTR6 | |
| TRANSACTIONS_ATTR7 | |
| TRANSACTIONS_ATTR8 | |
| TRANSACTIONS_ATTR9 | |
| TRANSACTIONS_ATTR10 | |
| TRANSACTIONS_ATTR11 | |
| TRANSACTIONS_ATTR12 | |
| TRANSACTIONS_ATTR13 | |
| TRANSACTIONS_ATTR14 | |
| ASSET_CAT_ATTR7 | |
| TRANSACTIONS_ATTR15 | |
| VENDOR_NAME | |
| PROJECT_NUMBER | |
| ASSET_KEY_CCID | |
| ASSET_KEY_SEGMENT1 | |
| ASSET_KEY_SEGMENT2 | |
| ASSET_KEY_SEGMENT3 | |
| ASSET_KEY_SEGMENT4 | |
| ASSET_KEY_SEGMENT5 | |
| ASSET_KEY_SEGMENT6 | |
| ASSET_CAT_ATTR8 | |
| ASSET_KEY_SEGMENT7 | |
| ASSET_KEY_SEGMENT8 | |
| ASSET_KEY_SEGMENT9 | |
| ASSET_KEY_SEGMENT10 | |
| SUPER_GROUP_ID | |
| METHOD_CODE | |
| DEPRN_BASIS_RULE_ID | |
| PRORATE_CONVENTION_CODE | |
| PRORATE_DATE | |
| BONUS_RULE | |
| ASSET_CAT_ATTR9 | |
| PRODUCTION | |
| REFERENCE_NUM | |
| SOLD_TO | |
| TRADE_IN_ASSET_ID | |
| ASSET_CAT_GLOBAL_ATTR1 | |
| ASSET_CAT_GLOBAL_ATTR2 | |
| CAT_GLOBAL_ATTR1 | |
| CAT_GLOBAL_ATTR2 | |
| CAT_GLOBAL_ATTR3 | |
| CAT_GLOBAL_ATTR4 | |
| ASSET_CAT_ATTR10 | |
| CAT_GLOBAL_ATTR5 | |
| CAT_GLOBAL_ATTR6 | |
| CAT_GLOBAL_ATTR7 | |
| CAT_GLOBAL_ATTR8 | |
| CAT_GLOBAL_ATTR9 | |
| CAT_GLOBAL_ATTR10 | |
| CAT_GLOBAL_ATTR11 | |
| CAT_GLOBAL_ATTR12 | |
| CAT_GLOBAL_ATTR13 | |
| CAT_GLOBAL_ATTR14 | |
| ASSET_CAT_ATTR11 | |
| CAT_GLOBAL_ATTR15 | |
| CAT_GLOBAL_ATTR16 | |
| CURRENCY_CODE | |
| GENERATED_CCID | |
| GENERATED_OFFSET_CCID | |
| BONUS_GENERATED_CCID | |
| BONUS_GENERATED_OFFSET_CCID | |
| REVAL_GENERATED_CCID | |
| REVAL_GENERATED_OFFSET_CCID | |
| LEDGER_ID | |
| BOOK_TYPE_CODE | |
| ASSET_CAT_ATTR12 | |
| DISTRIBUTION_TYPE_CODE | |
| TRANSACTION_REFERENCE_ID | |
| ADJUSTMENT_TYPE | |
| DEPRN_RUN_ID | |
| TAX_BOOK_TYPE_CODE | |
| PERIOD_COUNTER | |
| COUNTER_GENERATED_CCID | |
| COUNTER_GENERATED_OFFSET_CCID | |
| IMPAIR_EXPENSE_ACCOUNT_CCID | |
| IMPAIR_RESERVE_ACCOUNT_CCID | |
| ASSET_CAT_ATTR13 | |
| IMPAIR_EXPENSE_ACCT | |
| IMPAIR_RESERVE_ACCT | |
| GENERAL_FUND_ACCOUNT_CCID | |
| GENERAL_FUND_ACCT | |
| CAPITAL_ADJ_ACCOUNT_CCID | |
| CAPITAL_ADJ_ACCT | |
| CAPITAL_ADJ_GENERATED_CCID | |
| GENERAL_FUND_GENERATED_CCID | |
| REVAL_LOSS_ACCT | |
| REVAL_LOSS_ACCOUNT_CCID | |
| ASSET_CAT_ATTR14 | |
| OVERRIDE_ACCOUNT_SEGMENT | |
| ASSET_CAT_ATTR15 | |
| ASSET_CAT_ATTR16 | |
| ASSET_CAT_ATTR17 | |
| ASSET_CAT_ATTR18 | |
| ASSET_CAT_ATTR19 | |
| ASSET_CAT_ATTR20 | |
| ASSET_CAT_ATTR21 | |
| ASSET_NUMBER | |
| ASSET_CAT_ATTR22 | |
| ASSET_CAT_ATTR23 | |
| ASSET_CAT_ATTR24 | |
| ASSET_CAT_ATTR25 | |
| ASSET_CAT_ATTR26 | |
| ASSET_CAT_ATTR27 | |
| ASSET_CAT_ATTR28 | |
| ASSET_CAT_ATTR29 | |
| ASSET_CAT_ATTR30 | |
| DISTRIBUTION_ID | |
| ASSET_ID | |
| ENTERED_AMOUNT | |
| BONUS_ENTERED_AMOUNT | |
| REVAL_ENTERED_AMOUNT | |
| SOURCE_TYPE_CODE | |
| DEPRN_OVERRIDE_FLAG | |
| ADJUSTMENT_LINE_ID | |
| SOURCE_DEST_CODE | |
| SOURCE_LINE_ID | |
| ASSET_INVOICE_ID | |
| PAYABLES_CCID | |
| OWNED_LEASED | |
| PO_VENDOR_ID | |
| PO_NUMBER | |
| INVOICE_DATE | |
| INVOICE_NUMBER | |
| INVOICE_ID | |
| INVOICE_LINE_NUMBER | |
| INVOICE_DISTRIBUTION_ID | |
| AP_DISTRIBUTION_LINE_NUMBER | |
| PROJECT_ID | |
| TASK_ID | |
| TAG_NUMBER | |
| PROJECT_ASSET_LINE_ID | |
| FEEDER_SYSTEM_NAME | |
| ASSET_INVOICES_ATTR1 | |
| ASSET_INVOICES_ATTR2 | |
| ASSET_INVOICES_ATTR3 | |
| ASSET_INVOICES_ATTR4 | |
| ASSET_INVOICES_ATTR5 | |
| ASSET_INVOICES_ATTR6 | |
| ASSET_INVOICES_ATTR7 | |
| ASSET_INVOICES_ATTR8 | |
| SERIAL_NUMBER | |
| ASSET_INVOICES_ATTR9 | |
| ASSET_INVOICES_ATTR10 | |
| ASSET_INVOICES_ATTR11 | |
| ASSET_INVOICES_ATTR12 | |
| ASSET_INVOICES_ATTR13 | |
| ASSET_INVOICES_ATTR14 | |
| ASSET_INVOICES_ATTR15 | |
| DATE_PLACED_IN_SERVICE | |
| CONVERSION_DATE | |
| SHORT_FISCAL_YEAR_FLAG | |
| MODEL_NUMBER | |
| COST | |
| GROUP_ASSET_ID | |
| PRODUCTION_CAPACITY | |
| TRACKING_METHOD | |
| DRY_HOLE_FLAG | |
| CAT_FLEXFIELD_SEGMENT1 | |
| CAT_FLEXFIELD_SEGMENT2 | |
| CAT_FLEXFIELD_SEGMENT3 | |
| CAT_FLEXFIELD_SEGMENT4 | |
| CAT_FLEXFIELD_SEGMENT5 |
| Assets - FA_RESERVE_LEDGER_GT | |
|---|---|
| Column Name | Descritpion |
| ASSET_ID | |
| YTD_DEPRN | |
| PERCENT | |
| TRANSACTION_TYPE | |
| DEPRN_RESERVE | |
| PERIOD_COUNTER | |
| DATE_EFFECTIVE | |
| DEPRN_RESERVE_ACCT | |
| RESERVE_ACCT | |
| DISTRIBUTION_ID | |
| DH_CCID | |
| DATE_PLACED_IN_SERVICE | |
| METHOD_CODE | |
| LIFE | |
| RATE | |
| CAPACITY | |
| COST | |
| DEPRN_AMOUNT |
| Assets - FA_TRACK_MEMBERS | |
|---|---|
| Column Name | Descritpion |
| TRACK_MEMBER_ID | |
| ALLOCATED_BONUS_AMOUNT | |
| SYSTEM_DEPRN_AMOUNT | |
| SYSTEM_BONUS_AMOUNT | |
| FULLY_RESERVED_FLAG | |
| FULLY_RETIRED_FLAG | |
| OVERRIDE_FLAG | |
| COST | |
| ADJUSTED_COST | |
| EOFY_ADJ_COST | |
| RECOVERABLE_COST | |
| GROUP_ASSET_ID | |
| SALVAGE_VALUE | |
| ADJUSTED_RECOVERABLE_COST | |
| PRIOR_YEAR_RESERVE | |
| EOFY_AMOUNT | |
| DEPRN_RESERVE | |
| YTD_DEPRN | |
| BONUS_DEPRN_RESERVE | |
| BONUS_YTD_DEPRN | |
| EOFY_RECOVERABLE_COST | |
| EOP_RECOVERABLE_COST | |
| MEMBER_ASSET_ID | |
| EOFY_SALVAGE_VALUE | |
| EOP_SALVAGE_VALUE | |
| DEPRN_OVERRIDE_FLAG | |
| PERIOD_COUNTER | |
| FISCAL_YEAR | |
| SET_OF_BOOKS_ID | |
| ALLOCATION_BASIS | |
| TOTAL_ALLOCATION_BASIS | |
| ALLOCATED_DEPRN_AMOUNT |
| Assets - FA_SORP_LINK_REVAL_ITF | This table is populated from FA_REVAL_LINK_IMP_ASSET or FA_REVAL_LINK_IMP_CAT depending on whether the revaluation was run at asset level or category level |
|---|---|
| Column Name | Descritpion |
| ASSET_ID | Asset identification number |
| REVAL_RSV_ADJ_AMOUNT | The amount of revaluation reserve that was adjusted by the Impairment |
| REVAL_RSV_ADJ_DEPRN_EFFECT | The effect of depreciation on the REVAL_RSV_ADJ_AMOUNT |
| CALC_IMP_REVERSE_AMT | The amount of impairment loss attributed to I&E or CALC_IMP_AMOUNT reversed due to linking |
| CALC_IMP_REVERSE_DEPRN_EFFECT | The amount of CALC_IMP_DEPRN_EFFECT reversed due to linking |
| RSV_REVERSE_AMT | The amount of revaluation reserve or REVAL_RSV_ADJ_AMOUNT reversed due to linking |
| RSV_REVERSE_DEPRN_EFFECT | The amount of revaluation reserve depreciation effect or REVAL_RSV_ADJ_DEPRN_EFFECT reversed due to linking |
| REVAL_GAIN | The final revaluation gain after considering linking |
| IMPAIRMENT_LOSS_AMOUNT | Impairment loss amount |
| CATEGORY_ID | Unique identification number for each asset category |
| BOOK_TYPE_CODE | Book name |
| IMPAIRMENT_ID | Book name |
| SPLIT_NUMBER | Book name |
| IMP_LOSS_AMT | Total Impairment Loss Amount |
| REQUEST_ID | Concurrent Request id |
| IMPAIR_LOSS_IMPACT | The net impairment amount eligible for reversal. This is equal to total impairment loss amount minus change in depreciation due to impairment. |
| MASS_REVAL_ID | Unique mass revaluation identification number |
| IMPAIR_LOSS_ACCT | The account to which impairment loss must be booked |
| CREATED_BY | Standard Who column |
| CREATION_DATE | Standard Who column |
| RUN_MODE | Mode of concurrent request submission. This can have the value PREVIEW or RUN |
| IMP_DEPRN_EFFECT | The effect of depreciation on IMPAIRMENT_LOSS_AMOUNT |
| REVAL_RESERVE_IMPACT_FLAG | A value of Y indicates that the impairment had previously reversed out revaluation reserve |
| REASON | Reason description |
| IMPAIR_CLASS_TYPE | Impairment classification type |
| CALC_IMP_AMOUNT | The impairment amount attributed to the I&E account. This is calculated as total impairment loss amount minus amount of revaluation reserve adjusted by the impairment |
| CALC_IMP_DEPRN_EFFECT | The effect of depreciation on the CALC_IMP_AMOUNT |
| Assets - FA_REVAL_LINK_IMP_ASSET | Stores all the impairmets that are eligible for reversal during a given mass revaluation. The IMP_INCLUDE_FLAG determines whether the user has selected this impairment or not. This table has one record for each split, if the impairment is s |
|---|---|
| Column Name | Descritpion |
| BOOK_TYPE_CODE | Book name |
| IMPAIRMENT_ID | Unique identification number of an impairment |
| SPLIT_NUMBER | The split number if the impairment is Split |
| IMPAIRMENT_AMOUNT | Impairment loss amount |
| IMP_INCLUDE_FLAG | Y indicates that the impairment has been selected for linking. Any other value indicates the impairment is not selected for linking |
| ASSET_ID | Asset identification number |
| UNUSED_IMP_LOSS_AMOUNT | Impairment loss amount that has not been reversed by any prior linked revlauation. |
| CREATION_DATE | Standard Who column |
| CREATED_BY | Standard Who column |
| LAST_UPDATE_DATE | Standard Who column |
| LAST_UPDATED_BY | Standard Who column |
| LAST_UPDATE_LOGIN | Standard Who column |
| MASS_REVAL_ID | Unique mass revaluation identification number |
| Assets - FA_REVAL_LINK_IMP_CAT | Stores impairment classification type that can be selected for linking during a mass revaluation at the category level |
|---|---|
| Column Name | Descritpion |
| CATEGORY_ID | Unique identification number for each asset category |
| BOOK_TYPE_CODE | Book name |
| CPP_ENABLED_FLAG | A value of Y indicates that the impairment of type Change in Property Prices can be selected for linking |
| OTH_ENABLED_FLAG | A value of Y indicates that the impairment of type Others can be selected for linking |
| CREATION_DATE | Standard Who column |
| CREATED_BY | Standard Who column |
| LAST_UPDATE_DATE | Standard Who column |
| LAST_UPDATED_BY | Standard Who column |
| MASS_REVAL_ID | Unique mass revaluation identification number |
| LAST_UPDATE_LOGIN | Standard Who column |
No hay comentarios:
Publicar un comentario