Name | Description | Data Type | Len | Dec. | View lines | View type | Inst. | Visible | Codetable |
---|---|---|---|---|---|---|---|---|---|
PRDCOD | Product Code | Text | 6 | 1 | Edit | Yes | Public | PRDCOD | |
PRDSUB | Product Subtype | Text | 6 | 1 | Edit | Yes | Public | PRDSUB | |
PRDVAR | Product Variant | Text | 6 | 1 | Edit | Yes | Public | PRDVAR | |
BUS | Business Sector | Text | 2 | 1 | Edit | Yes | Public | BUSTXT | |
LCRTYP | Form of Documentary Credit | Text | 2 | 1 | Edit | Yes | Public | LCRTYP | |
DOMFLG | Domestic | Text | 1 | 1 | Edit | Yes | Public | ||
AVBBY | Available by [AVBBY0] | Text | 1 | 1 | Edit | Yes | Public | AVBBY0 | |
CNFSTA | Confirmation Status | Text | 1 | 1 | Edit | Yes | Public | CNFSTA | |
GARTYP | Undertaking Type | Text | 1 | 1 | Edit | Yes | Public | <fixed-length> | |
DOCTYPCOD | Collection Condition | Text | 1 | 1 | Edit | Yes | Public | DOCTYP | |
DFTGARFLG | Avalization | Text | 1 | 1 | Edit | Yes | Public | ||
FINRECFLG | Recourse Flag | Text | 1 | 1 | Edit | Yes | Public | ||
FINRSKTYP | Type of Risk | Text | 2 | 1 | Edit | Yes | Public | <fixed-length> | |
FINSUBTYP | Special Type of Financing | Text | 2 | 1 | Edit | Yes | Public | <fixed-length> | |
FINTYPBP | Type of Financing | Text | 1 | 1 | Edit | Yes | Public | <fixed-length> | |
FINTYPTR | Finance Type | Text | 3 | 1 | Edit | Yes | Public | <fixed-length> | |
LEGFRM | Undertaking Form | Text | 4 | 1 | Edit | Yes | Public | <fixed-length> | |
INR | Internal Unique ID of Contract Party | Text | 8 | 1 | Edit | Yes | Public | ||
UPATYP | UPAS / UPAU (Usance Payable at Sight or Usance) | Text | 4 | 1 | Edit | Yes | Public | <fixed-length> | |
CNFDET | Confirmation Instructions | Text | 1 | 1 | Edit | Yes | Public | CNFFLG | |
PRDCODREF | Product Code for Reference | Text | 3 | 1 | Edit | Yes | Public | ||
VER | Version Counter | Text | 4 | 1 | Edit | Yes | Public | ||
GETFLDNRM | Field holding the normalized search fields | Text | 60 | 1 | Edit | Yes | Public |
Name | Fields | Properties |
---|---|---|
PRD_CODES | BUS, PRDCOD, PRDSUB, PRDVAR | |
PRD_INR | INR | Unique |
/
INR
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.
This field contains the business module for which product codes should be defined.
This field specifies the type of L/C. According to SWIFT, further specification codes are available, such as transferable, standby and combinations of these.
Domestic - when the L/C / Guarantee is Domestic.
This field indicates whether the L/C is available by sight payment, deferred payment, acceptance, negotiation or mixed payment.
This field indicates whether the contract is available by sight payment, deferred payment, acceptance, negotiation or mixed payment.
This field contains the confirmation status of the DOKA bank under the export LC and therefore indicates whether the bank has added its confirmation (“Y”) to the L/C or not (“”). “S” indicates a silent confirmation which is not disclosed to the issuing bank.
This field holds the undertaking type or guarantee/ standby.
This field specifies the type of collection. E.g. whether sight or usance documents have been presented.
This field indicates if a draft should be avalized under the import collection.
This field specifies whether recourse can be claimed from the financing party.
This field specifies the type of risk involved in the underlying financing.
This field further specifies the type of the underlying financing.
This field contains the finance type of the advance.
This field contains the finance type of the loan.
This field contains the legal form or the undertaking.
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 PTS. The field INR is used to maintain links from other tables into this table.
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 specifies if the usance Letter of Credit is payable at Sight (UPAS) or at Usance (UPAU). This is beneficial for the beneficiary of the LC as he would receive the funds earlier than originally stipulated under the LC. For example, a UPAS LC means that the applicant of the LC has to pay at the end of the usance period/ Maturity date of the LC while the beneficiary is paid at sight, ie when documents are taken up.
This field contains the confirmation instruction under the import LC.
Field holding the concatenated and normalized sum of all search fields used by quick search. This is one of the fields set in a SdbSetNRMFields method defined in the table definition module.
Field holding the concatenated and normalized sum of all search fields used by quick search. This is one of the fields set in a SdbSetNRMFields method defined in the table definition module.
3 Digit Product Code, that can be used in Referencenumber configuration
This field holds the version counter to keep track of the version history of an PRD 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.