IRT is the data table for the Interest Rate Type data.
| Name | Description | Data Type | Len | Dec. | View lines | View type | Inst. | Visible | Codetable |
|---|---|---|---|---|---|---|---|---|---|
| INR | Internal Unique ID of IRT | Text | 8 | 1 | Edit | Yes | Public | ||
| COD | Interest Rate Type Code | Text | 6 | 1 | Edit | Yes | Public | IRTTXT | |
| CUR | Currency (SPACE for NONE) | Text | 3 | 1 | Edit | Yes | Public | CURTXT | |
| ALTCOD | Alternate Code | Text | 3 | 1 | Edit | Yes | Public | ||
| SEQ | Sequence in Rate Entering Tool (0: not in) | Numeric | 2 | 0 | Edit | Yes | Public | ||
| IRTMCC | Calendar Calculation Method | Text | 3 | 1 | Edit | Yes | Public | IRTMCC | |
| IRTMIC | Interest Calculation Method | Text | 3 | 1 | Edit | Yes | Public | IRTMIC | |
| IRTMICMAR | Special Method for Margin | Text | 3 | 1 | Edit | Yes | Public | IRTMIC | |
| VER | Version Counter | Text | 4 | 1 | Edit | Yes | Public | ||
| INTPOL | With Interpolation | Text | 1 | 1 | Edit | Yes | Public | ||
| ETGEXTKEY | Entity Group of Interest Rate | Text | 8 | 1 | Edit | Yes | Public | ||
| GETFLDNRM | Field holding the normalized search fields | Text | 10 | 1 | Edit | Yes | Public |
| Name | Fields | Properties |
|---|---|---|
| IRT_COD | COD, CUR | |
| IRT_ETGEXTKEY | ETGEXTKEY | |
| IRT_GETFLDNRM | GETFLDNRM | |
| IRT_INR | INR | Unique |
/
INR
Unique internal ID of a record within the table. The INR is a text field, which is created by retrieving the next valid entry from the counter IRT The field INR is used to maintain links from other tables into this table.
Unique internal ID of a record within the table. The INR is a text field, which is created by retrieving the next valid entry from the counter of this table. The field INR is used to enable links from other tables to this table.
For contractdata the INR also links the two tables xxD and xxT as associated entries hold the same INR.
This field is used to enter a code for a reference rate type. Details ofthis rate type are entered in subsequent fields.
This field is used to enter a currency for the reference interest rate types, as defined in the 'Rate type' field.
Alternate code used for the passed currency.
Alternate code used for the passed currency.
This field is used to enter a sequence number.
This field is used to define a calendar calculation method for the rate type selected (Reference Interest Rate).
The selection is made from the IRTMCC codetable.
This field is used to define the interest calculation method for the selected rate type (Reference Interest Rate).
The selection is made from the IRTMIC codetable.
This field holds the version counter to keep track of the version history of an IRT entry. The individual versions are controlled by entries in the SLG table.
This field holds the version counter used to keep track of the history of an entry of this table. The individual versions are managed by entries in the SLG table.
This table is defined on entity group level with separate entries for each entity group. This field holds the EXTKEY of the entity group which is the logical owner of this entry. This field is filled automatically during insert and is used as filter when accessing the database. Without special implementation only entries of the entity group of the currently active entity are visible to the user.
This field holds the external key of the owning entity group to identify the logical owner of this entry. This field is filled automatically during insert and is used as filter when accessing the database. Without special implementation only entries of the currently active entity group are visible to the user.
Optionally, some other interest calculation method is available for the surcharge/margin than for the reference rate. If this is necessary, then the calculation method differing from the interest calculation method for the reference rate must be defined in the “Method for Margin” field.
For the selected reference interest rate, it can be defined whether the exchange rate type can be interpolated. This may be necessary for variable interest rates, e.g. LIBOR, if the financing period is between 2 LIBOR maturities and a linear, interpolated interest rate is to be calculated.
The interest rates and validity period for the respective exchange rate type are recorded in the transaction 'Maintaining Reference Interest Rates'.
Field holding the concatenated and normalized sum of all search fields used by quick search. This is one of the fields set in a SdbSetNRMFields method defined in the table definition module.
Field holding the concatenated and normalized sum of all search fields used by quick search. This is one of the fields set in a SdbSetNRMFields method defined in the table definition module.