Master Fields
Accountants Enterprise only
These fields are found in the CDS file DS6CD100 and are used for text letter writing. (Client Master Data - Includes Client, Prospects, Employees etc)
Field | Name | Type | Len | Description |
---|---|---|---|---|
D101 | Name Code | Alphanumeric | 10 |
|
D102 | Group | Alpha | 1 | C = Contact E = Employee |
D105 | Status Type | Alpha | 1 | If group = Contact, then the status type is either prospect, client, creditor both client/creditor, other or edited code. If group = E Employee, then the status type is either partner, manager, staff or clerk. |
D106 | Alternate Code | Alphanumeric | 10 |
|
D110 | New Code | Alphanumeric | 10 | new code if edited |
D111 | Old Code | Alphanumeric | 10 | old code if edited |
D114 | Alphabetic | Alpha | 10 |
|
D120 | Date Added | Date |
|
|
D121 | Date Closed | Date |
|
|
D124 | Date of Birth | Date |
|
|
D125 | Last update | Date |
|
|
D126 | Last update Time | Numeric | 8 |
|
D142 | Employee- MLS- Level/category | Alpha | 10 |
|
D150 | Credit hold? | Alpha | 1 |
|
D151 | Credit limit $ | Numeric | 12 |
|
D152 | Credit Limit days | numeric | 30 |
|
D155 | Security- read | Alphanumeric | 20 |
|
D156 | Security - write | Alphanumeric | 20 |
|
D160 | Closed? | Alpha | 1 |
|
D163 | Individual? | Alpha | 1 |
|
D165 | Sex | Alpha | 1 |
|
D167 | Last Update By | Alphanumeric | 8 |
|
D168 | Initials | Alphanumeric | 10 |
|
D169 | Title | Alphanumeric | 10 |
|
D190 | Salutation | Alphanumeric | 30 |
|
D191 | Given Names | Alphanumeric | 60 |
|
D192 | Surname | Alphanumeric | 60 |
|
D193 | Occupation/Entity | Alphanumeric | 60 |
|
D194 | Place of Birth/ | Alphanumeric | 60 |
|
D195 | Block Name | Alphanumeric | 60 |
|
D196 | Name | Alphanumeric | 60 | Includes D192,D191,D169 |