Table of Contents

BRD - Document Set under Import L/C Data

Module BRD


Datafields

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
OPNTRNINR TRNINR which opened contract Text 8
CREDAT Date Created Date 12
OPNDAT Opening Date Date 12
CLSDAT Date Closed Date 12
PNTTYP Parent Contract Type Text 6
PNTINR Parent Contract INR Text 8
PREDAT Presentation Date Date 12
SHPDAT Date of Shipment Date 12
SETDAT Date of Settlement Date 12
SPDDAT Start Past-due Date Date 12
TOTDAT Date to be Paid Date 12
ADVDAT Date of Advice of Payment Date 12
MATDAT Maturity Date Date 12
RCVDAT Date of Receipt of Documents Date 12
DISDAT Date of Discrepancy Advice Date 12
DOCFLG Usance, Sight or Mixed Text 1 BRDTYP
REJFLG Direct rejection Text 1 REJFLG
APPROVCOD Documents on Approval Basis Text 1
RELGODFLG Release of Goods Text 1 RELGOD
RELGODDAT Request Date for Release of Goods Date 12
TRPDOCNUM Transport Document Number Text 40
FREPAYFLG Free of Payment Flag Text 1
VER Version Text 4
ADVTYP Type of Advice Received Text 3 Embedded
RELTYP Release Type Text 2 Embedded
EXPDAT Expiry Date of Shipping Guarantee Date 12
RTOAPLFLG Release Goods to Applicant? Text 1
TRPDOCTYP Transport Document Type Text 6
TRADAT Date of Transport Document Date 12
TRAMOD Mode of Transport Text 6
MATTXTFLG Multiple Tenor Flag Text 1
DSCINSFLG Enter Docs, Discrep. and Instructions Text 1
DOCPRBROL Presented by Text 3 <fixed-length>
DOCSTA Document Set Status Text 1 Embedded
IGNDISFLG Ignore Discrepancies Text 1
TOTCUR Currency of Total Amount to be Paid Text 3 CURTXT
TOTAMT Total Amount to be Paid Numeric 18
DOCPYRROL Payer Text 3 ROLALL
ACPNOWFLG Accept Documents Now Text 1
ORDDAT Order Date Date 12
ADVDOCFLG Return of Documents Text 1
STBFLG Sticker Bank Text 1
PAYNOWFLG Payment Remitted Text 1
INTMATDAT UPAU Maturity Date Date 12
ETYEXTKEY Entity Text 8

Datafield Description and Properties


Datafield INR Internal Unique ID

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

This field contains the reference number of the document set contract (BR). The reference number can comprise up to 16 characters. This field should be defined as a database key field to optimize performance. It can be used to search for BR contracts in the database.


Datafield NAM Name

This field contains the name of the bills received displayed externally to identify a BR contract. The name can comprise up to 40 characters.

This field should be defined as a database key field to optimize performance. It can be used to search for BR contracts in the database.


Datafield OWNUSR Responsible User

This field holds the User ID of the person responsible for handling this contract.


Datafield OPNTRNINR TRNINR which opened contract

This field holds the INR of the transaction which opened/issued the contract.


Datafield CREDAT Date Created

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


Datafield OPNDAT Opening Date

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

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

This field contains the type of the parent contract.


Datafield PNTINR Parent Contract INR

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


Datafield PREDAT Presentation Date

The presentation date is the date when the bank using the application presents the documents to the customer (e.g. the applicant or initiating institution).


Datafield SHPDAT Date of Shipment

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.


Datafield SETDAT Date of Settlement

This field is filled when settlement is effected before documents have been presented. If the field is filled, it is possible to claim back the document amount.


Datafield SPDDAT Start Past-due Date

This field specifies the date when the documents starting to become past-due/overdue. This happens when a clean set of documents has been presented to the issuing bank (bank using the application) and the bank is obliged to pay. For some reasons, the bank cannot debit the applicant's account in return and so gives (unwilligly) a credit to the applicant. If the bank is later on able to recover the document amount from the applicant, they may collect interest from this day on.


Datafield TOTDAT Date to be Paid

This field is necessary in case an Advice of Payment (MT 754) 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.


Datafield ADVDAT Date of Advice of Payment

Date contains the datet when an Advice of Payment (incoming MT754) was received (e.g. in transaction 'Advising Documents').


Datafield MATDAT Maturity Date

This field specifies the maturity date of a usance document set presented under the L/C.


Datafield RCVDAT Date of Receipt of Documents

Date when the bank using the application has received the documents from the presenter (date of receipt stamp, NOT date of customer order - that would be the order date).


Datafield DISDAT Date of Discrepancy Advice

This field indicates the date when an Advice of Discrepancy (incoming MT750) was received (e.g. in transaction 'Advising Documents').


Datafield DOCFLG Usance, Sight or Mixed

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

