If you just need to add some additional static information to records in the database, several of the tools we have discussed can satisfy that need. The best tool for that sort of thing is Extender. That's all good and fine, but if you don't happen to own the Extender module, that's not a good answer.
This section explores how you can store additional data using the DUOS tables.
DUOS stands for Dynamic User Object Store. The DUOS table is stored in the company database and has the following characteristics.
Display name |
Technical name |
Physical name |
Series |
---|---|---|---|
|
|
|
Company |
Field name |
Physical name |
Storage type |
Field Position |
---|---|---|---|
|
|
Long Integer |
1 |
|
|
String |
5 |
|
|
String |
37 |
|
|
String |
99 |
|
|
String |
131 |