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 |