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