FA_MC_BOOKS
FA_MC_BOOKS contains currency and financial information about assets in each reporting book associated with the parent record in FA_BOOKS. This table stores one active row for each asset per reporting book identified by a null TRANSACTION_HEADER_ID_OUT. Oracle Assets updates this table when ever a financial adjustment is performed on the asset by setting the TRANSACTION_HEADER_ID_OUT of the current row to the TRANSACTION_HEADER_ID_IN of the new row. RATE_ADJUSTMENT_FACTOR is stored in the parent record in FA_BOOKS. It is an MRC sub-table of FA_BOOKS.
Details
-
Schema: FUSION
-
Object owner: FA
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
Name | Columns |
---|---|
FA_MC_BOOKS_PK |
SET_OF_BOOKS_ID, TRANSACTION_HEADER_ID_IN |
Columns
Name | Datatype | Length | Precision | Not-null | Comments |
---|---|---|---|---|---|
ASSET_ID | NUMBER | 18 | Yes | Identifier of the asset number. | |
BOOK_TYPE_CODE | VARCHAR2 | 30 | Yes | Unique book identification name. | |
TRANSACTION_HEADER_ID_IN | NUMBER | 18 | Yes | Identifier of the transaction that created the row. | |
TRANSACTION_HEADER_ID_OUT | NUMBER | 18 | Identifier of the transaction that terminated the row. | ||
ADJUSTED_COST | NUMBER | Yes | Depreciable basis of the asset, calculated as recoverable cost for cost basis depreciation methods, and recoverable cost less the accumulated depreciation for net book value basis methods. | ||
COST | NUMBER | Yes | Total recorded cost of the asset. | ||
SOURCE_COST | NUMBER | Current cost of the asset in the primary functional currency. | |||
ORIGINAL_COST | NUMBER | Yes | Cost of the asset at the time of its addition. | ||
SOURCE_ORIGINAL_COST | NUMBER | Original cost of the asset in the primary functional currency. | |||
SALVAGE_VALUE | NUMBER | Yes | Salvage value amount for the asset. | ||
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. | |
RECOVERABLE_COST | NUMBER | Yes | Cost minus salvage value, or depreciation ceiling, whichever is lower. | ||
LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
REVAL_CEILING | NUMBER | Upper limit for revaluing asset cost. | |||
PERIOD_COUNTER_FULLY_RESERVED | NUMBER | 18 | Identifier of the depreciation period in which the asset was fully reserved. | ||
UNREVALUED_COST | NUMBER | Yes | Asset cost without regard to any revaluations. | ||
ALLOWED_DEPRN_LIMIT_AMOUNT | NUMBER | Depreciation limit amount for the asset. | |||
PERIOD_COUNTER_LIFE_COMPLETE | NUMBER | 18 | Identifier of the asset book period in which the asset's life was completed. | ||
PERIOD_COUNTER_FULLY_XFRD | NUMBER | 18 | Period identifier in which the asset was fully transferred to another book. | ||
ADJUSTED_RECOVERABLE_COST | NUMBER | Adjusted recoverable cost with special depreciation limits taken into account. | |||
CONVERTED_FLAG | VARCHAR2 | 1 | Status indicating whether the transaction amounts have been converted to the reporting currency. | ||
ANNUAL_DEPRN_ROUNDING_FLAG | VARCHAR2 | 5 | Option indicating whether Oracle Fusion Assets should subtract year-to-date depreciation from the annual depreciation amount to get the depreciation amount for the last period of the fiscal year. | ||
EOFY_ADJ_COST | NUMBER | Adjusted cost at the end of the previous fiscal year. | |||
OLD_ADJUSTED_COST | NUMBER | Cost before adjustment transaction for the asset depreciation under formula net book value based depreciation method. | |||
EOFY_FORMULA_FACTOR | NUMBER | Formula factor at the end of the previous fiscal year. | |||
FORMULA_FACTOR | NUMBER | Factor used to adjust the depreciation rate for formula-net book value method assets. | |||
REMAINING_LIFE1 | NUMBER | 4 | Remaining life of the asset calculated as on the conversion date, prorate date, or fiscal year start date. | ||
REMAINING_LIFE2 | NUMBER | 4 | Remaining life of the asset calculated as on the fiscal year start date. | ||
SHORT_FISCAL_YEAR_FLAG | VARCHAR2 | 3 | Option indicating whether the asset is added in short tax year. | ||
GROUP_ASSET_ID | NUMBER | 18 | Identification number of the group asset. | ||
REVAL_AMORTIZATION_BASIS | NUMBER | Revaluation reserve used in calculating amortization of revaluation reserve. This changes only when the asset is revalued or an amortized adjustment is performed. | |||
RETIREMENT_ID | NUMBER | 18 | Identifier of the asset retirement transaction. | ||
ADJUSTED_CAPACITY | NUMBER | Remaining production capacity used to depreciate assets that use units of production method. | |||
FULLY_RSVD_REVALS_COUNTER | NUMBER | Number of times the asset has been revalued as fully reserved. | |||
PERIOD_COUNTER_CAPITALIZED | NUMBER | Identifier of the depreciation period in which asset is capitalized. | |||
PERIOD_COUNTER_FULLY_RETIRED | NUMBER | Identifier of the depreciation period in which the asset was fully retired. | |||
PRODUCTION_CAPACITY | NUMBER | Production capacity for assets that use units of production method. | |||
UNIT_OF_MEASURE | VARCHAR2 | 25 | Physical quantity that is used as a standard for measurement. | ||
PERCENT_SALVAGE_VALUE | NUMBER | Salvage value percentage for the asset. | |||
ALLOWED_DEPRN_LIMIT | NUMBER | Depreciation limit percentage for the asset. | |||
DATE_PLACED_IN_SERVICE | DATE | Yes | Date on which the asset was placed in service. | ||
DATE_EFFECTIVE | DATE | Yes | Date when the row became effective. | ||
DEPRN_START_DATE | DATE | Yes | Date when the asset started to depreciate. | ||
RATE_ADJUSTMENT_FACTOR | NUMBER | Yes | Internal factor used to adjust depreciation rates to depreciate the net book value over the remaining life. | ||
PRORATE_DATE | DATE | Yes | Date used to calculate the annual depreciation for assets. | ||
CAPITALIZE_FLAG | VARCHAR2 | 3 | Yes | Option indicating whether the asset is a capitalized or construction-in-process asset. | |
DEPRECIATE_FLAG | VARCHAR2 | 3 | Yes | Option indicating whether the asset is depreciating. | |
DATE_INEFFECTIVE | DATE | Date when the row became inactive. | |||
CONVERSION_DATE | DATE | Date on which short tax year asset was added to the acquiring company. | |||
ORIGINAL_DEPRN_START_DATE | DATE | Date when the short tax year asset begin depreciating in the books of the acquired company. | |||
SALVAGE_TYPE | VARCHAR2 | 30 | Yes | Salvage type assigned to the asset. It can be either amount, percentage, or sum of member assets. | |
DEPRN_LIMIT_TYPE | VARCHAR2 | 30 | Yes | Depreciation limit type assigned to the asset. It can be either amount, percentage, sum of member assets, or none. | |
REDUCTION_RATE | NUMBER | Depreciation reduction percentage for the group and its member assets. | |||
REDUCE_ADDITION_FLAG | VARCHAR2 | 1 | Option indicating whether depreciation reduction should be considered for addition transaction. | ||
REDUCE_ADJUSTMENT_FLAG | VARCHAR2 | 1 | Option indicating whether depreciation reduction should be considered for adjustment transaction. | ||
REDUCE_RETIREMENT_FLAG | VARCHAR2 | 1 | Option indicating whether depreciation reduction should be considered for retirement transaction. | ||
RECOGNIZE_GAIN_LOSS | VARCHAR2 | 30 | Option indicating whether gain or loss should be recognized for member asset retirement. | ||
RECAPTURE_RESERVE_FLAG | VARCHAR2 | 1 | Option indicating whether reserve for the group asset can exceed its recoverable cost. | ||
LIMIT_PROCEEDS_FLAG | VARCHAR2 | 1 | Option indicating whether the member asset proceed of sale should be limited to its recoverable cost or not. | ||
TERMINAL_GAIN_LOSS | VARCHAR2 | 30 | Option indicating how terminal gain or loss should be recognized for member asset retirement. | ||
TRACKING_METHOD | VARCHAR2 | 30 | Option indicating the group asset tracking method that is used to calculate group and its member asset depreciation. | ||
EXCLUDE_FULLY_RSV_FLAG | VARCHAR2 | 1 | Option indicating whether fully reserved assets depreciable basis should be excluded from the group asset's depreciable basis or not. | ||
EXCESS_ALLOCATION_OPTION | VARCHAR2 | 30 | Option indicating whether excess depreciation of the group asset is to be allocated to its member assets or reduced from the group asset depreciation. | ||
DEPRECIATION_OPTION | VARCHAR2 | 30 | Option indicating whether the depreciation expense of the member asset is calculated using its group asset depreciation rules or the member asset depreciation rules. | ||
MEMBER_ROLLUP_FLAG | VARCHAR2 | 1 | Option indicating whether group asset depreciation is sum of member asset depreciation or calculated separately. | ||
ALLOCATE_TO_FULLY_RSV_FLAG | VARCHAR2 | 1 | Option indicating whether group asset depreciation amount should be allocated to fully retired assets. | ||
ALLOCATE_TO_FULLY_RET_FLAG | VARCHAR2 | 1 | Option indicating whether group asset depreciation amount should be allocated to fully retired assets. | ||
TERMINAL_GAIN_LOSS_AMOUNT | NUMBER | Accumulated depreciation remaining for the group asset after the last member asset of the group asset is retired. | |||
CIP_COST | NUMBER | Construction-in-Process cost of the asset. | |||
YTD_PROCEEDS | NUMBER | Year to date proceeds from sale of an asset. | |||
LTD_PROCEEDS | NUMBER | Life-to-date proceeds of sale amount for the asset. | |||
LTD_COST_OF_REMOVAL | NUMBER | Life-to-date cost of removal amount for the asset. | |||
EOFY_RESERVE | NUMBER | Depreciation reserve at the end of the previous fiscal year. | |||
PRIOR_EOFY_RESERVE | NUMBER | Previous accumulated depreciation at the end of the previous fiscal year. | |||
EOP_ADJ_COST | NUMBER | Adjusted cost at the end of the previous period. | |||
EOP_FORMULA_FACTOR | NUMBER | Formula factor at the end of the previous period | |||
EXCLUDE_PROCEEDS_FROM_BASIS | VARCHAR2 | 1 | Group asset retirement rule which indicates whether proceeds of sale should be excluded when calculating the group asset's depreciable basis or not. | ||
RETIREMENT_DEPRN_OPTION | VARCHAR2 | 30 | Option indicating whether group asset should depreciate till the last member asset is retired or end of the fiscal year. | ||
TERMINAL_GAIN_LOSS_FLAG | VARCHAR2 | 1 | Option indicating whether terminal gain or loss amount needs to be processed by the Calculate Gains and Losses program, when it is running for the last period of the fiscal year. | ||
OVER_DEPRECIATE_OPTION | VARCHAR2 | 30 | Option indicating whether over depreciation is allowed for the group asset depreciation. | ||
DISABLED_FLAG | VARCHAR2 | 1 | Option indicating whether the group asset is enabled or disabled. | ||
OLD_ADJUSTED_CAPACITY | NUMBER | Remaining production capacity before the last depreciation process run for assets that that use units of production method. | |||
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. | |
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. | |
METHOD_ID | NUMBER | 18 | Identifier of the depreciation method. | ||
FLAT_RATE_ID | NUMBER | 18 | Identifier of the rates for the flat rate depreciation method. | ||
CONVENTION_TYPE_ID | NUMBER | 18 | Identifier of the prorate convention. | ||
BONUS_RULE_ID | NUMBER | 18 | Identifier of the depreciation bonus rule. | ||
CEILING_TYPE_ID | NUMBER | 18 | Identifier of the depreciation ceiling. | ||
CASH_GENERATING_UNIT_ID | NUMBER | 18 | Identifier of the cash generating unit. | ||
CONTRACT_ID | NUMBER | 18 | Identifier of the lease contract of the asset. | ||
DRY_HOLE_FLAG | VARCHAR2 | 1 | Option indicating whether energy asset is classified as dry hole. | ||
EXTENDED_DEPRECIATION_PERIOD | NUMBER | 18 | No longer used. | ||
EXTENDED_DEPRN_FLAG | VARCHAR2 | 1 | Option indicating whether the asset depreciation is extended or not. | ||
ITC_AMOUNT | NUMBER | Investment tax credit amount of the asset. | |||
ITC_AMOUNT_ID | NUMBER | 18 | Identifier of the investment tax credit. | ||
ITC_BASIS | NUMBER | Investment tax credit calculation basis. | |||
NBV_AT_SWITCH | NUMBER | Net book value of the asset as of the date at which the original rate was switched to the revised rate. | |||
PERIOD_COUNTER_FULLY_EXTENDED | NUMBER | 18 | Identifier of the depreciation period in which the asset life was extended. | ||
PRIOR_DEPRN_LIMIT | NUMBER | Depreciation limit as a percentage of cost for the asset immediately before it began extended depreciation. | |||
PRIOR_DEPRN_LIMIT_AMOUNT | NUMBER | Depreciation limit amount for the asset immediately before it began extended depreciation. | |||
PRIOR_DEPRN_LIMIT_TYPE | VARCHAR2 | 30 | Depreciation limit type for the asset immediately before it began extended depreciation. | ||
RATE_IN_USE | NUMBER | Depreciation rates used to depreciate the net book value over the remaining life. | |||
PRIOR_METHOD_ID | NUMBER | 18 | Identifier of the depreciation method for the asset immediately before it began extended depreciation. | ||
PRIOR_FLAT_RATE_ID | NUMBER | 18 | Identifier of the flat rate for the depreciation method of the asset immediately before it began extended depreciation. | ||
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_CATEGORY | VARCHAR2 | 30 | Global Descriptive Flexfield: structure definition 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. | |||
FAIR_MARKET_VALUE | NUMBER | Stores the fair value of an asset. | |||
LAST_PRICE_INDEX_VALUE | NUMBER | Stores the value of the price index used during index-based revaluation for future revaluation. | |||
PERIOD_COUNTER_EXTENDED | NUMBER | 18 | Extended depreciation start period identifier. | ||
LOW_VALUE_ASSET_FLAG | VARCHAR2 | 1 | Indicates whether this line is a low value asset. | ||
USE_BOOKS_SUMMARY_FLAG | VARCHAR2 | 1 | Indicates whether the FA_MC_BOOKS_SUMMARY table for the asset was populated. | ||
ACCELERATED_BONUS_RULE_ID | NUMBER | 18 | Bonus rule used to take a higher depreciation amount than the amount calculated by the depreciation method. | ||
ACCELERATED_ADJUSTED_COST | NUMBER | The base amount on which the accelerated depreciation is calculated. | |||
BONUS_ADJUSTED_COST | NUMBER | The base amount on which the bonus depreciation is calculated. | |||
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. | |||
LEASE_SCHEDULE_ID | NUMBER | 18 | Unique lease payment schedule identification number. | ||
LEASE_ID | NUMBER | 18 | Unique lease identification number. | ||
LEASE_EXPENSE_BASIS | NUMBER | Basis used for calculating the periodic lease expense of the asset. | |||
LEASE_ADJUSTMENT_FACTOR | NUMBER | Internal factor used to amortize the lease basis over the remaining lease term of the asset. | |||
DEPRN_ADJUSTMENT_FACTOR | NUMBER | Controls the speed of depreciation of an asset by multiplying this factor by the annual depreciation rate. | |||
FULLY_RESERVE_ON_ADD_FLAG | VARCHAR2 | 1 | Indicates whether to fully depreciate an asset when the asset is added. | ||
REVALUED_COST | NUMBER | Increase or decrease in cost due to revaluation of the asset. Can be a positive or negative amount. | |||
EOFY_REVAL_RESERVE | NUMBER | Revaluation reserve at the end of previous fiscal year. | |||
PRIOR_EOFY_REVAL_RESERVE | NUMBER | Stores the value of revaluation reserve at the end of fiscal year before the transaction. This is used to rollback the depreciation for the last period of fiscal year. | |||
IB_ASSET_LINK_FLAG | VARCHAR2 | 1 | Indicates whether to synchronize the transaction between a fixed asset and its associated installed base asset. | ||
SET_OF_BOOKS_ID | NUMBER | 18 | Yes | Identifier of the accounting ledger. | |
ANNUITY_INTEREST_RATE | NUMBER | Annual interest rate used to calculate annual interest expense. |
Foreign Keys
Table | Foreign Table | Foreign Key Column |
---|---|---|
FA_MC_BOOKS | fa_book_controls | BOOK_TYPE_CODE |
FA_MC_BOOKS | fa_convention_types | CONVENTION_TYPE_ID |
FA_MC_BOOKS | fa_ceiling_types | CEILING_TYPE_ID |
FA_MC_BOOKS | fa_retirements | RETIREMENT_ID |
FA_MC_BOOKS | fa_mc_retirements | SET_OF_BOOKS_ID, RETIREMENT_ID |
FA_MC_BOOKS | fa_deprn_periods | BOOK_TYPE_CODE, PERIOD_COUNTER_FULLY_RESERVED |
FA_MC_BOOKS | fa_deprn_periods | BOOK_TYPE_CODE, PERIOD_COUNTER_LIFE_COMPLETE |
FA_MC_BOOKS | fa_deprn_periods | BOOK_TYPE_CODE, PERIOD_COUNTER_CAPITALIZED |
FA_MC_BOOKS | fa_deprn_periods | BOOK_TYPE_CODE, PERIOD_COUNTER_FULLY_RETIRED |
FA_MC_BOOKS | fa_mc_book_controls | SET_OF_BOOKS_ID, BOOK_TYPE_CODE |
FA_MC_BOOKS | fa_itc_rates | ITC_AMOUNT_ID |
FA_MC_BOOKS | gl_ledgers | SET_OF_BOOKS_ID |
FA_MC_BOOKS | fa_cash_gen_units | CASH_GENERATING_UNIT_ID |
FA_MC_BOOKS | fa_bonus_rules | ACCELERATED_BONUS_RULE_ID |
FA_MC_BOOKS | fa_additions_b | ASSET_ID |
FA_MC_BOOKS | fa_additions_b | GROUP_ASSET_ID |
FA_MC_BOOKS | fa_transaction_headers | TRANSACTION_HEADER_ID_IN, BOOK_TYPE_CODE |
FA_MC_BOOKS | fa_transaction_headers | TRANSACTION_HEADER_ID_OUT, BOOK_TYPE_CODE |
FA_MC_BOOKS | fa_methods | METHOD_ID |
FA_MC_BOOKS | fa_flat_rates | METHOD_ID, FLAT_RATE_ID |
FA_MC_BOOKS | fa_bonus_rules | BONUS_RULE_ID |
Indexes
Index | Uniqueness | Tablespace | Columns |
---|---|---|---|
FA_MC_BOOKS_N2 | Non Unique | Default | SET_OF_BOOKS_ID, TRANSACTION_HEADER_ID_OUT |
FA_MC_BOOKS_N3 | Non Unique | Default | SET_OF_BOOKS_ID, RETIREMENT_ID |
FA_MC_BOOKS_N4 | Non Unique | Default | GROUP_ASSET_ID |
FA_MC_BOOKS_U1 | Unique | Default | SET_OF_BOOKS_ID, TRANSACTION_HEADER_ID_IN |
FA_MC_BOOKS_U2 | Unique | Default | SET_OF_BOOKS_ID, ASSET_ID, BOOK_TYPE_CODE, TRANSACTION_HEADER_ID_OUT |