FA_MASS_ADDITIONS
FA_MASS_ADDITIONS stores information about assets that you want to automatically add to Oracle Assets from another system. You can use this table to load assets for system conversions. When you run the mass additions create process, Oracle Assets inserts one row into this table for each invoice line it selects from Oracle Payables. When you run the Mass Additions Post process, Oracle Assets creates assets or adjustments from any rows in which the POSTING_STATUS is POST. Mass additions post inserts rows into FA_ADDITIONS, FA_ASSET_HISTORY, FA_ASSET_INVOICES, FA_BOOKS, FA_DISTRIBUTION_HISTORY, FA_TRANSACTION_HEADERS, FA_INVOICE_TRANSACTIONS, FA_DEPRN_SUMMARY, FA_DEPRN_DETAIL, and FA_TRANSFER_DETAILS. Oracle Assets then changes POSTING_STATUS and QUEUE_NAME to POSTED. POSTING_STATUS shows the status of a mass addition. POSTING_STATUS and QUEUE_NAME are the same, except when you assign user-defined queue names, or you split or merge a mass addition. The following table summarizes the relationship between POSTING_STATUS and QUEUE_NAME: POSTING_STATUS QUEUE_NAME -- Description ========================= NEW NEW -- Status when mass addition is first created. ON HOLD ON HOLD -- Waiting for additional information before posting. Posting Status after split SPLIT -- You divided a multi-unit mass addition into individual mass additions. Posting Status after merge MERGED -- You merged other mass additions into this one. POST ADD TO ASSET -- You are adding a mass addition to an existing asset as a cost adjustment and the mass addition is ready for posting. POST POST -- Ready for posting. POSTED POSTED -- The Mass Additions Post program created an asset from this mass addition. DELETE DELETE -- Delete this mass addition. The SPLIT_MERGED_CODE column tells you whether a mass addition was split or merged: MC Merged child - You merged this mass addition into another one. MP Merged parent - You merged other mass additions into this one. SC Split child - Oracle Assets created this mass addition from a multi-unit mass addition. SP Split parent - You split this multi-unit mass addition into single-unit mass addition. When you add the cost of a mass addition to an existing asset, NEW_MASTER_FLAG is set to Yes by the Prepare Mass Additions form when the resulting asset has the asset category and description of the mass addition. This value is No when the resulting asset has the asset category and description of the existing asset. Descriptive flexfield segments (attribute1-30 and global_attribute1-20) will map to the same columns in FA_ADDITIONS if populated. This rule applies only to merged invoice parents, split invoices, or individual invoice lines which become new assets. This rule does not apply to Add-to-Assets invoice lines. For more information on loading this table, read the About the Mass Additions Interface section in the Asset Setup chapter in the Oracle Assets User Guide. When you add a mass addition to an existing asset, Oracle Assets does not allow you to enter a salvage value for the mass addition. Scope: public Product: FA Lifecycle: active Display Name: FA Mass Additions Category: BUSINESS_ENTITY FA_ASSET @rep:ihelp fa/@p_ma_oi#p_ma_oi About the Mass Additions Interface, Oracle Assets Help
Details
-
Schema: FUSION
-
Object owner: FA
-
Object type: TABLE
-
Tablespace: INTERFACE
Primary Key
Name | Columns |
---|---|
FA_MASS_ADDITIONS_PK |
MASS_ADDITION_ID |
Columns
Name | Datatype | Length | Precision | Not-null | Comments | Flexfield-mapping |
---|---|---|---|---|---|---|
MASS_ADDITION_ID | NUMBER | 18 | Yes | Unique mass addition identifier. | ||
ASSET_NUMBER | VARCHAR2 | 30 | Unique asset number. Free text field. Generated automatically if not provided. | |||
TAG_NUMBER | VARCHAR2 | 15 | Asset tag number. Must be unique. Free text field. | |||
DESCRIPTION | VARCHAR2 | 80 | Asset description. Required field. Free text field. | |||
ASSET_CATEGORY_ID | NUMBER | 18 | Asset category identifier. Required field. Use the Manage Asset Categories task to identify valid values. | |||
MANUFACTURER_NAME | VARCHAR2 | 360 | Manufacturers name. Free text field. Not validated. | |||
PREPARER_ID | NUMBER | 18 | Person who prepared the mass addition line. Use the Manage Resources task to identify valid values. | |||
SERIAL_NUMBER | VARCHAR2 | 35 | Serial number. Free text field. Not validated. | |||
MODEL_NUMBER | VARCHAR2 | 40 | ||||
BOOK_TYPE_CODE | VARCHAR2 | 30 | Asset Book name. Use the Manage Asset Books task to identify valid values. | |||
DATE_PLACED_IN_SERVICE | DATE | Date asset placed in service. Date format: YYYY/MM/DD. If the date is not entered the default date from the current open period is used. If the date is prior or after the current period, the beginning or last day of the period are used respectively. | ||||
FIXED_ASSETS_COST | NUMBER | Asset cost. Required field. Do not use thousands separator. Use a period or comma as decimal separator. | ||||
PAYABLES_UNITS | NUMBER | Oracle internal use only. Units from Oracle Fusion Payables. Use whole number without thousand separator. Must be right aligned. | ||||
FIXED_ASSETS_UNITS | NUMBER | Number of units. Must be right aligned. | ||||
PAYABLES_CODE_COMBINATION_ID | NUMBER | 18 | Oracle internal use only. Cost clearing account identifier. Use the Manage Account Combinations task to identify valid values. | |||
FEEDER_SYSTEM_NAME | VARCHAR2 | 40 | Identifies system in which the asset was created. Free text field. Not validated. | |||
CREATE_BATCH_DATE | DATE | Date mass additions program that created the asset. Date format: YYYY/MM/DD. | ||||
CREATE_BATCH_ID | NUMBER | 18 | Oracle internal use only. Process identification number of mass additions create program | |||
CASH_GENERATING_UNIT_ID | NUMBER | 18 | Cash generating unit identifier. Use the Manage Cash Generating Units task to identify valid values. Must be right aligned. | |||
YTD_IMPAIRMENT | NUMBER | Year-to-date impairment amount. Enter without thousands separator. Use a period or comma as decimal separator. Cannot exceed asset cost. | ||||
IMPAIRMENT_RESERVE | NUMBER | Total impairment loss for the asset. Enter without thousands separator. Use a period or comma as decimal separator. Cannot exceed asset cost. | ||||
LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: date and time of the last update of the row. | |||
LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: user who last updated the row. | ||
REVIEWER_COMMENTS | VARCHAR2 | 60 | Comments. Used to review mass additions process only: not available thereafter. Free text field. Not validated. | |||
INVOICE_NUMBER | VARCHAR2 | 50 | Oracle internal use only. Invoice number for associated asset invoice. | |||
VENDOR_NUMBER | VARCHAR2 | 30 | Oracle internal use only. Supplier number for associated asset invoice. | |||
PO_VENDOR_ID | NUMBER | 18 | Oracle internal use only. Supplier identifier for associated asset invoice. | |||
PO_NUMBER | VARCHAR2 | 30 | Oracle internal use only. Purchase order number for associated asset invoice. | |||
POSTING_STATUS | VARCHAR2 | 15 | Status of the mass addition. Valid values: ON HOLD, NEW, POST, MERGED. ON HOLD means the asset is not ready for addition. NEW means the asset must be added. POST means the asset is posted. MERGED means the asset is merged. | |||
QUEUE_NAME | VARCHAR2 | 30 | Mass addition queue name. Valid values: ON HOLD, NEW, POST, MERGED. ON HOLD means the asset is not ready for addition. NEW means the asset must be added. POST means the asset is posted. MERGED means the asset is merged. | |||
INVOICE_DATE | DATE | Oracle internal use only. Invoice date for associated asset invoice. | ||||
INVOICE_CREATED_BY | VARCHAR2 | 64 | Oracle internal use only. User identification of the person who created the associated asset invoice. | |||
INVOICE_UPDATED_BY | VARCHAR2 | 64 | Oracle internal use only. User identification of the person who updated the associated asset invoice. | |||
PAYABLES_COST | NUMBER | Original asset cost. Enter without thousands separator. Use a period or comma as decimal separator. Precision must not exceed currency definition. | ||||
INVOICE_ID | NUMBER | 18 | Oracle internal use only. Invoice identifier from Oracle Fusion Payables. | |||
PAYABLES_BATCH_NAME | VARCHAR2 | 50 | Oracle internal use only. Batch name used by associated asset invoice. | |||
DEPRECIATE_FLAG | VARCHAR2 | 3 | Identifies whether the asset must be depreciated. Valid values: Y, N. | |||
PARENT_MASS_ADDITION_ID | NUMBER | 18 | Oracle internal use only. Identifies the mass addition into which you merged this mass addition. | |||
PARENT_ASSET_ID | NUMBER | 18 | Parent asset identifier. Use Asset Inquiry in any work area to identify valid values. | |||
SPLIT_MERGED_CODE | VARCHAR2 | 3 | Oracle internal use only. Indicates whether a mass addition was split or merged. | |||
AP_DISTRIBUTION_LINE_NUMBER | NUMBER | 18 | Oracle internal use only. Distribution line number from associated asset invoice. | |||
POST_BATCH_ID | NUMBER | 18 | Oracle internal use only. Unique identification number for a mass additions post request. | |||
ADD_TO_ASSET_ID | NUMBER | 18 | Asset to apply the mass addition as a cost adjustment. Use the Asset Inquiry task to identify valid values. | |||
AMORTIZE_FLAG | VARCHAR2 | 3 | Option indicating whether the transaction should be amortized or expensed.Valid values: Y, N. | |||
NEW_MASTER_FLAG | VARCHAR2 | 3 | Oracle internal use only. Determines whether to reclassify the asset which is being adjusted. Valid values: Y, N. | |||
ASSET_KEY_CCID | NUMBER | 18 | Asset key flexfield identifier. Use the Manage Asset Keys task to identify valid values. Use either ASSET_KEY_CCID or the columns beginning with ASSET_KEY_SEGMENT, but not both. | |||
ASSET_TYPE | VARCHAR2 | 11 | Asset type. Valid values: CAPITALIZED, CIP, GROUP, EXPENSED. CAPITALIZED means the asset is to be depreciated. CIP means the asset is still unfinished or under construction. GROUP means the asset is a collection of member assets. EXPENSED means assets do not depreciate and have to be expensed in the period of addition. | |||
DEPRN_RESERVE | NUMBER | Depreciation reserve of the asset. Enter without thousands separator. Use a period or comma as decimal separator. | ||||
YTD_DEPRN | NUMBER | Year-to-date depreciation expense of the asset. Enter without thousands separator. Use a period or comma as decimal separator. | ||||
LOAD_REQUEST_ID | NUMBER | 18 | Oracle Fusion Enterprise Resource Planning: request ID of the job that created or last updated the row. | |||
CREATED_BY | VARCHAR2 | 64 | Yes | Who column: user who created the row. | ||
CREATION_DATE | TIMESTAMP | Yes | Who column: date and time of the creation of the row. | |||
LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: session login associated to the user who last updated the row. | |||
SALVAGE_VALUE | NUMBER | Asset salvage value. Enter without thousands separator. Use a period or comma as decimal separator. | ||||
ACCOUNTING_DATE | DATE | Oracle internal user only. Accounting Date of the Oracle Fusion Payables invoice distribution line from AP_INVOICE_DISTRIBUTIONS.. | ||||
ATTRIBUTE1 | VARCHAR2 | 150 | Segment value for Asset Category descriptive flexfield. | Asset Category (FA_ADDITIONS) | ||
ATTRIBUTE2 | VARCHAR2 | 150 | Segment value for Asset Category descriptive flexfield. | Asset Category (FA_ADDITIONS) | ||
ATTRIBUTE3 | VARCHAR2 | 150 | Segment value for Asset Category descriptive flexfield. | Asset Category (FA_ADDITIONS) | ||
ATTRIBUTE4 | VARCHAR2 | 150 | Segment value for Asset Category descriptive flexfield. | Asset Category (FA_ADDITIONS) | ||
ATTRIBUTE5 | VARCHAR2 | 150 | Segment value for Asset Category descriptive flexfield. | Asset Category (FA_ADDITIONS) | ||
ATTRIBUTE6 | VARCHAR2 | 150 | Segment value for Asset Category descriptive flexfield. | Asset Category (FA_ADDITIONS) | ||
ATTRIBUTE7 | VARCHAR2 | 150 | Segment value for Asset Category descriptive flexfield. | Asset Category (FA_ADDITIONS) | ||
ATTRIBUTE8 | VARCHAR2 | 150 | Segment value for Asset Category descriptive flexfield. | Asset Category (FA_ADDITIONS) | ||
ATTRIBUTE9 | VARCHAR2 | 150 | Segment value for Asset Category descriptive flexfield. | Asset Category (FA_ADDITIONS) | ||
ATTRIBUTE10 | VARCHAR2 | 150 | Segment value for Asset Category descriptive flexfield. | Asset Category (FA_ADDITIONS) | ||
ATTRIBUTE11 | VARCHAR2 | 150 | Segment value for Asset Category descriptive flexfield. | Asset Category (FA_ADDITIONS) | ||
ATTRIBUTE12 | VARCHAR2 | 150 | Segment value for Asset Category descriptive flexfield. | Asset Category (FA_ADDITIONS) | ||
ATTRIBUTE13 | VARCHAR2 | 150 | Segment value for Asset Category descriptive flexfield. | Asset Category (FA_ADDITIONS) | ||
ATTRIBUTE14 | VARCHAR2 | 150 | Segment value for Asset Category descriptive flexfield. | Asset Category (FA_ADDITIONS) | ||
ATTRIBUTE15 | VARCHAR2 | 150 | Segment value for Asset Category descriptive flexfield. | Asset Category (FA_ADDITIONS) | ||
ATTRIBUTE_CATEGORY_CODE | VARCHAR2 | 30 | Oracle internal use only. | |||
MERGE_INVOICE_NUMBER | VARCHAR2 | 50 | Oracle internal use only. Invoice number of a mass addition line merged parent. | |||
MERGE_VENDOR_NUMBER | VARCHAR2 | 30 | Oracle internal use only. Supplier number of a mass addition line merged parent. | |||
ATTRIBUTE16 | VARCHAR2 | 150 | Segment value for Asset Category descriptive flexfield. | Asset Category (FA_ADDITIONS) | ||
ATTRIBUTE17 | VARCHAR2 | 150 | Segment value for Asset Category descriptive flexfield. | Asset Category (FA_ADDITIONS) | ||
ATTRIBUTE18 | VARCHAR2 | 150 | Segment value for Asset Category descriptive flexfield. | Asset Category (FA_ADDITIONS) | ||
ATTRIBUTE19 | VARCHAR2 | 150 | Segment value for Asset Category descriptive flexfield. | Asset Category (FA_ADDITIONS) | ||
ATTRIBUTE20 | VARCHAR2 | 150 | Segment value for Asset Category descriptive flexfield. | Asset Category (FA_ADDITIONS) | ||
ATTRIBUTE21 | VARCHAR2 | 150 | Segment value for Asset Category descriptive flexfield. | Asset Category (FA_ADDITIONS) | ||
ATTRIBUTE22 | VARCHAR2 | 150 | Segment value for Asset Category descriptive flexfield. | Asset Category (FA_ADDITIONS) | ||
ATTRIBUTE23 | VARCHAR2 | 150 | Segment value for Asset Category descriptive flexfield. | Asset Category (FA_ADDITIONS) | ||
ATTRIBUTE24 | VARCHAR2 | 150 | Segment value for Asset Category descriptive flexfield. | Asset Category (FA_ADDITIONS) | ||
ATTRIBUTE25 | VARCHAR2 | 150 | Segment value for Asset Category descriptive flexfield. | Asset Category (FA_ADDITIONS) | ||
ATTRIBUTE26 | VARCHAR2 | 150 | Segment value for Asset Category descriptive flexfield. | Asset Category (FA_ADDITIONS) | ||
ATTRIBUTE27 | VARCHAR2 | 150 | Segment value for Asset Category descriptive flexfield. | Asset Category (FA_ADDITIONS) | ||
ATTRIBUTE28 | VARCHAR2 | 150 | Segment value for Asset Category descriptive flexfield. | Asset Category (FA_ADDITIONS) | ||
ATTRIBUTE29 | VARCHAR2 | 150 | Segment value for Asset Category descriptive flexfield. | Asset Category (FA_ADDITIONS) | ||
ATTRIBUTE30 | VARCHAR2 | 150 | Segment value for Asset Category descriptive flexfield. | Asset Category (FA_ADDITIONS) | ||
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. | ||||
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. | ||||
GLOBAL_ATTRIBUTE_CATEGORY | VARCHAR2 | 30 | Context code for Assets Additional Regional Information global descriptive flexfield. Use the Fixed Assets Descriptive Flexfields task to identify valid values. Use columns beginning with GLOBAL for segment values. | |||
GLOBAL_ATTRIBUTE1 | VARCHAR2 | 150 | Segment value for Assets Additional Regional Information global descriptive flexfield. | |||
GLOBAL_ATTRIBUTE2 | VARCHAR2 | 150 | Segment value for Assets Additional Regional Information global descriptive flexfield. | |||
GLOBAL_ATTRIBUTE3 | VARCHAR2 | 150 | Segment value for Assets Additional Regional Information global descriptive flexfield. | |||
GLOBAL_ATTRIBUTE4 | VARCHAR2 | 150 | Segment value for Assets Additional Regional Information global descriptive flexfield. | |||
GLOBAL_ATTRIBUTE5 | VARCHAR2 | 150 | Segment value for Assets Additional Regional Information global descriptive flexfield. | |||
GLOBAL_ATTRIBUTE6 | VARCHAR2 | 150 | Segment value for Assets Additional Regional Information global descriptive flexfield. | |||
GLOBAL_ATTRIBUTE7 | VARCHAR2 | 150 | Segment value for Assets Additional Regional Information global descriptive flexfield. | |||
GLOBAL_ATTRIBUTE8 | VARCHAR2 | 150 | Segment value for Assets Additional Regional Information global descriptive flexfield. | |||
GLOBAL_ATTRIBUTE9 | VARCHAR2 | 150 | Segment value for Assets Additional Regional Information global descriptive flexfield. | |||
GLOBAL_ATTRIBUTE10 | VARCHAR2 | 150 | Segment value for Assets Additional Regional Information global descriptive flexfield. | |||
GLOBAL_ATTRIBUTE11 | VARCHAR2 | 150 | Segment value for Assets Additional Regional Information global descriptive flexfield. | |||
GLOBAL_ATTRIBUTE12 | VARCHAR2 | 150 | Segment value for Assets Additional Regional Information global descriptive flexfield. | |||
GLOBAL_ATTRIBUTE13 | VARCHAR2 | 150 | Segment value for Assets Additional Regional Information global descriptive flexfield. | |||
GLOBAL_ATTRIBUTE14 | VARCHAR2 | 150 | Segment value for Assets Additional Regional Information global descriptive flexfield. | |||
GLOBAL_ATTRIBUTE15 | VARCHAR2 | 150 | Segment value for Assets Additional Regional Information global descriptive flexfield. | |||
GLOBAL_ATTRIBUTE16 | VARCHAR2 | 150 | Segment value for Assets Additional Regional Information global descriptive flexfield. | |||
GLOBAL_ATTRIBUTE17 | VARCHAR2 | 150 | Segment value for Assets Additional Regional Information global descriptive flexfield. | |||
GLOBAL_ATTRIBUTE18 | VARCHAR2 | 150 | Segment value for Assets Additional Regional Information global descriptive flexfield. | |||
GLOBAL_ATTRIBUTE19 | VARCHAR2 | 150 | Segment value for Assets Additional Regional Information global descriptive flexfield. | |||
GLOBAL_ATTRIBUTE20 | VARCHAR2 | 150 | Segment value for Assets Additional Regional Information global descriptive flexfield. | |||
GLOBAL_ATTRIBUTE_NUMBER1 | NUMBER | Number value for Assets Additional Regional Information global descriptive flexfield. | ||||
GLOBAL_ATTRIBUTE_NUMBER2 | NUMBER | Number value for Assets Additional Regional Information global descriptive flexfield. | ||||
GLOBAL_ATTRIBUTE_NUMBER3 | NUMBER | Number value for Assets Additional Regional Information global descriptive flexfield. | ||||
GLOBAL_ATTRIBUTE_NUMBER4 | NUMBER | Number value for Assets Additional Regional Information global descriptive flexfield. | ||||
GLOBAL_ATTRIBUTE_NUMBER5 | NUMBER | Number value for Assets Additional Regional Information global descriptive flexfield. | ||||
GLOBAL_ATTRIBUTE_DATE1 | DATE | Date value for Assets Additional Regional Information global descriptive flexfield. | ||||
GLOBAL_ATTRIBUTE_DATE2 | DATE | Date value for Assets Additional Regional Information global descriptive flexfield. | ||||
GLOBAL_ATTRIBUTE_DATE3 | DATE | Date value for Assets Additional Regional Information global descriptive flexfield. | ||||
GLOBAL_ATTRIBUTE_DATE4 | DATE | Date value for Assets Additional Regional Information global descriptive flexfield. | ||||
GLOBAL_ATTRIBUTE_DATE5 | DATE | Date value for Assets Additional Regional Information global descriptive flexfield. | ||||
MERGED_CODE | VARCHAR2 | 3 | Oracle internal use only. Indicates if the mass addition is a merged parent of a merged child. | |||
SPLIT_CODE | VARCHAR2 | 3 | Oracle internal use only. Indicates if the mass addition is a split parent or a split child. | |||
MERGE_PARENT_MASS_ADDITIONS_ID | NUMBER | 18 | Oracle internal use only. Merged parent mass addition identifier. Valid values: Y, N. | |||
SPLIT_PARENT_MASS_ADDITIONS_ID | NUMBER | 18 | Oracle internal use only. Split parent mass addition identifier. | |||
PROJECT_ASSET_LINE_ID | NUMBER | 18 | Oracle internal use only. Identifier of the summarized asset cost line transferred. | |||
PROJECT_ID | NUMBER | 18 | Oracle internal use only. Identifier of the project from which the costs were collected, summarized, and transferred. | |||
TASK_ID | NUMBER | 18 | Oracle internal use only. Identifier of the task from which costs were collected, summarized, and transferred. Only populated if the costs are summarized by task. | |||
SUM_UNITS | VARCHAR2 | 3 | Sum the units of merged mass additions. Valid values: Y, N. | |||
INVENTORIAL | VARCHAR2 | 3 | Indicator used to determine whether the asset should be included in physical inventory.Valid values: Y, N. | |||
DIST_NAME | VARCHAR2 | 25 | Oracle internal use only. Name of the distribution set. | |||
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) | ||
SHORT_FISCAL_YEAR_FLAG | VARCHAR2 | 3 | Asset is added in a short fiscal year indicator. Valid values: Y, N. | |||
CONVERSION_DATE | DATE | Date short fiscal year asset added to acquiring company. Date format: YYYY/MM/DD. Must be within current calendar period of the primary company. | ||||
ORIGINAL_DEPRN_START_DATE | DATE | Date short fiscal year asset began depreciating in the acquired company''s books. Date format: YYYY/MM/DD. Must be within current calendar period of the primary company. | ||||
GROUP_ASSET_ID | NUMBER | Oracle internal use only. Identification number of the group asset. | ||||
UNITS_TO_ADJUST | NUMBER | 18 | Total units to adjust. Use a whole number with no thousands separators. | |||
BONUS_YTD_DEPRN | NUMBER | Year-to-date bonus depreciation expense of the asset. Amount must be included in YTD_DEPRN. Enter without thousands separator. Use a period or comma as decimal separator. | ||||
BONUS_DEPRN_RESERVE | NUMBER | Bonus depreciation reserve of the asset. Amount must be included in DEPRN_RESERVE. Enter without thousands separator. Use a period or comma as decimal separator. | ||||
AMORTIZATION_START_DATE | DATE | Date to start amortizing the net book value for an asset if the transaction is amortized. Date format: YYYY/MM/DD. Must be equal to or later than the date the asset was placed in service. | ||||
PROPERTY_TYPE_CODE | VARCHAR2 | 30 | Property type. Valid values: PERSONAL, REAL. | |||
PROPERTY_1245_1250_CODE | VARCHAR2 | 4 | Property type. Valid values: 1245, 1250. 1245 means personal. 1250 means real. | |||
IN_USE_FLAG | VARCHAR2 | 3 | Indicates whether the asset is in use. Possible values: Y, N. | |||
OWNED_LEASED | VARCHAR2 | 15 | Indicates whether the asset is owned or leased. Valid values: OWNED, LEASED. | |||
NEW_USED | VARCHAR2 | 4 | Indicates whether the asset is new or used. Valid values: NEW, USED. | |||
ASSET_ID | NUMBER | 18 | Asset identifier. Use an Assets Inquiry in any work area to identify valid values. | |||
MATERIAL_INDICATOR_FLAG | VARCHAR2 | 1 | Indicates whether the source line is of material nature. Valid values: Y, N. | |||
SALVAGE_TYPE | VARCHAR2 | 30 | Salvage type. Valid values: PCT, AMT, SUM. PCT means percentage of value. AMT means amount. SUM means sum of member assets. | |||
PERCENT_SALVAGE_VALUE | NUMBER | Salvage value as a percentage of asset cost. Must be a value from 0 to 100. | ||||
DEPRN_LIMIT_TYPE | VARCHAR2 | 30 | Depreciation limit type. Valid values: PCT, AMT, SUM, NONE. PCT means percentage of asset cost. AMT means the limit is an amount. SUM is used for group assets, means the sum of member assets. NONE means there is no depreciation limit. | |||
ALLOWED_DEPRN_LIMIT | NUMBER | Default depreciation limit as a percentage of cost. Must be a value from 0 to 100. | ||||
ALLOWED_DEPRN_LIMIT_AMOUNT | NUMBER | Depreciation limit amount for the asset. Enter without thousands separator. Use a period or comma as decimal separator. Must be less than asset cost less depreciation. | ||||
INVOICE_LINE_NUMBER | NUMBER | Oracle internal use only. Line number from associated asset invoice. | ||||
INVOICE_DISTRIBUTION_ID | NUMBER | 18 | Oracle internal use only. Invoice distribution identifier from associated asset invoice. | |||
PO_DISTRIBUTION_ID | NUMBER | 18 | Oracle internal use only. Purchase order distribution identifier from associated asset invoice. | |||
REQUEST_ID | NUMBER | 18 | Oracle Fusion Enterprise Resource Planning: request ID of the job that created or last updated the row. | |||
WORKER_ID | NUMBER | 18 | Oracle internal use only. Internal identifier for parallel processing. | |||
PROCESS_ORDER | NUMBER | 18 | Internal identifier indicating the order in which transactions must be processed. | |||
MASS_PROPERTY_FLAG | VARCHAR2 | 1 | Eligible for mass property allocation. Valid values: Y, N. | |||
INVOICE_PAYMENT_ID | NUMBER | 18 | Oracle internal use only. Payment identifier for associated asset invoice. | |||
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. | ||
METHOD_ID | NUMBER | 18 | Depreciation method identifier. Use the Manage Depreciation Methods task to identify valid values. | |||
FLAT_RATE_ID | NUMBER | 18 | Flat rate depreciation method identifier. Use the Manage Depreciation Methods task to identify valid values. | |||
CONVENTION_TYPE_ID | NUMBER | 18 | Prorate convention identifier.Use the Manage Prorate Conventions to identify valid values. | |||
BONUS_RULE_ID | NUMBER | 18 | Bonus rule identifier. Use the Manage Bonus Rules task to identify valid values. | |||
CEILING_TYPE_ID | NUMBER | 18 | Depreciation ceiling type identifier. Use the Manage Ceilings task to identify valid values. | |||
COMMITMENT | VARCHAR2 | 30 | Indicates whether there are external commitments for the asset. Valid values: Y, N. | |||
INVESTMENT_LAW | VARCHAR2 | 30 | Indicates whether there are laws that may apply to purchasing the asset. Valid values: Y, N. | |||
TRANSACTION_NAME | VARCHAR2 | 240 | Description of the transaction. Free text field. Not validated. | |||
TH_ATTRIBUTE1 | VARCHAR2 | 150 | Segment value for Transactions descriptive flexfield. Used for ADDITION transaction type. | Transactions (FA_TRANSACTION_HEADERS) | ||
TH_ATTRIBUTE2 | VARCHAR2 | 150 | Segment value for Transactions descriptive flexfield. Used for ADDITION transaction type. | Transactions (FA_TRANSACTION_HEADERS) | ||
TH_ATTRIBUTE3 | VARCHAR2 | 150 | Segment value for Transactions descriptive flexfield. Used for ADDITION transaction type. | Transactions (FA_TRANSACTION_HEADERS) | ||
TH_ATTRIBUTE4 | VARCHAR2 | 150 | Segment value for Transactions descriptive flexfield. Used for ADDITION transaction type. | Transactions (FA_TRANSACTION_HEADERS) | ||
TH_ATTRIBUTE5 | VARCHAR2 | 150 | Segment value for Transactions descriptive flexfield. Used for ADDITION transaction type. | Transactions (FA_TRANSACTION_HEADERS) | ||
TH_ATTRIBUTE6 | VARCHAR2 | 150 | Segment value for Transactions descriptive flexfield. Used for ADDITION transaction type. | Transactions (FA_TRANSACTION_HEADERS) | ||
TH_ATTRIBUTE7 | VARCHAR2 | 150 | Segment value for Transactions descriptive flexfield. Used for ADDITION transaction type. | Transactions (FA_TRANSACTION_HEADERS) | ||
TH_ATTRIBUTE8 | VARCHAR2 | 150 | Segment value for Transactions descriptive flexfield. Used for ADDITION transaction type. | Transactions (FA_TRANSACTION_HEADERS) | ||
TH_ATTRIBUTE9 | VARCHAR2 | 150 | Segment value for Transactions descriptive flexfield. Used for ADDITION transaction type. | Transactions (FA_TRANSACTION_HEADERS) | ||
TH_ATTRIBUTE10 | VARCHAR2 | 150 | Segment value for Transactions descriptive flexfield. Used for ADDITION transaction type. | Transactions (FA_TRANSACTION_HEADERS) | ||
TH_ATTRIBUTE11 | VARCHAR2 | 150 | Segment value for Transactions descriptive flexfield. Used for ADDITION transaction type. | Transactions (FA_TRANSACTION_HEADERS) | ||
TH_ATTRIBUTE12 | VARCHAR2 | 150 | Segment value for Transactions descriptive flexfield. Used for ADDITION transaction type. | Transactions (FA_TRANSACTION_HEADERS) | ||
TH_ATTRIBUTE13 | VARCHAR2 | 150 | Segment value for Transactions descriptive flexfield. Used for ADDITION transaction type. | Transactions (FA_TRANSACTION_HEADERS) | ||
TH_ATTRIBUTE14 | VARCHAR2 | 150 | Segment value for Transactions descriptive flexfield. Used for ADDITION transaction type. | Transactions (FA_TRANSACTION_HEADERS) | ||
TH_ATTRIBUTE15 | VARCHAR2 | 150 | Segment value for Transactions descriptive flexfield. Used for ADDITION transaction type. | Transactions (FA_TRANSACTION_HEADERS) | ||
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. Used for ADDITION transaction type. | Transactions (FA_TRANSACTION_HEADERS) | ||
TH_ATTRIBUTE_NUMBER1 | NUMBER | Number value for Transactions descriptive flexfield. Used for ADDITION transaction type. | ||||
TH_ATTRIBUTE_NUMBER2 | NUMBER | Number value for Transactions descriptive flexfield. Used for ADDITION transaction type. | ||||
TH_ATTRIBUTE_NUMBER3 | NUMBER | Number value for Transactions descriptive flexfield. Used for ADDITION transaction type. | ||||
TH_ATTRIBUTE_NUMBER4 | NUMBER | Number value for Transactions descriptive flexfield. Used for ADDITION transaction type. | ||||
TH_ATTRIBUTE_NUMBER5 | NUMBER | Number value for Transactions descriptive flexfield. Used for ADDITION transaction type. | ||||
TH_ATTRIBUTE_DATE1 | DATE | Date value for Transactions descriptive flexfield. Used for ADDITION transaction type. | ||||
TH_ATTRIBUTE_DATE2 | DATE | Date value for Transactions descriptive flexfield. Used for ADDITION transaction type. | ||||
TH_ATTRIBUTE_DATE3 | DATE | Date value for Transactions descriptive flexfield. Used for ADDITION transaction type. | ||||
TH_ATTRIBUTE_DATE4 | DATE | Date value for Transactions descriptive flexfield. Used for ADDITION transaction type. | ||||
TH_ATTRIBUTE_DATE5 | DATE | Date value for Transactions descriptive flexfield. Used for ADDITION transaction type. | ||||
TH2_ATTRIBUTE1 | VARCHAR2 | 150 | Segment value for Transactions descriptive flexfield. Used for TRANSFER IN transaction type. | |||
TH2_ATTRIBUTE2 | VARCHAR2 | 150 | Segment value for Transactions descriptive flexfield. Used for TRANSFER IN transaction type. | |||
TH2_ATTRIBUTE3 | VARCHAR2 | 150 | Segment value for Transactions descriptive flexfield. Used for TRANSFER IN transaction type. | |||
TH2_ATTRIBUTE4 | VARCHAR2 | 150 | Segment value for Transactions descriptive flexfield. Used for TRANSFER IN transaction type. | |||
TH2_ATTRIBUTE5 | VARCHAR2 | 150 | Segment value for Transactions descriptive flexfield. Used for TRANSFER IN transaction type. | |||
TH2_ATTRIBUTE6 | VARCHAR2 | 150 | Segment value for Transactions descriptive flexfield. Used for TRANSFER IN transaction type. | |||
TH2_ATTRIBUTE7 | VARCHAR2 | 150 | Segment value for Transactions descriptive flexfield. Used for TRANSFER IN transaction type. | |||
TH2_ATTRIBUTE8 | VARCHAR2 | 150 | Segment value for Transactions descriptive flexfield. Used for TRANSFER IN transaction type. | |||
TH2_ATTRIBUTE9 | VARCHAR2 | 150 | Segment value for Transactions descriptive flexfield. Used for TRANSFER IN transaction type. | |||
TH2_ATTRIBUTE10 | VARCHAR2 | 150 | Segment value for Transactions descriptive flexfield. Used for TRANSFER IN transaction type. | |||
TH2_ATTRIBUTE11 | VARCHAR2 | 150 | Segment value for Transactions descriptive flexfield. Used for TRANSFER IN transaction type. | |||
TH2_ATTRIBUTE12 | VARCHAR2 | 150 | Segment value for Transactions descriptive flexfield. Used for TRANSFER IN transaction type. | |||
TH2_ATTRIBUTE13 | VARCHAR2 | 150 | Segment value for Transactions descriptive flexfield. Used for TRANSFER IN transaction type. | |||
TH2_ATTRIBUTE14 | VARCHAR2 | 150 | Segment value for Transactions descriptive flexfield. Used for TRANSFER IN transaction type. | |||
TH2_ATTRIBUTE15 | VARCHAR2 | 150 | Segment value for Transactions descriptive flexfield. Used for TRANSFER IN transaction type. | |||
TH2_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 TH2 for segment values. Used for TRANSFER IN transaction type. | |||
TH2_ATTRIBUTE_NUMBER1 | NUMBER | Number value for Transactions descriptive flexfield. Used for TRANSFER IN transaction type. | ||||
TH2_ATTRIBUTE_NUMBER2 | NUMBER | Number value for Transactions descriptive flexfield. Used for TRANSFER IN transaction type. | ||||
TH2_ATTRIBUTE_NUMBER3 | NUMBER | Number value for Transactions descriptive flexfield. Used for TRANSFER IN transaction type. | ||||
TH2_ATTRIBUTE_NUMBER4 | NUMBER | Number value for Transactions descriptive flexfield. Used for TRANSFER IN transaction type. | ||||
TH2_ATTRIBUTE_NUMBER5 | NUMBER | Number value for Transactions descriptive flexfield. Used for TRANSFER IN transaction type. | ||||
TH2_ATTRIBUTE_DATE1 | DATE | Date value for Transactions descriptive flexfield. Used for TRANSFER IN transaction type. | ||||
TH2_ATTRIBUTE_DATE2 | DATE | Date value for Transactions descriptive flexfield. Used for TRANSFER IN transaction type. | ||||
TH2_ATTRIBUTE_DATE3 | DATE | Date value for Transactions descriptive flexfield. Used for TRANSFER IN transaction type. | ||||
TH2_ATTRIBUTE_DATE4 | DATE | Date value for Transactions descriptive flexfield. Used for TRANSFER IN transaction type. | ||||
TH2_ATTRIBUTE_DATE5 | DATE | Date value for Transactions descriptive flexfield. Used for TRANSFER IN transaction type. | ||||
AI_ATTRIBUTE1 | VARCHAR2 | 150 | Segment value for Assets Invoices descriptive flexfield. | Assets Invoices (FA_ASSET_INVOICES) | ||
AI_ATTRIBUTE2 | VARCHAR2 | 150 | Segment value for Assets Invoices descriptive flexfield. | Assets Invoices (FA_ASSET_INVOICES) | ||
AI_ATTRIBUTE3 | VARCHAR2 | 150 | Segment value for Assets Invoices descriptive flexfield. | Assets Invoices (FA_ASSET_INVOICES) | ||
AI_ATTRIBUTE4 | VARCHAR2 | 150 | Segment value for Assets Invoices descriptive flexfield. | Assets Invoices (FA_ASSET_INVOICES) | ||
AI_ATTRIBUTE5 | VARCHAR2 | 150 | Segment value for Assets Invoices descriptive flexfield. | Assets Invoices (FA_ASSET_INVOICES) | ||
AI_ATTRIBUTE6 | VARCHAR2 | 150 | Segment value for Assets Invoices descriptive flexfield. | Assets Invoices (FA_ASSET_INVOICES) | ||
AI_ATTRIBUTE7 | VARCHAR2 | 150 | Segment value for Assets Invoices descriptive flexfield. | Assets Invoices (FA_ASSET_INVOICES) | ||
AI_ATTRIBUTE8 | VARCHAR2 | 150 | Segment value for Assets Invoices descriptive flexfield. | Assets Invoices (FA_ASSET_INVOICES) | ||
AI_ATTRIBUTE9 | VARCHAR2 | 150 | Segment value for Assets Invoices descriptive flexfield. | Assets Invoices (FA_ASSET_INVOICES) | ||
AI_ATTRIBUTE10 | VARCHAR2 | 150 | Segment value for Assets Invoices descriptive flexfield. | Assets Invoices (FA_ASSET_INVOICES) | ||
AI_ATTRIBUTE11 | VARCHAR2 | 150 | Segment value for Assets Invoices descriptive flexfield. | Assets Invoices (FA_ASSET_INVOICES) | ||
AI_ATTRIBUTE12 | VARCHAR2 | 150 | Segment value for Assets Invoices descriptive flexfield. | Assets Invoices (FA_ASSET_INVOICES) | ||
AI_ATTRIBUTE13 | VARCHAR2 | 150 | Segment value for Assets Invoices descriptive flexfield. | Assets Invoices (FA_ASSET_INVOICES) | ||
AI_ATTRIBUTE14 | VARCHAR2 | 150 | Segment value for Assets Invoices descriptive flexfield. | Assets Invoices (FA_ASSET_INVOICES) | ||
AI_ATTRIBUTE15 | VARCHAR2 | 150 | Segment value for Assets Invoices descriptive flexfield. | Assets Invoices (FA_ASSET_INVOICES) | ||
AI_ATTRIBUTE_CATEGORY_CODE | VARCHAR2 | 30 | Context code for Assets Invoices descriptive flexfield. Use the Manage Fixed Assets Descriptive Flexfields task to identify valid values. Use columns beginning with AI for segment values. | Assets Invoices (FA_ASSET_INVOICES) | ||
AI_ATTRIBUTE_NUMBER1 | NUMBER | Number value for Assets Invoices descriptive flexfield. | ||||
AI_ATTRIBUTE_NUMBER2 | NUMBER | Number value for Assets Invoices descriptive flexfield. | ||||
AI_ATTRIBUTE_NUMBER3 | NUMBER | Number value for Assets Invoices descriptive flexfield. | ||||
AI_ATTRIBUTE_NUMBER4 | NUMBER | Number value for Assets Invoices descriptive flexfield. | ||||
AI_ATTRIBUTE_NUMBER5 | NUMBER | Number value for Assets Invoices descriptive flexfield. | ||||
AI_ATTRIBUTE_DATE1 | DATE | Date value for Assets Invoices descriptive flexfield. | ||||
AI_ATTRIBUTE_DATE2 | DATE | Date value for Assets Invoices descriptive flexfield. | ||||
AI_ATTRIBUTE_DATE3 | DATE | Date value for Assets Invoices descriptive flexfield. | ||||
AI_ATTRIBUTE_DATE4 | DATE | Date value for Assets Invoices descriptive flexfield. | ||||
AI_ATTRIBUTE_DATE5 | DATE | Date value for Assets Invoices descriptive flexfield. | ||||
REDUCTION_RATE | NUMBER | Depreciation reduction rate for the group and its assets. Must be between 0 and 100. | ||||
REDUCE_ADDITION_FLAG | VARCHAR2 | 1 | Indicates whether reduction rate is applied to additions. Applicable only to group assets. Used when depreciable basis rule has year end balance with positive reduction amount and half year rule. Valid values: Y, N. | |||
REDUCE_ADJUSTMENT_FLAG | VARCHAR2 | 1 | Indicates whether reduction rate is applied to adjustments. Applicable only to group assets. Used when depreciable basis rule has year end balance with positive reduction amount and half year rule. Valid values: Y, N. | |||
REDUCE_RETIREMENT_FLAG | VARCHAR2 | 1 | Indicates whether reduction rate is applied to retirements. Applicable only to group assets. Used when depreciable basis rule has year end balance with positive reduction amount and half year rule. Valid values: Y, N. | |||
RECOGNIZE_GAIN_LOSS | VARCHAR2 | 30 | Recognize gain or loss at asset retirement. Valid values: Y, N. | |||
RECAPTURE_RESERVE_FLAG | VARCHAR2 | 1 | Reserve can exceed recoverable asset cost. Valid values: Y, N. | |||
LIMIT_PROCEEDS_FLAG | VARCHAR2 | 1 | Limit asset proceeds to recoverable cost. Valid values: Y, N. | |||
TERMINAL_GAIN_LOSS | VARCHAR2 | 30 | Indicates whether terminal gain or loss must be recognized for member asset retirement. Valid values: Y, N. | |||
TRACKING_METHOD | VARCHAR2 | 30 | Group asset tracking method for calculating group and member asset depreciation. Valid values: ALLOCATE, CALCULATE. ALLOCATE means allocate group depreciation amount to member assets. CALCULATE means calculate depreciation for each member asset. | |||
EXCESS_ALLOCATION_OPTION | VARCHAR2 | 30 | Indicate whether excess depreciation for group asset is allocated to member assets. Valid values: Y, N. | |||
DEPRECIATION_OPTION | VARCHAR2 | 30 | Depreciate member asset based on either group or individual member asset depreciation rules. Valid values: GROUP, MEMBER. | |||
MEMBER_ROLLUP_FLAG | VARCHAR2 | 1 | Option indicating whether group asset depreciation is sum of member asset depreciation or calculated separately.Valid values: Y, N. | |||
ALLOCATE_TO_FULLY_RSV_FLAG | VARCHAR2 | 1 | Option indicating whether to allocate group asset depreciation amount to a reserved member asset.Valid values: Y, N. | |||
OVER_DEPRECIATE_OPTION | VARCHAR2 | 30 | Over depreciation is allowed for group assets. Valid values: Y, N. | |||
NBV_AT_SWITCH | NUMBER | |||||
PERIOD_FULL_RESERVE | VARCHAR2 | 30 | Oracle internal use only. Period when asset became fully reserved. | |||
PERIOD_EXTD_DEPRN | VARCHAR2 | 30 | Oracle internal use only. Periods for extended depreciation. | |||
PRIOR_DEPRN_LIMIT_TYPE | VARCHAR2 | 30 | Oracle internal use only. Depreciation limit type for asset before it begins extended depreciation. | |||
PRIOR_DEPRN_LIMIT_AMOUNT | NUMBER | Prior depreciation limit amount. Enter without thousands separator. Use a period or comma as decimal separator. | ||||
PRIOR_DEPRN_LIMIT | NUMBER | Oracle internal use only. Depreciation limit as a percentage of asset cost immediately prior to beginning extended depreciation. | ||||
PRIOR_METHOD_ID | NUMBER | 18 | Oracle internal use only. Depreciation method identifier for asset immediately prior to beginning extended depreciation. | |||
PRIOR_FLAT_RATE_ID | NUMBER | 18 | Oracle internal use only. Flat rate identifier for depreciation method of asset immediately prior to beginning extended depreciation. | |||
WARRANTY_ID | NUMBER | 18 | Oracle internal use only. Warranty identifier for the asset. | |||
WARRANTY_NUMBER | VARCHAR2 | 15 | Oracle internal use only. Warranty number for the asset. | |||
ITC_AMOUNT_ID | NUMBER | 18 | Oracle internal use only. Investment Tax Credfit amount identification number for the asset. | |||
LEASE_ID | NUMBER | 18 | Oracle internal use only. Lease identifier for capital or operating lease. | |||
LESSOR_ID | NUMBER | 18 | Oracle internal use only. Lessor identifier. | |||
YTD_REVAL_DEPRN_EXPENSE | NUMBER | Year-to-date depreciation expense due to revaluation. Oracle Fusion Assets does not create any journal entries for this amount. Reporting purposes only. | ||||
PRODUCTION_CAPACITY | NUMBER | Production capacity. Enter a whole number with no thousands separators. | ||||
REVAL_AMORTIZATION_BASIS | NUMBER | Oracle internal use only. Revaluation reserve for calculating amortization of revaluation reserve. Updated when asset is revalued or has amortized adjustment. | ||||
REVAL_CEILING | NUMBER | Oracle internal use only. Upper limit for revaluating asset cost. | ||||
REVAL_RESERVE | NUMBER | Oracle internal use only. Change in net book value due to revaluation of depreciation reserve for revaluation period. For all other periods, the revaluation reserve amount after depreciation run. | ||||
UNIT_OF_MEASURE | VARCHAR2 | 25 | Unit of measure for depreciation based on production units. Use the Manage Units of Measure task to identify valid values. | |||
UNREVALUED_COST | NUMBER | Oracle internal use only. Cost that is independent of any revaluations. | ||||
FULLY_RSVD_REVALS_COUNTER | NUMBER | Oracle internal use only. Number of times asset is revalued as fully reserved. | ||||
ATTACHMENT_FLAG | VARCHAR2 | 1 | Indicates whether asset has attachments. Not available for Oracle Cloud customers. Valid values: Y, N. | |||
ERROR_MSG | VARCHAR2 | 2000 | Oracle internal use only. Encoded message text associated with a failure of the posting program. | |||
ASSET_KEY_SEGMENT1 | VARCHAR2 | 30 | Segment value for the Asset Key flexfield. Use the Manage Assets Keys task to identify valid values. Use either ASSET_KEY_CCID or the columns beginning with ASSET_KEY_SEGMENT, but not both. | |||
ASSET_KEY_SEGMENT2 | VARCHAR2 | 30 | Segment value for the Asset Key flexfield. Use the Manage Assets Keys task to identify valid values. Use either ASSET_KEY_CCID or the columns beginning with ASSET_KEY_SEGMENT, but not both. | |||
ASSET_KEY_SEGMENT3 | VARCHAR2 | 30 | Segment value for the Asset Key flexfield. Use the Manage Assets Keys task to identify valid values. Use either ASSET_KEY_CCID or the columns beginning with ASSET_KEY_SEGMENT, but not both. | |||
ASSET_KEY_SEGMENT4 | VARCHAR2 | 30 | Segment value for the Asset Key flexfield. Use the Manage Assets Keys task to identify valid values. Use either ASSET_KEY_CCID or the columns beginning with ASSET_KEY_SEGMENT, but not both. | |||
ASSET_KEY_SEGMENT5 | VARCHAR2 | 30 | Segment value for the Asset Key flexfield. Use the Manage Assets Keys task to identify valid values. Use either ASSET_KEY_CCID or the columns beginning with ASSET_KEY_SEGMENT, but not both. | |||
ASSET_KEY_SEGMENT6 | VARCHAR2 | 30 | Segment value for the Asset Key flexfield. Use the Manage Assets Keys task to identify valid values. Use either ASSET_KEY_CCID or the columns beginning with ASSET_KEY_SEGMENT, but not both. | |||
ASSET_KEY_SEGMENT7 | VARCHAR2 | 30 | Segment value for the Asset Key flexfield. Use the Manage Assets Keys task to identify valid values. Use either ASSET_KEY_CCID or the columns beginning with ASSET_KEY_SEGMENT, but not both. | |||
ASSET_KEY_SEGMENT8 | VARCHAR2 | 30 | Segment value for the Asset Key flexfield. Use the Manage Assets Keys task to identify valid values. Use either ASSET_KEY_CCID or the columns beginning with ASSET_KEY_SEGMENT, but not both. | |||
ASSET_KEY_SEGMENT9 | VARCHAR2 | 30 | Segment value for the Asset Key flexfield. Use the Manage Assets Keys task to identify valid values. Use either ASSET_KEY_CCID or the columns beginning with ASSET_KEY_SEGMENT, but not both. | |||
ASSET_KEY_SEGMENT10 | VARCHAR2 | 30 | Segment value for the Asset Key flexfield. Use the Manage Assets Keys task to identify valid values. Use either ASSET_KEY_CCID or the columns beginning with ASSET_KEY_SEGMENT, but not both. | |||
ADD_TO_ASSET_NUMBER | VARCHAR2 | 30 | Asset number of the asset to which the mass addition line will be applied as a cost adjustment | |||
PARENT_ASSET_NUMBER | VARCHAR2 | 30 | Asset number of the parent asset for the child or component asset. | |||
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. | |||
CLEARING_ACCT_SEGMENT1 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | |||
CLEARING_ACCT_SEGMENT2 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | |||
CLEARING_ACCT_SEGMENT3 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | |||
CLEARING_ACCT_SEGMENT4 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | |||
CLEARING_ACCT_SEGMENT5 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | |||
CLEARING_ACCT_SEGMENT6 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | |||
CLEARING_ACCT_SEGMENT7 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | |||
CLEARING_ACCT_SEGMENT8 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | |||
CLEARING_ACCT_SEGMENT9 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | |||
CLEARING_ACCT_SEGMENT10 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | |||
CLEARING_ACCT_SEGMENT11 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | |||
CLEARING_ACCT_SEGMENT12 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | |||
CLEARING_ACCT_SEGMENT13 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | |||
CLEARING_ACCT_SEGMENT14 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | |||
CLEARING_ACCT_SEGMENT15 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | |||
CLEARING_ACCT_SEGMENT16 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | |||
CLEARING_ACCT_SEGMENT17 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | |||
CLEARING_ACCT_SEGMENT18 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | |||
CLEARING_ACCT_SEGMENT19 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | |||
CLEARING_ACCT_SEGMENT20 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | |||
CLEARING_ACCT_SEGMENT21 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | |||
CLEARING_ACCT_SEGMENT22 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | |||
CLEARING_ACCT_SEGMENT23 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | |||
CLEARING_ACCT_SEGMENT24 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | |||
CLEARING_ACCT_SEGMENT25 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | |||
CLEARING_ACCT_SEGMENT26 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | |||
CLEARING_ACCT_SEGMENT27 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | |||
CLEARING_ACCT_SEGMENT28 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | |||
CLEARING_ACCT_SEGMENT29 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | |||
CLEARING_ACCT_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. | ||||
FAIR_MARKET_VALUE | NUMBER | Fair value of the asset after revaluation. | ||||
IMPAIR_LOSS_BALANCE | NUMBER | Accumulated impairment expense. | ||||
LAST_PRICE_INDEX_VALUE | NUMBER | Stores the value of the price index used during index-based revaluation for future revaluation. | ||||
REVAL_LOSS_BALANCE | NUMBER | Revaluation loss of an asset after revaluation. | ||||
PERIOD_NAME_FULLY_RESERVED | VARCHAR2 | 15 | Name of the period in which the asset was fully reserved. | |||
PERIOD_COUNTER_FULLY_RESERVED | NUMBER | 18 | Fully reserved period identifier. | |||
PERIOD_NAME_EXTENDED | VARCHAR2 | 15 | Name of the period in which the asset starts extended depreciation. | |||
PERIOD_COUNTER_EXTENDED | NUMBER | 18 | Extended depreciation start period identifier. | |||
PRIOR_METHOD_CODE | VARCHAR2 | 12 | Depreciation method code for the asset before extended depreciation. | |||
PRIOR_LIFE_IN_MONTHS | NUMBER | 18 | Life in months for the asset before extended depreciation. | |||
PRIOR_BASIC_RATE | NUMBER | Basic depreciation rate for the asset before extended depreciation. | ||||
PRIOR_ADJUSTED_RATE | NUMBER | Adjusted depreciation rate for the asset before extended depreciation. | ||||
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. | |||
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. | ||||
GLOBAL_ATTRIBUTE_DATE6 | DATE | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
GLOBAL_ATTRIBUTE_DATE7 | DATE | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
GLOBAL_ATTRIBUTE_DATE8 | DATE | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
GLOBAL_ATTRIBUTE_DATE9 | DATE | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
GLOBAL_ATTRIBUTE_DATE10 | DATE | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
BK_GLOBAL_ATTRIBUTE_CATEGORY | VARCHAR2 | 30 | Global Descriptive Flexfield: structure definition of the global descriptive flexfield. | |||
BK_GLOBAL_ATTRIBUTE1 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
BK_GLOBAL_ATTRIBUTE2 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
BK_GLOBAL_ATTRIBUTE3 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
BK_GLOBAL_ATTRIBUTE4 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
BK_GLOBAL_ATTRIBUTE5 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
BK_GLOBAL_ATTRIBUTE6 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
BK_GLOBAL_ATTRIBUTE7 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
BK_GLOBAL_ATTRIBUTE8 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
BK_GLOBAL_ATTRIBUTE9 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
BK_GLOBAL_ATTRIBUTE10 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
BK_GLOBAL_ATTRIBUTE11 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
BK_GLOBAL_ATTRIBUTE12 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
BK_GLOBAL_ATTRIBUTE13 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
BK_GLOBAL_ATTRIBUTE14 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
BK_GLOBAL_ATTRIBUTE15 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
BK_GLOBAL_ATTRIBUTE16 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
BK_GLOBAL_ATTRIBUTE17 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
BK_GLOBAL_ATTRIBUTE18 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
BK_GLOBAL_ATTRIBUTE19 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
BK_GLOBAL_ATTRIBUTE20 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
BK_GLOBAL_ATTRIBUTE_NUMBER1 | NUMBER | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
BK_GLOBAL_ATTRIBUTE_NUMBER2 | NUMBER | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
BK_GLOBAL_ATTRIBUTE_NUMBER3 | NUMBER | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
BK_GLOBAL_ATTRIBUTE_NUMBER4 | NUMBER | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
BK_GLOBAL_ATTRIBUTE_NUMBER5 | NUMBER | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
BK_GLOBAL_ATTRIBUTE_DATE1 | DATE | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
BK_GLOBAL_ATTRIBUTE_DATE2 | DATE | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
BK_GLOBAL_ATTRIBUTE_DATE3 | DATE | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
BK_GLOBAL_ATTRIBUTE_DATE4 | DATE | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
BK_GLOBAL_ATTRIBUTE_DATE5 | DATE | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
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. | ||||
AI_GLOBAL_ATTRIBUTE_CATEGORY | VARCHAR2 | 30 | Global Descriptive Flexfield: structure definition of the global descriptive flexfield. | |||
AI_GLOBAL_ATTRIBUTE1 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
AI_GLOBAL_ATTRIBUTE2 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
AI_GLOBAL_ATTRIBUTE3 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
AI_GLOBAL_ATTRIBUTE4 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
AI_GLOBAL_ATTRIBUTE5 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
AI_GLOBAL_ATTRIBUTE6 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
AI_GLOBAL_ATTRIBUTE7 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
AI_GLOBAL_ATTRIBUTE8 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
AI_GLOBAL_ATTRIBUTE9 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
AI_GLOBAL_ATTRIBUTE10 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
AI_GLOBAL_ATTRIBUTE11 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
AI_GLOBAL_ATTRIBUTE12 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
AI_GLOBAL_ATTRIBUTE13 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
AI_GLOBAL_ATTRIBUTE14 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
AI_GLOBAL_ATTRIBUTE15 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
AI_GLOBAL_ATTRIBUTE16 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
AI_GLOBAL_ATTRIBUTE17 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
AI_GLOBAL_ATTRIBUTE18 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
AI_GLOBAL_ATTRIBUTE19 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
AI_GLOBAL_ATTRIBUTE20 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
AI_GLOBAL_ATTRIBUTE_NUMBER1 | NUMBER | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
AI_GLOBAL_ATTRIBUTE_NUMBER2 | NUMBER | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
AI_GLOBAL_ATTRIBUTE_NUMBER3 | NUMBER | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
AI_GLOBAL_ATTRIBUTE_NUMBER4 | NUMBER | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
AI_GLOBAL_ATTRIBUTE_NUMBER5 | NUMBER | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
AI_GLOBAL_ATTRIBUTE_DATE1 | DATE | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
AI_GLOBAL_ATTRIBUTE_DATE2 | DATE | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
AI_GLOBAL_ATTRIBUTE_DATE3 | DATE | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
AI_GLOBAL_ATTRIBUTE_DATE4 | DATE | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
AI_GLOBAL_ATTRIBUTE_DATE5 | DATE | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
LOW_VALUE_ASSET_FLAG | VARCHAR2 | 1 | Indicates whether this line is a low value asset. | |||
CREATE_EXPENSED_ASSET_FLAG | VARCHAR2 | 1 | Indicates whether the source lines need to be created as an expensed asset. | |||
CAP_THRESHOLD_CHECK_FLAG | VARCHAR2 | 1 | Indicates whether this line was evaluated against the capitalization thresholds. | |||
INVOICE_LINE_TYPE | VARCHAR2 | 30 | Type of invoice line. It is based on INVOICE LINE TYPE lookup codes like FREIGHT,TAX,ITEM etc. | |||
LINE_TYPE_LOOKUP_CODE | VARCHAR2 | 25 | Type of invoice distribution. It is based on INVOICE DISTRIBUTION TYPE lookup codes like ITEM,ERV, FREIGHT, TAX, etc. | |||
INVOICE_LINE_DESCRIPTION | VARCHAR2 | 240 | Description of the invoice line. | |||
PROJECT_ORGANIZATION_ID | NUMBER | 18 | The organization that is responsible for the project work. | |||
TASK_ORGANIZATION_ID | NUMBER | 18 | The task organization that is responsible for the work task. This is a task-specific attribute. | |||
EXPENDITURE_ORGANIZATION_ID | NUMBER | 18 | The expenditure expendature organization that is responsible for the work task. This is a task-specific attribute. | |||
PROJECT_TXN_DOC_ENTRY_ID | NUMBER | 18 | Identifies a project document entry. | |||
EXPENDITURE_TYPE_ID | NUMBER | 18 | The project expenditure classification type. | |||
INTANGIBLE_ASSET_FLAG | VARCHAR2 | 1 | Indicates whether the asset is an intangible asset. | |||
LEASE_SCHEDULE_ID | NUMBER | 18 | Unique lease payment schedule identification number. | |||
ASSET_SCHEDULE_NUM | NUMBER | 18 | Unique Identifier of an asset lease schedule. | |||
LEASE_NUMBER | VARCHAR2 | 30 | User-defined lease number of the lease. | |||
VENDOR_NAME | VARCHAR2 | 360 | Oracle internal use only. Supplier name for associated asset invoice. | |||
INVOICE_VOUCHER_NUMBER | VARCHAR2 | 50 | Oracle internal use only. Voucher number for associated asset invoice. | |||
INVOICE_PAYMENT_NUMBER | NUMBER | 18 | Oracle internal use only. Payment number for associated asset invoice. | |||
PROJECT_NUMBER | VARCHAR2 | 25 | Oracle internal use only. Number of the project from which the costs are collected, summarized, and transferred. | |||
PROJECT_TASK_NUMBER | VARCHAR2 | 100 | Oracle internal use only. User-defined number of the task from which costs are collected, summarized, and transferred. Only populated if the costs are summarized by task. | |||
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. | |||
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. | ||||
SHIP_TO_CUST_LOCATION_ID | NUMBER | 18 | Customer location identifier indicating where the supplier shipped the goods. | |||
SHIP_TO_LOCATION_ID | NUMBER | 18 | Internal location identifier indicating where the supplier shipped the goods. | |||
IB_REFERENCE_ID | NUMBER | 18 | The reference identifier used to link a fixed asset with an installed base asset. | |||
BATCH_NAME | VARCHAR2 | 120 | User-defined name for a batch of records in the interface table. Free text field. | |||
APPROVAL_STATUS_CODE | VARCHAR2 | 30 | Status of the asset transaction approval. | |||
APPROVAL_TYPE_CODE | VARCHAR2 | 30 | Code that indicates whether the transaction should be approved separately or as part of a mass transaction group. | |||
AUTO_POST_TRANSACTION_FLAG | VARCHAR2 | 1 | Indicates whether an asset transaction should be automatically posted after approval. | |||
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. | ||||
PURCHASING_CATEGORY_ID | NUMBER | 18 | Item category unique identifier. |
Foreign Keys
Table | Foreign Table | Foreign Key Column |
---|---|---|
FA_MASS_ADDITIONS | fa_additions_b | ADD_TO_ASSET_ID |
FA_MASS_ADDITIONS | fa_mass_additions | MERGE_PARENT_MASS_ADDITIONS_ID |
FA_MASS_ADDITIONS | fa_mass_additions | SPLIT_PARENT_MASS_ADDITIONS_ID |
FA_MASS_ADDITIONS | fa_flat_rates | METHOD_ID, FLAT_RATE_ID |
FA_MASS_ADDITIONS | ap_invoice_distributions_all | INVOICE_DISTRIBUTION_ID |
FA_MASS_ADDITIONS | ap_invoices_all | INVOICE_ID |
FA_MASS_ADDITIONS | fa_convention_types | CONVENTION_TYPE_ID |
FA_MASS_ADDITIONS | fa_additions_b | PARENT_ASSET_ID |
FA_MASS_ADDITIONS | fa_ceiling_types | CEILING_TYPE_ID |
FA_MASS_ADDITIONS | fa_asset_keywords | ASSET_KEY_CCID |
FA_MASS_ADDITIONS | fa_bonus_rules | BONUS_RULE_ID |
FA_MASS_ADDITIONS | fa_categories_b | ASSET_CATEGORY_ID |
FA_MASS_ADDITIONS | pjf_proj_elements_b | TASK_ID |
FA_MASS_ADDITIONS | pjc_prj_asset_lns_all | PROJECT_ASSET_LINE_ID |
FA_MASS_ADDITIONS | poz_suppliers | PO_VENDOR_ID |
FA_MASS_ADDITIONS | fa_additions_b | GROUP_ASSET_ID |
FA_MASS_ADDITIONS | ap_invoice_payments_all | INVOICE_PAYMENT_ID |
FA_MASS_ADDITIONS | po_distributions_all | PO_DISTRIBUTION_ID |
FA_MASS_ADDITIONS | fa_book_controls | BOOK_TYPE_CODE |
FA_MASS_ADDITIONS | gl_code_combinations | PAYABLES_CODE_COMBINATION_ID |
FA_MASS_ADDITIONS | fa_methods | METHOD_ID |
FA_MASS_ADDITIONS | fa_category_books | ASSET_CATEGORY_ID, BOOK_TYPE_CODE |
FA_MASS_ADDITIONS | pjf_projects_all_b | PROJECT_ID |
FA_MASS_ADDITIONS | ap_invoice_lines_all | INVOICE_ID, INVOICE_LINE_NUMBER |
FA_MASS_ADDITIONS | fa_mass_additions | PARENT_MASS_ADDITION_ID |
fa_asset_invoices | fa_mass_additions | PARENT_MASS_ADDITION_ID |
fa_asset_invoices | fa_mass_additions | MERGE_PARENT_MASS_ADDITIONS_ID |
fa_asset_invoices | fa_mass_additions | SPLIT_PARENT_MASS_ADDITIONS_ID |
fa_massadd_distributions | fa_mass_additions | MASS_ADDITION_ID |
fa_mc_mass_rates | fa_mass_additions | MASS_ADDITION_ID |
fa_mc_mass_rates | fa_mass_additions | PARENT_MASS_ADDITION_ID |
fa_mc_asset_invoices | fa_mass_additions | PARENT_MASS_ADDITION_ID |
fa_mc_asset_invoices | fa_mass_additions | SPLIT_PARENT_MASS_ADDITIONS_ID |
fa_mc_asset_invoices | fa_mass_additions | MERGE_PARENT_MASS_ADDITIONS_ID |
fa_mass_additions | fa_mass_additions | MERGE_PARENT_MASS_ADDITIONS_ID |
fa_mass_additions | fa_mass_additions | SPLIT_PARENT_MASS_ADDITIONS_ID |
fa_mass_additions | fa_mass_additions | PARENT_MASS_ADDITION_ID |
Indexes
Index | Uniqueness | Tablespace | Columns |
---|---|---|---|
FA_MASS_ADDITIONS_N1 | Non Unique | Default | ASSET_KEY_CCID |
FA_MASS_ADDITIONS_N10 | Non Unique | Default | BOOK_TYPE_CODE, UPPER("INVOICE_NUMBER"), VENDOR_NUMBER |
FA_MASS_ADDITIONS_N11 | Non Unique | Default | MERGE_PARENT_MASS_ADDITIONS_ID |
FA_MASS_ADDITIONS_N12 | Non Unique | Default | SPLIT_PARENT_MASS_ADDITIONS_ID |
FA_MASS_ADDITIONS_N13 | Non Unique | Default | ADD_TO_ASSET_ID |
FA_MASS_ADDITIONS_N14 | Non Unique | Default | TAG_NUMBER |
FA_MASS_ADDITIONS_N15 | Non Unique | Default | CREATE_BATCH_ID |
FA_MASS_ADDITIONS_N16 | Non Unique | Default | QUEUE_NAME, BOOK_TYPE_CODE, FEEDER_SYSTEM_NAME |
FA_MASS_ADDITIONS_N17 | Non Unique | Default | INVOICE_DISTRIBUTION_ID |
FA_MASS_ADDITIONS_N2 | Non Unique | Default | ASSET_NUMBER, BOOK_TYPE_CODE |
FA_MASS_ADDITIONS_N3 | Non Unique | Default | PARENT_MASS_ADDITION_ID |
FA_MASS_ADDITIONS_N4 | Non Unique | Default | PROJECT_ID |
FA_MASS_ADDITIONS_N5 | Non Unique | Default | BOOK_TYPE_CODE, POSTING_STATUS, REQUEST_ID, WORKER_ID, PROCESS_ORDER |
FA_MASS_ADDITIONS_N6 | Non Unique | Default | PO_NUMBER |
FA_MASS_ADDITIONS_N7 | Non Unique | Default | PO_VENDOR_ID |
FA_MASS_ADDITIONS_N8 | Non Unique | Default | INVOICE_ID, AP_DISTRIBUTION_LINE_NUMBER |
FA_MASS_ADDITIONS_N9 | Non Unique | Default | MERGE_INVOICE_NUMBER, MERGE_VENDOR_NUMBER |
FA_MASS_ADDITIONS_U1 | Unique | Default | MASS_ADDITION_ID |