Table of Contents

TRD - Loan Data

Module TRD

Description

TRD is the main data table for the Loan contract.
All technical important fields have to be defined here.
Large text blocks should be defined in TRT.


Datafields

Name Description Data Type Len Dec. View lines View type Inst. Visible Codetable
INR INR of Loan Contract Text 8 1 Edit Yes Public
OWNREF Our Reference Text 16 1 Edit Yes Public
NAM Name of Loan Contract Text 80 1 Edit Yes Public
CREDAT Date of Creation Date 12 0 Date Yes Public
PNTTYP Parent Contract Type Text 6 1 Edit Yes Public
PNTINR Parent Contract Text 8 1 Edit Yes Public
PNTNAM Parent Contract Name Text 40 1 Edit Yes Public
PNTREF Parent Contract Reference Text 16 1 Edit Yes Public
ISSDAT Date Issued Date 12 0 Date Yes Public
MATDAT Maturity Date Date 12 0 Date Yes Public
LSTINTDAT Last Interest Settlement Date 12 0 Date Yes Public
STTTENDAT Start Date Tenor Date 12 0 Date Yes Public
SPDDAT Start Past-due Date Date 12 0 Date Yes Public
OPNDAT Date Opened Date 12 0 Date Yes Public
CLSDAT Date Closed Date 12 0 Date Yes Public
TENDAY Tenor Days Numeric 5 0 Edit Yes Public
ACTFINDAY Actual Financed Days Numeric 5 0 Edit Yes Public
INTRAT Margin (Spread) applied to Interest Rate Numeric 14 6 Edit Yes Public
OWNUSR Resp. User Text 8 1 20 Edit Yes Public <fixed-length>
VER Version Text 4 1 Edit Yes Public
IRTCOD Base Rate Text 6 1 Edit Yes Public IRTTXT
EXTNMB Number of Extensions Numeric 4 0 Edit Yes Public
FINTYP Type of Financing Text 3 1 Edit Yes Public Embedded
PCTFIN % Financed Numeric 5 2 Edit Yes Public
STAGOD Good's Code (for Statistics) Text 6 1 Edit Yes Public GODCOD
STACTY Country Code (for Statistics) Text 2 1 Edit Yes Public CTYTXT
FINRECFLG Recourse Flag Text 1 1 Edit Yes Public
FINSUBTYP Special Type of Financing Text 2 1 Edit Yes Public Embedded
FINRSKTYP Type of Risk Text 2 1 Edit Yes Public Embedded
BEGINTDAT Interest Start Date Date 12 0 Date Yes Public
CSHRAT Cash Base Numeric 14 6 Edit Yes Public
ENDINTDAT Interest Due Date Date 12 0 Date Yes Public
GRADAY Grace Days Numeric 2 0 Edit Yes Public
LQDRAT Liquidity Costs Numeric 14 6 Edit Yes Public
OPNTRNINR TRNINR which L/C Opened/Issued Text 8 1 Edit Yes Public
OWNRAT Our Share of Interest Numeric 14 6 Edit Yes Public
ROLOVRFLG Roll-Over Financing Text 1 1 Edit Yes Public
SHPFRO Shipment from Text 65 1 Edit Yes Public
SHPFRO23 Shipment from Text 140 1 65 Edit Yes Public
PORLOA Port of Loading Text 65 1 Edit Yes Public
PORLOA23 Port of Loading Text 140 1 65 Edit Yes Public
PORDIS Port of Discharge Text 65 1 Edit Yes Public
PORDIS23 Port of Discharge Text 140 1 65 Edit Yes Public
SHPTO For Transportation to Text 65 1 Edit Yes Public
SHPTO23 For Transportation to Text 140 1 65 Edit Yes Public
TRPDOCTYP Transport Document Type Text 6 1 Edit Yes Public
TRPDOCNUM Transport Document Number Text 40 1 Edit Yes Public
TRADAT Date of Transport Document Date 12 0 Date Yes Public
TRAMOD Mode of Transport Text 6 1 Edit Yes Public
INCTRMCOD Incoterm Code Text 3 1 Edit Yes Public Embedded
INCTRMVER Incoterm Version Text 1 1 Edit Yes Public Embedded
SHPFLG Provide Shipment Details Text 1 1 Edit Yes Public
PSTDUESTG Past Due Stage Text 3 1 Edit Yes Public Embedded
PSTDUEDAT Past Due Date set in TRTLAT Date 12 0 Date Yes Public
INTCAPFLG Interest To Be Capitalized Text 1 1 Edit Yes Public
TRXAMT Open Interest Amount Numeric 18 2 Edit Yes Public
TRXRFBAMT Forwarded Refinancing Interest Amount Numeric 18 2 Edit Yes Public
PDURAT Past Due Margin Numeric 14 6 Edit Yes Public
TRXCUR Currency of Open Interest Amount Text 3 1 Edit Yes Public
TRXRFBCUR Currency of Forwarded Refinancing Interest Amount Text 3 1 Edit Yes Public
ETYEXTKEY Entity holding Contract Text 8 1 Edit Yes Public
BACRMNDAY BA remaining financing tenor days Numeric 4 0 Edit Yes Public
BACSTDTEN Standard Tenor for FIA Numeric 3 0 Edit Yes Public
BACUSADAT Bill/usance start date Date 12 0 Date Yes Public
BPDINR INR of corresponding BP contract Text 8 1 Edit Yes Public
DRWVOCNUM draft serial number Text 6 1 Edit Yes Public
ECRMET Drawdown Method for ECR Text 3 1 Edit Yes Public Embedded
ECRTRDDAT Transport Document Date Date 12 0 Date Yes Public
FINAMT Financed Amount (BA) Numeric 18 3 Edit Yes Public
FINCUR Currency of Financed Amount Text 3 1 Edit Yes Public
INTDAY Interest Days Numeric 4 0 Edit Yes Public
PAYSUPFLG Pay supplier Text 1 1 Edit Yes Public
RESFLG Reserved Contract Text 1 1 Edit Yes Public Embedded
PRDCOD Product Code Text 6 1 Edit Yes Public PRDCOD
PRDSUB Product Subtype Text 6 1 Edit Yes Public PRDSUB
PRDVAR Product Variant Text 6 1 Edit Yes Public PRDVAR

