Table of Contents

LET - Export L/C Text

Module LET

Description

LET is the data table for text blocks and other large fields (not used in search functions) for Export L/C contracts.
LED and LET are linked by using the same INR contents.


Datafields

Name Description Data Type Len Dec. View lines View type Inst. Visible Codetable
INR Internal Unique ID of Export L/C Text 8 1 Edit Yes Public
ADLCND Additional Conditions Block 65 800 Block Yes Public
DEFDET Deferred Payment Details Block 35 4 4 Block Yes Public
DFTAT Drafts at Block 35 3 3 Block Yes Public
FEETXT Additional Details to Code for Charges (CHATO) Block 35 6 6 Block Yes Public
INSBNK Instructions to Paying/Accepting/Negotiating Bank Block 65 12 6 Block Yes Public
LCRDOC Documents Required Block 65 800 Block Yes Public
LCRGOD Description of Goods Block 65 800 Block Yes Public
MIXDET Mixed Payment Details Block 35 4 4 Block Yes Public
PREPER Presentation Period Block 35 4 4 Block Yes Public
SHPPER Shipment Period Block 65 6 4 Block Yes Public
VER Version Counter Text 4 1 Edit Yes Public
ADLCNDAME Additional Conditions (History) Block 50 999 10 Block Yes Public
LCRGODAME Description of Goods (History) Block 50 999 10 Block Yes Public
LCRDOCAME Documents Required (History) Block 50 999 10 Block Yes Public
NARTXTAME Narrative (History) Block 50 999 20 Block Yes Public
ADDAMTCOV Additional Amount Covered Block 35 4 4 Block Yes Public
FLDMODBLK List of Modified Fields in LEDGRP Block 40 500 30 Block Yes Public
REVNOTES Notes to Beneficiary Block 35 6 6 Block Yes Public
REVCLS Revolving Clause Block 65 6 6 Block Yes Public
AVBWTHTXT Available in Block 35 4 4 Block Yes Public
INSBNKAME Instruction to Paying/Accepting/Negotiating Bank (History) Block 50 999 10 Block Yes Public
CONTAG72 Content of TAG 72 Block 35 999 10 Block Yes Public
CONTAG79 Content of TAG79 Block 50 999 10 Block Yes Public
INCAPLADRBLK Address Info Applicant received Block 35 4 4 Block Yes Public
INCBENACT Account Beneficiary Received Text 35 1 Edit Yes Public
INCBENADRBLK Address Info Beneficiary received Block 35 4 4 Block Yes Public
SPCBEN Special Payment Conditions for Beneficiary Block 65 800 Block Yes Public
SPCRCB Special Payment Conditions for Bank Only Block 65 800 Block Yes Public
SPCBENAME Special payment Conditions for beneficiary (History) Block 50 999 Block Yes Public
SPCRCBAME Special Payment Conditions for Bank Only (History) Block 50 800 Block Yes Public
CHKASTSTM Stream with CHKAST Stream 1 0 Source Yes Public
INS78D Instructions from Intermediary Bank Block 65 12 12 Block Yes Public
NOTTXT Notification Information Block 65 12 4 Block Yes Public

Indices

Name Fields Properties
LET_INR INR Unique

/


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 filled from the INR field of the associated LED record. Thus the field INR is used to link the two tables LED and LET 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 ADLCND Additional Conditions

Description

This field contains any additional conditions for the L/C.

The content in this field is that when the L/C was issued. Amendments to the additional conditions are listed in ADLCNDAME.

Helpinformation

This field contains any additional conditions relating to the L/C. This field is the same as when the L/C was issued. Amendments to the additional conditions are listed in Additional Conditions (History).


Datafield DEFDET Deferred Payment Details

Description

This field specifies the payment dates, amounts and/or methods of an L/C that is available by deferred payment.

Helpinformation

This field specifies the date of payment or methods to determine it if the conctract offers a deferred payment option.


Datafield DFTAT Drafts at

Description

This field specifies the terms of drafts to be drawn under the L/C.

