| Name | Description | Data Type | Len | Dec. | View lines | View type | Inst. | Visible | Codetable |
|---|---|---|---|---|---|---|---|---|---|
| INR | Internal Unique ID | Text | 8 | 1 | Edit | Yes | Public | ||
| TURRAT | Cycle (Turnus) Interest | Text | 3 | 1 | Edit | Yes | Public | Embedded | |
| CAPDATRAT | Capitalization Date of Rate | Date | 12 | 0 | Date | Yes | Public | ||
| CAPRAT | Capitalization Rate | Numeric | 9 | 6 | Edit | Yes | Public | ||
| CUSRAT | Customize of Rate | Text | 1 | 1 | Edit | Yes | Public | Embedded | |
| MATDAT | First Maturity Date | Date | 12 | 0 | Date | Yes | Public | ||
| MATDATRAT | First Maturity Date Interest | Date | 12 | 0 | Date | Yes | Public | ||
| MATNO | Maturity Number | Numeric | 3 | 0 | Edit | Yes | Public | ||
| MATNORAT | Number of Maturity (Interest) | Numeric | 3 | 0 | Edit | Yes | Public | ||
| TURNUS | Cycle (Turnus) | Text | 3 | 1 | Edit | Yes | Public | Embedded | |
| UTMCOD | Ultimo Code | Text | 1 | 1 | Edit | Yes | Public | Embedded | |
| AMTSTR | Amount Structure | Text | 2 | 1 | Edit | Yes | Public | Embedded | |
| AMTSTRRAT | Amount Structure (Rate) | Text | 2 | 1 | Edit | Yes | Public | Embedded | |
| HOLTBL | Holiday Table | Text | 1 | 1 | Edit | Yes | Public | Embedded | |
| TAXPRC | Percentage of Withholding Tax | Numeric | 9 | 6 | Edit | Yes | Public | ||
| DISFLG | Discounting Flag | Text | 1 | 1 | Edit | Yes | Public | ||
| GRCDAY | Grace Days | Numeric | 2 | 0 | Edit | Yes | Public | ||
| FLDMODBLK | List of Modified Fields in RZD | Block | 6 | 25 | 25 | Block | Yes | Public | |
| GRACALFLG | Calculation basis | Text | 3 | 1 | Edit | Yes | Public | Embedded |
| Name | Fields | Properties |
|---|---|---|
| RZD_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 RZD. 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 defines the interest of each turnus
This field defines the interest of each turnus
| Code | Text |
|---|---|
| VAR | Variable |
| M01 | Monthly |
| M02 | Bimonthly |
| M03 | Quarterly |
| M06 | Semi-annually |
| M04 | Trimester(4 Months) |
| ONE | Flat(one-off) |
| M12 | Annually |
Capitalization Date of Rate
Capitalization Date of Rate
Capitalization Rate in persent
Capitalization Rate in persent
Customize of Rate holds “Y” if rate is customized and “N” if not
Customize of Rate holds “Y” if rate is customized and “N” if not
| Code | Text |
|---|---|
| Y | Yes |
| N | No |
This field holds the 1st maturity date
This field holds the 1st maturity date
This field holds the interest of 1st maturity date
This field holds the interest of 1st maturity date
This field holds the number of possible maturity dates
This field holds the number of possible maturity dates
This field holds the number of possible interest rates
This field holds the number of possible interest rates
This field defines the turnus of payments like monthly, quarterly, annually, variable and so on
This field defines the turnus of payments like monthly, quarterly, annually, variable and so on
| Code | Text |
|---|---|
| VAR | Variable |
| M01 | Monthly |
| M02 | Bimonthly |
| M03 | Quarterly |
| M06 | Semi-annually |
| M04 | Trimester(4 Months) |
| ONE | Flat(one-off) |
| M12 | Annually |
This field holds “Y” if Ultimo defined and “N” if not
This field holds “Y” if Ultimo defined and “N” if not
| Code | Text |
|---|---|
| Y | Yes |
| N | No |
This field holds the possible structur of amount (i.e. Linear, Variable or Percentage)
This field holds the possible structur of amount (i.e. Linear, Variable or Percentage)
| Code | Text |
|---|---|
| L | Linear |
| V | Variable |
| P | Percentage |
This field holds the possible structure of rate (i.e. Calculated or Variable)
This field holds the possible structure of rate (i.e. Calculated or Variable)
| Code | Text |
|---|---|
| C | Calculated |
| V | Variable |
This field holds holiday table (i.e. Yes (- Days), No, Yes (+ Days))
This field holds holiday table (i.e. Yes (- Days), No, Yes (+ Days))
| Code | Text |
|---|---|
| 1 | Yes (- Days) |
| 2 | No |
| 3 | Yes (+ Days) |
Percentage of Withholding Tax
Percentage of Withholding Tax
Non-empty if discounting flag is set
Non-empty if discounting flag is set
Grace days of repayment
Grace days of repayment
List of modified fields of this RZD entry to keep track of all modifications in the past. Used in SetModFldinRec and GetModFldinRec.
When adding new fields, please note that the number of LINES is increased accordingly.
List of modified fields of this RZD entry to keep track of all modifications in the past. Used in SetModFldinRec and GetModFldinRec.
When adding new fields, please note that the number of LINES is increased accordingly.
This field holds calculation basis for grace days (i.e. Bank working days or Calendar days)
This field holds calculation basis for grace days (i.e. Bank working days or Calendar days)
| Code | Text |
|---|---|
| BAT | Bank working days |
| KAL | Calendar days |