Indices

Name Fields Properties
TRD_ETYEXTKEY ETYEXTKEY
TRD_INR INR Unique
TRD_NAM NAM
TRD_OWNREF OWNREF
TRD_PNTINR PNTTYP, PNTINR
TRD_PNTREF PNTREF

/


Lock

INR

Datafield Description and Properties


Datafield INR Internal Unique ID

Description

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 TRD. The field INR is used to enable links from other tables to this table. It also links the two tables TRD and TRT as associated entries hold the same INR.

Helpinformation

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 OWNREF Own Reference

Description

This field contains the reference number of the loan being established. The reference number can have a maximum size of 16 characters. This field can be used to search for any loan from the database.

Helpinformation

This field contains the reference number of the trust receipt. The reference number can contain up to 16 characters. and should be defined as a database key field to optimize performance. The field can also be used to search for a bill received from the database.


Datafield NAM Name

Description

This field holds the displayed descriptive name used in the application to describe the contract and to search for a contract. Within the default configuration this field is set by a default rule based on contract amount and main party and cannot be modified by the user.

Helpinformation

This field holds the name of the trust receipt loan displayed externally. The name can contain up to 40 characters and should be defined as a database key field to optimize performance.


Datafield CREDAT Date Created

Description

This date field holds the date when the entry was physically added to the database. This may happen when opening the contract, when reserving the reference number or when, for other reasons, a contract is added to the database.

Helpinformation

This date field identifies the date the entry was physically added to the database.


Datafield PNTTYP Parent Contract Type

Description

This field contains the type of the parent contract.

Helpinformation

This field contains the type of the parent contract.


Datafield PNTINR Parent Contract INR

Description

This field contains the internal unique ID of the parent contract.

Helpinformation

This field contains the unique identifcation number of the parent contract.


