Table of Contents

BTD - Document Set under Transfer L/C - Data

Module BTD

Description

BTD is the main data table for the Document Set under Transfer L/C contract.
All technical important fields have to be defined here.
Large text blocks should be defined in BTT.


Datafields

Name Description Data Type Len Dec. View lines View type Inst. Visible Codetable
INR INR of BE Contract Text 8 1 Edit Yes Public
OWNREF Own Reference (BE Number) Text 16 1 Edit Yes Public
NAM Name of Bill Contract Text 80 1 Edit Yes Public
OWNUSR Resp. User Text 8 1 20 Edit Yes Public
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 Opened/Issued Date 12 0 Date Yes Public
CLSDAT Date Closed Date 12 0 Date Yes Public
PNTTYP Parent Contract Type Text 6 1 Edit Yes Public
PNTINR Parent Contract INR Text 8 1 Edit Yes Public
RCVDATBE1 Date of Receipt 1st Beneficiary 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 BRDTYP
DISDAT Date of Discrepancy Advice Date 12 0 Date Yes Public
VER Version 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
MATTXTFLG Multiple Tenor Flag Text 1 1 Edit Yes Public
ORDDATBE2 Order Date (2nd Beneficiary) Date 12 0 Date Yes Public
DOCPRBROL Presented by Text 3 1 Edit Yes Public <fixed-length>
PAYROL Payer Text 3 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
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
ADVTYP Type of Advice Received Text 3 1 Edit Yes Public Embedded
DOCSTA Document Set Status Text 40 1 Edit Yes Public Embedded
RCVDATBE2 Date of Receipt 2nd Beneficiary Date 12 0 Date Yes Public
DOCPRBROLBE1 Presented by (1st Ben-Side) Text 3 1 Edit Yes Public <fixed-length>
ORDDATBE1 Order Date (1st Beneficiary) Date 12 0 Date Yes Public
PREDAT Presentation Date Date 12 0 Date Yes Public
ADVDOCBE1FLG Return of Documents BE1 Text 1 1 Edit Yes Public
ADVDOCBE2FLG Return of Documents BE2 Text 1 1 Edit Yes Public
CANCNF Reduce Confirmation Liability Text 1 1 Edit Yes Public
DOCROL Receiver of Documents Text 3 1 Edit Yes Public ROLALL
DOCROLFLG Send Documents to Another Address Text 1 1 Edit Yes Public
ANTNEGREF Customer Negotiation Reference Text 20 1 Edit Yes Public
ETYEXTKEY Entity holding Contract Text 8 1 Edit Yes Public

Indices

Name Fields Properties
BTD_ETYEXTKEY ETYEXTKEY
BTD_INR INR Unique
BTD_NAM NAM
BTD_OWNREF OWNREF
BTD_PNTINR PNTTYP, PNTINR

/


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, which is created by retrieving the next valid entry from the counter BTD. The field INR is used to enable links from other tables to this table. It also links the two tables BTD and BTT as associated entries hold 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 subcontract which has been created for the set of documents received from 2nd beneficiary.

Helpinformation

This field contains the reference number of the subcontract created for the set of documents received from 2nd beneficiary.


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 contains the external name of the selected set of documents presented under the transfer.


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 opening the contract, when reserving the reference number or when, for other reasons, 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. This might be a date prior to the creation date, when 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 PNTTYP Parent Contract Type

Description

This field contains the type of the parent contract.

Helpinformation

This field contains the type of the parent contract.


Datafield PNTINR Parent Contract INR

Description

This field contains the internal unique ID of the parent contract.

Helpinformation

This field contains the unique identifcation number of the parent contract.


Datafield RCVDATBE1 Date of Receipt 1st Beneficiary

Description

This field specifies the date on which the exchange documents (such as commercial invoice) of the first beneficiary side (PRP) have been received by the bank using the application (date of the actual receipt stamp, NOT date of customer order - that is ORDDATBE1). This field should be entered when documents are received from the first beneficiary side in transaction BTTDCK.

Helpinformation

This field specifies the date on which the exchange documents (such as the commercial invoice) of the first beneficiary side were received by the bank using the application (date of the actual receipt stamp, NOT date of customer order - that is 'Order Date (1st Beneficiary)'). This field should be entered when documents are received from the first beneficiary side in the transaction 'Receiving Documents from 1st Beneficiary'.


Datafield SHPDAT Date of Shipment

Description

