User Tools
Add this page to your book 
Remove this page from your book 
Manage book (
Help Table of Contents
PRD - Product Codes
Module PRD
Datafields
| Name | Helptext Description | Data Type | Len | Codetable |
|---|---|---|---|---|
| PRDCOD | Product Code | Text | 6 | PRDCOD |
| PRDSUB | Product Subtype | Text | 6 | PRDSUB |
| PRDVAR | Product Variant | Text | 6 | PRDVAR |
| BUS | Business Sector | Text | 2 | BUSTXT |
| LCRTYP | Form of Documentary Credit | Text | 2 | LCRTYP |
| DOMFLG | Domestic | Text | 1 | |
| AVBBY | Available by | Text | 1 | AVBBY0 |
| CNFSTA | Confirmation Status | Text | 1 | CNFSTA |
| GARTYP | Undertaking Type | Text | 1 | <fixed-length> |
| DOCTYPCOD | Collection Condition | Text | 1 | DOCTYP |
| DFTGARFLG | Avalization | Text | 1 | |
| FINRECFLG | Recourse Flag | Text | 1 | |
| FINRSKTYP | Type of Risk | Text | 2 | <fixed-length> |
| FINSUBTYP | Special Type of Financing | Text | 2 | <fixed-length> |
| FINTYPBP | Type of Financing | Text | 1 | <fixed-length> |
| FINTYPTR | Finance Type | Text | 3 | <fixed-length> |
| LEGFRM | Undertaking Form | Text | 4 | <fixed-length> |
| INR | Internal Unique ID | Text | 8 | |
| UPATYP | UPAS / UPAU (Usance Payable at Sight or Usance) | Text | 4 | <fixed-length> |
| CNFDET | Confirmation Instructions | Text | 1 | CNFFLG |
| PRDCODREF | Product Code for Reference | Text | 3 | |
| VER | Version | Text | 4 | |
| GETFLDNRM | Field holding the normalized search fields. | Text | 60 |
Datafield Description and Properties
Datafield AVBBY Available by
This field indicates whether the contract is available by sight payment, deferred payment, acceptance, negotiation or mixed payment.
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 GETFLDNRM Field holding the normalized search fields.
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.
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.