Datafield PNTNAM Name of Parent Contract

Description

This field holds the displayed descriptive name of the parent contract.

Helpinformation

This field holds the descriptive name of the parent contract.


Datafield PNTREF Parent Reference

Description

This field holds the reference of the parent contract.

Helpinformation

This is the reference number of the parent contract.


Datafield ISSDAT Date Issued

Description

This date field contains the issuance date of the financing / loan contract and is used for calculation of the actual financed days. If not entered manually it will be defaulted with the actual date.

Helpinformation

This field holds the date a trust receipt loan was issued.


Datafield MATDAT Maturity Date

Description

This field contains the maturity of the loan. The interest is charged until the maturity date.

Helpinformation

This field contains the date a trust receipt loan matures. Interest is charged until the maturity date.


Datafield LSTINTDAT Last Interest Settlement

Description

This date field contains the date, on which interest has been settled the last time.

Helpinformation

This field contains the date of the last interest settlement.


Datafield STTTENDAT Start Date Tenor

Description

This date field contains the starting date of the financing / loan contract and is used for calculation of the actual financed days. If not entered manually it will be defaulted with the actual date.

Helpinformation

This field holds the starting date of the trust receipt loan.


Datafield SPDDAT Start Past-due Date

Description

This date field is set to maturity date and can be used for calculation of the past due period.

Helpinformation

This field contains the date on which the past-due date is to start.


Datafield OPNDAT Opening Date

Description

The field holds the opening/issuing date of a contract. If this field is set, the contract has been legally established and it might be used for business transactions. This date describes the point in time when this contract became legally binding. This might be a date prior to the creation date, when the contract was legally binding before it was stored in the database.

Helpinformation

The field holds the opening/issuing date of the contract. If this field is set, the contract has been legally established and it might be used for business transactions. This date describes the point in time when this contract became legally binding. This might be a date prior to the creation date, when the contract was legally binding before it was stored in the database.


Datafield CLSDAT Date Closed

Description

This fields holds the closing date of a contract. If this field is set, the contract is closed and may no longer be used for transaction processing of business transactions. The date specifies the date when the closing took place.

Helpinformation

This fields indicates the closing date of a contract. If an entry has been made, the contract is closed and may no longer be used to process business transactions except special transactions like Settling Charges or Common Messages.


Datafield TENDAY Tenor Days

Description

Tenor Days, maximum value is 99.999 days. Difference between start tenor date and due date, if no special TR-conditions for party (TRDCNDFLG) with initial TR-tenor (TRDTENINI) exists

Helpinformation

This field contains the tenure of the loan in figures.


Datafield ACTFINDAY Actual Financed Days

Description

This field hold the number of days between the issuance date and the maturity date of the loan. It is calculated automatically in case both dates are entered. If one of the dates is not entered, this field will be empty.

Helpinformation

This field displays the total number of days financed.


Datafield INTRAT Surcharge Applied to Interest Rate

Description

This field contains the margin applied to a loan/ financing contract.

Helpinformation

This field contains the surcharge on interest applied to a loan/financing contract.


Datafield OWNUSR Responsible User

Description

This field holds the user ID of the person who is responsible for handling this contract. This field is an optional field. Within Demobank it is initially filled with the user ID of the user creating/opening the contract.

Helpinformation

This field holds the User ID of the person responsible for handling this contract.


Datafield VER Version

Description

This field holds the version counter to keep track of the version history of a TRD entry. The individual versions are controlled by entries in the SLG table.

Helpinformation

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.


Datafield IRTCOD Base Rate

Description

This field contains the base rate for interest calculation.

Helpinformation

This field contains the base rate used to calculate interest.


Datafield EXTNMB Number of Extensions

Helpinformation

This field contains the maximum number of extensions allowed under the financed contract.


Datafield FINTYP Type of Financing

Description

This field contains the type of financing.

Helpinformation

This field contains the type of financing.

Codetable
Code Text
TRF Trust Receipt
LOA Clean Loan
PCL Packing credit
BEL Export Loan
BAA Bankers Accept.
ECR ECR Financing
OTH Other
RFI Int.Refinancing
RFN Refinancing

