Table of Contents

LID - Import L/C Data

Module LID

Description

LID is the main data table for the Import L/C contract.
All technical important fields have to be defined here.
Large text blocks should be defined in LIT.


Datafields

Name Description Data Type Len Dec. View lines View type Inst. Visible Codetable
INR Internal Unique ID of Import L/C Text 8 1 Edit Yes Public
OWNREF Reference Text 16 1 Edit Yes Public
NAM Externally Displayed Name to Identify the Contract Text 80 1 Edit Yes Public
OWNUSR Responsible User Text 8 1 20 Edit Yes Public <fixed-length>
OPNTRNINR TRNINR which L/C Opened/Issued Text 8 1 Edit Yes Public
CREDAT Date of Creation (Opening or Registry) Date 12 0 Date Yes Public
OPNDAT Date L/C Opened/Issued Date 12 0 Date Yes Public
CLSDAT Date L/C Closed Date 12 0 Date Yes Public
ADVNAM Advising Bank Text 40 1 Edit Yes Public
ADVREF Advising Bank Reference Text 16 1 Edit Yes Public
AMEDAT Date of Last Amendment Date 12 0 Date Yes Public
AMENBR Counter for Number of Amendments Numeric 3 0 Edit Yes Public
APLNAM Applicant Address Text 40 1 Edit Yes Public
APLREF Applicant Reference Text 16 1 Edit Yes Public
AVBBY Available by Text 1 1 Edit Yes Public AVBBY0
AVBWTH Available with Text 1 1 Edit Yes Public AVBWTH
BENNAM Beneficiary Text 40 1 Edit Yes Public
BENREF Beneficiary Reference Text 16 1 Edit Yes Public
CHATO Own Charges Borne by Text 1 1 Edit Yes Public CHADET
CNFDET Confirmation Instructions Text 1 1 Edit Yes Public CNFFLG
EXPDAT Date of Expiry Date 12 0 Date Yes Public
EXPPLC Place of Expiry Text 29 1 Edit Yes Public
LCRTYP Form of Documentary Credit Text 2 1 Edit Yes Public LCRTYP
NOMSPC Amount Specification Text 1 1 Edit Yes Public Embedded
NOMTOP Amount Tolerance - Positive Numeric 2 0 Edit Yes Public
NOMTON Amount Tolerance - Negative Numeric 2 0 Edit Yes Public
PREADVDT Date Pre-Opened Date 12 0 Date Yes Public
RMBACT Reimbursing Bank Account Identification Text 35 1 Edit Yes Public
RMBCHA Reimbursing Bank's Charges Text 3 1 Edit Yes Public RMBCHA
RMBFLG Reimbursement Information Text 1 1 Edit Yes Public
SHPDAT Shipment Date Date 12 0 Date 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
SHPPAR Partial Shipment Text 35 1 Edit Yes Public
SHPTO For Transportation to Text 65 1 Edit Yes Public
SHPTO23 For Transportation to Text 140 1 65 Edit Yes Public
SHPTRS Transshipment Text 35 1 Edit Yes Public
STACTY Country Code (Risk Country) Text 2 1 Edit Yes Public CTYTXT
STAGOD Goods Code Text 6 1 Edit Yes Public GODCOD
UTLNBR Count of Received Document Sets Numeric 3 0 Edit Yes Public
ADVNBR Count of Advised Sub-Contracts without Documents Numeric 3 0 Edit Yes Public
REDCLSFLG Red/Green Clause Text 1 1 Edit Yes Public
VER Version Counter Text 4 1 Edit Yes Public
LCITYP Internal Type of L/C (Default: Normal L/C; B: Back to Back) Text 1 1 Edit Yes Public
B2BINR INR of LE Backing this L/C Text 8 1 Edit Yes Public
B2BREF Reference of Contract Backing this L/C Text 16 1 Edit Yes Public
REVNBR Number of Revolvings under L/C Numeric 2 0 Edit Yes Public
REVTIMES Revolving Times Numeric 2 0 Edit Yes Public
REVFLG Revolving Flag Text 1 1 Edit Yes Public
REVAWAPL Awaiting Applicant's Request Text 1 1 Edit Yes Public
REVDAT Revolving Date Date 12 0 Date Yes Public
REVCUM Credit is Marked as Cumulative Text 1 1 Edit Yes Public
REVTYP Revolving Type Text 40 1 Edit Yes Public Embedded
INITPTY Applicant's Bank Text 3 1 Edit Yes Public Embedded
RESFLG Reserved Contract Text 1 1 Edit Yes Public Embedded
APPRUL Applicable Rules Text 30 1 Edit Yes Public Embedded
APPRULRMB Applicable Rules Reimbursement Text 30 1 Edit Yes Public Embedded
APPRULTXT Other Applicable Rules Text 35 1 Edit Yes Public
AUTDAT Date of Authorization to Reimburse Date 12 0 Date Yes Public
ORDDAT Date of customer order Date 12 0 Date Yes Public
REJFLG Direct rejection Text 1 1 Edit Yes Public
REQTYP Type of Request Text 1 1 Edit Yes Public Embedded
AUTRNWFLG Auto-Extension Text 1 1 Edit Yes Public
AOPFLG Assignment of Proceeds Text 1 1 Edit Yes Public
SYNFLG Participation Sold Flag Text 1 1 Edit Yes Public
EXPFLG Unlimited Guarantee Text 1 1 Edit Yes Public
RNWNBR Extension Period Numeric 3 0 Edit Yes Public
NOTNBR Notify Period Numeric 3 0 Edit Yes Public
EXPDATFIN Final Expiry Date Date 12 0 Date Yes Public
RNWPER Extension Period Type Text 1 1 2 Edit Yes Public Embedded
ADVPER Advice Period Type Text 1 1 2 Edit Yes Public Embedded
NOTPER Notify Period Type Text 1 1 2 Edit Yes Public Embedded
INCTRMCOD Incoterm Code Text 3 1 Edit Yes Public Embedded
INCTRMFRT Incoterm Freight Text 1 1 Edit Yes Public Embedded
INCTRMPLC Incoterm Place Text 65 1 Edit Yes Public
INCTRMVER Incoterm Version Text 1 1 Edit Yes Public Embedded
INCDFTON incoming allNETT/RIVO Dradt Drawn On selection Text 1 1 Edit Yes Public Embedded
SHPPARS18 Partial Shipment Text 11 1 Edit Yes Public Embedded
SHPTRSS18 Transshipment Text 11 1 Edit Yes Public Embedded
SPCBENFLG Special payment conditions for beneficiary exists Text 1 1 Edit Yes Public
SPCRCBFLG Special Payment Conditions for specified Bank only Text 1 1 Edit Yes Public
PREPERS18 Days of presentation period Numeric 3 0 Edit Yes Public
PREPERTXTS18 Presentation period text Text 35 1 Edit Yes Public
DFTNBR Draft Number Numeric 2 0 Edit Yes Public
FACINR INR of the linked Facility Text 8 1 Edit Yes Public
DOMFLG Domestic L/C Text 1 1 Edit Yes Public
REDCLSAMT Red/Green Clause Balance Numeric 18 3 Edit Yes Public
REDCLSCUR Red/Green Clause Currency Text 3 1 Edit Yes Public CURTXT
REDCLSPRC Red/Green Clause Percent Numeric 5 2 Edit Yes Public
REDCLSTYP Percentage or Amount Confirmed Text 1 1 Edit Yes Public Embedded
LQDRAT Liquidity Costs Numeric 14 6 Edit Yes Public
IRTCOD Base Rate Text 6 1 Edit Yes Public IRTTXT
CSHRAT Cash Base Numeric 14 6 Edit Yes Public
OWNRAT Our Share of Interest Numeric 14 6 Edit Yes Public
SPFINFLG Specify Loan Term Text 1 1 Edit Yes Public
OWNRATFLG Financing Flat Fee Text 1 1 Edit Yes Public
OWNCUR Document Currency Text 3 1 Edit Yes Public
OWNAMT Financing Flat Fee Amount Numeric 18 3 Edit Yes Public
ALADICOD ALADI Reimb. Code Text 16 1 Edit Yes Public
ALADIFLG Issued under ALADI Text 1 1 Edit Yes Public
UPATYP UPAS / UPAU (Usance Payable at Sight or Usance) Text 4 1 3 Edit Yes Public Embedded
UPAUDS UPAU Days Numeric 3 0 Edit Yes Public
OLDREF Alternate Reference Text 16 1 Edit Yes Public
ETYEXTKEY Entity holding Contract Text 8 1 Edit Yes Public
LCRTERM Terms of delivery Text 3 1 Edit Yes Public Embedded
CLRAVLFLG Book out peak amount set in contract ? Text 1 1 Edit Yes Public
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
INTDAYLC Interest Days Numeric 4 0 Edit Yes Public