Helpinformation

This field specifies the terms of the drafts to be drawn under the underlying contract


Datafield FEETXT Additional Details to Charges Condition

Description

Detailed charges information can be given to the receiver of the L/C in this field. For example, the information entered here is available in TAG 71B of the outgoing MT720 in case the L/C is advised through a second advising bank.

Helpinformation

Detailed charges information can be given to the receiver of the L/C in this field. For example, the information entered here is available in TAG 71B of the outgoing MT710 if the L/C is advised through a second advising bank.


Datafield INSBNK Instructions to Paying/Accepting/Negotiating Bank

Description

This field contains instructions to a paying, accepting or negotiating bank. The content in this field is that when the L/C was issued. Amendments to the instructions to P/A/N are listed in INSBNKAME.

Helpinformation

This field contains instructions to a paying, accepting or negotiating bank when the L/C was issued. Amendments to the instructions to P/A/N are listed in the 'Historic Overview' field.


Datafield LCRDOC Documents Required

Description

This field contains a list of documents which are required under the L/C. The content in this field is that when the L/C was issued. Amendments to the required documents are listed in LCRDOCAME.

Helpinformation

This field contains a list of documents which are required under the underlying obligation contract. The content in this field is that when the obligation was issued. Amendments to the required documents are listed in Documents Required (History)'.


Datafield LCRGOD Description of Goods

Description

This field contains a description of goods and/or services which are secured through the L/C. The content in this field is that when the L/C was issued. Amendments to the description of goods are listed in LCRGODAME.

Helpinformation

This field contains a description of goods and/or services which are secured through the underlying obligation contract. The content in this field is that when the contract was issued. Amendments to the description of goods are listed in field 'Description of Goods (History)'.


Datafield MIXDET Mixed Payment Details

Description

This field specifies the payment dates, amounts and/or methods of an L/C that is available by mixed payment.

Helpinformation

This field specifies the payment dates, amounts and/or methods of the underlying contract if available by mixed payment.


Datafield PREPER Presentation Period

Description

This field contains the presentation period, being the period of time during which documents have to be presented in order to be L/C compliant.

Helpinformation

This field contains the presentation period, i.e. the period of time during which documents are to be presented in order to be L/C-compliant.


Datafield SHPPER Shipment Period

Description

This field specifies the shipment period in which goods have to be shipped in order for the documents to be L/C compliant.

Helpinformation

This field specifies the shipment period in which goods are to be shipped in order for the documents to be L/C-compliant.


Datafield VER Version

Description

This field holds the version counter to keep track of the version history of an LET 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 ADLCNDAME Additional Conditions (History)

Description

This field contains the history of amendments to field ADLCND ('Additional Conditions').

Helpinformation

This field contains the history of amendments to the field 'Additional Conditions'.


Datafield LCRGODAME Description of Goods (History)

Description

This field contains the history of amendments to the goods description of the L/C.

Helpinformation

This field contains the history of amendments to the description of goods required under the underlying contract.


Datafield LCRDOCAME Documents Required (History)

Description

This field contains the history of amendments to the documents required under the L/C.

Helpinformation

This field contains the history of amendments to the documents required under the underlying contract.


Datafield NARTXTAME Narrative (History)

Description

This field contains the history of amendment narratives to the L/C.

Helpinformation

This field contains the history of amendment narratives to the L/C.


Datafield ADDAMTCOV Additional Amount Covered

Description

This field specifies any additional amount available to the beneficiary under the L/C, such as insurance premium, freight charges etc.

Helpinformation

This field specifies any additional amount available to the beneficiary under the L/C, such as insurance premium, freight charges, etc.


Datafield FLDMODBLK List of Modified Fields

Description

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.

Helpinformation

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.


Datafield REVNOTES Notes to Beneficiary

Description

This field can be used to enter information for the beneficiary regarding the revolving of the L/C.

Helpinformation

This field can be used to enter information for the beneficiary regarding the revolving L/C.


