Name | Helptext Description | Data Type | Len | Codetable |
---|---|---|---|---|
INR | Internal Unique ID | Text | 8 | |
RZPINR | INR of RZP | Text | 8 | |
BEGDAT | Begin Date | Date | 12 | |
ENDDAT | End Date | Date | 12 | |
RAT | Rate | Numeric | 8 | |
VER | Version | Text | 4 | |
USCRAT | Usance of Rate | Text | 1 | Embedded |
REFRAT | Refinancing Rate | Numeric | 8 | |
MODFLG | Rate modified manual | Text | 40 | |
FAZ | Floor At zero | Text | 1 |
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.
RZPINR holds a pointer on repayment plan
This field holds a “valid from”-date for particular interest
This field holds a “valid to”-date for particular interest
Rate of paid interest
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 field holds the usance of rate (i.e. CH (360/360), EU (365/360), EN (365/365))
Code | Text |
---|---|
0 | CH (360/360) |
1 | EU (365/360) |
2 | EN (365/365) |
Refinancing Rate is used only if field “Floor at zero” is set
Non-empty if rate modified manual
If this field is set, refinancing rate is used instead of rate for calculation.