FA_MASS_TRX_DETAILS
FA_MASS_TRX_DETAILS contains the new transaction details for mass transaction requests. Oracle Fusion Assets uses this information when determining the new transaction details for each of the candidate assets selected based on the criteria in the FA_MASS_TRANSACTIONS table.
Details
-
Schema: FUSION
-
Object owner: FA
-
Object type: TABLE
-
Tablespace: TRANSACTION_TABLES
Columns
Name | Datatype | Length | Precision | Not-null | Comments | Status |
---|---|---|---|---|---|---|
MASS_TRANSACTION_ID | NUMBER | 18 | Yes | Identifier of the mass transaction. | Active | |
METHOD_ID | NUMBER | 18 | Identifier of the depreciation method to be assigned to candidate assets. | Active | ||
FLAT_RATE_ID | NUMBER | 18 | Identifier of the flat rate record to be assigned to candidate assets. | Active | ||
PRODUCTION_CAPACITY | NUMBER | Total production capacity to be assigned to candidate assets depreciating under a units of production depreciation method. | Active | |||
UNIT_OF_MEASURE | VARCHAR2 | 25 | Unit of measure to be assigned to candidate assets depreciating under a units of production depreciation method. | Active | ||
CONVENTION_TYPE_ID | NUMBER | 18 | Identifier of the depreciation prorate convention to be assigned to candidate assets. | Active | ||
BONUS_RULE_ID | NUMBER | 18 | Identifier of the depreciation bonus rule to be assigned to candidate assets. | Active | ||
CEILING_TYPE_ID | NUMBER | Identifier of the depreciation ceiling to be assigned to candidate assets. | Active | |||
CASH_GENERATING_UNIT_ID | NUMBER | Identifier of the cash generating unit to be assigned to candidate assets. | Active | |||
GROUP_ASSOCIATION | VARCHAR2 | 30 | Group asset association option for selected candidate assets. Association is limited to standalone or member asset type. | Active | ||
GROUP_ASSET_ID | NUMBER | 18 | Identifier of the group asset to be assigned to candidate assets. | Active | ||
DATE_PLACED_IN_SERVICE | DATE | Date to be assigned as the new date placed in service to candidate assets. | Active | |||
SALVAGE_TYPE | VARCHAR2 | 30 | Salvage type to be assigned to candidate assets. | Active | ||
SALVAGE_PERCENT | NUMBER | Salvage value percentage to be assigned to candidate assets. | Active | |||
SALVAGE_VALUE | NUMBER | Salvage value amount to be assigned to candidate assets. | Active | |||
DEPRN_LIMIT_TYPE | VARCHAR2 | 30 | Depreciation limit type to be assigned to candidate assets. | Active | ||
DEPRN_LIMIT_PERCENT | NUMBER | Depreciation limit percentage to be assigned to candidate assets. | Active | |||
DEPRN_LIMIT_AMOUNT | NUMBER | Depreciation limit amount to be assigned to candidate assets. | Active | |||
DISTRIBUTION_SET_ID | NUMBER | 18 | Identifier of the distribution set to be applied to candidate assets. | Active | ||
ASSIGNED_TO | NUMBER | 18 | Identifier of the person to be applied as the custodian of candidate assets. | Active | ||
PROCEEDS_OF_SALE | NUMBER | Total proceeds from the sale of all assets in the batch to be allocated to the candidate assets during retirement. | Active | |||
COST_OF_REMOVAL | NUMBER | Total cost of removing all the assets in the batch to be allocated to the candidate assets during retirement. | Active | |||
RETIREMENT_TYPE_CODE | VARCHAR2 | 30 | Retirement type to be assigned to the candidate assets during retirement. | Active | ||
RETIREMENT_CONVENTION_TYPE_ID | NUMBER | 18 | Identifier of the prorate convention to be assigned to the candidate assets during retirement. | Active | ||
SOLD_TO | VARCHAR2 | 30 | Name of the party to whom all the assets were sold, which will be assigned to the candidate assets during retirement. | Active | ||
REFERENCE_NUM | VARCHAR2 | 15 | Internal reference number to be assigned to the candidate assets during retirement. | Active | ||
UNITS_TO_RETIRE | NUMBER | 18 | Total number of units to retire. Used in performing unit-based retirements of the candidate assets up to this limit. | Active | ||
RET_ATTRIBUTE1 | VARCHAR2 | 150 | Descriptive Flexfield:??segment of the user descriptive flexfield. | Active | ||
RET_ATTRIBUTE2 | VARCHAR2 | 150 | Descriptive Flexfield:??segment of the user descriptive flexfield. | Active | ||
RET_ATTRIBUTE3 | VARCHAR2 | 150 | Descriptive Flexfield:??segment of the user descriptive flexfield. | Active | ||
RET_ATTRIBUTE4 | VARCHAR2 | 150 | Descriptive Flexfield:??segment of the user descriptive flexfield. | Active | ||
RET_ATTRIBUTE5 | VARCHAR2 | 150 | Descriptive Flexfield:??segment of the user descriptive flexfield. | Active | ||
RET_ATTRIBUTE6 | VARCHAR2 | 150 | Descriptive Flexfield:??segment of the user descriptive flexfield. | Active | ||
RET_ATTRIBUTE7 | VARCHAR2 | 150 | Descriptive Flexfield:??segment of the user descriptive flexfield. | Active | ||
RET_ATTRIBUTE8 | VARCHAR2 | 150 | Descriptive Flexfield:??segment of the user descriptive flexfield. | Active | ||
RET_ATTRIBUTE9 | VARCHAR2 | 150 | Descriptive Flexfield:??segment of the user descriptive flexfield. | Active | ||
RET_ATTRIBUTE10 | VARCHAR2 | 150 | Descriptive Flexfield:??segment of the user descriptive flexfield. | Active | ||
RET_ATTRIBUTE11 | VARCHAR2 | 150 | Descriptive Flexfield:??segment of the user descriptive flexfield. | Active | ||
RET_ATTRIBUTE12 | VARCHAR2 | 150 | Descriptive Flexfield:??segment of the user descriptive flexfield. | Active | ||
RET_ATTRIBUTE13 | VARCHAR2 | 150 | Descriptive Flexfield:??segment of the user descriptive flexfield. | Active | ||
RET_ATTRIBUTE14 | VARCHAR2 | 150 | Descriptive Flexfield:??segment of the user descriptive flexfield. | Active | ||
RET_ATTRIBUTE15 | VARCHAR2 | 150 | Descriptive Flexfield:??segment of the user descriptive flexfield. | Active | ||
RET_ATTRIBUTE_NUMBER1 | NUMBER | Descriptive Flexfield:??segment of the user descriptive flexfield. | Active | |||
RET_ATTRIBUTE_NUMBER2 | NUMBER | Descriptive Flexfield:??segment of the user descriptive flexfield. | Active | |||
RET_ATTRIBUTE_NUMBER3 | NUMBER | Descriptive Flexfield:??segment of the user descriptive flexfield. | Active | |||
RET_ATTRIBUTE_NUMBER4 | NUMBER | Descriptive Flexfield:??segment of the user descriptive flexfield. | Active | |||
RET_ATTRIBUTE_NUMBER5 | NUMBER | Descriptive Flexfield:??segment of the user descriptive flexfield. | Active | |||
RET_ATTRIBUTE_DATE1 | DATE | Descriptive Flexfield:??segment of the user descriptive flexfield. | Active | |||
RET_ATTRIBUTE_DATE2 | DATE | Descriptive Flexfield:??segment of the user descriptive flexfield. | Active | |||
RET_ATTRIBUTE_DATE3 | DATE | Descriptive Flexfield:??segment of the user descriptive flexfield. | Active | |||
RET_ATTRIBUTE_DATE4 | DATE | Descriptive Flexfield:??segment of the user descriptive flexfield. | Active | |||
RET_ATTRIBUTE_DATE5 | DATE | Descriptive Flexfield:??segment of the user descriptive flexfield. | Active | |||
RET_ATTRIBUTE_CATEGORY_CODE | VARCHAR2 | 30 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | Active | ||
INHERIT_DEF_RULES_FLAG | VARCHAR2 | 1 | Option indicating whether assets undergoing a change in category should inherit the depreciation rules of the new category or not. | Active | ||
COPY_CATEGORY_DFF_FLAG | VARCHAR2 | 1 | Option indicating whether to copy the descriptive flexfield information to the new category or not. | Active | ||
DEST_BOOK_TYPE_CODE | VARCHAR2 | 30 | Unique destination book identification name. | |||
CREATE_NEW_ASSET_FLAG | VARCHAR2 | 1 | Indicates whether the destination asset number is the same as the source. | |||
CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | Active | ||
CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | Active | |
LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | Active | ||
LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | Active | |
LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | Active | ||
OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | Used to implement optimistic locking. 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. | Active | |
CATEGORY_FLEX_FILTER | XMLTYPE | Key Flexfield: filter criteria for the asset category key flexfield in xml format | ||||
LOCATION_FLEX_FILTER | XMLTYPE | Key Flexfield: filter criteria for the asset location key flexfield in xml format | ||||
DEPRN_EXPENSE_FLEX_FILTER | XMLTYPE | Key Flexfield: filter criteria for the general ledger accounting key flexfield in xml format | ||||
REVAL_METHOD | VARCHAR2 | 30 | Stores the method used for revaluation. | |||
REVAL_FULLY_RSVD_FLAG | VARCHAR2 | 1 | Allows fully reserved asset revaluation. | |||
LIFE_EXTENSION_FACTOR | NUMBER | Stores the value of the life extension factor entered by the user. Used to default life extension factor for all assets in a batch. | ||||
LIFE_EXTENSION_CEILING | NUMBER | Stores the value of the life extension ceiling entered by the user. Used to default life extension ceiling for all assets in a batch. | ||||
PERIOD_END_REVAL_FLAG | VARCHAR2 | 1 | Stores the value of the include current period depreciation option entered by the user. Used to default the value of the include current period depreciation option for all assets in a batch. | |||
REVAL_VALUE_TYPE | VARCHAR2 | 30 | Stores the value type used for revaluation. | |||
LINKED_FLAG | VARCHAR2 | 1 | Allows revaluation to be linked to prior impairment transactions. | |||
REVAL_PERCENTAGE | NUMBER | Stores the revaluation percentage value. | ||||
MAX_FULLY_RSVD_REVALS | NUMBER | 18 | Stores the default value of the maximum number of revaluations allowed on a fully reserved asset. | |||
EXTENDED_DEPRN_FLAG | VARCHAR2 | 1 | Indicates whether the asset depreciation needs to be extended. | |||
PERIOD_COUNTER_EXTENDED | NUMBER | 18 | Extended depreciation start period identifier. | |||
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. | ||||
UNPLAN_EXPENSE_ACCOUNT_CCID | NUMBER | 18 | The account code combination identifier used to account the unplanned depreciation expense. | |||
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. | ||||
UPDATE_LAST_USED_INDEX_FLAG | VARCHAR2 | 1 | Specifies whether the value of the last used price index will be updated to a new value as of the revaluation date. | |||
ANNUITY_INTEREST_RATE | NUMBER | Annual interest rate used to calculate annual interest expense. |
Foreign Keys
Table | Foreign Table | Foreign Key Column |
---|---|---|
FA_MASS_TRX_DETAILS | gl_code_combinations | UNPLAN_EXPENSE_ACCOUNT_CCID |
Indexes
Index | Uniqueness | Tablespace | Columns |
---|---|---|---|
FA_MASS_TRX_DETAILS_U1 | Unique | Default | MASS_TRANSACTION_ID |