8.2.63.2 Module Usage

INSTRUMENT_TYPE_CD identifies the source table of the instrument record. The following table lists each of the available INSTRUMENT_TYPE_CD values:

Table 8-21 List of Instrument Type Code Values

Code Values Description
110 Commercial loans
120 Consumer loans
130 Mortgages
140 Investments
141 MBS
145 Money Market Contracts
150 Credit card
160 Credit Lines
170 Leases
180 Loan Contracts
205 Annuity Contracts
210 Deposits
215 Checking and Savings
220 Wholesale Funding
230 Term Deposits
240 Retirement Accounts
310 Break Funding
410 Ledger Instruments
510 Merchant Cards
520 Mutual Funds
530 Other Services
540 Trusts
910 Derivatives
920 Forward Rate Agreements
925 Futures
930 FX Contracts
940 Caps / Floors / Collars
950 Guarantees
960 Swaps
970 Rate Lock Commitments

The Cash Flow Engine uses the INSTRUMENT_TYPE_CD to determine the instrument of an account when accounts of different instruments are grouped (on a report or other query).

It is also important for instruments with Payment Schedules (AMRT_TYPE_CD 800, 801, 802) because the Cash Flow Engine uses the INSTRUMENT_TYPE_CD and ID_NUMBER to determine the payment dates and amounts from the FSI_D_PAYMENT_SCHEDULE table.