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.
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 |
Name | Fields | Properties |
---|---|---|
LET_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 LED record. Thus the field INR is used to link the two tables LED and LET 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 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.
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).
This field specifies the payment dates, amounts and/or methods of an L/C that is available by deferred payment.
This field specifies the date of payment or methods to determine it if the conctract offers a deferred payment option.
This field specifies the terms of drafts to be drawn under the L/C.
This field specifies the terms of the drafts to be drawn under the underlying contract
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.
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.
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.
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.
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.
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)'.
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.
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)'.
This field specifies the payment dates, amounts and/or methods of an L/C that is available by mixed payment.
This field specifies the payment dates, amounts and/or methods of the underlying contract if available by mixed payment.
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.
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.
This field specifies the shipment period in which goods have to be shipped in order for the documents to be L/C compliant.
This field specifies the shipment period in which goods are to be shipped in order for the documents to be L/C-compliant.
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.
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.
This field contains the history of amendments to field ADLCND ('Additional Conditions').
This field contains the history of amendments to the field 'Additional Conditions'.
This field contains the history of amendments to the goods description of the L/C.
This field contains the history of amendments to the description of goods required under the underlying contract.
This field contains the history of amendments to the documents required under the L/C.
This field contains the history of amendments to the documents required under the underlying contract.
This field contains the history of amendment narratives to the L/C.
This field contains the history of amendment narratives to the L/C.
This field specifies any additional amount available to the beneficiary under the L/C, such as insurance premium, freight charges etc.
This field specifies any additional amount available to the beneficiary under the L/C, such as insurance premium, freight charges, etc.
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 can be used to enter information for the beneficiary regarding the revolving of the L/C.
This field can be used to enter information for the beneficiary regarding the revolving L/C.
This field is used to enter revolving clauses for the revolving of the L/C.
This field is used to enter clauses for the revolving L/C.
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.
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.
This field contains the history of amendments to the instructions to paying, accepting, negotiating bank.
This field contains the history of amendments to the instructions to the paying, accepting, negotiating bank.
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
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.
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).
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.
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).
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.
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).
This field contains the special payment conditions for beneficiary.
This field contains the special payment conditions for beneficiary.
This field contains the special payment conditions for receiving bank.
This field contains the special payment conditions for receiving bank.
This field contains the history of special payment conditions for beneficiary of the L/C.
This field contains the history of special payment conditions for beneficiary of the L/C.
This field contains the history of special payment conditions for receiving bank of the L/C.
This field contains the history of special payment conditions for receiving bank of the L/C.
Notification information about auto-extension to beneficiary
Notification information about auto-extension to beneficiary
This field holds all activated checboxes of “Allow *” to carry them automatically forward in follow transaction.
This field holds all activated checboxes of “Allow *” to carry them automatically forward in follow transaction.
This field contains instructions from Intermediary Bank
This field specifies the instructions to the bank advising the Export LC to the Beneficiary.