| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
---|
TOP01: Address Book |
1 | F01112 | Related Person | 4 | CP | RELY | Relation Type | String | UDC | 5 | 0 |
2 | F01112Z1 | Batch - Related Person | 17 | PB | RELY | Relation Type | String | UDC | 5 | 0 |
3 | F01501 | Enhanced Parent Child | 5 | PR | RELY | Relation Type | String | UDC | 5 | 0 |
User Defined Codes are, by design, customisable and thus will differ from system to system depending on the business requirements.
TOPUDC 01 / RT (Relation Type) stock values
| Value | Description | Special Handling Code | Hard Coded |
---|
1 | | . | | N |
2 | A | Administrative Assistant | | N |
3 | B | Important Business Contact | | N |
4 | C | Child | | N |
5 | D | Project Lead | | N |
6 | E | Researcher | | N |
7 | F | Administrator | | N |
8 | H | Husband | | N |
9 | R | Receptionist | | N |
10 | S | Spouse | | N |
11 | W | Wife | | N |