For example, if “sight documents” (= P) has been selected, the document set can be settled in the 'Send, Accept and Settle Documents' transaction, while for usance documents (= A, D) only liabilities can be booked in 'Send, Accept and Settle Documents'.


Datafield REJFLG Direct rejection

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


Datafield APPROVCOD Documents on Approval Basis

This field specifies whether documents are sent on approval basis, i.e. that discrepant documents can be received which the applicant may pay or reject.


Datafield RELGODFLG Release of Goods

This flag indicates the party instigating the release of goods.


Datafield RELGODDAT Request Date for Release of Goods

This date specifies the date when the bank using the application has issued the release of goods.


Datafield TRPDOCNUM Transport Document Number

This field indicates the number of the transport document (e.g. number of bill of lading, air waybill).


Datafield FREPAYFLG Free of Payment Flag

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


Datafield VER Version

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 ADVTYP Type of Advice Received

This field specifies whether documents have been advised by means of an incoming Payment Advice (e.g. MT754) or Advice of Discrepancy (e.g. MT750).

The option “Other” can be used for incoming messages other than MT750 or MT754 which might also advise a document set. Example: The issuing bank has issued the L/C with the authorization to reimburse (L/C is payable abroad and the issuing bank itself is the reimbursing bank). If the bank abroad accepts documents and claims for reimbursement, the issuing bank might receive a MT742 (reimbursement claim).

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

Datafield RELTYP Release Type

This field is used to differentiate between goods released under a shipping guarantee or under an air waybill, etc.

Codetable
Code Text
SG Release under Shipping Guarantee
AW Release under AWB/ FCR/ CMR
BL B/L Endorsement

Datafield EXPDAT Expiry Date of Shipping Guarantee

In case a shipping guarantee is issued under the L/C, this date specifies the expiry date of the shipping guarantee.


Datafield RTOAPLFLG Release Goods to Applicant?

If this flag is set, goods are released to the applicant of the L/C. Otherwise, goods can be released to another party entered in 'Release to Address'.


Datafield TRPDOCTYP Transport Document Type

This field indicates the type of transport document (e.g. bill of lading, air waybill etc.) which is presented under this L/C.


Datafield TRADAT Date of Transport Document

This field indicates the date of the transport document (e.g. bill of lading, air waybill) which is presented under this L/C.


Datafield TRAMOD Mode of Transport

This field indicates how the goods have been shipped (e.g. via sea, air or a combination of different transport modes).


Datafield MATTXTFLG Multiple Tenor Flag

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


Datafield DSCINSFLG Enter Docs, Discrep. and Instructions

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 DOCPRBROL Presented by

Defines the party who has presented documents and is the receiver of payment. Exception: In case a stickerbank has been entered, the payment is made to the stickerbank.


Datafield DOCSTA Document Set Status

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

Codetable
Code Text
A Goods released, Adv. of Payment received
B Goods released, Adv. of Payment + docs
C Adv. of Payment received, wait for docs
D Advice of Payment and documents received
E Adv. of Discrep. received, wait for docs
F Advice of Discrepancy and docs received
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
T Discrepant document received in trust
O Other Type of Advice, wait for documents
R Documents have been refused and returned

Datafield IGNDISFLG Ignore Discrepancies

This field is closely linked to field 'Discrepancies' where the discrepancies of the document set are listed. If this field is set to a non-empty value, the content of 'Discrepancies' will be ignored. For example: If the field is filled, the discrepancies are not listed in the outgoing correspondence, diaries are not generated to follow up acceptance of discrepant documents.


Datafield TOTCUR Currency of Total Amount to be Paid

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 in 'Accept Discrepancies') or 'Send and Settle Documents'), the field is stored here.


Datafield TOTAMT Total Amount to be Paid

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 subsequent transactions (outgoing MT752 in 'Accept Discrepancies' or 'Send, Accept and Settle Documents'), the field is stored here.


Datafield DOCPYRROL Payer

This field specifies the debit party who is paying the document set (e.g. applicant)


Datafield ACPNOWFLG Accept Documents Now

This field specifies whether documents are to be accepted and whether liabilities can be booked against the BR.


Datafield ORDDAT Order Date

Date of incoming cover letter received from the presenter.


Datafield ADVDOCFLG Return of Documents

When this flag is set, documents were returned.


Datafield STBFLG Sticker Bank

When this flag is set, the document presenting bank acts as a Sticker Bank, which means the receivables have been sold to this bank and payment must be effected to the Sticker Bank according to the presenting bank's instructions. Usually, this is documented by a sticker on the document presentation letter.


Datafield ETYEXTKEY Entity

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 PAYNOWFLG Payment Remitted

This is applicable only for UPAS/UPAU LCs.

This checkbox denotes if payment to Beneficiary can be remitted or not (by debiting the internal UPF account). If the flag is set, settlement will be made final and payment remitted to the Beneficiary.


Datafield INTMATDAT UPAU Maturity Date

This field specifies the UPAU Maturity date.