Indices

Name Fields Properties
LID_B2BINR B2BINR
LID_B2BREF B2BREF
LID_ETYEXTKEY ETYEXTKEY
LID_INR INR Unique
LID_NAM NAM
LID_OWNREF OWNREF

/


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 that is created by retrieving the next valid entry from the counter LID. The field INR is used to enable links from other tables to this table. It also links the two tables LID and LIT as associated entries holding 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 import L/C. The reference number can have a maximum size of 16 characters. This field can be used to search for an import L/C in the database.

Helpinformation

This field contains the reference number of the import L/C. The reference number can be up to 16 characters long. This field can be used for searching import L/Cs in 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 descriptive name displayed in the application to describe and to search for a contract. in the standard version this field is set by a default rule based on the contract amount and the main party and cannot be modified by the user.


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 CREDAT Date Created

Description

This date field holds the date when the entry was physically added to the database. This may happen when (pre)opening the contract, when reserving the reference number or when, for other reasons (such as data migration), a contract is added to the database.

Helpinformation

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


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. For example, if the L/C has been pre-opened, the creation date (CREDAT) will be before the opening date. If the contract has been migrated, the opening date might be a date prior to the creation date (CREDAT), as 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 ADVNAM Advising Bank

Description

Replicated copy of the field PTS\NAM of the associated entry of the role “ADV”. This field is only used to speed up search and database access.

