FA_DELETED_MASS_ADDITIONS
FA_DELETED_MASS_ADDITIONS contains information about the mass additions that are deleted for audit trail. The delete mass additions process inserts a row into this table for each mass addition that has a POSTING_STATUS of DELETE in FA_MASS_ADDITIONS for the asset book. The mass additions purge process will delete the records in this table.
Details
-
Schema: FUSION
-
Object owner: FA
-
Object type: TABLE
-
Tablespace: INTERFACE
Primary Key
Name | Columns |
---|---|
FA_DELETED_MASS_ADDITIONS_PK |
MASS_ADDITION_ID |
Columns
Name | Datatype | Length | Precision | Not-null | Comments |
---|---|---|---|---|---|
STATUS | VARCHAR2 | 1 | Mass addition line preparation, processing and posting status. | ||
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 | Asset model identification number. | ||
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: indicates the date and time of the last update of the row. | ||
LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the 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: indicates the user who created the row. | |
CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the 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 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE11 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE12 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE13 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE14 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE15 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
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 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE17 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE18 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE19 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE20 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE21 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE22 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE23 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE24 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE25 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE26 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE27 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE28 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE29 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE30 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE_NUMBER1 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_NUMBER2 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_NUMBER3 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_NUMBER4 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_NUMBER5 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_DATE1 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_DATE2 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_DATE3 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_DATE4 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_DATE5 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
GLOBAL_ATTRIBUTE_CATEGORY | VARCHAR2 | 30 | Global Descriptive Flexfield: structure definition of the global descriptive flexfield. | ||
GLOBAL_ATTRIBUTE1 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
GLOBAL_ATTRIBUTE2 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
GLOBAL_ATTRIBUTE3 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
GLOBAL_ATTRIBUTE4 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
GLOBAL_ATTRIBUTE5 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
GLOBAL_ATTRIBUTE6 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
GLOBAL_ATTRIBUTE7 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
GLOBAL_ATTRIBUTE8 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
GLOBAL_ATTRIBUTE9 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
GLOBAL_ATTRIBUTE10 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
GLOBAL_ATTRIBUTE11 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
GLOBAL_ATTRIBUTE12 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
GLOBAL_ATTRIBUTE13 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
GLOBAL_ATTRIBUTE14 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
GLOBAL_ATTRIBUTE15 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
GLOBAL_ATTRIBUTE16 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
GLOBAL_ATTRIBUTE17 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
GLOBAL_ATTRIBUTE18 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
GLOBAL_ATTRIBUTE19 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
GLOBAL_ATTRIBUTE20 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
GLOBAL_ATTRIBUTE_NUMBER1 | NUMBER | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
GLOBAL_ATTRIBUTE_NUMBER2 | NUMBER | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
GLOBAL_ATTRIBUTE_NUMBER3 | NUMBER | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
GLOBAL_ATTRIBUTE_NUMBER4 | NUMBER | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
GLOBAL_ATTRIBUTE_NUMBER5 | NUMBER | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
GLOBAL_ATTRIBUTE_DATE1 | DATE | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
GLOBAL_ATTRIBUTE_DATE2 | DATE | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
GLOBAL_ATTRIBUTE_DATE3 | DATE | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
GLOBAL_ATTRIBUTE_DATE4 | DATE | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
GLOBAL_ATTRIBUTE_DATE5 | DATE | Global Descriptive Flexfield: segment of the 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. | ||
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 | Enterprise Service Scheduler: indicates the 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. This number is incremented every time that the row is updated. The number is 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. | ||
TH_ATTRIBUTE2 | VARCHAR2 | 150 | Segment value for Transactions descriptive flexfield. Used for ADDITION transaction type. | ||
TH_ATTRIBUTE3 | VARCHAR2 | 150 | Segment value for Transactions descriptive flexfield. Used for ADDITION transaction type. | ||
TH_ATTRIBUTE4 | VARCHAR2 | 150 | Segment value for Transactions descriptive flexfield. Used for ADDITION transaction type. | ||
TH_ATTRIBUTE5 | VARCHAR2 | 150 | Segment value for Transactions descriptive flexfield. Used for ADDITION transaction type. | ||
TH_ATTRIBUTE6 | VARCHAR2 | 150 | Segment value for Transactions descriptive flexfield. Used for ADDITION transaction type. | ||
TH_ATTRIBUTE7 | VARCHAR2 | 150 | Segment value for Transactions descriptive flexfield. Used for ADDITION transaction type. | ||
TH_ATTRIBUTE8 | VARCHAR2 | 150 | Segment value for Transactions descriptive flexfield. Used for ADDITION transaction type. | ||
TH_ATTRIBUTE9 | VARCHAR2 | 150 | Segment value for Transactions descriptive flexfield. Used for ADDITION transaction type. | ||
TH_ATTRIBUTE10 | VARCHAR2 | 150 | Segment value for Transactions descriptive flexfield. Used for ADDITION transaction type. | ||
TH_ATTRIBUTE11 | VARCHAR2 | 150 | Segment value for Transactions descriptive flexfield. Used for ADDITION transaction type. | ||
TH_ATTRIBUTE12 | VARCHAR2 | 150 | Segment value for Transactions descriptive flexfield. Used for ADDITION transaction type. | ||
TH_ATTRIBUTE13 | VARCHAR2 | 150 | Segment value for Transactions descriptive flexfield. Used for ADDITION transaction type. | ||
TH_ATTRIBUTE14 | VARCHAR2 | 150 | Segment value for Transactions descriptive flexfield. Used for ADDITION transaction type. | ||
TH_ATTRIBUTE15 | VARCHAR2 | 150 | Segment value for Transactions descriptive flexfield. Used for ADDITION transaction type. | ||
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. | ||
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. | ||
AI_ATTRIBUTE2 | VARCHAR2 | 150 | Segment value for Assets Invoices descriptive flexfield. | ||
AI_ATTRIBUTE3 | VARCHAR2 | 150 | Segment value for Assets Invoices descriptive flexfield. | ||
AI_ATTRIBUTE4 | VARCHAR2 | 150 | Segment value for Assets Invoices descriptive flexfield. | ||
AI_ATTRIBUTE5 | VARCHAR2 | 150 | Segment value for Assets Invoices descriptive flexfield. | ||
AI_ATTRIBUTE6 | VARCHAR2 | 150 | Segment value for Assets Invoices descriptive flexfield. | ||
AI_ATTRIBUTE7 | VARCHAR2 | 150 | Segment value for Assets Invoices descriptive flexfield. | ||
AI_ATTRIBUTE8 | VARCHAR2 | 150 | Segment value for Assets Invoices descriptive flexfield. | ||
AI_ATTRIBUTE9 | VARCHAR2 | 150 | Segment value for Assets Invoices descriptive flexfield. | ||
AI_ATTRIBUTE10 | VARCHAR2 | 150 | Segment value for Assets Invoices descriptive flexfield. | ||
AI_ATTRIBUTE11 | VARCHAR2 | 150 | Segment value for Assets Invoices descriptive flexfield. | ||
AI_ATTRIBUTE12 | VARCHAR2 | 150 | Segment value for Assets Invoices descriptive flexfield. | ||
AI_ATTRIBUTE13 | VARCHAR2 | 150 | Segment value for Assets Invoices descriptive flexfield. | ||
AI_ATTRIBUTE14 | VARCHAR2 | 150 | Segment value for Assets Invoices descriptive flexfield. | ||
AI_ATTRIBUTE15 | VARCHAR2 | 150 | Segment value for Assets Invoices descriptive flexfield. | ||
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. | ||
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 | Net book value at switch. | |||
PERIOD_FULL_RESERVE | VARCHAR2 | 30 | No longer used. | ||
PERIOD_EXTD_DEPRN | VARCHAR2 | 30 | No longer used. | ||
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. | ||
IB_REFERENCE_ID | NUMBER | 18 | The reference identifier used to link a fixed asset with an installed base asset. |
Foreign Keys
Table | Foreign Table | Foreign Key Column |
---|---|---|
FA_DELETED_MASS_ADDITIONS | pjf_proj_elements_b | TASK_ID |
FA_DELETED_MASS_ADDITIONS | fa_book_controls | BOOK_TYPE_CODE |
FA_DELETED_MASS_ADDITIONS | pjc_prj_asset_lns_all | PROJECT_ASSET_LINE_ID |
FA_DELETED_MASS_ADDITIONS | gl_code_combinations | PAYABLES_CODE_COMBINATION_ID |
Indexes
Index | Uniqueness | Tablespace | Columns |
---|---|---|---|
FA_DELETED_MASS_ADDITIONS_U1 | Unique | Default | MASS_ADDITION_ID |