FA_MASS_TRANSACTIONS
FA_MASS_TRANSACTIONS contains information about mass transaction requests. Oracle Fusion Assets stores basic information about the transactions, as well as the criteria used to select all candidate assets for the mass transactions in this table.
Details
-
Schema: FUSION
-
Object owner: FA
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
FA_MASS_TRANSACTIONS_PK |
MASS_TRANSACTION_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| MASS_TRANSACTION_ID | NUMBER | 18 | Yes | Identifier number of the mass transaction. | |
| BOOK_TYPE_CODE | VARCHAR2 | 30 | Yes | Name of the asset book for which the mass transaction is defined. | |
| BATCH_NAME | VARCHAR2 | 120 | Unique user-defined name for the mass transaction. | ||
| BATCH_STATUS | VARCHAR2 | 30 | Yes | Overall status for the mass transaction batch. Possible values are NEW, IN PROGRESS, and POSTED. | |
| MASS_TRANSACTION_TYPE_CODE | VARCHAR2 | 30 | Yes | Mass transaction classification. Possible values are FINANCIAL, RETIREMENT, and TRANSFER. | |
| TRANSACTION_TYPE_CODE | VARCHAR2 | 30 | Yes | Detailed transaction type for the various mass transactions. Possible values are ADJUSTMENT, GROUP CHANGE, RECLASS, SUSPEND, and RESUME. | |
| TRANSACTION_DATE_ENTERED | DATE | Transaction date for the selected transaction type. | |||
| TRANSACTION_NAME | VARCHAR2 | 240 | User-defined description of the mass transaction. | ||
| AMORTIZE_FLAG | VARCHAR2 | 1 | Option indicating whether the transaction is to be amortized or not. | ||
| CREATE_REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the asset candidate selection job that created or last updated the row. | ||
| POST_REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the interface posting job that created or last updated the row. | ||
| FROM_ASSET_NUMBER | VARCHAR2 | 30 | Starting value of the asset number range used to select candidate assets. | ||
| TO_ASSET_NUMBER | VARCHAR2 | 30 | Ending value of the asset number range used to select candidate assets. | ||
| FROM_DATE_PLACED_IN_SERVICE | DATE | Starting value of the date placed in service range used to select candidate assets. | |||
| TO_DATE_PLACED_IN_SERVICE | DATE | Ending value of the date placed in service range used to select candidate assets. | |||
| FROM_COST | NUMBER | Starting value of the cost range used to select candidate assets. | |||
| TO_COST | NUMBER | Ending value of the cost range used to select candidate assets. | |||
| ASSET_TYPE | VARCHAR2 | 11 | Asset type used to select candidate assets. Possible asset types are capitalized, expensed, construction in process, or group. | ||
| MANUFACTURER_NAME | VARCHAR2 | 360 | Manufacturer name used to select candidate assets. | ||
| MODEL_NUMBER | VARCHAR2 | 40 | Model number used to select candidate assets. | ||
| SERIAL_NUMBER | VARCHAR2 | 35 | Serial number used to select candidate assets. | ||
| TAG_NUMBER | VARCHAR2 | 15 | Tag number used to select candidate assets. | ||
| METHOD_CODE | VARCHAR2 | 12 | Depreciation method used to select candidate assets. | ||
| LIFE_IN_YEARS | NUMBER | 18 | Life in years used to select candidate assets depreciating under a calculated, table, or formula depreciation method. | ||
| LIFE_IN_MONTHS | NUMBER | 18 | Life in months used to select candidate assets depreciating under a calculated, table, or formula depreciation method. | ||
| BASIC_RATE | NUMBER | Basic rate used to select candidate assets depreciating under a flat rate depreciation method. | |||
| ADJUSTED_RATE | NUMBER | Adjusted rate used to select candidate assets depreciating under a flat rate depreciation method. | |||
| PRODUCTION_CAPACITY | NUMBER | 18 | Total production capacity used to select candidate assets depreciating under a units of production depreciation method. | ||
| UNIT_OF_MEASURE | VARCHAR2 | 20 | Unit of measure used to select candidate assets depreciating under a units of production depreciation method. | ||
| CONVENTION_TYPE_ID | NUMBER | 18 | Identifier of the depreciation prorate convention used to select candidate assets. | ||
| BONUS_RULE_ID | NUMBER | Identifier of the depreciation bonus rule used to select candidate assets. | |||
| CEILING_TYPE_ID | NUMBER | Identifier of the depreciation ceiling used to select candidate assets. | |||
| DEPRECIATE_FLAG | VARCHAR2 | 1 | Option indicating whether the asset is depreciating or not. | ||
| SALVAGE_TYPE | VARCHAR2 | 30 | Salvage type used to select candidate assets. | ||
| SALVAGE_PERCENT | NUMBER | Salvage value percentage used to select candidate assets. | |||
| SALVAGE_VALUE | NUMBER | Salvage value amount used to select candidate assets. | |||
| DEPRN_LIMIT_TYPE | VARCHAR2 | 30 | Depreciation limit type used to select candidate assets. | ||
| DEPRN_LIMIT_PERCENT | NUMBER | Depreciation limit percentage used to select candidate assets. | |||
| DEPRN_LIMIT_AMOUNT | NUMBER | Depreciation limit amount used to select candidate assets. | |||
| GROUP_ASSOCIATION | VARCHAR2 | 30 | Group asset association used to select candidate assets. | ||
| GROUP_ASSET_ID | NUMBER | 18 | Identifier of the group asset used to select candidate assets. | ||
| CASH_GENERATING_UNIT_ID | NUMBER | Identifier of the cash generating unit used to select candidate assets. | |||
| ASSIGNED_TO | NUMBER | 18 | Identifier of the person used to select candidate assets. | ||
| INCLUDE_FULLY_RESERVED_FLAG | VARCHAR2 | 1 | Option indicating whether to include fully reserved assets when selecting candidate assets. | ||
| INCLUDE_SUBCOMPONENTS_FLAG | VARCHAR2 | 1 | Option to include child assets of the matching candidate assets for the mass transaction. | ||
| RETIREMENT_BATCH_NAME | VARCHAR2 | 30 | Original batch name of a mass retirement used to select candidate assets for mass reinstatement. | ||
| FROM_DATE_RETIRED | DATE | Starting value of the date placed in service range used to select candidate assets for mass reinstatement. | |||
| TO_DATE_RETIRED | DATE | Ending value of the date placed in service range used to select candidate assets for mass reinstatement. | |||
| FROM_COST_RETIRED | NUMBER | Starting value of the cost range used to select candidate assets for mass reinstatement. | |||
| TO_COST_RETIRED | NUMBER | Ending value of the cost range used to select candidate assets for mass reinstatement. | |||
| FROM_TRADE_IN_ASSET_NUMBER | VARCHAR2 | 30 | Starting value of the trade-in asset number range used to select candidate assets for mass reinstatement. | ||
| TO_TRADE_IN_ASSET_NUMBER | VARCHAR2 | 30 | Ending value of the trade-in asset number range used to select candidate assets for mass reinstatement. | ||
| FROM_PROCEEDS_OF_SALE | NUMBER | Starting value of the proceeds of sale range used to select candidate assets for mass reinstatement. | |||
| TO_PROCEEDS_OF_SALE | NUMBER | Ending value of the proceeds of sale range used to select candidate assets for mass reinstatement. | |||
| FROM_COST_OF_REMOVAL | NUMBER | Starting value of the cost of removal range used to select candidate assets for mass reinstatement. | |||
| TO_COST_OF_REMOVAL | NUMBER | Ending value of the cost of removal range used to select candidate assets for mass reinstatement. | |||
| RETIREMENT_TYPE_CODE | VARCHAR2 | 30 | Internal identification number of the retirement type used to select candidate asset retirements for mass reinstatement. | ||
| RETIREMENT_CONVENTION_TYPE_ID | NUMBER | 18 | Internal identification number of the retirement prorate convention used to select candidate asset retirements for mass reinstatement. | ||
| SOLD_TO | VARCHAR2 | 30 | Name of the customer to whom the asset was sold. Used for mass reinstatements. | ||
| REFERENCE_NUM | VARCHAR2 | 15 | Internal reference number used on selected candidate assets for mass reinstatement. | ||
| 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_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. | |||
| ATTRIBUTE_CATEGORY_CODE | VARCHAR2 | 30 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | ||
| PREPARER_ID | NUMBER | 18 | Identifier of the person assigned to prepare the mass addition line. | ||
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| 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. | |
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
| 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. | |
| CATEGORY_FLEX_FILTER | XMLTYPE | Key Flexfield: filter criteria for the asset category key flexfield. | |||
| ASSET_KEY_FLEX_FILTER | XMLTYPE | Key Flexfield: filter criteria for the asset key flexfield. | |||
| LOCATION_FLEX_FILTER | XMLTYPE | Key Flexfield: filter criteria for the asset location flexfield. | |||
| DEPRN_EXPENSE_FLEX_FILTER | XMLTYPE | Key Flexfield: filter criteria for the general ledger flexfield. | |||
| LIFE_IN_PERIODS | NUMBER | 4 | Life of an asset that uses this depreciation method. Used only for life-based depreciation methods. | ||
| EXTENDED_DEPRN_FLAG | VARCHAR2 | 1 | Indicates whether the assets with extended depreciation need to be selected for mass transactions. | ||
| FROM_PERIOD_COUNTER_FULLY_RSVD | NUMBER | 18 | Starting fully reserved period identifier, used to select candidate assets for mass transactions. | ||
| TO_PERIOD_COUNTER_FULLY_RSVD | NUMBER | 18 | Ending fully reserved period identifier, used to select candidate assets for mass transactions. | ||
| 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. | |||
| 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. | |||
| 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. | |||
| 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. | |||
| FEEDER_SYSTEM_NAME | VARCHAR2 | 40 | Name of the source system from which the asset transaction was created. This is a free text field that is not validated. | ||
| AUTO_POST_TRANSACTION_FLAG | VARCHAR2 | 1 | Indicates whether an asset transaction should be automatically posted after the approval. | ||
| APPROVAL_STATUS_CODE | VARCHAR2 | 30 | Status of the mass transaction batch approval. | ||
| ASSET_LEVEL_APPROVAL_FLAG | VARCHAR2 | 1 | Indicates whether each asset in a mass transaction batch requires separate approval. | ||
| ANNUITY_INTEREST_RATE | NUMBER | Annual interest rate used to calculate annual interest expense. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| fa_mc_revaluations | fa_mass_transactions | MASS_REVAL_ID |
| fa_revaluations | fa_mass_transactions | MASS_REVAL_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| FA_MASS_TRANSACTIONS_N1 | Non Unique | Default | BOOK_TYPE_CODE, MASS_TRANSACTION_TYPE_CODE, BATCH_STATUS, TRANSACTION_TYPE_CODE |
| FA_MASS_TRANSACTIONS_U1 | Unique | Default | MASS_TRANSACTION_ID |
| FA_MASS_TRANSACTIONS_U2 | Unique | Default | BOOK_TYPE_CODE, MASS_TRANSACTION_TYPE_CODE, BATCH_NAME, TRANSACTION_TYPE_CODE |