Datafield PCTFIN % Financed

Description

This field contains the financed portion in percent of the parent contract amount. If no parent contract is financed, this field is empty.

Helpinformation

This field contains the financed portion in percent of the parent contract amount. If no parent contract is financed, this field is empty.


Datafield STAGOD Goods Code (for Statistics)

Description

The field can be used for statistical reasons and allows to evaluate financings by the types of goods that were shipped under the financing. The codetable for this field can be customized by the bank according to their needs.

Helpinformation

This field contains the type of goods shipped. The goods code is used to evaluate contracts by the type of goods. The codetable can be customized by the bank according to their needs.


Datafield STACTY Country Code (for Statistics)

Description

This field indicates the risk country of the loan / financing. It is used for statistical reasons and allows the reimbursing bank to evaluate the country risks it may have entered by issuing an reimbursement undertaking.

Helpinformation

This field indicates the risk country of the loan / financing. It is used for statistical reasons and allows the bank to evaluate the country risks it may have entered by issuing the financing.


Datafield ETYEXTKEY Entity holding Contract

Description

This table is defined on entity level with separate entries for each entity. This field holds the EXTKEY of the owning entity to identify the logical owner of this entry. This field is filled automatically during insert and is used as filter when accessing the database. Without special implementation only entries of the currently active entity are visible to the user.

Helpinformation

This table is defined on entity level with separate entries for each entity. This field holds the EXTKEY of the owning entity to identify the logical owner of this entry. This field is filled automatically during insert and is used as filter when accessing the database. Without special implementation only entries of the currently active entity are visible to the user. This field holds the external key of the owning entity to identify the logical owner of this entry.

This field is filled automatically during insert and is used as filter when accessing the database. Without special implementation only entries of the currently active entity are visible to the user.


Datafield BACRMNDAY BA remaining financing tenor days

Description

This is the number of days computed from business date (today) to maturity/due date

Helpinformation

This is the number of days computed from business date (today) to maturity/due date


Datafield BACSTDTEN Standard tenor

Helpinformation

Standard tenor of the party to the financing.


Datafield BACUSADAT Bill/ Usance Start Date

Description

This is the earliest date on supporting documents (bill of exchange or invoice) for bill under credit / usance terms.

Helpinformation

The Start Date of a Bankers Acceptance is calculated as the earliest invoice date of all registered invoices.


Datafield BPDINR INR of corresponding BP contract

Description

This field contains the internal unique ID of the corresponding BP contract.

Optional field, used for ECR financings.

Helpinformation

This field contains the internal unique ID of the corresponding BP contract.

Optional field, used for ECR financings.


Datafield DRWVOCNUM draft serial number

Description

This is the 6-digit number on the BA draft.

Helpinformation

This is the 6-digit number on the BA draft.


Datafield ECRMET Draw down method for ECR

Helpinformation

Possible draw down methods are: ECR-DLC ECR-DPO LPO CRS FIP

Codetable
Code Text
DLC ECR-DLC
DPO ECR-DPO
LPO LPO
CRS CRS
FIP FIP

Datafield ECRTRDDAT Transport Document Date

Helpinformation

Date of the Transport Document


Datafield FINAMT Financed amount (bankers acceptance)

Description

The converted amount of AMT. If XRFCUR has been set, this field holds the converted amount based on the middle rate of the date, when entering the originating CBE entry. If XRFCUR is empty, this field has to be zero.

Helpinformation

This field contains the converted total amount in local currency. If the conversion currency exists, then the conversion will be based on the middle rate. If no conversion currency exists, then this field will be set to zero.


Datafield FINCUR Currency of the financed amount

Description

Currency of the converted amount. This currency is usually set from SYSCUR. This field is an optional field and may be empty, if no converted amount of the specific balance is known.

Helpinformation

This field contains the currency of the converted amount. The currency is normally determined by the system currency. This field is optional and may be blank.


Datafield INTDAY Financing period

Helpinformation

The Financing period indicates the duration of the finance / loan.

