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 |
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 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.
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.
This field holds the User ID of the person responsible for handling this contract.
This field holds the INR of the transaction which opened/issued the 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 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 type of the parent contract.
This field contains the unique identifcation number of the parent contract.
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).
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 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.
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.
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.
Date contains the datet when an Advice of Payment (incoming MT754) was received (e.g. in transaction 'Advising Documents').
This field specifies the maturity date of a usance document set presented under the L/C.
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).
This field indicates the date when an Advice of Discrepancy (incoming MT750) was received (e.g. in transaction 'Advising Documents').
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'.
This flag is set in the (pre)opening transaction in case an incoming message is rejected. The contract is closed directly.
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.
This flag indicates the party instigating the release of goods.
This date specifies the date when the bank using the application has issued the release of goods.
This field indicates the number of the transport document (e.g. number of bill of lading, air waybill).
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.
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 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).
Code | Text |
---|---|
750 | Advice of Discrepancy (MT750) |
754 | Advice of Payment (MT754) |
OTH | Other |
This field is used to differentiate between goods released under a shipping guarantee or under an air waybill, etc.
Code | Text |
---|---|
SG | Release under Shipping Guarantee |
AW | Release under AWB/ FCR/ CMR |
BL | B/L Endorsement |
In case a shipping guarantee is issued under the L/C, this date specifies the expiry date of the shipping guarantee.
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'.
This field indicates the type of transport document (e.g. bill of lading, air waybill etc.) which is presented under this L/C.
This field indicates the date of the transport document (e.g. bill of lading, air waybill) which is presented under this L/C.
This field indicates how the goods have been shipped (e.g. via sea, air or a combination of different transport modes).
This field is set to an non-empty value, if the document set holds more than one tenor.
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.
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.
The current status of the document set is stored in this field.
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 |
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.
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.
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.
This field specifies the debit party who is paying the document set (e.g. applicant)
This field specifies whether documents are to be accepted and whether liabilities can be booked against the BR.
Date of incoming cover letter received from the presenter.
When this flag is set, documents were returned.
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.
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 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.
This field specifies the UPAU Maturity date.