Helpinformation

This field contains the name of the advising bank.


Datafield ADVREF Advising Bank Reference

Description

Replicated copy of the field PTS\REF of the associated entry of the role “ADV”. This field is only used to speed up search and database access.

Helpinformation

This field contains the reference number of the advising bank.


Datafield AMEDAT Date of Last Amendment

Description

This field contains the date of the last amendment which has been processed under the L/C.

Helpinformation

This field contains the date of the last amendment processed under the contract. If it is empty the contract is still in its original condition. This date is automatically updated by the relevant amendment transactions.


Datafield AMENBR Number of Amendments

Description

This field counts the number of all initiated amendments under the Import L/C. An amendment is initiated when the first transaction of an amendment is finally stored.

The field is technically incremented after loading of the contract in init of all amending transactions (litamr, litram, litame), if no already existing amendment is further processed.

Helpinformation

This field is used to store the number of amendments made to the contract so far. This field is automatically updated from the relevant amendment transaction.


Datafield APLNAM Applicant Address

Description

Replicated copy of the field PTS\NAM of the associated entry of the role “APL”. This field is only used to speed up search and database access.

Helpinformation

This is a copy of relevant field for the 'Applicant'. This field is only used to speed up search and database access.


Datafield APLREF Applicant Reference

Description

Replicated copy of the field PTS\REF of the associated entry of the role “APL”. This field is only used to speed up search and database access.

Helpinformation

This is a copy of relevant field for the 'Applicant'. This field is only used to speed up search and database access.


Datafield AVBBY Available by

Description

This field indicates whether the L/C is available by sight payment, deferred payment, acceptance, negotiation or mixed payment.

Helpinformation

This field indicates whether the contract is available by sight payment, deferred payment, acceptance, negotiation or mixed payment.


Datafield AVBWTH Available with

Description

This field indicates the bank authorized to pay, accept, negotiate or incur a deferred payment for the L/C.

Helpinformation

This field contains the bank/role that is authorized to pay, accept, negotiate or transfer an obligation under a deferred payment for the contract.


Datafield BENNAM Beneficiary

Description

Replicated copy of the field PTS\NAM of the associated entry of the role “BEN”. This field is only used to speed up search and database access.

Helpinformation

This field contains the name of the beneficiary.


Datafield BENREF Beneficiary Reference

Description

Replicated copy of the field PTS\REF of the associated entry of the role “BEN”. This field is only used to speed up search and database access.

Helpinformation

This field contains the reference number of the beneficiary.


Datafield CHATO Fee settlement - our fee to be debited to

Description

This field defines whether the charges and commissions of the issuing bank are borne by the applicant side (=“U”), by the beneficiary side (=“B”) or others. According to the selection entered in this field, the roles in the second settlement grid (own commission/charges) are defaulted.

Helpinformation

This field defines whether the fees and commissions of the bank using using the application is to be borne by applicant or 'Our fees borne by client' (='U'), of the beneficiary side or 'Our fees borne by abroad' (='B') or by other parties. Depending on the selection made in this field, the roles in the second settlement table (own commission / fees) are proposed.

Meaning 'borne by client': If, in the fee settlement field, 'borne by client' was selected or if the field is not completed, then own fees will be proposed in the settlement to the debit of the applicant Side.

Meaning of 'borne by abroad': Own fees in the settlement are proposed to the debit of the beneficiary SIDE

Meaning of 'Others': No role is proposed on the fees in the settlement panel.


Datafield CNFDET Confirmation Instructions

Description

This field contains the confirmation instructions for the receiver of the L/C, e.g. the advising bank (ADV). According to SWIFT regulations, one of the following code words must be selected: “Without”, “May add” or “Confirm”.

Helpinformation

This field contains the confirmation instructions for the receiver of the L/C, e.g. the advising bank. According to SWIFT regulations, one of the following code words must be selected: “Without”, “May add” or “Confirm”.


