1. Tables and Views for Financials
  2. FA_ADJUSTMENTS_T

FA_ADJUSTMENTS_T

FA_ADJUSTMENTS_T is an interface table used for mass financial transactions.

Details

  • Schema: FUSION

  • Object owner: FA

  • Object type: TABLE

  • Tablespace: INTERFACE

Primary Key

Name Columns

FA_ADJUSTMENTS_T_PK

ADJUSTMENT_INTERFACE_ID

Columns

Name Datatype Length Precision Not-null Comments Flexfield-mapping Status
ADJUSTMENT_INTERFACE_ID NUMBER 18 Yes Oracle internal use only. Adjustment interface identifier.
PARENT_INTERFACE_ID NUMBER 18 Oracle internal use only. Parent interface identifier. Active
POSTING_STATUS VARCHAR2 30 Posting status. Valid values: NEW, POST, ON HOLD. NEW means the asset is new. POST means the asset is ready to be posted. ON HOLD means the asset needs further review. Active
ASSET_ID NUMBER 18 Asset identifier. Use an Assets work area to identify valid values. Active
BOOK_TYPE_CODE VARCHAR2 30 Asset book. Use the Manage Asset Books task to identify valid values. Active
TRANSACTION_TYPE_CODE VARCHAR2 30 Transaction type. Valid values: ADJUSTMENT, SUSPEND RESUME, RECLASS, UNPLANNED, DELETE, GROUP CHANGE, CAPITALIZATION, CIP REVERSE, RESERVE TRANSFER, INVOICE ADDITION, INVOICE ADJUSTMENT, INVOICE DELETE, INVOICE REINSTATE, INVOICE DEP, INVOICE NO DEP, INVOICE TRANSFER. Active
COST NUMBER Asset cost. Enter without thousands separator. Use either comma or period as decimal separator. Active
DATE_PLACED_IN_SERVICE DATE Date asset was placed in service. Date format: YYYY/MM/DD. Active
DEPRECIATE_FLAG VARCHAR2 3 Indicates whether the asset must be depreciated. Valid values: Y, N. Active
METHOD_ID NUMBER 18 Depreciation method identifier. Use the Manage Depreciation Methods task to identify valid values. Active
FLAT_RATE_ID NUMBER 18 Flat rate identifier. Use the Manage Depreciation Methods task to identify valid values. Active
CEILING_TYPE_ID NUMBER 18 Ceiling type identifier. Use the Manage Ceilings task to identify valid values. Active
CONVENTION_TYPE_ID NUMBER 18 Convention type identifier. Use the Manage Prorate Conventions task to identify valid values. Active
BONUS_RULE_ID NUMBER 18 Bonus rule identifier. Use the Manage Bonus Rules task to identify valid values. Active
YTD_DEPRN NUMBER Year-to-date depreciation. Enter without thousands. Use either comma or period as decimal separator. Active
DEPRN_RESERVE NUMBER Accumulated depreciation for the asset. Enter without thousands. Use either comma or period as decimal separator. Active
BONUS_YTD_DEPRN NUMBER Year-to-date bonus depreciation. Enter without thousands. Use either comma or period as decimal separator. Active
BONUS_DEPRN_RESERVE NUMBER Bonus depreciation reserve. Enter without thousands. Use either comma or period as decimal separator. Active
AMORTIZE_FLAG VARCHAR2 3 Amortize the asset. Valid values: Y, N. Enter a value for AMORTIZATION_START_DATE if Y is used. Active
AMORTIZATION_START_DATE DATE Amortization start date. Date format: YYYY/MM/DD. Only used if AMORTIZE_FLAG is set to Y. Cannot be earlier than the date the asset is placed in service. Active
DEPRN_LIMIT_TYPE VARCHAR2 30 Depreciation limit type. Valid values: PCT, AMT, SUM, NONE. PCT means percent. AMT means amount. SUM means sum of member assets. Active
ALLOWED_DEPRN_LIMIT NUMBER Depreciation limit percentage for the asset. Must be between 0 and 100. Active
ALLOWED_DEPRN_LIMIT_AMOUNT NUMBER Depreciation limit. Enter without thousands. Use either comma or period as decimal separator. Active
SALVAGE_TYPE VARCHAR2 30 Salvage type. Valid values: PCT, AMT, SUM. PCT means percent. AMT means amount. SUM means sum of member assets. Active
SALVAGE_VALUE NUMBER Salvage value. Enter without thousands. Use either comma or period as decimal separator. Cannot exceed asset cost. Active
PERCENT_SALVAGE_VALUE NUMBER Salvage value as a percentage of asset cost. Enter without thousands. Use either comma or period as decimal separator. Must be between 0 and 100. Active
SHORT_FISCAL_YEAR_FLAG VARCHAR2 3 Indicates whether the asset was added during a short fiscal year. Valid values: Y, N. Active
CONVERSION_DATE DATE Date asset added during short fiscal year was entered into service. Date format: YYYY/MM/DD. Must be within current calendar period of parent company. Active
ORIGINAL_DEPRN_START_DATE DATE Date short tax year asset begin depreciating in the acquired company''s books. Date format: YYYY/MM/DD. Active
TRANSACTION_NAME VARCHAR2 240 Transaction name for the asset. Free text field. No validations. Active
CATEGORY_ID NUMBER 18 Category identifier. Use the Manage Asset Categories task to identify valid values. Active
COPY_CATEGORY_DFF_FLAG VARCHAR2 1 Indicates whether the descriptive flexfield information must be copied to the asset category. Valid values: Y, N. Active
INHERIT_DEF_RULES_FLAG VARCHAR2 1 Indicates whether depreciation rules of the new category must be inherited. Valid values: Y, N. Active
UNIT_OF_MEASURE VARCHAR2 25 Unit of measure used for depreciation using units of production method. Use the Manage Units of Measure task to identify valid values. Active
CURRENT_YTD_DEPRN NUMBER Current value of the year-to-date depreciation expense. Enter without thousands. Use either comma or period as decimal separator. Active
CURRENT_DEPRN_RESERVE NUMBER Current depreciation reserve. Enter without thousands. Use either comma or period as decimal separator. Active
CURRENT_BONUS_YTD_DEPRN NUMBER Current value of the bonus year-to-date depreciation expense. Enter without thousands. Use either comma or period as decimal separator. Active
CURRENT_BONUS_DEPRN_RESERVE NUMBER Current value of the total bonus depreciation for the asset. Enter without thousands. Use either comma or period as decimal separator. Active
YTD_IMPAIRMENT NUMBER Year-to-date impairment amount. Enter without thousands. Use either comma or period as decimal separator. Active
CURRENT_YTD_IMPAIRMENT NUMBER Current value of the year-to-date impairment amount. Enter without thousands. Use either comma or period as decimal separator. Active
CURRENT_IMPAIRMENT_RESERVE NUMBER Current value of the total impairment loss recognized for the asset. Enter without thousands. Use either comma or period as decimal separator. Active
CURRENT_BACKLOG_DEPRN_RESERVE NUMBER Backlog depreciation reserve for an asset before revaluation.
CURRENT_REVALUED_COST NUMBER Revalued cost of an asset before revaluation.
ATTRIBUTE1 VARCHAR2 150 Segment value for Asset Category descriptive flexfield. Asset Category (FA_ADDITIONS) Active
ATTRIBUTE2 VARCHAR2 150 Segment value for Asset Category descriptive flexfield. Asset Category (FA_ADDITIONS) Active
ATTRIBUTE3 VARCHAR2 150 Segment value for Asset Category descriptive flexfield. Asset Category (FA_ADDITIONS) Active
ATTRIBUTE4 VARCHAR2 150 Segment value for Asset Category descriptive flexfield. Asset Category (FA_ADDITIONS) Active
ATTRIBUTE5 VARCHAR2 150 Segment value for Asset Category descriptive flexfield. Asset Category (FA_ADDITIONS) Active
ATTRIBUTE6 VARCHAR2 150 Segment value for Asset Category descriptive flexfield. Asset Category (FA_ADDITIONS) Active
ATTRIBUTE7 VARCHAR2 150 Segment value for Asset Category descriptive flexfield. Asset Category (FA_ADDITIONS) Active
ATTRIBUTE8 VARCHAR2 150 Segment value for Asset Category descriptive flexfield. Asset Category (FA_ADDITIONS) Active
ATTRIBUTE9 VARCHAR2 150 Segment value for Asset Category descriptive flexfield. Asset Category (FA_ADDITIONS) Active
ATTRIBUTE10 VARCHAR2 150 Segment value for Asset Category descriptive flexfield. Asset Category (FA_ADDITIONS) Active
ATTRIBUTE11 VARCHAR2 150 Segment value for Asset Category descriptive flexfield. Asset Category (FA_ADDITIONS) Active
ATTRIBUTE12 VARCHAR2 150 Segment value for Asset Category descriptive flexfield. Asset Category (FA_ADDITIONS) Active
ATTRIBUTE13 VARCHAR2 150 Segment value for Asset Category descriptive flexfield. Asset Category (FA_ADDITIONS) Active
ATTRIBUTE14 VARCHAR2 150 Segment value for Asset Category descriptive flexfield. Asset Category (FA_ADDITIONS) Active
ATTRIBUTE15 VARCHAR2 150 Segment value for Asset Category descriptive flexfield. Asset Category (FA_ADDITIONS) Active
ATTRIBUTE16 VARCHAR2 150 Segment value for Asset Category descriptive flexfield. Asset Category (FA_ADDITIONS) Active
ATTRIBUTE17 VARCHAR2 150 Segment value for Asset Category descriptive flexfield. Asset Category (FA_ADDITIONS) Active
ATTRIBUTE18 VARCHAR2 150 Segment value for Asset Category descriptive flexfield. Asset Category (FA_ADDITIONS) Active
ATTRIBUTE19 VARCHAR2 150 Segment value for Asset Category descriptive flexfield. Asset Category (FA_ADDITIONS) Active
ATTRIBUTE20 VARCHAR2 150 Segment value for Asset Category descriptive flexfield. Asset Category (FA_ADDITIONS) Active
ATTRIBUTE21 VARCHAR2 150 Segment value for Asset Category descriptive flexfield. Asset Category (FA_ADDITIONS) Active
ATTRIBUTE22 VARCHAR2 150 Segment value for Asset Category descriptive flexfield. Asset Category (FA_ADDITIONS) Active
ATTRIBUTE23 VARCHAR2 150 Segment value for Asset Category descriptive flexfield. Asset Category (FA_ADDITIONS) Active
ATTRIBUTE24 VARCHAR2 150 Segment value for Asset Category descriptive flexfield. Asset Category (FA_ADDITIONS) Active
ATTRIBUTE25 VARCHAR2 150 Segment value for Asset Category descriptive flexfield. Asset Category (FA_ADDITIONS) Active
ATTRIBUTE26 VARCHAR2 150 Segment value for Asset Category descriptive flexfield. Asset Category (FA_ADDITIONS) Active
ATTRIBUTE27 VARCHAR2 150 Segment value for Asset Category descriptive flexfield. Asset Category (FA_ADDITIONS) Active
ATTRIBUTE28 VARCHAR2 150 Segment value for Asset Category descriptive flexfield. Asset Category (FA_ADDITIONS) Active
ATTRIBUTE29 VARCHAR2 150 Segment value for Asset Category descriptive flexfield. Asset Category (FA_ADDITIONS) Active
ATTRIBUTE30 VARCHAR2 150 Segment value for Asset Category descriptive flexfield. Asset Category (FA_ADDITIONS) Active
CONTEXT VARCHAR2 250 Context code for Asset Category descriptive flexfield. Use the Fixed Assets Descriptive Flexfields task to identify valid values. Use columns beginning with ATTRIBUTE for segment values. Asset Category (FA_ADDITIONS) Active
TH_ATTRIBUTE1 VARCHAR2 150 Segment value for Transactions descriptive flexfield. Transactions (FA_TRANSACTION_HEADERS) Active
TH_ATTRIBUTE2 VARCHAR2 150 Segment value for Transactions descriptive flexfield. Transactions (FA_TRANSACTION_HEADERS) Active
TH_ATTRIBUTE3 VARCHAR2 150 Segment value for Transactions descriptive flexfield. Transactions (FA_TRANSACTION_HEADERS) Active
TH_ATTRIBUTE4 VARCHAR2 150 Segment value for Transactions descriptive flexfield. Transactions (FA_TRANSACTION_HEADERS) Active
TH_ATTRIBUTE5 VARCHAR2 150 Segment value for Transactions descriptive flexfield. Transactions (FA_TRANSACTION_HEADERS) Active
TH_ATTRIBUTE6 VARCHAR2 150 Segment value for Transactions descriptive flexfield. Transactions (FA_TRANSACTION_HEADERS) Active
TH_ATTRIBUTE7 VARCHAR2 150 Segment value for Transactions descriptive flexfield. Transactions (FA_TRANSACTION_HEADERS) Active
TH_ATTRIBUTE8 VARCHAR2 150 Segment value for Transactions descriptive flexfield. Transactions (FA_TRANSACTION_HEADERS) Active
TH_ATTRIBUTE9 VARCHAR2 150 Segment value for Transactions descriptive flexfield. Transactions (FA_TRANSACTION_HEADERS) Active
TH_ATTRIBUTE10 VARCHAR2 150 Segment value for Transactions descriptive flexfield. Transactions (FA_TRANSACTION_HEADERS) Active
TH_ATTRIBUTE11 VARCHAR2 150 Segment value for Transactions descriptive flexfield. Transactions (FA_TRANSACTION_HEADERS) Active
TH_ATTRIBUTE12 VARCHAR2 150 Segment value for Transactions descriptive flexfield. Transactions (FA_TRANSACTION_HEADERS) Active
TH_ATTRIBUTE13 VARCHAR2 150 Segment value for Transactions descriptive flexfield. Transactions (FA_TRANSACTION_HEADERS) Active
TH_ATTRIBUTE14 VARCHAR2 150 Segment value for Transactions descriptive flexfield. Transactions (FA_TRANSACTION_HEADERS) Active
TH_ATTRIBUTE15 VARCHAR2 150 Segment value for Transactions descriptive flexfield. Transactions (FA_TRANSACTION_HEADERS) Active
TH_ATTRIBUTE_CATEGORY_CODE VARCHAR2 30 Context code for Transactions descriptive flexfield. Use the Fixed Assets Descriptive Flexfields task to identify valid values. Use columns beginning with TH for segment values. Transactions (FA_TRANSACTION_HEADERS) Active
TH_ATTRIBUTE_NUMBER1 NUMBER Number value for Transactions descriptive flexfield.
TH_ATTRIBUTE_NUMBER2 NUMBER Number value for Transactions descriptive flexfield.
TH_ATTRIBUTE_NUMBER3 NUMBER Number value for Transactions descriptive flexfield.
TH_ATTRIBUTE_NUMBER4 NUMBER Number value for Transactions descriptive flexfield.
TH_ATTRIBUTE_NUMBER5 NUMBER Number value for Transactions descriptive flexfield.
ATTRIBUTE_NUMBER1 NUMBER Number value for Asset Category descriptive flexfield.
ATTRIBUTE_NUMBER2 NUMBER Number value for Asset Category descriptive flexfield.
ATTRIBUTE_NUMBER3 NUMBER Number value for Asset Category descriptive flexfield.
ATTRIBUTE_NUMBER4 NUMBER Number value for Asset Category descriptive flexfield.
ATTRIBUTE_NUMBER5 NUMBER Number value for Asset Category descriptive flexfield.
TH_ATTRIBUTE_DATE1 DATE Date value for Transactions descriptive flexfield.
TH_ATTRIBUTE_DATE2 DATE Date value for Transactions descriptive flexfield.
TH_ATTRIBUTE_DATE3 DATE Date value for Transactions descriptive flexfield.
TH_ATTRIBUTE_DATE4 DATE Date value for Transactions descriptive flexfield.
TH_ATTRIBUTE_DATE5 DATE Date value for Transactions descriptive flexfield.
ATTRIBUTE_DATE1 DATE Date value for Asset Category descriptive flexfield.
ATTRIBUTE_DATE2 DATE Date value for Asset Category descriptive flexfield.
ATTRIBUTE_DATE3 DATE Date value for Asset Category descriptive flexfield.
ATTRIBUTE_DATE4 DATE Date value for Asset Category descriptive flexfield.
ATTRIBUTE_DATE5 DATE Date value for Asset Category descriptive flexfield.
TRANSACTION_HEADER_ID_IN NUMBER 18 Oracle internal use only. Identifier of the transaction that created the row. Active
CODE_COMBINATION_ID NUMBER 18 Unplanned depreciation expense account identifier. Use the Manage Account Combinations task to identify valid values. Active
UNPLANNED_TYPE VARCHAR2 30 Unplanned depreciation type. Use the Manage Fixed Assets Lookups, lookup type FA_DEPRN_REASON to identify valid values. Active
UNPLANNED_DEPRN_AMOUNT NUMBER Unplanned depreciation amount. Enter without thousands. Use either comma or period as decimal separator. Active
WORKER_ID NUMBER 18 Oracle internal use only. Internal identifier for parallel processing. Active
REQUEST_ID NUMBER 18 Oracle Fusion Enterprise Resource Planning: request ID of the process that created or last updated the row. Active
GROUP_ASSET_ID NUMBER 18 Group asset identifier. Use asset inquiry in any work area to identify valid values. Active
REDUCTION_RATE NUMBER Depreciation reduction percentage. Must be between 0 and 100. Active
REDUCE_ADDITION_FLAG VARCHAR2 1 Option indicating whether depreciation reduction to be considered for addition transaction. Valid values: Y, N. Active
REDUCE_ADJUSTMENT_FLAG VARCHAR2 1 Option indicating whether depreciation reduction to be considered for adjustment transaction. Valid values: Y, N. Active
REDUCE_RETIREMENT_FLAG VARCHAR2 1 Option indicating whether depreciation reduction is to be considered for retirement transaction. Valid values: Y, N. Active
RECOGNIZE_GAIN_LOSS VARCHAR2 30 Recognize gain or loss from member asset retirement. Valid values: Y, N. Active
RECAPTURE_RESERVE_FLAG VARCHAR2 1 Reserve for group asset can exceed recoverable cost. Valid values: Y, N. Active
LIMIT_PROCEEDS_FLAG VARCHAR2 1 Option indicating whether the member asset proceed of sale to be limited to its recoverable cost. Valid values: Y, N. Active
TERMINAL_GAIN_LOSS VARCHAR2 30 Indicates how terminal gain or loss is recognized for member asset retirement. Valid values: YES, NO, END_OF_YEAR. Active
TRACKING_METHOD VARCHAR2 30 Calculation method for group asset depreciation. Valid values: ALLOCATE, CALCULATE. ALLOCATE means allocate group depreciation amount to member assets. CALCULATE means calculate depreciation for each member asset. Active
EXCESS_ALLOCATION_OPTION VARCHAR2 30 Allocate excess depreciation for group asset to member assets or reduce from the group asset depreciation. Valid values: DISTRIBUTE, REDUCE. Active
DEPRECIATION_OPTION VARCHAR2 30 Indicates whether the member asset''s depreciation expense is calculated using its group asset depreciation rules or the member asset depreciation rules. Valid values: GROUP, MEMBER. Active
MEMBER_ROLLUP_FLAG VARCHAR2 1 Roll up group depreciation to the group asset. Valid values: Y, N. Active
ALLOCATE_TO_FULLY_RSV_FLAG VARCHAR2 1 Indicates whether to allocate group asset depreciation amount to a reserved member asset. Valid values: Y, N. Active
OVER_DEPRECIATE_OPTION VARCHAR2 30 Allow over depreciation for group assets. Valid values: Y, N. Active
DISABLED_FLAG VARCHAR2 1 Group asset is enabled. Valid values: Y, N. Active
GROUP_CHANGE_TYPE VARCHAR2 30 Group asset reclass rule for depreciation reserve calculation for transferring assets between group assets. Valid values: MANUAL, CALC. Active
GROUP_CHANGE_RESERVE_AMOUNT NUMBER Depreciation reserve amount transferred from one group asset to another group asset.Enter without thousands. Use either comma or period as decimal separator. Active
SOURCE_EOFY_RESERVE NUMBER Source asset depreciation reserve amount of the group asset, from which depreciation reserve is transferred. Enter without thousands. Use either comma or period as decimal separator. Active
DESTINATION_EOFY_RESERVE NUMBER Destination asset depreciation reserve amount of the group asset to which depreciation reserve is transferred. Enter without thousands. Use either comma or period as decimal separator. Active
LOAD_REQUEST_ID NUMBER 18 Oracle Fusion Enterprise Resource Planning: process ID of the process that created or last updated the row.
INTERFACE_LINE_NUMBER NUMBER 18 Identifier to process the distributions of the asset in a single transaction.
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row. Active
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row. Active
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row. Active
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row. Active
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row. Active
OBJECT_VERSION_NUMBER NUMBER 9 Yes Used to implement optimistic locking. Incremented every time the row is updated. Compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. Active
BATCH_NAME VARCHAR2 30 Unique name of the batch. Free text field.
CASH_GENERATING_UNIT_ID NUMBER 18 Cash generating unit identifier. Use the Manage Cash Generating Unit task to identify valid values. Active
PREPARER_ID NUMBER 18 Preparer identifier. Use the Manage Resources task to identify valid values. Active
EXTENDED_DEPRECIATION_PERIOD NUMBER 18 Oracle internal use only. Number of periods the asset depreciation is extended. Active
EXTENDED_DEPRN_FLAG VARCHAR2 1 Oracle internal use only. Indicates whether asset depreciation is extended. Valid values: Y, N. Active
EXTENDED_DEPRN_LIMIT NUMBER 18 Oracle internal use only. Extended depreciation limit of the asset. Active
EXTENDED_DEPRN_PERIOD_NAME VARCHAR2 15 Oracle internal use only. Period in which asset depreciation is extended. Active
FULLY_RSVD_REVALS_COUNTER NUMBER 18 Oracle internal use only. Number of times the asset has been revalued as fully reserved. Active
ITC_AMOUNT_ID NUMBER 18 Oracle internal use only. Investment tax credit identifier. Active
ORIGINAL_COST NUMBER Original asset cost. Enter without thousands. Use either comma or period as decimal separator. Active
PERIOD_COUNTER_FULLY_RESERVED NUMBER 18 Oracle internal use only. Identifier of the depreciation period in which the asset was fully reserved. Active
PERIOD_NAME VARCHAR2 15 Oracle internal use only. Asset book depreciation period name. Active
PRODUCTION_CAPACITY NUMBER Production capacity for a units of production asset. Must be a whole number, with no thousand separator or decimal separator. Active
REVAL_AMORTIZATION_BASIS NUMBER Oracle internal use only. Revaluation amortization basis. Active
REVAL_CEILING NUMBER Upper limit for revaluing asset cost. Enter without thousands. Use either comma or period as decimal separator. Active
REVAL_RESERVE NUMBER Revaluation reserve. Enter without thousands. Use either comma or period as decimal separator. Active
UNREVALUED_COST NUMBER Unrevalued cost. Enter without thousands. Use either comma or period as decimal separator. Active
YTD_REVAL_DEPRN_EXPENSE NUMBER Year-to-date revaluation depreciation expense. Enter without thousands. Use either comma or period as decimal separator. Active
ERROR_MSG VARCHAR2 2000 Oracle internal use only. Error message detailing failure of the posting program.
GLOBAL_ATTRIBUTE_CATEGORY VARCHAR2 30 Oracle internal use only.Global Descriptive Flexfield: structure definition of the global descriptive flexfield.
GLOBAL_ATTRIBUTE1 VARCHAR2 150 Oracle internal use only. Global Descriptive Flexfield: structure definition of the global descriptive flexfield.
GLOBAL_ATTRIBUTE2 VARCHAR2 150 Oracle internal use only. Global Descriptive Flexfield: structure definition of the global descriptive flexfield.
GLOBAL_ATTRIBUTE3 VARCHAR2 150 Oracle internal use only. Global Descriptive Flexfield: structure definition of the global descriptive flexfield.
GLOBAL_ATTRIBUTE4 VARCHAR2 150 Oracle internal use only. Global Descriptive Flexfield: structure definition of the global descriptive flexfield.
GLOBAL_ATTRIBUTE5 VARCHAR2 150 Oracle internal use only. Global Descriptive Flexfield: structure definition of the global descriptive flexfield.
GLOBAL_ATTRIBUTE6 VARCHAR2 150 Oracle internal use only. Global Descriptive Flexfield: structure definition of the global descriptive flexfield.
GLOBAL_ATTRIBUTE7 VARCHAR2 150 Oracle internal use only. Global Descriptive Flexfield: structure definition of the global descriptive flexfield.
GLOBAL_ATTRIBUTE8 VARCHAR2 150 Oracle internal use only. Global Descriptive Flexfield: structure definition of the global descriptive flexfield.
GLOBAL_ATTRIBUTE9 VARCHAR2 150 Oracle internal use only. Global Descriptive Flexfield: structure definition of the global descriptive flexfield.
GLOBAL_ATTRIBUTE10 VARCHAR2 150 Oracle internal use only. Global Descriptive Flexfield: structure definition of the global descriptive flexfield.
GLOBAL_ATTRIBUTE11 VARCHAR2 150 Oracle internal use only. Global Descriptive Flexfield: structure definition of the global descriptive flexfield.
GLOBAL_ATTRIBUTE12 VARCHAR2 150 Oracle internal use only. Global Descriptive Flexfield: structure definition of the global descriptive flexfield.
GLOBAL_ATTRIBUTE13 VARCHAR2 150 Oracle internal use only. Global Descriptive Flexfield: structure definition of the global descriptive flexfield.
GLOBAL_ATTRIBUTE14 VARCHAR2 150 Oracle internal use only. Global Descriptive Flexfield: structure definition of the global descriptive flexfield.
GLOBAL_ATTRIBUTE15 VARCHAR2 150 Oracle internal use only. Global Descriptive Flexfield: structure definition of the global descriptive flexfield.
GLOBAL_ATTRIBUTE16 VARCHAR2 150 Oracle internal use only. Global Descriptive Flexfield: structure definition of the global descriptive flexfield.
GLOBAL_ATTRIBUTE17 VARCHAR2 150 Oracle internal use only. Global Descriptive Flexfield: structure definition of the global descriptive flexfield.
GLOBAL_ATTRIBUTE18 VARCHAR2 150 Oracle internal use only. Global Descriptive Flexfield: structure definition of the global descriptive flexfield.
GLOBAL_ATTRIBUTE19 VARCHAR2 150 Oracle internal use only. Global Descriptive Flexfield: structure definition of the global descriptive flexfield.
GLOBAL_ATTRIBUTE20 VARCHAR2 150 Oracle internal use only. Global Descriptive Flexfield: structure definition of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_NUMBER1 NUMBER Oracle internal use only. Global Descriptive Flexfield: structure definition of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_NUMBER2 NUMBER Oracle internal use only. Global Descriptive Flexfield: structure definition of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_NUMBER3 NUMBER Oracle internal use only. Global Descriptive Flexfield: structure definition of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_NUMBER4 NUMBER Oracle internal use only. Global Descriptive Flexfield: structure definition of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_NUMBER5 NUMBER Oracle internal use only. Global Descriptive Flexfield: structure definition of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_DATE1 DATE Oracle internal use only. Global Descriptive Flexfield: structure definition of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_DATE2 DATE Oracle internal use only. Global Descriptive Flexfield: structure definition of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_DATE3 DATE Oracle internal use only. Global Descriptive Flexfield: structure definition of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_DATE4 DATE Oracle internal use only. Global Descriptive Flexfield: structure definition of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_DATE5 DATE Oracle internal use only. Global Descriptive Flexfield: structure definition of the global descriptive flexfield.
IMPAIRMENT_RESERVE NUMBER Total impairment reserve for the asset. Enter without thousands. Use either comma or period as decimal separator.
ASSET_NUMBER VARCHAR2 30 User-defined asset identification number.
GROUP_ASSET_NUMBER VARCHAR2 30 Asset number of the group asset.
BONUS_RULE VARCHAR2 30 Name of the bonus depreciation rule.
CASH_GENERATING_UNIT VARCHAR2 30 Name of the cash generating unit.
CEILING_NAME VARCHAR2 30 Name of the cost or depreciation ceiling.
PRORATE_CONVENTION_CODE VARCHAR2 10 Unique name of the prorate convention.
METHOD_CODE VARCHAR2 12 Name of the depreciation method.
LIFE_IN_MONTHS NUMBER 4 Life in months for the depreciation method.
BASIC_RATE NUMBER Basic depreciation rate for a flat rate depreciation method.
ADJUSTED_RATE NUMBER Basic flat depreciation rate plus the adjusting depreciation rate multiplied by the basic depreciation rate.
CATEGORY_SEGMENT1 VARCHAR2 30 Key Flexfield: segment of the key flexfield.
CATEGORY_SEGMENT2 VARCHAR2 30 Key Flexfield: segment of the key flexfield.
CATEGORY_SEGMENT3 VARCHAR2 30 Key Flexfield: segment of the key flexfield.
CATEGORY_SEGMENT4 VARCHAR2 30 Key Flexfield: segment of the key flexfield.
CATEGORY_SEGMENT5 VARCHAR2 30 Key Flexfield: segment of the key flexfield.
CATEGORY_SEGMENT6 VARCHAR2 30 Key Flexfield: segment of the key flexfield.
CATEGORY_SEGMENT7 VARCHAR2 30 Key Flexfield: segment of the key flexfield.
DEPRN_EXPENSE_SEGMENT1 VARCHAR2 25 Key Flexfield: segment of the key flexfield.
DEPRN_EXPENSE_SEGMENT2 VARCHAR2 25 Key Flexfield: segment of the key flexfield.
DEPRN_EXPENSE_SEGMENT3 VARCHAR2 25 Key Flexfield: segment of the key flexfield.
DEPRN_EXPENSE_SEGMENT4 VARCHAR2 25 Key Flexfield: segment of the key flexfield.
DEPRN_EXPENSE_SEGMENT5 VARCHAR2 25 Key Flexfield: segment of the key flexfield.
DEPRN_EXPENSE_SEGMENT6 VARCHAR2 25 Key Flexfield: segment of the key flexfield.
DEPRN_EXPENSE_SEGMENT7 VARCHAR2 25 Key Flexfield: segment of the key flexfield.
DEPRN_EXPENSE_SEGMENT8 VARCHAR2 25 Key Flexfield: segment of the key flexfield.
DEPRN_EXPENSE_SEGMENT9 VARCHAR2 25 Key Flexfield: segment of the key flexfield.
DEPRN_EXPENSE_SEGMENT10 VARCHAR2 25 Key Flexfield: segment of the key flexfield.
DEPRN_EXPENSE_SEGMENT11 VARCHAR2 25 Key Flexfield: segment of the key flexfield.
DEPRN_EXPENSE_SEGMENT12 VARCHAR2 25 Key Flexfield: segment of the key flexfield.
DEPRN_EXPENSE_SEGMENT13 VARCHAR2 25 Key Flexfield: segment of the key flexfield.
DEPRN_EXPENSE_SEGMENT14 VARCHAR2 25 Key Flexfield: segment of the key flexfield.
DEPRN_EXPENSE_SEGMENT15 VARCHAR2 25 Key Flexfield: segment of the key flexfield.
DEPRN_EXPENSE_SEGMENT16 VARCHAR2 25 Key Flexfield: segment of the key flexfield.
DEPRN_EXPENSE_SEGMENT17 VARCHAR2 25 Key Flexfield: segment of the key flexfield.
DEPRN_EXPENSE_SEGMENT18 VARCHAR2 25 Key Flexfield: segment of the key flexfield.
DEPRN_EXPENSE_SEGMENT19 VARCHAR2 25 Key Flexfield: segment of the key flexfield.
DEPRN_EXPENSE_SEGMENT20 VARCHAR2 25 Key Flexfield: segment of the key flexfield.
DEPRN_EXPENSE_SEGMENT21 VARCHAR2 25 Key Flexfield: segment of the key flexfield.
DEPRN_EXPENSE_SEGMENT22 VARCHAR2 25 Key Flexfield: segment of the key flexfield.
DEPRN_EXPENSE_SEGMENT23 VARCHAR2 25 Key Flexfield: segment of the key flexfield.
DEPRN_EXPENSE_SEGMENT24 VARCHAR2 25 Key Flexfield: segment of the key flexfield.
DEPRN_EXPENSE_SEGMENT25 VARCHAR2 25 Key Flexfield: segment of the key flexfield.
DEPRN_EXPENSE_SEGMENT26 VARCHAR2 25 Key Flexfield: segment of the key flexfield.
DEPRN_EXPENSE_SEGMENT27 VARCHAR2 25 Key Flexfield: segment of the key flexfield.
DEPRN_EXPENSE_SEGMENT28 VARCHAR2 25 Key Flexfield: segment of the key flexfield.
DEPRN_EXPENSE_SEGMENT29 VARCHAR2 25 Key Flexfield: segment of the key flexfield.
DEPRN_EXPENSE_SEGMENT30 VARCHAR2 25 Key Flexfield: segment of the key flexfield.
PREPARER_EMAIL_ADDRESS VARCHAR2 240 Optional email address of the person assigned to prepare the line.
ADJUSTED_COST NUMBER Depreciable basis of the asset. Enter without the thousands separator. Use a period or comma as the decimal separator.
REVAL_METHOD VARCHAR2 30 Stores the method used for revaluation.
REVAL_FULLY_RSVD_FLAG VARCHAR2 1 Allows fully reserved asset revaluation.
LIFE_EXTENSION_FACTOR NUMBER Value of the life extension factor used when revaluing fully reserved assets using life-based methods.
LIFE_EXTENSION_CEILING NUMBER Value of the life extension ceiling used when revaluing fully reserved assets using life-based methods.
REVAL_VALUE_TYPE VARCHAR2 30 Stores the value type used for revaluation.
REVAL_PERCENTAGE NUMBER Stores the revaluation percentage value.
REVAL_AMOUNT NUMBER Stores the revaluation amount value.
FAIR_MARKET_VALUE NUMBER Fair value of the asset after revaluation.
MAX_FULLY_RSVD_REVALS NUMBER 18 Default value of the maximum number of revaluations allowed on a fully reserved asset.
LINKED_FLAG VARCHAR2 1 Allows revaluation to be linked to prior impairment transactions.
CURRENT_REVAL_RESERVE NUMBER Revaluation reserve of an asset prior to revaluation.
CURRENT_REVAL_LOSS_BALANCE NUMBER Revaluation loss of an asset prior to revaluation.
REVAL_LOSS_BALANCE NUMBER Revaluation loss of an asset after revaluation.
CURRENT_IMPAIR_LOSS_BALANCE NUMBER Impairment loss of an asset prior to revaluation.
PERIOD_END_REVAL_FLAG VARCHAR2 1 Include current period depreciation in revaluation calculations.
REVAL_GAIN_LOSS NUMBER Stores the revaluation gain or loss amounts.
IMPAIR_LOSS_BALANCE NUMBER Impairment loss of an asset after revaluation.
LAST_PRICE_INDEX_VALUE NUMBER Stores the value of the price index used during index-based revaluation for future revaluation.
PRICE_INDEX_ID NUMBER 18 Stores the identifier of the price index used during index-based revaluation.
PREPARER_NAME VARCHAR2 240 Optional name of the person assigned to prepare the line.
PREPARER_NUMBER VARCHAR2 30 Optional number of the person assigned to prepare the line.
TH_GLOBAL_ATTRIBUTE_CATEGORY VARCHAR2 30 Global Descriptive Flexfield: structure definition of the global descriptive flexfield.
TH_GLOBAL_ATTRIBUTE1 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
TH_GLOBAL_ATTRIBUTE2 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
TH_GLOBAL_ATTRIBUTE3 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
TH_GLOBAL_ATTRIBUTE4 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
TH_GLOBAL_ATTRIBUTE5 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
TH_GLOBAL_ATTRIBUTE6 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
TH_GLOBAL_ATTRIBUTE7 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
TH_GLOBAL_ATTRIBUTE8 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
TH_GLOBAL_ATTRIBUTE9 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
TH_GLOBAL_ATTRIBUTE10 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
TH_GLOBAL_ATTRIBUTE11 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
TH_GLOBAL_ATTRIBUTE12 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
TH_GLOBAL_ATTRIBUTE13 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
TH_GLOBAL_ATTRIBUTE14 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
TH_GLOBAL_ATTRIBUTE15 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
TH_GLOBAL_ATTRIBUTE16 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
TH_GLOBAL_ATTRIBUTE17 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
TH_GLOBAL_ATTRIBUTE18 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
TH_GLOBAL_ATTRIBUTE19 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
TH_GLOBAL_ATTRIBUTE20 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
TH_GLOBAL_ATTRIBUTE_NUMBER1 NUMBER Global Descriptive Flexfield: segment of the global descriptive flexfield.
TH_GLOBAL_ATTRIBUTE_NUMBER2 NUMBER Global Descriptive Flexfield: segment of the global descriptive flexfield.
TH_GLOBAL_ATTRIBUTE_NUMBER3 NUMBER Global Descriptive Flexfield: segment of the global descriptive flexfield.
TH_GLOBAL_ATTRIBUTE_NUMBER4 NUMBER Global Descriptive Flexfield: segment of the global descriptive flexfield.
TH_GLOBAL_ATTRIBUTE_NUMBER5 NUMBER Global Descriptive Flexfield: segment of the global descriptive flexfield.
TH_GLOBAL_ATTRIBUTE_DATE1 DATE Global Descriptive Flexfield: segment of the global descriptive flexfield.
TH_GLOBAL_ATTRIBUTE_DATE2 DATE Global Descriptive Flexfield: segment of the global descriptive flexfield.
TH_GLOBAL_ATTRIBUTE_DATE3 DATE Global Descriptive Flexfield: segment of the global descriptive flexfield.
TH_GLOBAL_ATTRIBUTE_DATE4 DATE Global Descriptive Flexfield: segment of the global descriptive flexfield.
TH_GLOBAL_ATTRIBUTE_DATE5 DATE Global Descriptive Flexfield: segment of the global descriptive flexfield.
NET_BOOK_VALUE NUMBER Net book value of the asset in the tax book.
CORP_BOOK_TYPE_CODE VARCHAR2 30 Name of the corporate book in which the asset is recorded.
CORP_METHOD_CODE VARCHAR2 12 Name of the depreciation method for the asset in the tax book.
CORP_COST NUMBER Cost of the asset in the corporate book.
CORP_YTD_DEPRN NUMBER Year-to-date depreciation of the asset in the corporate book.
CORP_DEPRN_RESERVE NUMBER Depreciation reserve of the asset in the corporate book.
CORP_IMPAIRMENT_RESERVE NUMBER Impairment reserve of the asset in the corporate book.
CORP_NET_BOOK_VALUE NUMBER Net book value of the asset in the corporate book.
ASSET_TYPE VARCHAR2 11 Type of the asset. Possible values are CAPITALIZED, CIP, EXPENSED, and GROUP.
LOW_VALUE_ASSET_FLAG VARCHAR2 1 Indicates whether this line is a low value asset.
GLOBAL_ATTRIBUTE_NUMBER6 NUMBER Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_NUMBER7 NUMBER Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_NUMBER8 NUMBER Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_NUMBER9 NUMBER Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_NUMBER10 NUMBER Global Descriptive Flexfield: segment of the global descriptive flexfield.
DEPRN_ADJUSTMENT_FACTOR NUMBER Controls the speed of depreciation of an asset by multiplying this factor by the annual depreciation rate.
FULLY_RESERVE_ON_ADD_FLAG VARCHAR2 1 Indicates whether to fully depreciate an asset when the asset is added.
ADJ_CONVENTION_TYPE_ID NUMBER 18 Convention type identifier for adjustment transactions.
ADJ_PRORATE_CONVENTION_CODE VARCHAR2 10 Convention type for adjustment transactions.
REVAL_AMORT_BALANCE NUMBER Accumulated revaluation amortization.
YTD_REVAL_AMORTIZATION NUMBER Year-to-date revaluation reserve amortization amount.
REVALUED_COST NUMBER Increase or decrease in cost due to revaluation of the asset. Can be a positive or negative amount.
BACKLOG_DEPRN_RESERVE NUMBER Life-to-date backlog depreciation amount.
YTD_BACKLOG_DEPRN NUMBER Year-to-date backlog depreciation amount.
UPDATE_LAST_USED_INDEX_FLAG VARCHAR2 1 Specifies whether the value of the last used price index will be updated to a new value as of the revaluation date.
FEEDER_SYSTEM_NAME VARCHAR2 40 Name of the source system from which the asset transaction was created. This is a free text field that is not validated.
AUTO_POST_TRANSACTION_FLAG VARCHAR2 1 Indicates whether an asset transaction should be automatically posted after approval.
APPROVAL_STATUS_CODE VARCHAR2 30 Status of the asset transaction approval.
ASSET_LEVEL_APPROVAL_FLAG VARCHAR2 1 Indicates whether each asset in a mass transaction batch requires separate approval.

