User Tools
Add this page to your book 
Remove this page from your book 
Manage book (
Help Table of Contents
Maintaining Reference Number Configuration
Transaction DBIREF
Reference numbers are unique identification numbers for all the business contracts. Each contract has to have a unambiguous and continuous reference under each business module. Thereby allowing clients/users to primarily identify the type of business module the contract belongs too. In addition, the application also allows the client/user to identify the entity/branch to which the contract belongs and the year of input.
This transaction is used to customize the configuration of reference numbers as per the using bank's requirement. The configuration is common for the entire entity group (see Maintaining Entity Groups).
Please note, if there are open contracts still available in the environment, then modifying the structure of a reference number is not possible.
In that case, the panel “Configuration Reference Number” will be disabled for modification.
However, if required, user could still go ahead and update the “References for Business sectors” panel (i.e., the business module structure in the reference number).
Note, this has been done to avoid changing the length of reference number which might impact the sequences of follow up transactions such as drawings.
Only when there are no open contracts in an environment, it is possible to modify the reference number configuration.
The following transactions can be started from here by clicking the icons in the list below for:
printing reference number configuration.
creating a Reference Number Configuration List 
showing the Version Log of the modifications to the reference number configuration.
Configuration Reference Number
The structure of the reference numbers consists of below iterations:
- Business Module: The dropdown supports Business Module / Product Code. Either of the value could be chosen to be a part of reference number. However, for option “Product Code”, the length is fixed to 3 characters.
- Entity: This dropdown supports Entity ID / Entity Name. Either of the value could be chosen to be a part of contract reference number.
- Year: Supports either 2 digit (YY) or 4 digit (YYYY) value. As they are the mostly used preferences.
- Counter: This is the running sequence of the contract. It is generated by the parent contract and will also be used by the child contract.
- Special Character (1): Special character to separate the parent contract from child contract. Allowed characters are “()/':.,-_”
- Sequence (1): This is the running sequence of child contract.
- Special Character (2): Special character to separate the sub-child contract. Allowed characters are “()/':.,-_”
- Sequence (2): This is the running sequence of the sub-child contract.
Input is mandatory for iterations, “Business Module”, “Counter”, “Sequence 1” and “Sequence 2”. Input for other iterations are optional.
Order is used to configure/re-arrange the position of the iterations as per client's requirement. Example: If client's reference number starts with Entity, it could be placed at 1st position followed by other iterations such as Business module and Year and so on.
Length is used define the length of each iterations as per client's requirement. However, the total length cannot exceed 16 digits. Total length is automatically calculated based on the user's input.
References for Business Sector
The columns “Business module”, “Special character 1” and “Special character 2” are user definable in accordance to the definition from the configuration panel. However, these columns are inter-related and system will display an error prompt to fill the linked columns if left blank. Special character 1 & 2 columns are used under child and sub-child sectors/business modules. They can also be used under standalone business modules which has sequences such as “Loan” and “Advance” module.
If a parent module is defined, input will be mandatory for its linked child modules as well. Example: If “Import LC” is defined, it will be mandatory to define “Import LC Document set”. It works the other way around also.
Other columns such as “Entity”, “Year”, “Counter”, “Sequence 1 & 2” are system defined based on definition from configuration panel. These will be disabled for user input.
At the end of each row, for each business sector, a view button is available for previewing the defined structure of reference number. This button will be enabled if all necessary columns are filled in that row.
Transaction Panels
Configuration Reference Number
Datafields
| Datafield | Description |
|---|---|
| Entity's Group | cf Appendix A, Table ETY field ETG |
| Timestamp of Modification | cf Appendix A, Table SLG field DATTIM |
| Business Module | cf Appendix A, Table REF field COL1 |
| Position of column1 | cf Appendix A, Table REF field POS1 |
| Length of COL1 | cf Appendix A, Table REF field LEN1 |
| Entity | cf Appendix A, Table REF field COL2 |
| Position of column2 | cf Appendix A, Table REF field POS2 |
| Length of COL2 | cf Appendix A, Table REF field LEN2 |
| Year | cf Appendix A, Table REF field COL3 |
| Position of column3 | cf Appendix A, Table REF field POS3 |
| Length of COL3 | cf Appendix A, Table REF field LEN3 |
| Counter | cf Appendix A, Table REF field COL4 |
| Position of column4 | cf Appendix A, Table REF field POS4 |
| Length of COL4 | cf Appendix A, Table REF field LEN4 |
| Special Character | cf Appendix A, Table REF field COL5 |
| Position of column5 | cf Appendix A, Table REF field POS5 |
| Length of COL5 | cf Appendix A, Table REF field LEN5 |
| First Sequence | cf Appendix A, Table REF field COL6 |
| Position of column6 | cf Appendix A, Table REF field POS6 |
| Length of COL6 | cf Appendix A, Table REF field LEN6 |
| Special Character | cf Appendix A, Table REF field COL7 |
| Position of column7 | cf Appendix A, Table REF field POS7 |
| Length of COL7 | cf Appendix A, Table REF field LEN7 |
| Second Sequence | cf Appendix A, Table REF field COL8 |
| Position of column8 | cf Appendix A, Table REF field POS8 |
| Length of COL8 | cf Appendix A, Table REF field LEN8 |
| Total Length | This is the total length of the contract reference numbers under the entity group. It cannot exceed 16 digits. This is automatically updated by the system based on sum of each iteration's length. |
References for Business Sectors
