REF is the data table for the Configuration of Reference Number.
| Name | Description | Data Type | Len | Dec. | View lines | View type | Inst. | Visible | Codetable |
|---|---|---|---|---|---|---|---|---|---|
| INR | Internal Unique ID of Configuration | Text | 8 | 1 | Edit | Yes | Public | ||
| EXTKEY | Entity Group of Configurable Reference Number | Text | 8 | 1 | Edit | Yes | Public | ||
| COL1 | Iteraction1 (business module or product code) | Text | 3 | 1 | Edit | Yes | Public | Embedded | |
| POS1 | Position of column1 | Numeric | 1 | 0 | Edit | Yes | Public | ||
| LEN1 | Length of COL1 | Numeric | 1 | 0 | Edit | Yes | Public | ||
| COL2 | Iteraction2 (entity name or entity code) | Text | 3 | 1 | Edit | Yes | Public | Embedded | |
| POS2 | Position of column2 | Numeric | 1 | 0 | Edit | Yes | Public | ||
| LEN2 | Length of COL2 | Numeric | 1 | 0 | Edit | Yes | Public | ||
| COL3 | Iteraction3 (year) | Text | 4 | 1 | Edit | Yes | Public | ||
| POS3 | Position of column3 | Numeric | 1 | 0 | Edit | Yes | Public | ||
| LEN3 | Length of COL3 | Numeric | 1 | 0 | Edit | Yes | Public | ||
| COL4 | Iteraction4 (counter) | Text | 4 | 1 | Edit | Yes | Public | ||
| POS4 | Position of column4 | Numeric | 1 | 0 | Edit | Yes | Public | ||
| LEN4 | Length of COL4 | Numeric | 1 | 0 | Edit | Yes | Public | ||
| COL5 | Iteraction5 (special character) | Text | 4 | 1 | Edit | Yes | Public | ||
| POS5 | Position of column5 | Numeric | 1 | 0 | Edit | Yes | Public | ||
| LEN5 | Length of COL5 | Numeric | 1 | 0 | Edit | Yes | Public | ||
| COL6 | Iteraction6 (sequence) | Text | 4 | 1 | Edit | Yes | Public | ||
| POS6 | Position of column6 | Numeric | 1 | 0 | Edit | Yes | Public | ||
| LEN6 | Length of COL6 | Numeric | 1 | 0 | Edit | Yes | Public | ||
| COL7 | Iteraction7 (special character | Text | 4 | 1 | Edit | Yes | Public | ||
| POS7 | Position of column7 | Numeric | 1 | 0 | Edit | Yes | Public | ||
| LEN7 | Length of COL7 | Numeric | 1 | 0 | Edit | Yes | Public | ||
| COL8 | Iteraction8 (sequence) | Text | 4 | 1 | Edit | Yes | Public | ||
| POS8 | Position of column8 | Numeric | 1 | 0 | Edit | Yes | Public | ||
| LEN8 | Length of COL8 | Numeric | 1 | 0 | Edit | Yes | Public | ||
| VER | Version Counter | Text | 4 | 1 | Edit | Yes | Public | ||
| ETGEXTKEY | Entity Group of Config. References | Text | 8 | 1 | Edit | Yes | Public | ||
| GETFLDNRM | Field holding the normalized search fields | Text | 60 | 1 | Edit | Yes | Public |
| Name | Fields | Properties |
|---|---|---|
| REF_ETGEXTKEY | ETGEXTKEY | Unique |
| REF_GETFLDNRM | GETFLDNRM | |
| REF_INR | INR | Unique |
/
INR
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 REF. 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 holds the external key to identify a Configurable Reference Number.
This field holds the external key to identify a Configurable Reference Number.
This denotes the business module (such as Import LC, Guarantee etc.) to which the contract belongs to.
Mandatory field
This denotes the business module (such as Import LC, Guarantee etc.) to which the contract belongs to.
1st panel: User can define its order or position in the contract reference and its total length.
2nd panel: It is user-definable, in accordance to the definition in 1st panel. Swift X characters are also allowed.
| Code | Text |
|---|---|
| BUS | Business Module |
| PRD | Product Code |
Position/Order of the 1st iteration “Business Module”. User to input the position in which business module to appear in the reference number.
Position/Order of the 1st iteration “Business Module”. User to input the position in which business module to appear in the reference number.
The length of first iteration “Business module”.
The length of first iteration “Business module”.
Optional field
Used to identify the entity/branch from where the contract was processed. Options are available to use either “Entity ID” or “Entity Name” as part of the contract reference for entity identification.
1st panel: User can define its order or position in the contract reference and its total length.
2nd panel: System populates the value from Entity table as per the selection (ID/Name) in the 1st panel.
| Code | Text |
|---|---|
| ETY | Entity ID |
| NAM | Entity Name |
Position/Order of the 2nd iteration “Entity”. User to input the position in which the entity is to appear in the reference number.
Position/Order of the 2nd iteration “Entity”. User to input the position in which the entity is to appear in the reference number.
The length of 2nd iteration Entity
The length of 2nd iteration Entity
Optional field
Used to identify the year in which the contract was processed. Allowed values in the length are just “2” (YY) or “4” (YYYY).
1st panel: User can define its order or position in the contract reference and its total length.
2nd panel: System populates the value “YY” or “YYYY”, based on the definition in 1st panel.
Position/Order of the 3rd iteration “Year”. User to input the position in which the year should appear in the reference number.
Position/Order of the 3rd iteration “Year”. User to input the position in which the year should appear in the reference number.
The length of 3rd iteration “Year”.
The length of 3rd iteration “Year”.
Mandatory field
This would be the running counter/sequence of the contract reference.
1st panel: User can define its order or position in the contract reference and its total length.
2nd panel: System populates the value, based on the definition in 1st panel.
Position/Order of the 4th iteration “Counter”. User to input the position in which counter is to appear in the reference number.
Position/Order of the 4th iteration “Counter”. User to input the position in which counter is to appear in the reference number.
The length of 4th iteration “Counter”.
The length of 4th iteration “Counter”.
Optional field
Could be used to differentiate the sequence of child contract.
1st panel: User can define its order or position in the contract reference and its total length.
2nd panel: It is user-definable, in accordance to the definition in 1st panel and allowed characters.
Position/Order of the 5th iteration “Special Character (1st level)”. User to input the position in which the special character is to appear in the reference number.
Position/Order of the 5th iteration “Special Character (1st level)”. User to input the position in which the special character is to appear in the reference number.
The length of 5th iteration “Special Character” (1st level).
The length of 5th iteration “Special Character” (1st level).
Mandatory field
Denotes the sequence of the child contract.
1st panel: User can define its order or position in the contract reference and its total length.
2nd panel: System defined, in accordance to the definition in 1st panel.
Position/Order of the 6th iteration “Sequence (1st level)”. User to input the position in which the 1st level sequence is to appear in the reference number.
Position/Order of the 6th iteration “Sequence (1st level)”. User to input the position in which the 1st level sequence is to appear in the reference number.
The length of 6th iteration “Sequence” (1st level).
The length of 6th iteration “Sequence” (1st level).
Optional field
Could be used to differentiate the sequence of sub-child contract.
1st panel: User can define its order or position in the contract reference and its total length.
2nd panel: It is user-definable, in accordance to the definition in 1st panel and allowed characters.
Position/Order of the 7th iteration “Special Character (2nd level)”. User to input the position in which special character is to appear in the reference number.
Position/Order of the 7th iteration “Special Character (2nd level)”. User to input the position in which special character is to appear in the reference number.
The length of 7th iteration “Special Character” (2nd level).
The length of 7th iteration “Special Character” (2nd level).
Mandatory field
Denotes the sequence of the sub-child contract.
1st panel: User can define its order or position in the contract reference and its total length.
2nd panel: System defined, in accordance to the definition in 1st panel.
Position/Order of the 8th iteration “Sequence (2nd level)”. User to input the position in which 2nd level sequence is to appear in the reference number.
Position/Order of the 8th iteration “Sequence (2nd level)”. User to input the position in which 2nd level sequence is to appear in the reference number.
The length of 8th iteration “Sequence” (2nd level)
The length of 8th iteration “Sequence” (2nd level)
This field holds the version counter to keep track of the version history of a REF 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.
This field holds the external key of the owning entity group 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 group are visible to the user.
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.