The duration / period commences on the Financing Start Date and ends on the Financing Due Date. In case Grace days have been given, these will be added to the duration / period. If the calculated Financing Due Date falls on a holiday or a non-working day, the next working day would be considered as the End date for the financing period calculation. Both the start date and the calculated Financing Due Date date are taken into account for the calculation of the financing period.


Datafield PAYSUPFLG Pay supplier

Description

If checkbox is filled, costumer wants bank to pay supplier on their behalf.

Helpinformation

If checkbox is checked, the costumer wants the bank to pay the supplier on their behalf.


Datafield RESFLG Reserved Contract

Description

Contract status flag. If not empty, contract is reserved. That means, only a few basic fields have to be filled in. Visible on LETP in LETPOP and INFLED. Invisible in all other transactions.

Helpinformation

Contract status flag. If not empty, the contract has been reserved and only a few basic fields have to be filled in.

Codetable
Code Text
Normal Contract
X Reserved Contract

Datafield FINRECFLG Recourse Flag

Description

This field specifies whether recourse can be claimed from the financing party.

Helpinformation

This field specifies whether recourse can be claimed from the financing party.


Datafield FINSUBTYP Special type of financing

Description

This field further specifies the type of the underlying financing.

Helpinformation

This field specifies the special type of financing. Examples are: BA = purchase from reside, BB = purchase from non-reside, BC = Sale to resident, BD = Sale to non-resident

Codetable
Code Text
BA Purchase fr. resident
BB Purchase fr. non-resident
BC Sale to resident
BD Sale to non-resident
OE Overhead Expenses
DP Domestic Purchase
FP Foreign Purchase
BE Export L/C Documents
BR Import L/C Documents
BI Import Collection
BO Export Collection
DA Accepted Draft
DU Unaccepted Draft
IN Invoice
OT Other

Datafield FINRSKTYP Type of risk

Description

This field specifies the type of risk involved in the underlying financing.

Helpinformation

This field specifies the type of risk on which this financing is based. Examples are: BA = bank guarantee, CS = confirmed Standby L/C, CB = confirmed bank guarantee

Codetable
Code Text
BA Bankaval
CS Confirmed Standby LC
CB Confirmed Bank Guarantee
US Unconfirmed Standby LC
UB Unconfirmed Bank Guarantee
DI Credit Issuance
II Indirect Insurance
EA Export Credit Agency
LI Import Letter of Credit
DA Draft avalized by us
CE Confirmed Export LC
CO Corporate
UE Unconfirmed Export LC
BR Bank Risk
SI Standby LC issued by us
GI Guarantee issued by us
OT Other

Datafield BEGINTDAT Interest Start Date

Description

This field hold the current begin date for interest calculation

Helpinformation

The date from which the interest is calculated.


Datafield CSHRAT Cash Base

Description

Costs for refinanzing in the market

Helpinformation

Costs of procuring the funds on the money market.


Datafield ENDINTDAT Interest Due Date

Description

This field hold the current end date for interest calculation

Helpinformation

Date until which interest are calculated.


Datafield GRADAY Grace Days

Description

Additional days for interest calculation

Helpinformation

Additional Grace Days used for interest calculation.


Datafield LQDRAT Liquidity costs

Description

Costs for keeping liquidity

Helpinformation

The liquidity costs refer to the costs of the bank which occur in order to provide the neccessary liquidity.


Datafield OPNTRNINR TRNINR which opened contract

Description

This field holds the INR of the transaction which opened the contract.

Helpinformation

This field holds the INR of the transaction which opened/issued the contract.


Datafield OWNRAT Our margin

Description

Our Share of Interest

Helpinformation

The share of the overall interest rate booked as income in the bank's books. Is pre-defined and noted by rate type possible special terms and conditions.


Datafield ROLOVRFLG Roll-Over Financing

Description

If, checked, the current TR is a roll over tr. That means, that the interest rate is adjusted from time to time.

Helpinformation

Indicates whether the selected contract is a roll-over financing or not.


Datafield PRDCOD Product Code

Description

