BED is the main data table for the Document Set under Export L/C contract.
All technical important fields have to be defined here.
Large text blocks should be defined in BET.
Name | Description | Data Type | Len | Dec. | View lines | View type | Inst. | Visible | Codetable |
---|---|---|---|---|---|---|---|---|---|
INR | Internal Unique ID of Export L/C Document Set | Text | 8 | 1 | Edit | Yes | Public | ||
OWNREF | Own Reference (BE Number) | Text | 16 | 1 | Edit | Yes | Public | ||
NAM | Externally Displayed Name to Identify the Contract | Text | 80 | 1 | Edit | Yes | Public | ||
PNTTYP | Parent Contract Type | Text | 6 | 1 | Edit | Yes | Public | ||
PNTINR | Parent Contract INR | Text | 8 | 1 | Edit | Yes | Public | ||
OPNTRNINR | TRNINR which L/C Opened/Issued | Text | 8 | 1 | Edit | Yes | Public | ||
PREDAT | Presentation Date | Date | 12 | 0 | Date | Yes | Public | ||
RCVDAT | Date of Receipt of Documents | Date | 12 | 0 | Date | Yes | Public | ||
SHPDAT | Date of Shipment | Date | 12 | 0 | Date | Yes | Public | ||
ADVDAT | Date of Advice of Payment | Date | 12 | 0 | Date | Yes | Public | ||
MATDAT | Maturity Date | Date | 12 | 0 | Date | Yes | Public | ||
DOCTYPCOD | Document Type | Text | 1 | 1 | Edit | Yes | Public | BEDTYP | |
OPNDAT | Date Opened/Issued | Date | 12 | 0 | Date | Yes | Public | ||
CLSDAT | Date Closed | Date | 12 | 0 | Date | Yes | Public | ||
CREDAT | Date of Creation (Opening or Registry) | Date | 12 | 0 | Date | Yes | Public | ||
OWNUSR | Responsible User | Text | 8 | 1 | 20 | Edit | Yes | Public | |
VER | Version Counter | Text | 4 | 1 | Edit | Yes | Public | ||
APPROVCOD | Documents on Approval Basis | Text | 1 | 1 | Edit | Yes | Public | ||
FREPAYFLG | Free of Payment | Text | 1 | 1 | Edit | Yes | Public | ||
DOCPRBROL | Presented by | Text | 3 | 1 | Edit | Yes | Public | <fixed-length> | |
DOCPYRROL | Payer | Text | 3 | 1 | Edit | Yes | Public | ROLALL | |
ORDDAT | Order Date | Date | 12 | 0 | Date | Yes | Public | ||
MATTXTFLG | Multiple Tenor Flag | Text | 1 | 1 | Edit | Yes | Public | ||
DSCINSFLG | Enter Docs, Discrep. and Instructions | Text | 1 | 1 | Edit | Yes | Public | ||
ACPNOWFLG | Accept Documents Now | Text | 1 | 1 | Edit | Yes | Public | ||
ADVTYP | Type of Advice Received | Text | 3 | 1 | Edit | Yes | Public | Embedded | |
DISDAT | Date of Discrepancy Advice | Date | 12 | 0 | Date | Yes | Public | ||
TOTCUR | Currency of Total Amount to be Paid | Text | 3 | 1 | Edit | Yes | Public | CURTXT | |
TOTAMT | Total Amount to be Paid | Numeric | 18 | 3 | Edit | Yes | Public | ||
TOTDAT | Date to be Paid | Date | 12 | 0 | Date | Yes | Public | ||
DOCSTA | Document Set Status | Text | 40 | 1 | Edit | Yes | Public | Embedded | |
DOCROL | Receiver of Documents | Text | 3 | 1 | Edit | Yes | Public | ROLALL | |
DOCROLFLG | Send Documents to Another Address | Text | 1 | 1 | Edit | Yes | Public | ||
DTA770SND | Send Date of Acknowledgment Message | Date | 12 | 0 | Date | Yes | Public | ||
ADVDOCFLG | Return of Documents | Text | 1 | 1 | Edit | Yes | Public | ||
CANCNF | Reduce Confirmation Liability | Text | 1 | 1 | Edit | Yes | Public | ||
SPDDAT | Start Past-due Date | Date | 12 | 0 | Date | Yes | Public | ||
ANTNEGREF | Customer Negotiation Reference | Text | 20 | 1 | Edit | Yes | Public | ||
ETYEXTKEY | Entity holding Contract | Text | 8 | 1 | Edit | Yes | Public | ||
RMBFLG | Flag if MT 742 has been send out | Text | 1 | 1 | Edit | Yes | Public | Embedded |
Name | Fields | Properties |
---|---|---|
BED_ETYEXTKEY | ETYEXTKEY | |
BED_INR | INR | Unique |
BED_NAM | NAM | |
BED_OWNREF | OWNREF | |
BED_PNTINR | PNTTYP, PNTINR |
/
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 BED. The field INR is used to enable links from other tables to this table. It also links the two tables BED and BET 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 document set being established under an Export L/C. The reference number can have a maximum size of 16 characters. This field can be used to search for any document set from the database.
This field contains the reference number of the subcontract created for the set of documents received. The number is created automatically when the subcontract is created.
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. Within the default configuration, this field is set by a default rule based on the contract amount and main party, and cannot be modified by the user.
This field contains the type of the parent contract.
This field contains the type of the parent contract.
This field contains the internal unique ID of the parent contract.
This field contains the unique identifcation number of the parent contract.
The presentation date is the date, on which the DOKA bank presents the documents to the payer (e.g. issuing bank or 1st advising bank) (in other words - the dispatch date).
The presentation date is the date on which the bank using the application presents the documents to the payer (e.g. issuing bank or 1st advising bank).
Date on which the DOKA bank has received the documents from the presenter (date of receipt stamp, NOT date of customer order - that is ORDDAT).
Date on which the bank using the application received the documents from the presenter (date of receipt stamp, NOT date of customer order - that is the order date).
This date specifies when the goods have been shipped. If goods are shipped by sea, this field specifies the date when the goods are taken on board the vessel in the beneficiary's country.
This date specifies when the goods have been shipped. If goods are shipped by sea, this field specifies the date when the goods are taken on board of the vessel in the beneficiary's country.
Date is set when an Advice of Payment (incoming MT754) has been received ( e.g. in TRN LETDAV).
Date is set when an Advice of Payment (incoming MT754) has been received (e.g. in the 'Advising Documents' transaction).
This field specifies the maturity date of a usance document set presented under the L/C.
This field specifies the maturity date of a usance document set presented under the L/C.
This field specifies the type of documents which have been received under the L/C. The selection made in this field strongly influences the available processing options in BE.
For example, if “sight documents” (= P) has been selected, the document set can be settled in transaction BETPAY,while for usance documents (= A, D) only liabilities can be booked in BETPAY.
This field is defaulted from LEDGRP\REC\AVBBY. In case LEDGRP\REC\AVBBY = “N” the user is asked to select another option because “by negotiation” is not allowed in BE. “N” must be defaulted because the information from parent contract should not get lost.
This field specifies the type of documents which have been received under the L/C. The selection made in this field strongly influences the processing options available in BE.
For example, if “sight documents” (= P) has been selected, the document set can be settled in the 'Send and Settle Documents' transaction, while for usance documents (= A, D) only liabilities can be booked in 'Send and Settle Documents'.
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. This might be a date prior to the creation date, when 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 field 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.
This date field holds the date when the entry was physically added to the database. This may happen when opening the contract, when reserving the reference number or when, for other reasons, a contract is added to the database.
This date field identifies the date the entry was physically added to the database.
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 field holds the version counter to keep track of the version history of a BED entry. The individual versions are controlled by entries in the SLG table.
This field holds the version counter used to keep track of the history of an entry of this table. The individual versions are managed by entries in the SLG table.
This field specifies if documents are sent on approval basis, meaning that discrepant documents are received which the applicant may pay or reject.
Check this box if documents are to be handled on approval basis, i.e. whether documents have been received which the applicant may pay or reject.
This field specifies if the documents are handled free of payment, meaning that the documents are presented to the applicant without him having to pay for them. In German, this is called “Dokumente ohne Zahlung/wertfrei aushändigen”.
This field specifies whether the documents are handled free of payment, i.e. whether documents are presented to the applicant without them having to be settled.
Defines the party who has presented documents and is the receiver of payment. The payee might be the beneficiary.
Defines the party who has presented documents and is the receipient of payment.
This field specifies the debit party who is paying the document set (e.g. applicant).
Formerly PAYROL
This field specifies the debit party who is paying the document set (e.g. issuing bank).
Date of incoming cover letter received from the presenter.
Date of incoming cover letter received from the presenter.
This field is set to a non-empty value, if the document set holds more than one tenor.
This field is set to a non-empty value, if the document set holds more than one tenor.
This checkbox enables the banks to decide whether they want to use a 'slim' version of TRN LETDRV (Documents received) where only minimal information is entered (→ This function is preferred by larger banks). Smaller banks use TRN LETDRV to enter document details, discrepancies and instructions. When the checkbox is set to 'not empty' the relevant additional panels are visible.
his checkbox allows banks to decide whether they want to use a 'slim' version of transaction 'Documents received', where only minimal information is entered.
This function is preferred by larger banks. Smaller banks use the 'Documents received' transaction to enter details, discrepanies, instructions and shipping details. If the checkbox is checked, relevant additional panels are visible.
This flag specifies that documents are taken up for payment, acceptance, negotiation. The selection made in this field strongly influences the available processing options in BE. The flag is used in transaction BETPAY in order to pay sight documents or to book in liability for usance documents.
This flag specifies that documents have been taken up for payment, acceptance, negotiation. The selection made in this field strongly influences the processing options available in Export Documents. The flag is used in the 'Send and Settle Documents' transaction to pay sight documents or to book in the liability with usance documents.
This field specifies if documents have been advised via incoming Payment Advice (e.g. MT754) or Advice of Discrepancy (e.g. MT750).
This field specifies whether documents have been advised via an incoming Payment Advice (e.g. MT754) or Advice of Discrepancy (e.g. MT750).
Code | Text |
---|---|
750 | Advice of Discrepancy (MT750) |
754 | Advice of Payment (MT754) |
OTH | Other Advice |
Date is set when an Advice of Discrepancy (incoming MT750) has been received ( e.g. in TRN LETDAV).
Date is set when an Advice of Discrepancy (incoming MT750) has been received.
This field contains the currency of the total amount of the MT750 message to be remitted to the sender of the message. As this field is required in other transactions lateron (outgoing MT752 in BETPAY), the field is stored here.
This field contains the currency of the total amount of the MT750 message to be remitted to the sender of the message. As this field is required in other subsequent transactions (outgoing MT752), the field is stored here.
This field contains the total amount of the MT750 message to be remitted to the sender of the message. As this field is required in other transaction lateron (outgoing MT752 in BETPAY), the field is stored here.
This field contains the total amount of the MT750 message to be remitted to the sender of the message. As this field is required in subsequent transactions (outgoing MT752), the field is stored here.
This field is necessary in case an Advice of Payment (MT754) is received under the L/C where TAG 34A has been specified. According to SWIFT regulations, TAG 34A can contain a value date, being the date when the document set should be paid or has been paid. The information received is stored in this field.
This field is necessary should an Advice of Payment (MT754) be received under the L/C where TAG 34A has been specified. According to SWIFT regulations, TAG 34A can contain a value date, i.e. the date when the document set should be paid or has been paid. The information received is stored in this field.
The current document set status is stored in this field. The field is set via a default in the panel module.
The current status of the document set is stored in this field.
Code | Text |
---|---|
A | Advice of Payment rec., wait for docs |
B | Advice of Payment rec., documents rec. |
C | Advice of Discrepancy rec, wait for doc |
D | Advice of Discrepancy rec, docs rec. |
E | Clean documents received |
F | Discrepant documents received |
I | Documents taken up |
J | Documents settled free of payment |
R | Documents have been refused and returned |
This field can be used to send the documents (e.g. Document Presentation 1st/ 2nd mail) to another address than the payer of documents (DOCPYRROL).
This field can be used to send the documents (e.g. Document Presentation 1st/ 2nd mail) to an address other than the payer of documents.
This flag is used to indicate that documents shall be sent to another address. The address is selected in DOCROL.
If LEDGRP\REC\APLBNKDIRSND was set under the LE, this field is defaulted accordingly.
This checkbox can be used to indicate that documents are to be sent to another address. The address is selected in 'Receiver of Documents'.
If 'Send Directly to Applicant's Bank' was set under the LE, this field is defaulted accordingly.
This fields indicates if an acknowledgment message for received documents was send either in LETDRV or in BETPAY or in BETSND. A non empty value means, the message was already send on the date stored in the field.
This fields indicates if an acknowledgment message for received documents was send either in 'Receiving Documents', in 'Send and Settle Documents' or in 'Sending Documents'. A field filled means that the message was sent on the date stored in the field.
When this flag is set, Documents are returned.
When this flag is set, the documents have been returned.
Checkbox to trigger the outbooking of liability in case that documents are to be sent on approval basis. When set to a nonspace value the liability of the main contract is already booked out (or will be booked out in the transaktion setting this flag)
This triggers the debitting of an liability if authorization documents have been sent.
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.
Flag is set, if an MT 742 has been sent out.
Code | Text |
---|---|
X | MT 742 has been send |
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.
This field specifies the date when the documents are starting to be past-due/ overdue. This happens when a set of documents has been presented and the bank is obliged to pay. For some reasons, the bank cannot debit the payer's account in return and so gives (unwillingly) a credit to the payer. If the bank is lateron able to recover the document amount from the payer, they may collect interest from this day on.
This field specifies the date when the documents are starting to be past-due/ overdue. This happens when a set of documents has been presented and the bank is obliged to pay. For some reasons, the bank cannot debit the payer's account in return and so gives (unwillingly) a credit to the payer. If the bank is lateron able to recover the document amount from the payer, they may collect interest from this day on.
allNETT Negotiation Reference.
Send A2D in the initial negotiaition Message and is stored with the document contract for later use in case it needs to be send back D2A.
Dissplayed on the allNETTFields Panel. Can not be changed
The customer reference no. assigned for this negotiation.