Contact Fields

The following field information is intended assist those who design reports for Sage 50 using Crystal Reports.

Filename: CONTACTS.DAT

Contacts.DAT is the contact file. It contains a row (record) for each contact. Most of the information below is entered or displayed in Sage 50's Maintain Customers/Prospects> Contact tab.

To add Sage 50 contact fields to your Crystal reports, select CONTACTS.DAT.

Indexes and Their Uses

CONTACTS.DAT has 3 keys, as follows:

0 = ByContactRecordNum

1 = ByGuid

2 = ByCustRecordNumber

Fields

The following table shows the fields available in the CONTACTS.DAT file and includes the type and size in number of bytes of each field.

Field Name	Type	Size	Comment
RecordNumber	Integer	4	Identity value. Primary key for the table. This value is not visible on the Contacts tab.
Guid	Binary	16	(Globally Unique Identifier) Unique identifier for the contact. It is used for linking the contact to other tables. This value is not visible on the Contacts tab.
LastName	ZString	20	Contact's last name
FirstName	ZString	15	Contact's first name
MiddleInitial	ZString	1	Contact's middle initial (without the period)
Prefix	ZString	4	Contact's prefix designation (e.g. Ms., Mr.
Suffix	ZString	4	Contact's suffix (e.g. Jr.
Gender	Integer	2	0=unspecified 1=male 2=female
Title	ZString	30	The contact's job title.
CompanyName	ZString	39	The company name associated with the contact
Telephone1	ZString	20	The Telephone 1 value from the Contacts tab.
Telephone2	ZString	20	The Telephone 2 value from the Contacts tab.
Fax	ZString	20	The Fax number from the Contacts tab.
Email	ZString	64	The email address from the Contacts tab.
Notes	ZString	255	Any notes that were entered for the contact
AddressRecordNumber	Integer	4	A foreign key to the Address record assigned to this contact. This column matches up to the Address.AddressRecordNumber column.
CustomerRecord	Integer	4	A foreign key back to the Customer record. It associates a customer record with the contact. This column matches the Customer.CustomerRecordNumber column.
IsPrimaryContact	Integer	1	0 = false. This contact is not the primary or bill-to contact. 1 = true. This contact is the primary or bill-to contact. Note: Only one contact for each customer can be the primary or bill-to contact.
IsDefaultShipTo	Integer	1	0 = false. This contact is not the default ship-to contact. 1 = true. This contact is the default ship-to contact. Note: Only one contact for each customer can be the default ship-to contact.
NameToUseOnForms	Integer	2	0 = use the full contact name when a contact name is required. 1 = use the company name associated with the contact when a contact name is required.

What do you want to do next?

See a list of Crystal Reports data (.DAT) files