Initial version to support the differentiation of predefined bank products cross business sectors. This organizational solution is made up of three fields PRDCOD, PRDSUB and PRDVAR providing a bank product, a sub differentiation and individual variants if needed. Here the PRDCOD shall identify the business sector together with some key criteria like confirmed or unconfirmed LC in a cross business sectors unique identification.

Helpinformation

Initial version to support the differentiation of predefined bank products cross business sectors. This organizational solution is made up of three fields PRDCOD, PRDSUB and PRDVAR providing a bank product, a sub differentiation and individual variants if needed. Here the PRDCOD shall identify the business sector together with some key criteria like confirmed or unconfirmed LC in a cross business sectors unique identification.


Datafield PRDSUB Product Subtype

Description

Initial version to support the differentiation of predefined bank products cross business sectors. This organizational solution is made up of three fields PRDCOD, PRDSUB and PRDVAR providing a bank product, a sub differentiation and individual variants if needed. Here the PRDSUB shall identify the business sector specific bankside defined products adding some key sub criteria in a cross business sectors unique identification.

Helpinformation

Initial version to support the differentiation of predefined bank products cross business sectors. This organizational solution is made up of three fields PRDCOD, PRDSUB and PRDVAR providing a bank product, a sub differentiation and individual variants if needed. Here the PRDSUB shall identify the business sector specific bankside defined products adding some key sub criteria in a cross business sectors unique identification.


Datafield PRDVAR Product Variant

Description

Initial version to support the differentiation of predefined bank products cross business sectors. This organizational solution is made up of three fields PRDCOD, PRDSUB and PRDVAR providing a bank product, a sub differentiation and individual variants if needed. Here the product variant is intended as possible extension to setup specific variants below the product and subproduct code.

Helpinformation

Initial version to support the differentiation of predefined bank products cross business sectors. This organizational solution is made up of three fields PRDCOD, PRDSUB and PRDVAR providing a bank product, a sub differentiation and individual variants if needed. Here the product variant is intended as possible extension to setup specific variants below the product and subproduct code.


Datafield SHPFRO Shipment from

Description

This field specifies the place of taking in charge (in case of a multimodal transport document), the place of receipt (in case of a road, rail or inland waterway transport document or a courier or expedited delivery service document), the place of dispatch or the place of shipment to be indicated on the transport document.

Helpinformation

This field specifies the place of transfer (in the case of a multimodal transport document), the place of receipt (in the case of a road, rail or inland waterway transport document or a courier or express delivery service document), the place of dispatch or the place of shipment to be indicated on the transport document.


Datafield PORLOA Port of Loading

Description

This field specifies the port of loading or airport of departure to be indicated on the transport document.

Helpinformation

This field specifies the port or airport of departure indicated on the transport document.


Datafield PORDIS Port of Discharge

Description

This field specifies the port of discharge or airport of destination to be indicated on the transport document.

Helpinformation

This field contains the port or airport of destination, where the goods shipped under the L/C are unloaded. This is not necessarily the place of delivery.


Datafield SHPTO For Transportation to

Description

This field specifies the final destination or place of delivery to be indicated on the transport document.

Helpinformation

This field specifies the final destination of the goods shipped under the underlying contract.


Datafield TRPDOCTYP Transport Document Type

Description

This field indicates the type of transport document (e.g. bill of lading, airway bill etc.) which is presented under this Loan.

Helpinformation

This field indicates the type of transport document (e.g. bill of lading, air waybill etc).


Datafield TRPDOCNUM Transport Document Number

Description

This field indicates the number of the transport document (e.g. number of bill of lading, airway bill).

Helpinformation

This field indicates the unique reference number assigned to the transport document (e.g. bill of lading number or air waybill number).


Datafield TRADAT Date of Transport Document

Description

This field indicates the date of the transport document (e.g. bill of lading, airway bill) which is presented under this Loan.

Helpinformation

This field indicates the date the transport document (e.g. bill of lading, air waybill) was issued.


Datafield TRAMOD Mode of Transport

Description

This field indicates how the goods have been shipped (e.g. via sea, air or a combination of different transport modes).

