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. | ||||
IB_ASSET_LINK_FLAG | VARCHAR2 | 1 | Indicates whether to synchronize the transaction between a fixed asset and its associated installed base asset. | ||||
ANNUITY_INTEREST_RATE | NUMBER | Annual interest rate used to calculate annual interest expense. | |||||
YTD_ANNUITY_INTEREST | NUMBER | Year-to-date annuity interest expense amount. | |||||
LTD_ANNUITY_INTEREST | NUMBER | Total annuity interest expense amount. |
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 |