Datafield EXPDAT Date of Expiry

Description

This date field specifies when the L/C expires and therefore indicates the latest date for the presentation of documents under the Letter of Credit.

Helpinformation

This date field specifies when the L/C expires and therefore indicates the latest date for presentating documents under the L/C.


Datafield EXPPLC Place of Expiry

Description

This field specifies where the L/C expires. The expiry place is closely linked to the expiry date, as it specifies the place where documents have to be presented under the Letter of Credit in more detail.

Helpinformation

This field specifies the place where the L/C expires. The expiry place is closely linked to the expiry date, as it specifies the place where documents have to be presented under the L/C in more detail.


Datafield LCRTYP Form of Documentary Credit

Description

This field specifies the type of L/C. According to SWIFT, further specification codes are available, such as transferable, standby and combinations of these.

Helpinformation

This field specifies the type of L/C. According to UCP, the L/C has to indicate whether it is irrevocable. SWIFT provides for further specification codes, such as transferable or standby and combinations of these. In DTA, the code '..standby' will not be allowed.


Datafield NOMSPC Amount Specification

Description

This field further qualifies the documentary credit amount and becomes important when checking documents presented under the L/C. If the code “not exceeding” is used, no amount tolerance is allowed. If the code “according to UCP” is used, allowances in credit amount are granted according to what is stipulated in article 39 of the UCP.

Helpinformation

This field further qualifies the contract amount and becomes important when checking documents presented under the contract. If the code “not exceeding” is used, no tolerance is permitted. If the code “according to UCP” is used, allowances are granted based on stipulations provided in Article 30 of the UCP.

Codetable
Code Text
N NOT EXCEEDING
X Accord to UCP

Datafield NOMTOP Amount Tolerance - Positive

Description

This field specifies the positive tolerance to the documentary credit amount as percentage plus that amount. In order to calculate the maximum amount (e.g. the maximum risk of the issuing bank), the positive tolerance amount is added to the document amount.

Helpinformation

This field specifies the positive tolerance to the nominal amount of the underlying contract as percentage plus that amount. In order to calculate the maximum amount (e.g. the maximum risk of the bank), the positive tolerance amount is added to the nominal amount.


Datafield NOMTON Amount Tolerance - Negative

Description

This field specifies the negative tolerance to the documentary credit amount as percentage minus that amount.

Helpinformation

This field specifies the negative tolerance to the nominal amount of the underlying contract as percentage minus that amount.


Datafield PREADVDT Date Pre-advised

Description

This field indicates the date when the L/C has been pre-opened (e.g. via SWIFT MT705) to the receiver (e.g. the advising bank) prior to the issuing of the contract.

Helpinformation

This field indicates the date when the L/C was pre-advised (e.g. via SWIFT MT705) to the receiver (e.g. the advising bank) prior to issuing the contract.


Datafield RMBACT Reimbursing Bank Account Identification

Description

Account number of the reimbursing bank in the books of the reimbursing bank. (related to LIDGRP\RMB\PTS\DFTACT)

Helpinformation

Account number of the reimbursing bank in the books of the reimbursing bank.


Datafield RMBCHA Reimbursing Bank's Charges

Description

This field contains the codes for reimbursing bank's charges according to specification of TAG 71A of the outgoing SWIFT MT740 (reimbursement authorization).

Helpinformation

This field contains the codes for reimbursing bank's charges according to TAG 71A of the outgoing reimbursement authorization (SWIFT MT 740).


Datafield RMBFLG Reimbursement Information

Description

If this flag is set, the reimbursement panel becomes visible and reimbursement information can be entered under the Import L/C.

Helpinformation

If this flag is set, the reimbursement panel becomes visible and reimbursement information can be entered under the Import L/C.


Datafield SHPDAT Shipment Date

Description

This date field specifies the latest date of shipment.

Upon checking of documents presented under the L/C, this field is compared with the actual shipment date in order to check for L/C compliance.

The presentation period, being the date difference between latest date of shipment and expiry date, can be calculated from this field.

Helpinformation

This date field specifies the latest date of shipment.

When the documents presented under the L/C are checked, this field is compared with the actual date of shipment in order to monitor L/C compliance.

The presentation period, being the date difference between latest date of shipment and expiry date, can be calculated from this field.


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 SHPPAR Partial Shipment

Description

This field indicates whether or not partial shipments (shipment in more than one lot) are allowed under the L/C.

Helpinformation

This field indicates whether or not partial shipments (shipment in more than one lot) are permitted under the contract.


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 SHPTRS Transshipment

Description

This field indicates whether or not transshipments are allowed under the L/C. Transshipment (German “Umladung”) is the shipment of goods to an intermediate destination, and then from there to yet another destination. One reason for this is, that the means of transport can be changed during the journey (eg. from ship to road transport).