Foreign Keys

Table Foreign Table Foreign Key Column
FA_ADJUSTMENTS_T fa_adjustments_t ADJUSTMENT_INTERFACE_ID
FA_ADJUSTMENTS_T fa_category_books CATEGORY_ID, BOOK_TYPE_CODE
FA_ADJUSTMENTS_T fa_additions_b GROUP_ASSET_ID
FA_ADJUSTMENTS_T gl_code_combinations CODE_COMBINATION_ID
FA_ADJUSTMENTS_T fa_book_controls BOOK_TYPE_CODE
FA_ADJUSTMENTS_T fa_additions_b ASSET_ID
FA_ADJUSTMENTS_T fa_methods METHOD_ID
FA_ADJUSTMENTS_T fa_flat_rates METHOD_ID, FLAT_RATE_ID
FA_ADJUSTMENTS_T fa_ceiling_types CEILING_TYPE_ID
FA_ADJUSTMENTS_T fa_convention_types CONVENTION_TYPE_ID
FA_ADJUSTMENTS_T fa_bonus_rules BONUS_RULE_ID
FA_ADJUSTMENTS_T fa_categories_b CATEGORY_ID
fa_adj_src_lines_t fa_adjustments_t ADJUSTMENT_INTERFACE_ID
fa_adjustments_t fa_adjustments_t ADJUSTMENT_INTERFACE_ID

Indexes

Index Uniqueness Tablespace Columns
FA_ADJUSTMENTS_T_N1 Non Unique Default BOOK_TYPE_CODE, POSTING_STATUS, REQUEST_ID, WORKER_ID
FA_ADJUSTMENTS_T_N2 Non Unique Default BOOK_TYPE_CODE, POSTING_STATUS, BATCH_NAME, ASSET_ID, INTERFACE_LINE_NUMBER
FA_ADJUSTMENTS_T_U1 Unique Default ADJUSTMENT_INTERFACE_ID