This table holds the interest rates valid for the different date ranges. The values refer to the table IRT which defines the available interest rates.
Name | Description | Data Type | Len | Dec. | View lines | View type | Inst. | Visible | Codetable |
---|---|---|---|---|---|---|---|---|---|
INR | Internal Unique ID of IRS | Text | 8 | 1 | Edit | Yes | Public | ||
OBJTYP | Object Type (Contract Type or IRT) | Text | 6 | 1 | Edit | Yes | Public | ||
OBJINR | Object INR | Text | 8 | 1 | Edit | Yes | Public | ||
CUR | Currency (SPACE for NONE) | Text | 3 | 1 | Edit | Yes | Public | CURTXT | |
BEGDAT | Begin Date (Incl.) | Date | 12 | 0 | Date | Yes | Public | ||
ENDDAT | End Date (Excl.) | Date | 12 | 0 | Date | Yes | Public | ||
RAT | Rate | Numeric | 14 | 6 | Edit | Yes | Public | ||
TRNINR | Transaction INR | Text | 8 | 1 | Edit | Yes | Public | ||
VER | Version Counter | Text | 4 | 1 | Edit | Yes | Public | ||
FNZPRD | Financing period ( till days) | Numeric | 16 | 0 | Edit | Yes | Public | ||
ETGEXTKEY | Entity Group of Interest Rate Set | Text | 8 | 1 | Edit | Yes | Public |
Name | Fields | Properties |
---|---|---|
IRS_INR | INR | Unique |
IRS_OBJINR | OBJTYP, OBJINR, CUR, BEGDAT, ENDDAT |
/
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 IRS. 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.
Type of object the Contract Type or IRT refers to. Usually this is the table the object is associated to.
Type of object the Contract Type or IRT refers to. Usually this is the table the object is associated to.
INR of the object within the table, defined in OBJTYP.
The unique ID of the object in the table, defined in the Object Type field.
Currency for the interest rate.
Currency for the interest rate.
This field defines the starting date from which on this rate should be valid.
This field defines the date from which this rate is valid.
This marks the date from which the reference interest rate no longer applies.
This field defines the interest rate valid from the start date entered.
INR of the transaction which created or processed the contract.
INR of the transaction which created or processed the contract.
This field holds the version counter to keep track of the version history of an IRS 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.
Validity of a variable interest rate, e.g. SONIA (GBP), SOFR (USD), SARON (CHF), EURIBOR or others.
The maturity, which is indicated in days, is valid as of the beginn date of the interest rate.
For variable interest rates, such as LIBOR, it is possible to enter the validity of the interest rate into this field. The maturity, which is indicated in days, is valid as of the beginn date of the interest rate.