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.
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 |
Name | Fields | Properties |
---|---|---|
LID_B2BINR | B2BINR | |
LID_B2BREF | B2BREF | |
LID_ETYEXTKEY | ETYEXTKEY | |
LID_INR | INR | Unique |
LID_NAM | NAM | |
LID_OWNREF | OWNREF |
/
INR
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.
Unique internal ID of a record within the table. The INR is a text field, which is created by retrieving the next valid entry from the counter of this table. The field INR is used to enable links from other tables to this table.
For contractdata the INR also links the two tables xxD and xxT as associated entries hold the same INR.
This field contains the 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.
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.
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.
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.
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.
This field holds the User ID of the person responsible for handling this contract.
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.
This date field identifies the date the entry was physically added to the database.
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.
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.
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.
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.
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.
This field contains the name of the advising bank.
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.
This field contains the reference number of the advising bank.
This field contains the date of the last amendment which has been processed under the L/C.
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.
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.
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.
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.
This is a copy of relevant field for the 'Applicant'. This field is only used to speed up search and database access.
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.
This is a copy of relevant field for the 'Applicant'. This field is only used to speed up search and database access.
This field indicates whether the L/C is available by sight payment, deferred payment, acceptance, negotiation or mixed payment.
This field indicates whether the contract is available by sight payment, deferred payment, acceptance, negotiation or mixed payment.
This field indicates the bank authorized to pay, accept, negotiate or incur a deferred payment for the L/C.
This field contains the bank/role that is authorized to pay, accept, negotiate or transfer an obligation under a deferred payment for the contract.
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.
This field contains the name of the beneficiary.
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.
This field contains the reference number of the beneficiary.
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.
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.
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”.
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”.
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.
This date field specifies when the L/C expires and therefore indicates the latest date for presentating documents under the L/C.
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.
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.
This field specifies the type of L/C. According to SWIFT, further specification codes are available, such as transferable, standby and combinations of these.
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.
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.
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.
Code | Text |
---|---|
N | NOT EXCEEDING |
X | Accord to UCP |
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.
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.
This field specifies the negative tolerance to the documentary credit amount as percentage minus that amount.
This field specifies the negative tolerance to the nominal amount of the underlying contract as percentage minus that amount.
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.
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.
Account number of the reimbursing bank in the books of the reimbursing bank. (related to LIDGRP\RMB\PTS\DFTACT)
Account number of the reimbursing bank in the books of the reimbursing bank.
This field contains the codes for reimbursing bank's charges according to specification of TAG 71A of the outgoing SWIFT MT740 (reimbursement authorization).
This field contains the codes for reimbursing bank's charges according to TAG 71A of the outgoing reimbursement authorization (SWIFT MT 740).
If this flag is set, the reimbursement panel becomes visible and reimbursement information can be entered under the Import L/C.
If this flag is set, the reimbursement panel becomes visible and reimbursement information can be entered under the Import L/C.
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.
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.
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.
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.
This field specifies the port of loading or airport of departure to be indicated on the transport document.
This field specifies the port or airport of departure indicated on the transport document.
This field specifies the port of discharge or airport of destination to be indicated on the transport document.
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.
This field indicates whether or not partial shipments (shipment in more than one lot) are allowed under the L/C.
This field indicates whether or not partial shipments (shipment in more than one lot) are permitted under the contract.
This field specifies the final destination or place of delivery to be indicated on the transport document.
This field specifies the final destination of the goods shipped under the underlying contract.
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).
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).
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.
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.
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.
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.
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.
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.
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.
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.
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).
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).
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.
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.
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.
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'.
This field contains the INR of the export L/C (LE) which this import L/C is based on.
This field contains the unique ID of the export L/C on which this import L/C is based.
This field contains the reference of the export L/C which this import L/C is based on.
This field contains the reference of the export L/C on which this import L/C is based.
This field counts the actual number of revolvings processed under the L/C.
This field counts the actual number of times the revolving L/C has been processed.
This field indicates the maximum number of revolvings allowed under the L/C.
This field counts the number of times the revolving L/C can be processed.
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.
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.
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.
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.
This field contains the date when the next revolving should take place.
This field contains the date when the L/C is next revolved.
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.
'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.
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.
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.
Code | Text |
---|---|
REVUTI | Revolving upon utilization |
REVPER | Revolving periodically |
Not mentioned Ordering Party used for Holding Company.
This field contains the name of the applicant's bank.
Code | Text |
---|---|
NIL | |
APB | Applicant Bank |
NMO | Not ment. Ordering Party |
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.
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.
Code | Text |
---|---|
Normal Contract | |
X | Reserved Contract |
This field specifies the rules the credit is subject to.
This field specifies the rules governing the contract.
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 |
This field specifies the rules the credit is subject to (for reimbursements).
This field specifies the rules governing the reimbursement authorization.
Code | Text |
---|---|
URR LATEST VERSION | URR LATEST VERSION |
NOTURR | NOT SUBJECT TO URR |
This field specifies details to the applicable rules.
This field specifies details of the applicable rules.
This field contains the date of the original authorization to reimburse
This field contains the date of the original authorization to reimburse.
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.
Order date of incoming message from the applicant's side. Is only used for outgoing messages to the applicant.
Set in LITPOP, if incoming message is rejected / contract closed directly.
This flag is set in the (pre)opening transaction in case an incoming message is rejected. The contract is closed directly.
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.
The delivery terms may be FOB, CIF or FCR, for example.
Code | Text |
---|---|
FOB | FOB |
CIF | CIF |
FCR | FCR |
This field holds the INR of the transaction which opened the contract.
This field holds the INR of the transaction which opened/issued the contract.
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.
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.
Code | Text |
---|---|
P | Pre-Opening |
D | Draft |
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.
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.
Flag for activation of auto extension checkbox. If selected, a new panel for auto extension details opens.
Flag for activation of auto extension checkbox. If selected, a new panel for auto extension details opens.
Flag to activate assignment of proceeds panel.
Flag to activate assignment of proceeds panel.
Flag to activate participation sold logic.
Flag to activate participation sold logic.
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.
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.
For Auto-Extension: Period for the next extension of the LC.
For Auto-Extension: Period for the next extension of the LC.
For Auto-Extension: Period of advance notification about the next renewal.
For Auto-Extension: Period of advance notification about the next renewal.
For Auto-Extension: The LC expires on this date and after this date no further Auto-extensions are allowed.
For Auto-Extension: The LC expires on this date and after this date no further Auto-extensions are allowed.
Code | Text |
---|---|
D | Days |
M | Months |
Y | Years |
Code | Text |
---|---|
D | Days |
M | Months |
Code | Text |
---|---|
D | Days |
M | Months |
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 |
This field relates to the payment of the freight and depends on the selected Incoterm.
Code | Text |
---|---|
- | Irrelevant |
C | Freight Collect |
P | Freight Prepaid |
Place of delivery for the incoterms.
Place of delivery for the incoterms.
Code | Text |
---|---|
1 | Incoterm Version 2010 |
2 | Incoterm Version 2000 |
3 | Incoterm Version 2020 |
Code | Text |
---|---|
1 | Advising Bank |
2 | Issuing Bank |
0 | No Draft |
5 | Other |
This field indicates whether or not partial shipments (shipment in more than one lot) are allowed under the L/C.
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.
Code | Text |
---|---|
ALLOWED | allowed |
NOT ALLOWED | not allowed |
CONDITIONAL | conditional |
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).
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.
Code | Text |
---|---|
ALLOWED | allowed |
NOT ALLOWED | not allowed |
CONDITIONAL | conditional |
This flag is used to indicate whether for this L/C a special payment condition for beneficiary is avaiable.
This flag is used to indicate whether for this L/C a special payment condition for beneficiary is avaiable.
This flag is used to indicate whether for this L/C a special payment condition for receiving bank is avaiable.
This flag is used to indicate whether for this L/C a special payment condition for receiving bank is avaiable.
This field contains the days of presentation period.
This field contains the days of presentation period.
This field contains details to the presentation period.
This field contains details to the presentation period.
Draft number to be printed in Score MT 771 Score message. Incremented in LITPOP
Draft number to be printed in Score MT 771 Score message. Incremented in LITPOP
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.
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.
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.
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.
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.
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.
Unique internal ID of a linked facility record
Unique internal ID of a linked facility record
Domestic L/C - set if issuing Bank and Beneficiary belong to same country.Otherwise it is empty and means International L/C.
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.
This denotes the amount out of the LC contract amount that is available for red/green clause advance.
This is the currency of the red/green clause amount.
This field denotes the red/green clause currency. It is usually same as the LC contract currency.
This denotes the percentage out of the LC contract amount that is available for red/green clause advance.
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.
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.
Code | Text |
---|---|
A | Amount |
P | Percentage |
Costs for keeping liquidity
The liquidity costs refer to the costs of the bank which occur in order to provide the neccessary liquidity.
This field contains the base rate for interest calculation.
This field contains the base rate used to calculate interest.
Costs for refinanzing in the market
Costs of procuring the funds on the money market.
Our Share of Interest
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.
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.
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.
If not empty the fee for the complete period is defined by the amount OWNAMT instead of the rate OWNRAT.
If not empty the fee for the complete period is defined by the amount OWNAMT instead of the rate OWNRAT.
Document Currency used for display purpose only
Document Currency used for display purpose only
Flat amount used to calculated own interest rate based on an fixed amount.
Alternative fixed amount for the total term to maturity. (instead of an interest rate for 'Our margin')
INTDAYLC specifies the number of days to be added to the start date of the loan to calculate the maturity of the loan.
The financing period indicates the number of days to be financed.
The bank using DOKA must issue the ALADI Reimbursement code on customer request when a contract is opened.
The bank using DOKA must issue the ALADI Reimbursement code on customer request when a contract is opened.
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)
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.
Denotes if the LC is Usance Payable at Sight (UPAS) or Usance Payable at Usance (UPAU).
Code | Text |
---|---|
UPAS | Usance Payable at Sight |
UPAU | Usance Payable at Usance |
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.
This field is enabled only for UPAU LCs. The number of UPAU days is to be given here.
Alternate Reference. I.e. for old reference of migrated contracts.
Alternate Reference. I.e. for old reference of migrated contracts.
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.
Introduced with Swift Release 2023 This field specifies the port of loading or airport of departure to be indicated on the transport document.
Introduced with Swift Release 2023 This field specifies the port of discharge or airport of destination to be indicated on the transport document.
Introduced with Swift Release 2023 This field specifies the final destination or place of delivery to be indicated on the transport document.