This field contains the date of shipment as per transport document presented.

Helpinformation

This field contains the date of shipment as per the transport document presented.


Datafield ADVDAT Date of Advice of Documents Received

Description

This date is set when an Advice of Payment (incoming MT754) has been received ( e.g. in TRN LTTDAV).

Helpinformation

This date is set when an Payment Advice (incoming MT754) has been received.


Datafield MATDAT Maturity Date

Description

This field specifies the date when the documents under the transfer are due for payment.

Helpinformation

This field contains a fixed maturity date for the set of documents presented.


Datafield DOCTYPCOD Document Type

Description

This field contains the type of documents presented under the Transfer L/C.

Helpinformation

This field contains a list to select the type of the document presentation.


Datafield DISDAT Date Discrepancies Advised

Description

This date is set when an Advice of Discrepancy (incoming MT750) has been received ( e.g. in TRN LTTDAV).

Helpinformation

This date is set when an Advice of Discrepancy (incoming MT750) has been received.


Datafield VER Version

Description

This field holds the version counter to keep track of the version history of an BTD 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 APPROVCOD Documents on Approval Basis

Description

This field specifies if documents are sent on approval basis, meaning that discrepant documents are received which the applicant may pay or reject.

Helpinformation

Check this box if documents are to be handled on approval basis.


Datafield FREPAYFLG Free of Payment

Description

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”.

Helpinformation

This field specifies whether documents are handled free of payment, i.e. whether they are presented to the applicant without the applicant having to pay for them.


Datafield MATTXTFLG Multiple Tenor Flag

Description

This field is set to a non-empty value, if the document set holds more than one tenor.

Helpinformation

This field is set to a non-empty value, if the document set holds more than one tenor.


Datafield ORDDATBE2 Order Date (2nd Beneficiary)

Description

This field specifies the date of the incoming cover letter received from the second beneficiary side (PRB). The documents can be presented by the second beneficiary directly or via a second advising bank (refer to default BTDGRP\REC\DOCPRBROL).

This date should be entered when the receipt of second beneficiary documents is logged in transaction LTTDCK. If necessary, the date can be corrected in BTTDRV.

Helpinformation

This field specifies the date the incoming cover letter was received from the second beneficiary side. The documents can be presented by the second beneficiary directly or via a second advising bank.

This date should be entered when the receipt of second beneficiary documents is logged in transaction 'Receiving Documents from 2nd Beneficiary'. If necessary, the date can be corrected in 'Receive Documents'.


Datafield DOCPRBROL Presented by

Description

Role of the party which presented the documents.

Helpinformation

Role of the party which presented the documents.


Datafield PAYROL Payer

Description

This field specifies the debit party who is paying the document set (e.g. Issuing bank resp. their customer who is the applicant of the L/C).

Helpinformation

This field specifies the party to be debitted, i.e. the party responsible for paying the document set (e.g. the issuing bank or their customer, who is the applicant of the L/C).


Datafield DSCINSFLG Enter Docs, Discrep. and Instructions

Description

This checkbox enables the banks to decide whether they want to use a 'slim' version of TRN LTTDCK (Receiving Documents from 2nd Beneficiary) where only minimal information is entered (→ This function is preferred by larger banks). Smaller banks use TRN LTTDCK to enter document details, discrepancies and instructions. When the checkbox is set to 'not empty' the relevant additional panels are visible.

Helpinformation

This 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.


Datafield ACPNOWFLG Accept Documents now

Description

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 BT. The flag is used in transaction BTTPAY in order to pay sight documents or to book in liability for usance documents.

Helpinformation

This flag specifies that documents are taken up for payment, acceptance, negotiation. The selection made in this field strongly influences the processing options available in the BT (business sector Back-to-Back-L/C).

This flag is used in the BTTPAY transaction to pay sight documents or to book the liability for usance documents.


Datafield TOTCUR Currency of Total Amount to be Paid

Description

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 BTTPAY), the field is stored here.

Helpinformation

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 subsequent transactions (outgoing MT752), the field is stored here.


Datafield TOTAMT Total Amount to be Paid

Description

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 BTTPAY), the field is stored here.

Helpinformation

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.


Datafield TOTDAT Date to be Paid

Description

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.

Helpinformation

This field is necessary if 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, i.e. the date when the document set should be paid or has been paid. The information received is stored in this field.


Datafield ADVTYP Type of Advice Received

Description