Helpinformation

This field indicates whether or not transshipment is allowed under the contract. Transshipment is the shipment of goods to an intermediate destination, from where they are transported to another destination. One reason for this is the change in the means of transport during shipment (e.g. from ship to road transport).


Datafield STACTY Country Code (Risk Country)

Description

This field is defaulted with the country code of the receiver of the L/C and therefore indicates the risk country of the L/C. It is used for statistical reasons and allows the issuing bank to evaluate the country risks it has entered by issuing the L/C.

Helpinformation

This field is defaulted with the country code for the receiver of the L/C and therefore indicates the 'risk country' of the L/C. It is used for statistical purposes to evaluate the country risks it may have incurred by issuing the L/C.


Datafield STAGOD Goods Code (for Statistics)

Description

This field can be used for statistical reasons and allows the issuing bank to evaluate L/Cs by the types of goods that were shipped under the L/C. 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 UTLNBR Count of Received Document Sets

Description

This field counts the number of document sets which have been received (RCVDAT filled) by the issuing bank under the L/C. This number is not decreased when the document set is settled or closed.

Helpinformation

This field counts the number of document sets received (Date of Documents Received filled) by the issuing bank under the L/C. This number is not decreased when the document set is settled or closed.


Datafield ADVNBR Count of Advised Subcontracts without Documents

Description

This field counts the number of document sets which have been advised (e.g. via SWIFT MT 750 or MT754) to the issuing bank (OWN) but the physical documents have not been received yet (RCVDAT empty). When the physical documents are received (RCVDAT filled), the count of ADVNBR is decreased.

Helpinformation

This field counts the number of document sets advised (e.g. via SWIFT MT 750 or MT754) to the issuing bank (OWN) where the physical documents have not yet been received (Date Documents Received is empty). When the physical documents have been received (Date Documents Received (RCVDAT) is filled), the number of subcontracts advised decreases.


Datafield REDCLSFLG Red/Green Clause

Description

This flag is used to indicate whether the L/C is a red or green clause L/C. For these types of L/C the beneficiary is entitled to receive advances (so called Packing Credit).

Helpinformation

This flag is used to indicate whether the L/C is a red or green clause L/C. For these types of L/C the beneficiary is entitled to receive advances (so called Packing Credit).


Datafield VER Version

Description

This field holds the version counter to keep track of the version history of a LID 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 LCITYP Internal Type of L/C (Default: Normal L/C; B: Back to Back)

Description

LCITYP is set to Back-to-Back if there is an export L/C (LE) which is backing this import L/C. Back-to-Back L/C's can only be issued via LITOPN from LETSEL.

Helpinformation

The internal type is set to Back-to-Back, if there is an export L/C which backs this import L/C. Back-to-Back L/Cs can only be issued via 'Opening an Import L/C' from 'Selecting an Export L/C'.


Datafield B2BINR INR of LE Backing this L/C

Description

This field contains the INR of the export L/C (LE) which this import L/C is based on.

Helpinformation

This field contains the unique ID of the export L/C on which this import L/C is based.


Datafield B2BREF Reference of Contract Backing this L/C

Description

This field contains the reference of the export L/C which this import L/C is based on.

Helpinformation

This field contains the reference of the export L/C on which this import L/C is based.


Datafield REVNBR Number of Revolvings under L/C

Description

This field counts the actual number of revolvings processed under the L/C.

Helpinformation

This field counts the actual number of times the revolving L/C has been processed.


Datafield REVTIMES Revolving Times

Description

This field indicates the maximum number of revolvings allowed under the L/C.

Helpinformation

This field counts the number of times the revolving L/C can be processed.


Datafield REVFLG Revolving Flag

Description

This field indicates if a L/C is revolving. If this flag is set, the revolving panel is visible and revolving details can be entered.

Helpinformation

This field indicates whether the L/C is a revolving L/C. If this flag is set, the revolving panel is visible and revolving details can be entered.


Datafield REVAWAPL Awaiting Applicant's Request

Description

The bank may reserve the right to revolve the L/C after receipt of applicant's instructions and/or credit approval. If not empty, the L/C is not automatically revolving.

Helpinformation

The bank may reserve the right to revolve the L/C after receiving the applicant's instructions and/or credit approval. If not empty, the L/C is not automatically revolving.


Datafield REVDAT Revolving Date

Description

This field contains the date when the next revolving should take place.

Helpinformation

This field contains the date when the L/C is next revolved.


Datafield REVCUM Credit is Marked as Cumulative

Description