Datafield REVCLS Revolving Clause

Description

This field is used to enter revolving clauses for the revolving of the L/C.

Helpinformation

This field is used to enter clauses for the revolving L/C.


Datafield AVBWTHTXT Available in

Description

This field holds additional text information regarding availability of the L/C in case in field LED.AVBWTH (“Available with”) “Any Bank” has been selected. In most cases, a country will be entered in this field.

Helpinformation

This field holds additional text information regarding availability of the contract, if the “Any Bank” option has been selected in the “Available with” field. In most cases, a country will be entered in this field.


Datafield INSBNKAME Instruction to Paying/Accepting/Negotiating Bank (History)

Description

This field contains the history of amendments to the instructions to paying, accepting, negotiating bank.

Helpinformation

This field contains the history of amendments to the instructions to the paying, accepting, negotiating bank.


Datafield CONTAG72 Content of TAG 72

Description

This field contains the history of former TAGs 72.

Helpinformation

This field contains the history of former TAGs 72


Datafield CONTAG79 Content of TAG 79

Description

This field contains the history of former TAGs 79.

Helpinformation

This field contains the history of former TAGs 79


Datafield INCAPLADRBLK Address Info Applicant received

Description

Address information of applicant from received SWIFT message, filled from incoming message and used for outgoing MT710 (as in MT 710 the address information should be the same as in received MT 700, even if address information of applicant differs between database and received message.

Helpinformation

Address information of applicant from received SWIFT message, filled from incoming message and used for outgoing MT710 (as in MT 710 the address information should be the same as in received MT 700, even if address information of applicant differs between database and received message).


Datafield INCBENACT Account Beneficiary Received

Description

Account information of beneficiary from received SWIFT message, filled from incoming message and used for outgoing MT710 (as in MT 710 the account information should be the same as in received MT 700, even if account number had been changed in the contract.

Helpinformation

Account information of beneficiary from received SWIFT message, filled from incoming message and used for outgoing MT710 (as in MT 710 the account information should be the same as in received MT 700, even if account number had been changed in the contract).


Datafield INCBENADRBLK Address Info Beneficiary received

Description

Address information of beneficiary from received SWIFT message, filled from incoming message and used for outgoing MT710 (as in MT 710 the address information should be the same as in received MT 700, even if address information of beneficiary differs between database and received message.

Helpinformation

Address information of beneficiary from received SWIFT message, filled from incoming message and used for outgoing MT710 (as in MT 710 the address information should be the same as in received MT 700, even if address information of beneficiary differs between database and received message).


Datafield SPCBEN Special Payment Conditions for Beneficiary

Description

This field contains the special payment conditions for beneficiary.

Helpinformation

This field contains the special payment conditions for beneficiary.


Datafield SPCRCB Special Payment Conditions for Bank Only

Description

This field contains the special payment conditions for receiving bank.

Helpinformation

This field contains the special payment conditions for receiving bank.


Datafield SPCBENAME Special payment Conditions for beneficiary (History)

Description

This field contains the history of special payment conditions for beneficiary of the L/C.

Helpinformation

This field contains the history of special payment conditions for beneficiary of the L/C.


Datafield SPCRCBAME Special Payment Conditions for Bank Only (History)

Description

This field contains the history of special payment conditions for receiving bank of the L/C.

Helpinformation

This field contains the history of special payment conditions for receiving bank of the L/C.


Datafield NOTTXT Notification Information

Description

Notification information about auto-extension to beneficiary

Helpinformation

Notification information about auto-extension to beneficiary


Datafield CHKASTSTM Stream with CHKAST

Description

This field holds all activated checboxes of “Allow *” to carry them automatically forward in follow transaction.

Helpinformation

This field holds all activated checboxes of “Allow *” to carry them automatically forward in follow transaction.


Datafield INS78D Instructions from 1st Advising Bank

Description

This field contains instructions from Intermediary Bank

Helpinformation

This field specifies the instructions to the bank advising the Export LC to the Beneficiary.