[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | FA_MASS_ADDITIONS |
|---|---|
| Object Type: | TABLE |
| Owner: | FA |
| FND Design Data: |  OFA.FA_MASS_ADDITIONS
|
| Subobject Name: | |
| Status: | VALID |
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
| Tablespace: |  APPS_TS_INTERFACE |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| FA_MASS_ADDITIONS_U1 | NORMAL | UNIQUE |
APPS_TS_INTERFACE
|
 MASS_ADDITION_ID
|
| FA_MASS_ADDITIONS_N1 | NORMAL | NONUNIQUE |
APPS_TS_INTERFACE
|
ASSET_KEY_CCID
|
| FA_MASS_ADDITIONS_N10 | NORMAL | NONUNIQUE |
APPS_TS_INTERFACE
|
INVOICE_NUMBER
BOOK_TYPE_CODE
|
| FA_MASS_ADDITIONS_N11 | NORMAL | NONUNIQUE |
APPS_TS_INTERFACE
|
MERGE_PARENT_MASS_ADDITIONS_ID
|
| FA_MASS_ADDITIONS_N12 | NORMAL | NONUNIQUE |
APPS_TS_INTERFACE
|
SPLIT_PARENT_MASS_ADDITIONS_ID
|
| FA_MASS_ADDITIONS_N13 | NORMAL | NONUNIQUE |
APPS_TS_INTERFACE
|
ADD_TO_ASSET_ID
|
| FA_MASS_ADDITIONS_N14 | NORMAL | NONUNIQUE |
APPS_TS_INTERFACE
|
TAG_NUMBER
|
| FA_MASS_ADDITIONS_N15 | NORMAL | NONUNIQUE |
APPS_TS_INTERFACE
|
CREATE_BATCH_ID
|
| FA_MASS_ADDITIONS_N16 | NORMAL | NONUNIQUE |
APPS_TS_INTERFACE
|
INVOICE_DISTRIBUTION_ID
|
| FA_MASS_ADDITIONS_N2 | NORMAL | NONUNIQUE |
APPS_TS_INTERFACE
|
ASSET_NUMBER
BOOK_TYPE_CODE
|
| FA_MASS_ADDITIONS_N3 | NORMAL | NONUNIQUE |
APPS_TS_INTERFACE
|
PARENT_MASS_ADDITION_ID
|
| FA_MASS_ADDITIONS_N4 | NORMAL | NONUNIQUE |
APPS_TS_INTERFACE
|
INVOICE_NUMBER
VENDOR_NUMBER
|
| FA_MASS_ADDITIONS_N5 | NORMAL | NONUNIQUE |
APPS_TS_INTERFACE
|
POSTING_STATUS
BOOK_TYPE_CODE
REQUEST_ID
WORKER_ID
PROCESS_ORDER
|
| FA_MASS_ADDITIONS_N6 | NORMAL | NONUNIQUE |
APPS_TS_INTERFACE
|
PO_NUMBER
|
| FA_MASS_ADDITIONS_N7 | NORMAL | NONUNIQUE |
APPS_TS_INTERFACE
|
PO_VENDOR_ID
|
| FA_MASS_ADDITIONS_N8 | NORMAL | NONUNIQUE |
APPS_TS_INTERFACE
|
INVOICE_ID
AP_DISTRIBUTION_LINE_NUMBER
|
| FA_MASS_ADDITIONS_N9 | NORMAL | NONUNIQUE |
APPS_TS_INTERFACE
|
MERGE_INVOICE_NUMBER
MERGE_VENDOR_NUMBER
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| MASS_ADDITION_ID | NUMBER | (15) | Unique identification number of the mass addition | |
| ASSET_NUMBER | VARCHAR2 | (15) | Asset number entered by the user | |
| TAG_NUMBER | VARCHAR2 | (15) | Tag number of the asset | |
| DESCRIPTION | VARCHAR2 | (80) | Asset description | |
| ASSET_CATEGORY_ID | NUMBER | (15) | Identifies the asset category | |
| MANUFACTURER_NAME | VARCHAR2 | (360) | Name of the manufacturer | |
| SERIAL_NUMBER | VARCHAR2 | (35) | Serial number | |
| MODEL_NUMBER | VARCHAR2 | (40) | Model number | |
| BOOK_TYPE_CODE | VARCHAR2 | (15) | Book name | |
| DATE_PLACED_IN_SERVICE | DATE | Date placed in service of the asset | ||
| FIXED_ASSETS_COST | NUMBER | Cost of the asset in Oracle Assets | ||
| PAYABLES_UNITS | NUMBER | Number of units from accounts payable | ||
| FIXED_ASSETS_UNITS | NUMBER | Number of units in Oracle Assets | ||
| PAYABLES_CODE_COMBINATION_ID | NUMBER | (15) | Account debited in accounts payable | |
| EXPENSE_CODE_COMBINATION_ID | NUMBER | (15) | Identifies depreciation expense account | |
| LOCATION_ID | NUMBER | (15) | Identifies the location | |
| ASSIGNED_TO | NUMBER | (15) | Identifies the employee to whom the asset is assigned | |
| FEEDER_SYSTEM_NAME | VARCHAR2 | (40) | Identifies the system from which the mass addition was created | |
| CREATE_BATCH_DATE | DATE | System date of the mass additions create program | ||
| CREATE_BATCH_ID | NUMBER | (15) | Concurrent request identification number of mass additions create program | |
| LAST_UPDATE_DATE | DATE | Standard Who column | ||
| LAST_UPDATED_BY | NUMBER | Standard Who column | ||
| REVIEWER_COMMENTS | VARCHAR2 | (60) | Comments. This information is for reviewing during the Mass Additions Process only. Mass Additions Post does not propagate it to other Oracle Assets tables | |
| INVOICE_NUMBER | VARCHAR2 | (50) | Invoice number from accounts payable | |
| VENDOR_NUMBER | VARCHAR2 | (30) | Supplier number entered by the user from purchasing through accounts payable | |
| PO_VENDOR_ID | NUMBER | (15) | Supplier identification number from purchasing through accounts payable | |
| PO_NUMBER | VARCHAR2 | (20) | Purchase Order number entered by the user from purchasing through accounts payable | |
| POSTING_STATUS | VARCHAR2 | (15) | Shows the status of the mass addition | |
| QUEUE_NAME | VARCHAR2 | (15) | Mass addition queue name | |
| INVOICE_DATE | DATE | Invoice date | ||
| INVOICE_CREATED_BY | NUMBER | (15) | Userid of the person who created the invoice | |
| INVOICE_UPDATED_BY | NUMBER | (15) | Userid of the person who updated the invoice | |
| PAYABLES_COST | NUMBER | Cost of the asset in accounts payable | ||
| INVOICE_ID | NUMBER | (15) | Invoice identification number in accounts payable | |
| PAYABLES_BATCH_NAME | VARCHAR2 | (50) | Payables batch name of invoices | |
| DEPRECIATE_FLAG | VARCHAR2 | (3) | Identifies whether the asset should be depreciated or not | |
| PARENT_MASS_ADDITION_ID | NUMBER | (15) | Identifies the mass addition into which you merged this mass addition | |
| PARENT_ASSET_ID | NUMBER | (15) | Identifies the parent asset of a mass addition | |
| SPLIT_MERGED_CODE | VARCHAR2 | (3) | Identifies if a mass addition was split or merged | |
| AP_DISTRIBUTION_LINE_NUMBER | NUMBER | (15) | Distribution line number from accounts payable | |
| POST_BATCH_ID | NUMBER | (15) | Unique identification number for a mass additions post request | |
| ADD_TO_ASSET_ID | NUMBER | (15) | Identifies the asset to which to apply the mass addition as a cost adjustment | |
| AMORTIZE_FLAG | VARCHAR2 | (3) | Identifies whether cost adjustment should be amortized or expensed | |
| NEW_MASTER_FLAG | VARCHAR2 | (3) | Determines whether to reclassify the asset which is being adjusted | |
| ASSET_KEY_CCID | NUMBER | (15) | Unique identification number for the asset key flexfield | |
| ASSET_TYPE | VARCHAR2 | (11) | Type of the asset | |
| DEPRN_RESERVE | NUMBER | Depreciation reserve of the asset | ||
| YTD_DEPRN | NUMBER | Year-to-date depreciation expense of the asset | ||
| BEGINNING_NBV | NUMBER | Beginning net book value of the asset | ||
| CREATED_BY | NUMBER | (15) | Standard Who column | |
| CREATION_DATE | DATE | Standard Who column | ||
| LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who column | |
| SALVAGE_VALUE | NUMBER | Salvage value of the asset. Oracle Assets does not include the salvage value in the recoverable cost when you add a mass addition to an existing asset. | ||
| ACCOUNTING_DATE | DATE | Accounting date from AP_INVOICE_DISTRIBUTIONS | ||
| ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE_CATEGORY_CODE | VARCHAR2 | (30) | Descriptive flexfield structure defining column | |
| FULLY_RSVD_REVALS_COUNTER | NUMBER | Number of times an asset has been revalued as fully reserved | ||
| MERGE_INVOICE_NUMBER | VARCHAR2 | (50) | Invoice number of a mass addition line merged parent | |
| MERGE_VENDOR_NUMBER | VARCHAR2 | (30) | Supplier number of a mass addition line merged parent | |
| PRODUCTION_CAPACITY | NUMBER | Capacity of a units of production asset | ||
| REVAL_AMORTIZATION_BASIS | NUMBER | Revaluation reserve used in calculating amortization of revaluation reserve. Updated only when the asset is revalued or has an amortized adjustment | ||
| REVAL_RESERVE | NUMBER | For a period in which this asset was revalued: change in net book value due to revaluation of asset cost and sometimes also revaluation of depreciation reserve. For all other periods: revaluation reserve amount after depreciation run | ||
| UNIT_OF_MEASURE | VARCHAR2 | (25) | Unit of measure for a units of production asset | |
| UNREVALUED_COST | NUMBER | Cost without regard to any revaluations | ||
| YTD_REVAL_DEPRN_EXPENSE | NUMBER | Year-to-date depreciation expense due to revaluation. Oracle Assets does not create any journal entries for this amount. It is for reporting only | ||
| ATTRIBUTE16 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE17 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE18 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE19 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE20 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE21 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE22 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE23 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE24 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE25 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE26 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE27 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE28 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE29 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE30 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| MERGED_CODE | VARCHAR2 | (3) | Indicates if the mass addition is a merged parent of a merged child | |
| SPLIT_CODE | VARCHAR2 | (3) | Indicates if the mass addition is a split parent or a split child | |
| MERGE_PARENT_MASS_ADDITIONS_ID | NUMBER | (15) | Merged parent mass addition ID | |
| SPLIT_PARENT_MASS_ADDITIONS_ID | NUMBER | (15) | Split parent mass addition ID | |
| PROJECT_ASSET_LINE_ID | NUMBER | (15) | Identifier of the summarized asset cost line transferred from Oracle Projects to create this line | |
| PROJECT_ID | NUMBER | (15) | Identifier of the project from which the costs were collected, summarized, and transferred from Oracle Projects | |
| TASK_ID | NUMBER | (15) | Identifier of the task from which costs were collected, summarized, and transferred from Oracle Projects. This column is only populated if the costs were summarized by task | |
| SUM_UNITS | VARCHAR2 | (3) | Indicates whether to sum the units of merged mass additions | |
| DIST_NAME | VARCHAR2 | (25) | Name of the distribution set | |
| GLOBAL_ATTRIBUTE1 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE2 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE3 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE4 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE5 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE6 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE7 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE8 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE9 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE10 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE11 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE12 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE13 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE14 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE15 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE16 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE17 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE18 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE19 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE20 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Reserved for country-specific functionality | |
| CONTEXT | VARCHAR2 | (210) | Structure defining column for descriptive flexfield | |
| INVENTORIAL | VARCHAR2 | (3) | Indicates whether the asset should be included in physical inventory | |
| SHORT_FISCAL_YEAR_FLAG | VARCHAR2 | (3) | Indicated if asset is added in a short fiscal year | |
| CONVERSION_DATE | DATE | Date short fiscal year asset added to the acquiring company | ||
| ORIGINAL_DEPRN_START_DATE | DATE | Date short fiscal year asset began depreciating in the acquired company's books | ||
| GROUP_ASSET_ID | NUMBER | Reserved for system use. Do not use. | ||
| CUA_PARENT_HIERARCHY_ID | NUMBER | Reserved for system use. Do not use. | ||
| UNITS_TO_ADJUST | NUMBER | (15) | Reserved for system use. Do not use. | |
| BONUS_YTD_DEPRN | NUMBER | Year-to-date bonus depreciation expense of the asset. Amount should be included in ytd_deprn. | ||
| BONUS_DEPRN_RESERVE | NUMBER | Bonus depreciation reserve of the asset. Amount should be included in deprn_reserve. | ||
| AMORTIZE_NBV_FLAG | VARCHAR2 | (1) | Determines whether to enable the asset to amortize the NBV over remaining useful life | |
| AMORTIZATION_START_DATE | DATE | Date to start amortizing the NBV for an asset if the amortize_nbv_flag is set to Y | ||
| TRANSACTION_TYPE_CODE | VARCHAR2 | (20) | Identifies the type of future transaction as FUTURE ADD, FUTURE ADJ or FUTURE CAP | |
| TRANSACTION_DATE | DATE | Date on which the transaction is processed | ||
| WARRANTY_ID | NUMBER | (15) | Identifier of the warranty number | |
| LEASE_ID | NUMBER | (15) | Identifier of the lease number | |
| LESSOR_ID | NUMBER | (15) | Identifier of the lessor number | |
| PROPERTY_TYPE_CODE | VARCHAR2 | (10) | Indicates the property type | |
| PROPERTY_1245_1250_CODE | VARCHAR2 | (4) | Indicates the property type class is 1245(personal) or 1250 (real) | |
| IN_USE_FLAG | VARCHAR2 | (3) | Indicates whether the asset is in use | |
| OWNED_LEASED | VARCHAR2 | (15) | Indicates whether the asset is owned or leased | |
| NEW_USED | VARCHAR2 | (4) | Indicates whether the asset is new or used | |
| ASSET_ID | NUMBER | (15) | System generated unique Identifier of the Asset | |
| MATERIAL_INDICATOR_FLAG | VARCHAR2 | (1) | Indicates whether source line is of material or non-material nature. | |
| DEPRN_METHOD_CODE | VARCHAR2 | (12) | Name of the depreciation method for the asset | |
| LIFE_IN_MONTHS | NUMBER | (4) | Life of the asset in total months | |
| BASIC_RATE | NUMBER | Base rate used to calculate depreciation amount for flat rate methods | ||
| ADJUSTED_RATE | NUMBER | Actual rate used to calculate depreciation for flat rate methods | ||
| PRORATE_CONVENTION_CODE | VARCHAR2 | (10) | Depreciation prorate convention | |
| BONUS_RULE | VARCHAR2 | (30) | Identifies the bonus rule to use in calculating depreciation for the flat rate methods | |
| SALVAGE_TYPE | VARCHAR2 | (30) | Indicates whether the salvage type is the amount, percentage, or sum of member assets | |
| PERCENT_SALVAGE_VALUE | NUMBER | Salvage value percentage amount | ||
| DEPRN_LIMIT_TYPE | VARCHAR2 | (30) | Indicates whether the depreciation limit type is the amount, percentage, sum of member assets, or no depreciation limit type(NONE) | |
| ALLOWED_DEPRN_LIMIT | NUMBER | The default depreciation limit as a percentage of cost | ||
| ALLOWED_DEPRN_LIMIT_AMOUNT | NUMBER | Cost without regard to any revaluations | ||
| WARRANTY_NUMBER | VARCHAR2 | (15) | User assigned warranty number | |
| INVOICE_LINE_NUMBER | NUMBER | Invoice line number | ||
| INVOICE_DISTRIBUTION_ID | NUMBER | (15) | Invoice distribution identifier | |
| PO_DISTRIBUTION_ID | NUMBER | (15) | Purchase order distribution identifier | |
| ASSET_KEY_SEGMENT1 | VARCHAR2 | (30) | Key flexfield segment for the asset key | |
| ASSET_KEY_SEGMENT2 | VARCHAR2 | (30) | Key flexfield segment for the asset key | |
| ASSET_KEY_SEGMENT3 | VARCHAR2 | (30) | Key flexfield segment for the asset key | |
| ASSET_KEY_SEGMENT4 | VARCHAR2 | (30) | Key flexfield segment for the asset key | |
| ASSET_KEY_SEGMENT5 | VARCHAR2 | (30) | Key flexfield segment for the asset key | |
| ASSET_KEY_SEGMENT6 | VARCHAR2 | (30) | Key flexfield segment for the asset key | |
| ASSET_KEY_SEGMENT7 | VARCHAR2 | (30) | Key flexfield segment for the asset key | |
| ASSET_KEY_SEGMENT8 | VARCHAR2 | (30) | Key flexfield segment for the asset key | |
| ASSET_KEY_SEGMENT9 | VARCHAR2 | (30) | Key flexfield segment for the asset key | |
| ASSET_KEY_SEGMENT10 | VARCHAR2 | (30) | Key flexfield segment for the asset key | |
| REQUEST_ID | NUMBER | (15) | Internal identifier for the parent request ID of the Mass Additions posting program. | |
| WORKER_ID | NUMBER | (15) | Internal identifier for parallel processing | |
| PROCESS_ORDER | NUMBER | (15) | Internal identifier indicating the order in which transactions should be processed | |
| MASS_PROPERTY_FLAG | VARCHAR2 | (1) | Identifies whether the line is to undergo mass property allocation. Internal use only - leave null during upload. | |
| INVOICE_PAYMENT_ID | NUMBER | (15) | Invoice payment identifier | |
| TH_ATTRIBUTE1 | VARCHAR2 | (150) | Transaction-level descriptive flexfield segment | |
| TH_ATTRIBUTE2 | VARCHAR2 | (150) | Transaction-level descriptive flexfield segment | |
| TH_ATTRIBUTE3 | VARCHAR2 | (150) | Transaction-level descriptive flexfield segment | |
| TH_ATTRIBUTE4 | VARCHAR2 | (150) | Transaction-level descriptive flexfield segment | |
| TH_ATTRIBUTE5 | VARCHAR2 | (150) | Transaction-level descriptive flexfield segment | |
| TH_ATTRIBUTE6 | VARCHAR2 | (150) | Transaction-level descriptive flexfield segment | |
| TH_ATTRIBUTE7 | VARCHAR2 | (150) | Transaction-level descriptive flexfield segment | |
| TH_ATTRIBUTE8 | VARCHAR2 | (150) | Transaction-level descriptive flexfield segment | |
| TH_ATTRIBUTE9 | VARCHAR2 | (150) | Transaction-level descriptive flexfield segment | |
| TH_ATTRIBUTE10 | VARCHAR2 | (150) | Transaction-level descriptive flexfield segment | |
| TH_ATTRIBUTE11 | VARCHAR2 | (150) | Transaction-level descriptive flexfield segment | |
| TH_ATTRIBUTE12 | VARCHAR2 | (150) | Transaction-level descriptive flexfield segment | |
| TH_ATTRIBUTE13 | VARCHAR2 | (150) | Transaction-level descriptive flexfield segment | |
| TH_ATTRIBUTE14 | VARCHAR2 | (150) | Transaction-level descriptive flexfield segment | |
| TH_ATTRIBUTE15 | VARCHAR2 | (150) | Transaction-level descriptive flexfield segment | |
| TH_ATTRIBUTE_CATEGORY_CODE | VARCHAR2 | (30) | Descriptive flexfield structure defining segment | |
| NBV_AT_SWITCH | NUMBER | The net book value of an asset at the date the original rate was switched to the revised rate. | ||
| PERIOD_FULL_RESERVE | VARCHAR2 | (30) | The period in which the asset became fully reserved. | |
| PERIOD_EXTD_DEPRN | VARCHAR2 | (30) | The first period for which the asset begins extended depreciation. | |
| PRIOR_DEPRN_LIMIT_TYPE | VARCHAR2 | (30) | The depreciation limit type for the asset immediately before it began extended depreciation. | |
| PRIOR_DEPRN_LIMIT_AMOUNT | NUMBER | The depreciation limit amount for the asset immediately before it began extended depreciation. | ||
| PRIOR_DEPRN_LIMIT | NUMBER | The depreciation limit as a percentage of cost for the asset immediately before it began extended depreciation. | ||
| PRIOR_DEPRN_METHOD | VARCHAR2 | (12) | The depreciation method for the asset immediately before it began extended depreciation. | |
| PRIOR_LIFE_IN_MONTHS | NUMBER | (6) | The life in months for the asset immediately before it began extended depreciation. | |
| PRIOR_BASIC_RATE | NUMBER | The basic rate of the asset immediately before it began extended depreciation. | ||
| PRIOR_ADJUSTED_RATE | NUMBER | The adjusted rate of the asset immediately before it began extended depreciation. | ||
| ADJUSTED_COST | NUMBER | Cost of the asset in Oracle Assets |
Cut, paste (and edit) the following text to query this object:
SELECT MASS_ADDITION_ID
, ASSET_NUMBER
, TAG_NUMBER
, DESCRIPTION
, ASSET_CATEGORY_ID
, MANUFACTURER_NAME
, SERIAL_NUMBER
, MODEL_NUMBER
, BOOK_TYPE_CODE
, DATE_PLACED_IN_SERVICE
, FIXED_ASSETS_COST
, PAYABLES_UNITS
, FIXED_ASSETS_UNITS
, PAYABLES_CODE_COMBINATION_ID
, EXPENSE_CODE_COMBINATION_ID
, LOCATION_ID
, ASSIGNED_TO
, FEEDER_SYSTEM_NAME
, CREATE_BATCH_DATE
, CREATE_BATCH_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, REVIEWER_COMMENTS
, INVOICE_NUMBER
, VENDOR_NUMBER
, PO_VENDOR_ID
, PO_NUMBER
, POSTING_STATUS
, QUEUE_NAME
, INVOICE_DATE
, INVOICE_CREATED_BY
, INVOICE_UPDATED_BY
, PAYABLES_COST
, INVOICE_ID
, PAYABLES_BATCH_NAME
, DEPRECIATE_FLAG
, PARENT_MASS_ADDITION_ID
, PARENT_ASSET_ID
, SPLIT_MERGED_CODE
, AP_DISTRIBUTION_LINE_NUMBER
, POST_BATCH_ID
, ADD_TO_ASSET_ID
, AMORTIZE_FLAG
, NEW_MASTER_FLAG
, ASSET_KEY_CCID
, ASSET_TYPE
, DEPRN_RESERVE
, YTD_DEPRN
, BEGINNING_NBV
, CREATED_BY
, CREATION_DATE
, LAST_UPDATE_LOGIN
, SALVAGE_VALUE
, ACCOUNTING_DATE
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ATTRIBUTE_CATEGORY_CODE
, FULLY_RSVD_REVALS_COUNTER
, MERGE_INVOICE_NUMBER
, MERGE_VENDOR_NUMBER
, PRODUCTION_CAPACITY
, REVAL_AMORTIZATION_BASIS
, REVAL_RESERVE
, UNIT_OF_MEASURE
, UNREVALUED_COST
, YTD_REVAL_DEPRN_EXPENSE
, ATTRIBUTE16
, ATTRIBUTE17
, ATTRIBUTE18
, ATTRIBUTE19
, ATTRIBUTE20
, ATTRIBUTE21
, ATTRIBUTE22
, ATTRIBUTE23
, ATTRIBUTE24
, ATTRIBUTE25
, ATTRIBUTE26
, ATTRIBUTE27
, ATTRIBUTE28
, ATTRIBUTE29
, ATTRIBUTE30
, MERGED_CODE
, SPLIT_CODE
, MERGE_PARENT_MASS_ADDITIONS_ID
, SPLIT_PARENT_MASS_ADDITIONS_ID
, PROJECT_ASSET_LINE_ID
, PROJECT_ID
, TASK_ID
, SUM_UNITS
, DIST_NAME
, GLOBAL_ATTRIBUTE1
, GLOBAL_ATTRIBUTE2
, GLOBAL_ATTRIBUTE3
, GLOBAL_ATTRIBUTE4
, GLOBAL_ATTRIBUTE5
, GLOBAL_ATTRIBUTE6
, GLOBAL_ATTRIBUTE7
, GLOBAL_ATTRIBUTE8
, GLOBAL_ATTRIBUTE9
, GLOBAL_ATTRIBUTE10
, GLOBAL_ATTRIBUTE11
, GLOBAL_ATTRIBUTE12
, GLOBAL_ATTRIBUTE13
, GLOBAL_ATTRIBUTE14
, GLOBAL_ATTRIBUTE15
, GLOBAL_ATTRIBUTE16
, GLOBAL_ATTRIBUTE17
, GLOBAL_ATTRIBUTE18
, GLOBAL_ATTRIBUTE19
, GLOBAL_ATTRIBUTE20
, GLOBAL_ATTRIBUTE_CATEGORY
, CONTEXT
, INVENTORIAL
, SHORT_FISCAL_YEAR_FLAG
, CONVERSION_DATE
, ORIGINAL_DEPRN_START_DATE
, GROUP_ASSET_ID
, CUA_PARENT_HIERARCHY_ID
, UNITS_TO_ADJUST
, BONUS_YTD_DEPRN
, BONUS_DEPRN_RESERVE
, AMORTIZE_NBV_FLAG
, AMORTIZATION_START_DATE
, TRANSACTION_TYPE_CODE
, TRANSACTION_DATE
, WARRANTY_ID
, LEASE_ID
, LESSOR_ID
, PROPERTY_TYPE_CODE
, PROPERTY_1245_1250_CODE
, IN_USE_FLAG
, OWNED_LEASED
, NEW_USED
, ASSET_ID
, MATERIAL_INDICATOR_FLAG
, DEPRN_METHOD_CODE
, LIFE_IN_MONTHS
, BASIC_RATE
, ADJUSTED_RATE
, PRORATE_CONVENTION_CODE
, BONUS_RULE
, SALVAGE_TYPE
, PERCENT_SALVAGE_VALUE
, DEPRN_LIMIT_TYPE
, ALLOWED_DEPRN_LIMIT
, ALLOWED_DEPRN_LIMIT_AMOUNT
, WARRANTY_NUMBER
, INVOICE_LINE_NUMBER
, INVOICE_DISTRIBUTION_ID
, PO_DISTRIBUTION_ID
, ASSET_KEY_SEGMENT1
, ASSET_KEY_SEGMENT2
, ASSET_KEY_SEGMENT3
, ASSET_KEY_SEGMENT4
, ASSET_KEY_SEGMENT5
, ASSET_KEY_SEGMENT6
, ASSET_KEY_SEGMENT7
, ASSET_KEY_SEGMENT8
, ASSET_KEY_SEGMENT9
, ASSET_KEY_SEGMENT10
, REQUEST_ID
, WORKER_ID
, PROCESS_ORDER
, MASS_PROPERTY_FLAG
, INVOICE_PAYMENT_ID
, TH_ATTRIBUTE1
, TH_ATTRIBUTE2
, TH_ATTRIBUTE3
, TH_ATTRIBUTE4
, TH_ATTRIBUTE5
, TH_ATTRIBUTE6
, TH_ATTRIBUTE7
, TH_ATTRIBUTE8
, TH_ATTRIBUTE9
, TH_ATTRIBUTE10
, TH_ATTRIBUTE11
, TH_ATTRIBUTE12
, TH_ATTRIBUTE13
, TH_ATTRIBUTE14
, TH_ATTRIBUTE15
, TH_ATTRIBUTE_CATEGORY_CODE
, NBV_AT_SWITCH
, PERIOD_FULL_RESERVE
, PERIOD_EXTD_DEPRN
, PRIOR_DEPRN_LIMIT_TYPE
, PRIOR_DEPRN_LIMIT_AMOUNT
, PRIOR_DEPRN_LIMIT
, PRIOR_DEPRN_METHOD
, PRIOR_LIFE_IN_MONTHS
, PRIOR_BASIC_RATE
, PRIOR_ADJUSTED_RATE
, ADJUSTED_COST
FROM FA.FA_MASS_ADDITIONS;
FA.FA_MASS_ADDITIONS does not reference any database object
FA.FA_MASS_ADDITIONS is referenced by following:
FA
FA_MASS_ADDITIONS#
|
|
|
|