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