8.2.59.2 Module Usage

ID_NUMBER identifies the individual customer accounts in the instrument tables. The ID_NUMBER should be unique for a given IDENTITY_CODE within an instrument table. Cash flow processing uses ID_NUMBER to identify each account as it is processed.

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.

Note:

Unique Constraint on all Aggregated tables is the same as other instrument tables with ID Number and Identity Code. To preserve uniqueness, DEFAULT value should not be used for ID_NUMBER and IDENTITY_CODE mappings. MIN/MAX should be used for these fields accordingly.