| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPMarketing Retail Network |
| 1 | OIFCOPT1 | Retail Network Contract option type | 2 | OPTTYP | Option type | nvarchar | 2 | 0 | | |
| 2 | OIFCOPT1S | Retail Network Contract option type description | 3 | OPTTYP | Option type | nvarchar | 2 | 0 | | |
| TOPRisk Analysis |
| 3 | JBRDBOPTI | RM: DB Table OPTI Extended Category of Primary Transaction | 17 | OPTTYP | Original Option category (On Conclusion of Deal) | nvarchar | 3 | 0 | | |
| 4 | JBRHOPTI | RM: Version Table OPTI Extended Category of Primary Trans. | 18 | OPTTYP | Original Option category (On Conclusion of Deal) | nvarchar | 3 | 0 | | |
| 5 | JBRSVOPTI | RM: Option Data Table of Cat. Prim. Trans for Saved Datasets | 18 | OPTTYP | Original Option category (On Conclusion of Deal) | nvarchar | 3 | 0 | | |
| TOPTransaction Management |
| 6 | TCHT_HD_OPTION | SFGDT FGET Option Structure | 17 | OPTTYP | Original Option category (On Conclusion of Deal) | nvarchar | 3 | 0 | | |
| TOPTransaction Manager |
| 7 | ATO1 | Check Table for Option Categories | 1 | OPTTYP | Original option category (on closing) | nvarchar | 3 | 0 | | |
| 8 | ATO1T | Text Table for ATO1 | 2 | OPTTYP | Original option category (on closing) | nvarchar | 3 | 0 | | |
| 9 | ATPA | Treasury: Product Type Supplements | 12 | OPTTYP | Original option category (on closing) | nvarchar | 3 | 0 | | |
| 10 | VTIOF | Additional Option Data | 22 | OPTTYP | Original option category (on closing) | nvarchar | 3 | 0 | | |