The 'cumulative' information is relevant for the further processing of the revolving L/C. If the L/C is marked as 'cumulative', this means that irrespective of what was drawn previously, the remaining available amount is retained and increased with the full revolving amount on the revolving date. If the L/C is marked 'non cumulative' (REVCUM empty), any unutilized amount is lost and the available amount is raised to the value of the next shipment.

Helpinformation

'Cumulative' information is relevant for the further processing of a revolving L/C. If the L/C is marked as 'cumulative', irrespective of what was drawn previously, the remaining available amount is retained and increased with the full revolving amount on the revolving date. If the L/C is marked 'non cumulative' (checkbox not checked), any unutilized amount is lost and the available amount is raised to the amount of the next shipment.


Datafield REVTYP Revolving Type

Description

This field indicates whether the L/C revolves at the time of utilization (e.g. when documents are presented) or periodically on a specific date.

Helpinformation

This field indicates whether the L/C revolves at the time of utilization (e.g. when documents are presented) or periodically on a specific date.

Codetable
Code Text
REVUTI Revolving upon utilization
REVPER Revolving periodically

Datafield INITPTY Applicant's Bank

Description

Not mentioned Ordering Party used for Holding Company.

Helpinformation

This field contains the name of the applicant's bank.

Codetable
Code Text
NIL
APB Applicant Bank
NMO Not ment. Ordering Party

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 LITP in LITPOP and INFLID. 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. Visible in 'Pre-Opening an Import L/C' (LITPOP) and 'Info Import L/C' (INFLID). Invisible in all other transactions.

Codetable
Code Text
Normal Contract
X Reserved Contract

Datafield APPRUL Applicable Rules

Description

This field specifies the rules the credit is subject to.

Helpinformation

This field specifies the rules governing the contract.

Codetable
Code Text
UCP LATEST VERSION UCP latest version
EUCP LATEST VERSION EUCP latest version
UCPURR LATEST VERSION UCP + URR latest version
EUCPURR LATEST VERSION EUCP + URR latest version
ISP LATEST VERSION ISP latest version
OTHR any other rule

Datafield APPRULRMB Applicable Rules Reimbursement

Description

This field specifies the rules the credit is subject to (for reimbursements).

Helpinformation

This field specifies the rules governing the reimbursement authorization.

Codetable
Code Text
URR LATEST VERSION URR LATEST VERSION
NOTURR NOT SUBJECT TO URR

Datafield APPRULTXT Other Applicable Rules

Description

This field specifies details to the applicable rules.

Helpinformation

This field specifies details of the applicable rules.


Datafield AUTDAT Date of Authorization to Reimburse

Description

This field contains the date of the original authorization to reimburse

Helpinformation

This field contains the date of the original authorization to reimburse.


Datafield ORDDAT Your Order Dated

Description

Date of applicants order to issue/amend an L/C. Can be used in order confirmation messages to the applicant to further specify the order of the applicant.

Helpinformation

Order date of incoming message from the applicant's side. Is only used for outgoing messages to the applicant.


Datafield REJFLG Direct rejection

Description

Set in LITPOP, if incoming message is rejected / contract closed directly.

Helpinformation

This flag is set in the (pre)opening transaction in case an incoming message is rejected. The contract is closed directly.


Datafield ETYEXTKEY Entity

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 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 LCRTERM Delivery terms

Helpinformation

The delivery terms may be FOB, CIF or FCR, for example.

Codetable
Code Text
FOB FOB
CIF CIF
FCR FCR

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 REQTYP Type of Request

Description

Possible values are 'Pre-Opening' and 'Draft'. In case of draft only INT-engagment booking and only message 'LC Draft' to APL/INI are generated.

Helpinformation

This selection list contains the type of request. Possible values are 'Pre-Opening' and 'Draft'. In case of 'Draft' no liability is booked and only the message 'LC Draft' to the applicant/ initiating institution is generated. In case of 'Pre-Opening', the LC is preavised to the advising bank / beneficiary side (usually with a SWIFT MT705). Liability is booked accordingly.

Codetable
Code Text
P Pre-Opening
D Draft

Datafield CLRAVLFLG Book out peak amount set in contract ?

Description

A “peak amount” is understood to be the remaining liability balance under a Letter of Credit that remains unutilized after payment of documents. The checkbox “Book out Peak Amount” can be activated when documents are taken up. If set, the application checks the contract for other pending document sets and calculates the liability amount which should be booked out under the Letter of Credit. The calculation of the amount is displayed in the warnings for the user.

Helpinformation

A “peak amount” is understood to be the remaining liability balance under a Letter of Credit that remains unutilized after payment of documents. The checkbox “Book out Peak Amount” can be activated when documents are taken up. If set, the application checks the contract for other pending document sets and calculates the liability amount which should be booked out under the Letter of Credit. The calculation of the amount is displayed in the warnings for the user.


