Name | Helptext Description | Data Type | Len | Codetable |
---|---|---|---|---|
INR | Internal Unique ID | Text | 8 | |
OWNREF | Own Reference | Text | 16 | |
NAM | Name | Text | 80 | |
OWNUSR | Responsible User | Text | 8 | <fixed-length> |
CREDAT | Date Created | Date | 12 | |
OPNDAT | Opening Date | Date | 12 | |
OPNTRNINR | TRNINR which opened contract | Text | 8 | |
CLSDAT | Date Closed | Date | 12 | |
CNFDAT | Confirmation Date | Date | 12 | |
ADVDAT | Date Released on | Date | 12 | |
ISSNAM | Name of Issuing Bank | Text | 40 | |
ISSREF | Issuing Bank Reference | Text | 16 | |
AMEDAT | Date of Last Amendment | Date | 12 | |
AMENBR | Number of Amendments | Numeric | 3 | |
AVBBY | Available by | Text | 1 | AVBBY0 |
AVBWTH | Available with | Text | 1 | AVBWTH |
BENNAM | Beneficiary | Text | 40 | |
BENREF | Beneficiary Reference | Text | 16 | |
CHATO | Fee settlement - our fee to be debited to | Text | 1 | CHADET |
CNFFLG | Percentage or Amount Confirmed | Text | 1 | Embedded |
CNFDET | Confirmation Instructions from Iss.Bank | Text | 1 | CNFFLG |
CNFSTA | Confirmation Status / Confirmed by us | Text | 1 | CNFSTA |
EXPDAT | Date of Expiry | Date | 12 | |
EXPPLC | Place of Expiry | Text | 29 | |
LCRTYP | Form of Documentary Credit | Text | 2 | LCRTYP |
NOMSPC | Amount Specification | Text | 1 | Embedded |
NOMTOP | Amount Tolerance - Positive | Numeric | 2 | |
NOMTON | Amount Tolerance - Negative | Numeric | 2 | |
PREADVDT | Date Pre-advised | Date | 12 | |
SHPDAT | Shipment Date | Date | 12 | |
SHPFRO | Shipment from | Text | 65 | |
SHPPAR | Partial Shipment | Text | 35 | |
SHPTO | For Transportation to | Text | 65 | |
SHPTRS | Transshipment | Text | 35 | |
STACTY | Country Code (for Statistics) | Text | 2 | CTYTXT |
STAGOD | Goods Code (for Statistics) | Text | 6 | GODCOD |
UTLNBR | Count of Received Document Sets | Numeric | 3 | |
VER | Version | Text | 4 | |
APLBNKDIRSND | Send Directly to Applicant's Bank | Text | 1 | |
TENMAXDAY | Maximum Tenor | Numeric | 4 | |
CNFSND | Confirmation Status of 1st Advising Bank | Text | 1 | CNFSND |
REVFLG | Revolving Flag | Text | 1 | |
REVNBR | Number of Revolvings under L/C | Numeric | 2 | |
REVTIMES | Allowed Revolving Times | Numeric | 2 | |
REVDAT | Revolving Date | Date | 12 | |
REVCUM | Credit is Marked as Cumulative | Text | 1 | |
REVTYP | Revolving Type | Text | 40 | Embedded |
CNFINS | Confirmation Instructions to 2nd Advising Bank | Text | 1 | CNFFLG |
REDCLSFLG | Red/Green Clause | Text | 1 | |
ADVNBR | Count of Advised Subcontracts without Documents | Numeric | 3 | |
RESFLG | Reserved Contract | Text | 1 | Embedded |
INCTRF | Incoming Transfer | Text | 1 | |
APPRUL | Applicable Rules | Text | 30 | Embedded |
APPRULTXT | Other Applicable Rules | Text | 35 | |
PORDIS | Port of Discharge | Text | 65 | |
PORLOA | Port of Loading | Text | 65 | |
NONBAN | Non-Bank Issuer | Text | 1 | |
REJFLG | Direct rejection | Text | 1 | |
EXPDATFIN | Final Expiry Date | Date | 12 | |
RNWPER | Extension Period Type | Text | 1 | Embedded |
RNWNBR | Extension Period | Numeric | 3 | |
NOTPER | Notify Period Type | Text | 1 | Embedded |
NOTNBR | Notify Period | Numeric | 3 | |
ADVPER | Advice Period Type | Text | 1 | Embedded |
AUTRNWFLG | Auto-Extension | Text | 1 | |
EXPFLG | Unlimited Guarantee | Text | 1 | |
SHPPARS18 | Partial Shipment | Text | 11 | Embedded |
SHPTRSS18 | Transhipment | Text | 11 | Embedded |
SPCBENFLG | Special payment conditions for beneficiary exists | Text | 1 | |
SPCRCBFLG | Special Payment Conditions for specified Bank only | Text | 1 | |
PREPERS18 | Days of presentation period | Numeric | 3 | |
PREPERTXTS18 | Presentation period text | Text | 35 | |
AOPFLG | Assignment of Proceeds | Text | 1 | |
SYNFLG | Participation Sold Flag | Text | 1 | |
FACINR | FACINR | Text | 8 | |
REDCLSAMT | Red/Green Clause Amount | Numeric | 18 | |
REDCLSCUR | Red/Green Clause Currency | Text | 3 | CURTXT |
REDCLSPRC | Red/Green Clause Percentage | Numeric | 5 | |
REDCLSTYP | Percentage or Amount Confirmed | Text | 1 | Embedded |
DOMFLG | Domestic L/C | Text | 1 | |
ALADICOD | ALADI Reimb. Code | Text | 16 | |
ALADIFLG | ALADI Checkbox | Text | 1 | |
OLDREF | Alternate Reference | Text | 16 | |
ETYEXTKEY | Entity | Text | 8 | |
PARTCON | Partial Confirmation | Numeric | 5 | |
COLLFLG | Collateralized L/C | Text | 1 | |
CLRAVLFLG | Book out peak amount set in contract ? | Text | 1 | |
PRDCOD | Product Code | Text | 6 | PRDCOD |
PRDSUB | Product Subtype | Text | 6 | PRDSUB |
PRDVAR | Product Variant | Text | 6 | PRDVAR |
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 L/C being established. The reference number can be up to 16 characters long. This field can be used to search for any L/C from the database.
This field holds the descriptive name displayed in the application to describe and to search for a contract. Within the default configuration 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 responsible for handling this contract.
This date field identifies the date the entry was physically added to 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 field holds the INR of the transaction which opened/issued the contract.
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.
This field contains the date when the L/C was confirmed.
This field holds the date the L/C was advised, or when L/C was captured and stored in the system.
This field contains the name of the issuing bank.
This field contains the reference number of the issuing bank, i.e. the original L/C number.
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 is used to store the number of amendments made to the contract so far. This field is automatically updated from the relevant amendment transaction.
This field indicates whether the contract is available by sight payment, deferred payment, acceptance, negotiation or mixed payment.
This field contains the bank/role that is authorized to pay, accept, negotiate or transfer an obligation under a deferred payment for the contract.
This field contains the name of the beneficiary.
This field contains the reference number of the beneficiary.
This field defines whether the fees and commissions of the bank using using the application is to be borne by the customer or 'Our fees borne by client' (='U'), of the foreign 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 customer SIDE. (In the case of an export LC, the BEN or A2B would thus be available).
Meaning of 'borne by abroad': Own fees in the settlement are proposed to the debit of the foreign SIDE (For an export LC, the ISS or ADV/ CON would thus be available).
Meaning of 'Others': No role is proposed on the fees in the settlement panel.
This field defines whether if the amount or the percentage has been confirmed in a partially-confirmed contract.
Thus either the percentage or amount is protected and calculated using the other field.
Code | Text |
---|---|
A | Amount |
P | Percentage |
This field contains confirmation instructions received from the issuing bank. According to SWIFT regulations, one of the following codes must be selected: “Without”, “May add” or “Confirm”.
This field contains the confirmation status of the bank using the application and therefore indicates whether the bank has added its confirmation to the L/C or not. “Silent” indicates a silent confirmation which is not disclosed to the issuing bank.
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 are to be presented under the L/C.
This field specifies the type of L/C. According to UCP, the L/C has to indicate whether it is irrevocable. According to SWIFT, further specification codes are available, such as transferable, standby and combinations of these. In DTA, the code '…standby' will not be allowed.
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 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 nominal amount of the underlying contract as percentage minus that amount.
This field indicates when the L/C was pre-advised (e.g. via SWIFT MT705) to the receiver (e.g. the advising bank) before the L/C was issued.
This date field specifies the latest date of shipment.
When checking the documents presented under the L/C, this field is compared with the actual shipment date to check for L/C compliance.
The presentation period, i.e. the difference between latest date of shipment and expiry date, can be calculated from this field.
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 indicates whether or not partial shipments (shipment in more than one lot) are permitted under the contract.
This field specifies the final destination of the goods shipped under the underlying contract.
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 sender of the L/C and therefore indicates the 'risk country' of the L/C. It is used for statistical purposes and allows the advising bank to evaluate the country risks it may have incurred by advising/confirming the L/C.
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 received by the advising bank under the L/C. This number does not decrease when the document set is settled or closed.
This field holds the version counter used to keep track of the history of an entry of this table. The individual versions are managed by entries in the SLG table.
This field is used to indicate that the acknowledgment (generated in Pre-Advising/Notifying an Export L/C, Advising/Confirming is sent directly to the Applicant's Bank rather than the Issuing Bank/First Advising Bank.
Sometimes the L/C already states how documents are to be sent when presented. The field therefore defaults the 'Send Documents to Another Address' field in the document set, which indicates that documents can be sent to an address other than the payer of documents.
This field is used to calculate the maximum maturity of the export L/C when the L/C has been confirmed (open or silent). If filled, the maximum tenor is added to the expiry date and the result is entered as the maturity date in the liability grid for the liability booking of the L/C.
This field provides the bank using the application (which is advising the L/C to the beneficary or to another second advising bank (A2B)) with the confirmation status of the first advising bank.
Possible values: - The sender has added his confirmation to the credit - The sender has not added his confirmation to the credit
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.
This field counts the actual number of times the revolving L/C has been processed.
This field indicates the number of times a revolving L/C can be processed.
This field indicates 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', it 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', any unutilized amount is lost and the available amount is raised to the value 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.
Code | Text |
---|---|
REVUTI | Revolving upon utilization |
REVPER | Revolving periodically |
If the L/C is advised to another advising bank (2nd advising bank of the bank of the beneficiary), this field shows the confirmation instructions to this bank (e.g. in Tag 49 of an outgoing MT 710).
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 counts the number of incoming document sets advised (e.g. via SWIFT MT 750 or MT754) to the bank using the application, but where the physical documents have not yet been received.
Contract status flag. If not empty, the contract has been reserved and only a few basic fields have to be filled in. Visible in 'Reserving an Export L/C' (LETRSV) and 'Info Export L/C' (INFLED). Invisible in all other transactions.
Code | Text |
---|---|
Normal Contract | |
X | Reserved Contract |
The 'Incoming Transfer' checkbox is checked when a transferred L/C has been received. It is used in message management. and is automatically checked if the receipt was notified via an MT 720 SWIFT message.
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 contains details of the applicable rules, if 'other' rules have been specified. The field is only enabled if 'Any Other Rule' was selected previously.
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 specifies the port or airport of departure indicated on the transport document.
The field defines whether the issuer of the L/C is a bank or not. A non-empty content marks this L/C as being issued by an institute other than a bank.
This flag is set in the (pre)opening transaction in case an incoming message is rejected. The contract is closed directly.
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.
This fields contains the percentage of any partial confirmation. It is only enabled for user entries, if the L/C has been confirmed by the bank using the application.
This field is automatically set when Cash Cover is booked to a 'hold account' under the L/C.
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.
For Auto-Extension: The LC expires on this date and after this date no further Auto-extensions are allowed.
Code | Text |
---|---|
D | Days |
M | Month |
Y | Years |
For Auto-Extension: Period for the next extension of the LC.
Code | Text |
---|---|
D | Days |
M | Month |
For Auto-Extension: Period of advance notification about the next renewal.
Code | Text |
---|---|
D | Days |
M | Month |
Flag for activation of auto extension checkbox. If selected, a new panel for auto extension details opens.
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 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 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 receiving bank is avaiable.
This field contains the days of presentation period.
This field contains details to the presentation period.
Flag to activate assignment of proceeds panel.
Flag to activate participation sold logic.
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 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.
This denotes the amount out of the LC contract amount that is available for red/green clause advance.
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.
Code | Text |
---|---|
A | Amount |
P | Percentage |
This flag indicates if the L/C is a domestic L/C or not. If the country of the DOKA-NG Bank and the applicant's country are same, it is termed as a domestic L/C.
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)
Alternate reference number, can i.e. contain the old reference for migrated contracts.