User Tools
Add this page to your book 
Remove this page from your book 
Manage book (
Help Table of Contents
IRS - Interest Rates per Date Range
Module IRS
Datafields
| Name | Helptext Description | Data Type | Len | Codetable |
|---|---|---|---|---|
| INR | Internal Unique ID | Text | 8 | |
| OBJTYP | Object Type | Text | 6 | |
| OBJINR | Object INR | Text | 8 | |
| CUR | Currency (SPACE for NONE) | Text | 3 | CURTXT |
| BEGDAT | Begin Date (Incl.) | Date | 12 | |
| ENDDAT | End Date (excluding) | Date | 12 | |
| RAT | Rate | Numeric | 14 | |
| TRNINR | Transaction INR | Text | 8 | |
| VER | Version | Text | 4 | |
| FNZPRD | Maturity | Numeric | 16 | |
| ETGEXTKEY | Entitygroup | Text | 8 |
Datafield Description and Properties
Datafield INR Internal Unique ID
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.
Datafield OBJTYP Object Type
Type of object the Contract Type or IRT refers to. Usually this is the table the object is associated to.
Datafield OBJINR Object INR
The unique ID of the object in the table, defined in the Object Type field.
Datafield CUR Currency (SPACE for NONE)
Currency for the interest rate.
Datafield BEGDAT Begin Date (Incl.)
This field defines the date from which this rate is valid.
Datafield ENDDAT End Date (excluding)
This marks the date from which the reference interest rate no longer applies.
Datafield RAT Rate
This field defines the interest rate valid from the start date entered.
Datafield TRNINR Transaction INR
INR of the transaction which created or processed the contract.
Datafield VER Version
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.
Datafield FNZPRD Maturity
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.
Datafield ETGEXTKEY Entitygroup
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.