This field specifies if documents have been advised via incoming Payment Advice (e.g. MT754) or Advice of Discrepancy (e.g. MT750).

Helpinformation

This field specifies if documents have been advised via incoming Payment Advice (e.g. MT754) or Advice of Discrepancy (e.g. MT750).

Codetable
Code Text
750 Advice of Discrepancy (MT750)
754 Advice of Payment (MT754)

Datafield DOCSTA Document Set Status

Description

The current document set status is stored in this field. This field is set via default in the panel module.

Helpinformation

The current status of the document set is stored in this field.

Codetable
Code Text
A Goods rel., Advice of Payment received
B Goods rel., Advice of Payment + docs rec
C Advice of Payment rec., wait for docs
D Advice of Payment rec., documents rec.
E Adv. of Discrep. received, wait for docs
F Adv of Discrepancy rec., document rec.
G Documents received
H Clean documents received
I Discrepant documents received
J Goods released, wait for documents
K Goods released, documents received
L Documents sent on approval basis
M Documents taken up
N Documents settled free of payment
R Documents have been refused and returned

Datafield RCVDATBE2 Date of Receipt 2nd Beneficiary

Description

This field specifies the date on which documents of the second beneficiary side (PRB) have been received by the bank using the application (date of the actual receipt stamp, NOT date of customer order - that is ORDDATBE2). This field should be entered when documents are received from the second beneficiary side in transaction LTTDCK.

Helpinformation

This field specifies the date on which documents of the second beneficiary side were received by the bank using the application (date of the actual receipt stamp, NOT date of customer order - that is 'Order Date (2nd Beneficiary)'). This field should be entered when documents are received from the second beneficiary side in transaction 'Receiving Documents from 2nd Beneficiary'.


Datafield DOCPRBROLBE1 Presented by (1st Beneficiary Side)

Description

This field specifies the presenting party on the 1st beneficiary side. In most cases, the exchange documents will be presented by the first beneficiary directly, but in some cases another bank might be involved (PRP).

Helpinformation

This field specifies the presenting party on the 1st beneficiary side. In most cases, the exchange documents are presented by the first beneficiary directly, in other cases, however, another bank may be involved.


Datafield ORDDATBE1 Order Date (1st Beneficiary)

Description

This field specifies the date of the incoming cover letter received from the first beneficiary side (PRP). The documents can be presented by the first beneficiary directly or via a second advising bank (refer to default BTDGRP\REC\DOCPRBROLBE1).

This date should be entered when the exchange documents (e.g. commercial invoice) of the first beneficiary are received and logged via transaction BTTDCK. If necessary, the date can be corrected in BTTDRV.

Helpinformation

This field specifies the date the incoming cover letter was received from the first beneficiary side. The documents can be presented by the first beneficiary directly or via a second advising bank.

This date should be entered when the exchange documents (e.g. commercial invoice) of the first beneficiary are received and logged via transaction 'Receive Documents from 1st beneficiary'. If necessary, the date can be corrected in 'Receive Documents'.


Datafield PREDAT Presentation Date

Description

This field specifies the date on which the bank using the application presents the documents to the L/C issuing bank. The presentation date should be set in transaction BTTSND or BTTPAY.

Helpinformation

This field specifies the date on which the bank using the application presents the documents to the L/C issuing bank. The presentation date should be set in transaction 'Sending Documents' or 'Send and Settle Documents'.


Datafield ADVDOCBE1FLG Return of Documents First Beneficiary

Description

When this flag is set, Documents to BE1 are returned.

Helpinformation

When this flag is set, documents to first beneficiary are returned.


Datafield ADVDOCBE2FLG Return of Documents Second Beneficiary

Description

When this flag is set, Documents to BE2 are returned.

Helpinformation

When this flag is set, documents to second beneficiary are returned.


Datafield CANCNF Reduce Confirmation Liability

Description

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)

Helpinformation

Triggers the booking of a liability if documents are to be sent on approval basis.


Datafield DOCROL Receiver of Documents

Description

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).

Helpinformation

This field can be used to send the documents (e.g. document presentation 1st/ 2nd mail) to an address other than that of the payer of documents.


Datafield DOCROLFLG Send Documents to Another Address

Description

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.

Helpinformation

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.


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 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 ANTNEGREF Customer Negotiation Reference

Description

Contains the reference number for customer negotiation.

Helpinformation

Contains the reference number for customer negotiation.