TRT is the data table for text blocks and other large fields (not used in search functions) for Loan contracts.
TRD and TRT are linked by using the same INR contents.
| Name | Description | Data Type | Len | Dec. | View lines | View type | Inst. | Visible | Codetable |
|---|---|---|---|---|---|---|---|---|---|
| INR | Internal Unique ID of TR (Contract Group Loan) | Text | 8 | 1 | Edit | Yes | Public | ||
| NARHIS | Historic Overview of Narratives | Block | 35 | 999 | 10 | Block | Yes | Public | |
| FLDMODBLK | List of Modified Fields in TRDGRP | Block | 40 | 100 | 30 | Block | Yes | Public | |
| INFPTY | Information Finance Party | Block | 50 | 4 | 4 | Block | Yes | Public | |
| CONTAG72 | Content of TAG 72 | Block | 35 | 999 | 10 | Block | Yes | Public | |
| CONTAG79 | Content of TAG 79 | Block | 50 | 999 | 10 | Block | Yes | Public | |
| ROGGOD | Identification of Goods | Block | 40 | 40 | 10 | Block | Yes | Public | |
| VESNAM | Vessel Name | Text | 40 | 1 | Edit | Yes | Public | ||
| STDENRPER | Standard Enroute Period | Numeric | 3 | 0 | Edit | Yes | Public | ||
| ECREXMREF | Reference of EXIM Bank | Text | 16 | 1 | Edit | Yes | Public | ||
| EXIMCODE | Drawee Code | Text | 6 | 1 | Edit | Yes | Public | ||
| ECRSUBREF | CP / EO Refrerence | Text | 20 | 1 | Edit | Yes | Public | ||
| ECRGOD | Goods Description | Block | 50 | 50 | 10 | Block | Yes | Public | |
| EXPBILDES | Destination | Text | 2 | 1 | Edit | Yes | Public | CTYTXT | |
| EXPBILDAT | Export Bill Start Date | Date | 12 | 0 | Date | Yes | Public | ||
| EXPBILTEN | Export Bill Tenor | Numeric | 3 | 0 | Edit | Yes | Public | ||
| EXPBILMATDAT | Export Bill Maturity | Date | 12 | 0 | Date | Yes | Public |
| Name | Fields | Properties |
|---|---|---|
| TRT_INR | INR | Unique |
/
INR
Unique internal ID of a record within the table. The INR is a text field, which is filled from the INR field of the associated TRD record. Thus the field INR is used to link the two tables TRD and TRT as associated entries hold the same 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 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 contains the history of amendments made to the narratives of the financing.
The field holds a list of all fields which were marked as modified when the last update of the contract took place. This field is used to mark the respective fields upon loading of the contract automatically as modified-2.
The field holds a list of all fields identified as modified when the contract was last updated. This field is used to mark the respective fields as modified when the contract is loaded.
This field holds additional information for the financed party.
This field holds additional information for the financed party.
This field contains the history of former TAGs 72.
This field contains the history of former TAGs 72
This field contains the history of former TAGs 79.
This field contains the history of former TAGs 79
If the parent contract is a forfaiting sale (FP), then this period will be derived from the parent contract.
Reference of EXIM Bank
If the parent contract is a forfaiting sale (FP), this code will be derived from the parent contract.
Reference of the underlying Export Certificate / Certificate of Performance
Reference of the underlying Export Certificate / Certificate of Performance
Description of Goods
A country can be selected in this field.
For financing type ECR, this date is set to today, unless it is changed manually.
Tenor of the Export Bill
The due date of the export invoice is determined from the start date of the export invoice and the period set in the export invoice.
This field holds a brief description of goods shipped under the Loan.
This field holds a brief description of goods shipped.
This fields holds the name of the vessel/ship which has been used to transport the goods which are shipped under this Loan.
This field holds the name of the vessel that has been used to transport the goods shipped.