Datafield AUTRNWFLG Auto-Extension

Description

Flag for activation of auto extension checkbox. If selected, a new panel for auto extension details opens.

Helpinformation

Flag for activation of auto extension checkbox. If selected, a new panel for auto extension details opens.


Datafield AOPFLG Assignment of Proceeds

Description

Flag to activate assignment of proceeds panel.

Helpinformation

Flag to activate assignment of proceeds panel.


Datafield SYNFLG Participation Sold Flag

Description

Flag to activate participation sold logic.

Helpinformation

Flag to activate participation sold logic.


Datafield EXPFLG Unlimited Guarantee

Description

This field is used to refine the logical meaning of an empty value in EXPDAT.

This field may only be set, when EXPDAT is empty.

When set to a non-empty value, this identifies an unlimited validity of the contract.

Helpinformation

This field is used to refine the logical meaning of an empty value in EXPDAT.

This field may only be set, when EXPDAT is empty.

When set to a non-empty value, this identifies an unlimited validity of the contract.


Datafield RNWNBR Extension Period

Description

For Auto-Extension: Period for the next extension of the LC.

Helpinformation

For Auto-Extension: Period for the next extension of the LC.


Datafield NOTNBR Notify Period

Description

For Auto-Extension: Period of advance notification about the next renewal.

Helpinformation

For Auto-Extension: Period of advance notification about the next renewal.


Datafield EXPDATFIN Final Expiry Date

Description

For Auto-Extension: The LC expires on this date and after this date no further Auto-extensions are allowed.

Helpinformation

For Auto-Extension: The LC expires on this date and after this date no further Auto-extensions are allowed.


Datafield RNWPER Extension Period Type

Codetable
Code Text
D Days
M Months
Y Years

Datafield ADVPER Advice Period Type

Codetable
Code Text
D Days
M Months

Datafield NOTPER Notify Period Type

Codetable
Code Text
D Days
M Months

Datafield INCTRMCOD Incoterm Code

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
DAP DAP

Datafield INCTRMFRT Incoterm Freight

Helpinformation

This field relates to the payment of the freight and depends on the selected Incoterm.

Codetable
Code Text
- Irrelevant
C Freight Collect
P Freight Prepaid

Datafield INCTRMPLC Incoterm Place

Description

Place of delivery for the incoterms.

Helpinformation

Place of delivery for the incoterms.


Datafield INCTRMVER Incoterm Version

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

Datafield INCDFTON Draft Drawn On

Codetable
Code Text
1 Advising Bank
2 Issuing Bank
0 No Draft
5 Other

Datafield SHPPARS18 Partial Shipment

Description

This field indicates whether or not partial shipments (shipment in more than one lot) are allowed under the L/C.

Helpinformation

This field indicates whether or not partial shipments (shipment in more than one lot) are allowed under the contract. Other conditions must be stated elsewhere in the message.

Codetable
Code Text
ALLOWED allowed
NOT ALLOWED not allowed
CONDITIONAL conditional

Datafield SHPTRSS18 Transhipment

Description

This field indicates whether or not transshipments are allowed under the L/C. Transshipment (German “Umladung”) is the shipment of goods to an intermediate destination, and then from there to yet another destination. One reason for this is, that the means of transport can be changed during the journey (eg. from ship to road transport).

Helpinformation

This field indicates whether or not transshipment is allowed under the contract. Transshipment is the shipment of goods to an intermediate destination, from where they are transported to another destination. One reason for this is the change in the means of transport during shipment (e.g. from ship to road transport). Other conditions must be stated elsewhere in the message.

Codetable
Code Text
ALLOWED allowed
NOT ALLOWED not allowed
CONDITIONAL conditional

Datafield SPCBENFLG Special payment conditions for beneficiary exists

Description

This flag is used to indicate whether for this L/C a special payment condition for beneficiary is avaiable.

Helpinformation

This flag is used to indicate whether for this L/C a special payment condition for beneficiary is avaiable.


Datafield SPCRCBFLG Special Payment Conditions for specified Bank only

Description

This flag is used to indicate whether for this L/C a special payment condition for receiving bank is avaiable.

Helpinformation

This flag is used to indicate whether for this L/C a special payment condition for receiving bank is avaiable.


Datafield PREPERS18 Days of presentation period

Description

This field contains the days of presentation period.

Helpinformation

This field contains the days of presentation period.


Datafield PREPERTXTS18 Presentation period text

Description

This field contains details to the presentation period.

Helpinformation

This field contains details to the presentation period.


Datafield DFTNBR Draft Number

Description

Draft number to be printed in Score MT 771 Score message. Incremented in LITPOP

Helpinformation