Helpinformation

This field indicates how the goods have been shipped (e.g. via sea, or air or a combination of different transport modes).


Datafield INCTRMCOD Incoterm Code

Helpinformation

To select from the list of available Incoterms.

Codetable
Code Text
CIF CIF
CFR CFR
FOB FOB
FCA FCA
FAS FAS
CPT CPT
CIP CIP
DAF DAF
DDP DDP
DDU DDU
DES DES
DEQ DEQ
EXW EXW
DPU DPU

Datafield INCTRMVER Incoterm Version

Helpinformation

This field refers to the published version of the Incoterms.

Codetable
Code Text
1 Incoterm Version 2010
2 Incoterm Version 2000
3 Incoterm Version 2020

Datafield SHPFLG Provide Shipment Details

Description

If the checkbox is selected, it opens the shipment details panel where details of the shipment are to be provided.

Helpinformation

If the checkbox is selected, it opens the shipment details panel where details of the shipment are to be provided.


Datafield PSTDUESTG Past Due Stage

Description

This field contains the past due stage of the loan as specified in the ETG / ETY setting for the finance type.

Helpinformation

This field contains the past due stage of the loan as specified in the ETG / ETY setting for the finance type.

Codetable
Code Text
GRA Grace
PDU Past Due
NPF Non Performance
WOF Write Off
Not Past Due
NPM Non Performance

Datafield PSTDUEDAT Past Due Date set in TRTLAT

Description

This field specifies the date when the loan becomes past due according to the ETG/ ETY settings.

Helpinformation

This field specifies the date when the loan becomes past due according to the ETG/ ETY settings.


Datafield INTCAPFLG Interest To Be Capitalized

Description

This field specifies the interest of a past due loan that has to be capitalized.

Helpinformation

This field specifies the interest of a past due loan that has to be capitalized.


Datafield TRXAMT Open Interest Amount

Description

Open Interest Amount: Pending TRCX commission amount which is yet to be settled.

Helpinformation

Open Interest Amount: Pending TRCX commission amount which is yet to be settled.


Datafield TRXRFBAMT Forwarded Refinancing Interest Amount

Description

Open Past Due Interest: Pending TRCXPD commission amount which are yet to be settled.

Helpinformation

Open Past Due Interest: Pending TRCXPD commission amount which are yet to be settled.


Datafield PDURAT Pastdue Margin

Description

Past Due Interest Rate (TRCXPD)

Helpinformation

The share of Past due total interest if contract moves to Past due status. It is/ can be pre-defined from fee setup of past due commission.


Datafield TRXCUR Currency of Open Interest Amount

Description

Currency of the converted amount. This currency is usually set from SYSCUR. This field is an optional field and may be empty, if no converted amount of the specific balance is known.

Helpinformation

Currency of the converted amount. This currency is usually set from SYSCUR. This field is an optional field and may be empty, if no converted amount of the specific balance is known.


Datafield TRXRFBCUR Currency of Forwarded Refinancing Interest Amount

Description

Currency of the converted amount. This currency is usually set from SYSCUR. This field is an optional field and may be empty, if no converted amount of the specific balance is known.

Helpinformation

Currency of the converted amount. This currency is usually set from SYSCUR. This field is an optional field and may be empty, if no converted amount of the specific balance is known.


Datafield SHPFRO23 Shipment from

Description

Introduced with Swift Release 2023 This field specifies the place of taking in charge (in case of a multimodal transport document), the place of receipt (in case of a road, rail or inland waterway transport document or a courier or expedited delivery service document), the place of dispatch or the place of shipment to be indicated on the transport document.


Datafield PORLOA23 Port of Loading

Description

Introduced with Swift Release 2023 This field specifies the port of loading or airport of departure to be indicated on the transport document.


Datafield PORDIS23 Port of Discharge

Description

Introduced with Swift Release 2023 This field specifies the port of discharge or airport of destination to be indicated on the transport document.


Datafield SHPTO23 For Transportation to

Description

Introduced with Swift Release 2023 This field specifies the final destination or place of delivery to be indicated on the transport document.