User Tools
Add this page to your book 
Remove this page from your book 
Manage book (
Help Table of Contents
RZD - Repayment Plan Header
Module RZD
Datafields
| Name | Helptext Description | Data Type | Len | Codetable |
|---|---|---|---|---|
| INR | Internal Unique ID | Text | 8 | |
| TURRAT | Cycle (Turnus) Interest | Text | 3 | Embedded |
| CAPDATRAT | Capitalization Date of Rate | Date | 12 | |
| CAPRAT | Capitalization Rate | Numeric | 9 | |
| CUSRAT | Customize of Rate | Text | 1 | Embedded |
| MATDAT | First Maturity Date | Date | 12 | |
| MATDATRAT | First Maturity Date Interest | Date | 12 | |
| MATNO | Maturity Number | Numeric | 3 | |
| MATNORAT | Number of Maturity (Interest) | Numeric | 3 | |
| TURNUS | Cycle (Turnus) | Text | 3 | Embedded |
| UTMCOD | Ultimo Code | Text | 1 | Embedded |
| AMTSTR | Amount Structure | Text | 2 | Embedded |
| AMTSTRRAT | Amount Structure (Rate) | Text | 2 | Embedded |
| HOLTBL | Holiday Table | Text | 1 | Embedded |
| TAXPRC | Percentage of Withholding Tax | Numeric | 9 | |
| DISFLG | Discounting Flag | Text | 1 | |
| GRCDAY | Grace Days | Numeric | 2 | |
| FLDMODBLK | List of Modified Fields in RZD | Block | 6 | |
| GRACALFLG | Calculation basis | Text | 3 | Embedded |
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 TURRAT Cycle (Turnus) Interest
This field defines the interest of each turnus
Codetable
| Code | Text |
|---|---|
| VAR | Variable |
| M01 | Monthly |
| M02 | Bimonthly |
| M03 | Quarterly |
| M06 | Semi-annually |
| M04 | Trimester(4 Months) |
| ONE | Flat(one-off) |
| M12 | Annually |
Datafield CAPDATRAT Capitalization Date of Rate
Capitalization Date of Rate
Datafield CAPRAT Capitalization Rate
Capitalization Rate in persent
Datafield CUSRAT Customize of Rate
Customize of Rate holds “Y” if rate is customized and “N” if not
Codetable
| Code | Text |
|---|---|
| Y | Yes |
| N | No |
Datafield MATDAT First Maturity Date
This field holds the 1st maturity date
Datafield MATDATRAT First Maturity Date Interest
This field holds the interest of 1st maturity date
Datafield MATNO Maturity Number
This field holds the number of possible maturity dates
Datafield MATNORAT Number of Maturity (Interest)
This field holds the number of possible interest rates
Datafield TURNUS Cycle (Turnus)
This field defines the turnus of payments like monthly, quarterly, annually, variable and so on
Codetable
| Code | Text |
|---|---|
| VAR | Variable |
| M01 | Monthly |
| M02 | Bimonthly |
| M03 | Quarterly |
| M06 | Semi-annually |
| M04 | Trimester(4 Months) |
| ONE | Flat(one-off) |
| M12 | Annually |
Datafield UTMCOD Ultimo Code
This field holds “Y” if Ultimo defined and “N” if not
Codetable
| Code | Text |
|---|---|
| Y | Yes |
| N | No |
Datafield AMTSTR Amount Structure
This field holds the possible structur of amount (i.e. Linear, Variable or Percentage)
Codetable
| Code | Text |
|---|---|
| L | Linear |
| V | Variable |
| P | Percentage |
Datafield AMTSTRRAT Amount Structure (Rate)
This field holds the possible structure of rate (i.e. Calculated or Variable)
Codetable
| Code | Text |
|---|---|
| C | Calculated |
| V | Variable |
Datafield HOLTBL Holiday Table
This field holds holiday table (i.e. Yes (- Days), No, Yes (+ Days))
Codetable
| Code | Text |
|---|---|
| 1 | Yes (- Days) |
| 2 | No |
| 3 | Yes (+ Days) |
Datafield TAXPRC Percentage of Withholding Tax
Percentage of Withholding Tax
Datafield DISFLG Discounting Flag
Non-empty if discounting flag is set
Datafield GRCDAY Grace Days
Grace days of repayment
Datafield FLDMODBLK List of Modified Fields in RZD
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.
Datafield GRACALFLG Calculation basis
This field holds calculation basis for grace days (i.e. Bank working days or Calendar days)
Codetable
| Code | Text |
|---|---|
| BAT | Bank working days |
| KAL | Calendar days |