Draft number to be printed in Score MT 771 Score message. Incremented in LITPOP


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 FACINR INR of the linked Facility

Description

Unique internal ID of a linked facility record

Helpinformation

Unique internal ID of a linked facility record


Datafield DOMFLG Domestic L/C

Description

Domestic L/C - set if issuing Bank and Beneficiary belong to same country.Otherwise it is empty and means International L/C.

Helpinformation

This flag indicates if the L/C is a domestic L/C or not. If the risk country of L/C and the beneficiary's country are same, it is termed as a domestic L/C.


Datafield REDCLSAMT Red/Green Clause Amount

Helpinformation

This denotes the amount out of the LC contract amount that is available for red/green clause advance.


Datafield REDCLSCUR Red/Green Clause Currency

Description

This is the currency of the red/green clause amount.

Helpinformation

This field denotes the red/green clause currency. It is usually same as the LC contract currency.


Datafield REDCLSPRC Red/Green Clause Percentage

Helpinformation

This denotes the percentage out of the LC contract amount that is available for red/green clause advance.


Datafield REDCLSTYP Percentage or Amount Confirmed

Description

This (invisible) field defines, if the amount or the percentage is used for red/green clause.

Based on this information, the percentage or amount are protected and calculated from the other field.

Helpinformation

This (invisible) field defines, if the amount or the percentage is used for red/green clause.

Based on this information, the percentage or amount are protected and calculated from the other field.

Codetable
Code Text
A Amount
P Percentage

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 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 CSHRAT Cash Base

Description

Costs for refinanzing in the market

Helpinformation

Costs of procuring the funds on the money market.


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 SPFINFLG Specify Loan Term

Description

Checkbox to enable Loan details panel. User could provide loan terms and details requested by applicant, which could be considered if finance is created for the contract during settlement.

Helpinformation

Checkbox to enable Loan details panel. User could provide loan terms and details requested by applicant, which could be considered if finance is created for the contract during settlement.


Datafield OWNRATFLG Financing Flat Fee

Description

If not empty the fee for the complete period is defined by the amount OWNAMT instead of the rate OWNRAT.

Helpinformation

If not empty the fee for the complete period is defined by the amount OWNAMT instead of the rate OWNRAT.


Datafield OWNCUR Document Currency

Description

Document Currency used for display purpose only

Helpinformation

Document Currency used for display purpose only


Datafield OWNAMT Fixed price for total maturity

Description

Flat amount used to calculated own interest rate based on an fixed amount.

Helpinformation

Alternative fixed amount for the total term to maturity. (instead of an interest rate for 'Our margin')


Datafield INTDAYLC Financing Period

Description

INTDAYLC specifies the number of days to be added to the start date of the loan to calculate the maturity of the loan.

Helpinformation

The financing period indicates the number of days to be financed.


Datafield ALADICOD ALADI Reimb. Code

Description

The bank using DOKA must issue the ALADI Reimbursement code on customer request when a contract is opened.

Helpinformation

The bank using DOKA must issue the ALADI Reimbursement code on customer request when a contract is opened.


Datafield ALADIFLG ALADI Checkbox

Helpinformation

This flag will be visible only if entity group is in the LATAM region.

Also, this will be enabled for input only if the current entity has an ALADI member ID and the counter-party bank is also defined as an ALADI member in the party table.

Checking this flag denotes this contract is under ALADI Inter-bank Settlement and therefore: a) System auto generates the ALADI Reimbursement code for (Import LC and Export Collection contracts). b) System allows the user to manually input the ALADI Reimbursement code for (Export LC and Import Collection contracts)


Datafield UPATYP Usance Payable at Sight/Usance

Description

This field specifies if the usance Letter of Credit is payable at Sight (UPAS) or at Usance (UPAU). This is beneficial for the beneficiary of the LC as he would receive the funds earlier than originally stipulated under the LC. For example, a UPAS LC means that the applicant of the LC has to pay at the end of the usance period/ Maturity date of the LC while the beneficiary is paid at sight, ie when documents are taken up.

Helpinformation

Denotes if the LC is Usance Payable at Sight (UPAS) or Usance Payable at Usance (UPAU).

Codetable
Code Text
UPAS Usance Payable at Sight
UPAU Usance Payable at Usance

Datafield UPAUDS UPAU days

Description

This field specifies the number of days for the UPAU (Usance Payable at Usance) period. The number of days indicated here will be used to calculate the interim maturity date of the document set.

Helpinformation

This field is enabled only for UPAU LCs. The number of UPAU days is to be given here.


Datafield OLDREF Alternate Reference

Description

Alternate Reference. I.e. for old reference of migrated contracts.

Helpinformation

Alternate Reference. I.e. for old reference of migrated contracts.


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.