Client Note Fields

Accountants Enterprise only

These fields are found in the file DS6CN100 and are used for text letter writing.

Field	Name	Type	Length	Description
H101	Code	Alphanumeric	10
H102	Contact/Employee	Alphanumeric	1	C=Contact, E=Employee
H103	Note code	Alphanumeric	20
H110	Last update	Date
H111	Last update time	Numeric	8
H112	Last update	Alphanumeric	10
H113	Date added	Date
H114	Added by	Alphanumeric	10
H191	Text	Text	40

Control Record Fields

Accountants Enterprise only

These Control Record fields are used for text letter writing in CDS.

Field	Name	Type	Len	Description
D409	Number of prospects	Numeric	12
D410	Number of clients	Numeric	12
D411	Number of creditors	Numeric	12
D412	Number of both	Numeric	12
D413	Number of other	Numeric	12
D416	Client Count	Numeric	12
D417	Employee Count	Numeric	12
D420	Country Code	Alphanumeric	2
D421	Keep modify audit?	Alphanumeric	1
D422	Maintain	Alphanumeric	1
D423	Use alternate code?	Alphanumeric	1
D429	Labels	Alphanumeric	10	Default Labels layout
D430	Reports	Alphanumeric	10	Default Reports layout
D431	Letters	Alphanumeric	10	Default Letters layout
D437	PMA Ledger	Alphanumeric	8	PMA Ledger Code
D438	Tax Ledger	Alphanumeric	8	Tax Ledger Code
D480	Telephone	Alphanumeric	20
D481	Default Address	Alphanumeric	60	Default address for reports
D491	Ledger Name	Alphanumeric	60
D492	Ledger Address 1	Alphanumeric	60
D493	Ledger Address 2	Alphanumeric	60
D494	Ledger Address 3	Alphanumeric	60
D495	Ledger Address 4	Alphanumeric	60
D496	A.C.N.	Alphanumeric	10

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 Entity - Other Details	Alphanumeric	30
D191	Given Names Entity - Name 1	Alphanumeric	60
D192	Surname Entity - Name 2	Alphanumeric	60
D193	Occupation/Entity Trade Name 1	Alphanumeric	60
D194	Place of Birth/ Entity - Trade Name 2	Alphanumeric	60
D195	Block Name	Alphanumeric	60
D196	Name	Alphanumeric	60	Includes D192,D191,D169

Sort Sequence Fields

Accountants Enterprise only

These Sort Sequence fields are used for text letter writing in CDS.

Field	Name	Type	Len
D501	Code	Alphanumeric	10
D502	Status	Alpha	1
D503	Type	Alpha	10
D504	Value	Alphanumeric	10
D690	Description	Alphanumeric	60

Table Data Fields

Accountants Enterprise only

These Table Data fields are used for text letter writing in CDS.

Field	Name	Type	Len	Description
D301	Table Type	Alpha	2	Ap - Relation, Ad - Address, Na - Name, Nu - Number
D309	Number Referenced	Numeric	5	No. of clients using this data
D320	Last Update	Date
D321	Last Update Time	numeric	8
D322	Last Update By	Alphanumeric	10
D390	Addr/Name/Number 1	Alphanumeric	60	Line 1
D391	Addr/Name/Number 2	Alphanumeric	60	Line 2
D392	Addr/Name/Number 3	Alphanumeric	60	Line 3
D393	Addr/Name/Number 4	Alphanumeric	60	Line 4