Address Fields

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

Filename: ADDRESS.DAT

The ADDRESS.DAT file holds address records. Addresses have been moved from the vendor and customer records to this file. Use the pairs CustomerRecordNumber/AddressTypeNumber and VendorRecordNumber/AddressTypeNumber to uniquely identify address records belonging to specific customers and vendors respectively.

To add Sage 50 address fields to your Crystal reports, select ADDRESS.DAT.

Indexes and Their Uses

The ADDRESS.DAT file has the following indexes:

0 = By address record number

1 = By vendor record number, then by slot number

2 = By customer record number, then by slot number

3 = By slot number, then by ZIP code

4 = By GUID

5 = By vendor record number, customer record number, and then by slot number.

Fields

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

Field Name	Type	Size	Comment
AddressRecordNumber	UBinary		Unique key for each address record.
CustomerRecordNumber	UBinary		0 if this record is for a vendor.
VendorRecordNumber	UBinary		0 if this record is for a customer.
AddressTypeNumber	UBinary		This is the "slot" number.
AddressTypeDesc	ZString	20	Usually the name of the record ("Ship To 1", for example).
Name	ZString	39
AddressLine1	ZString	30
AddressLine2	ZString	30
City	ZString	20
State	ZString	2
ZIP	ZString	12
Country	ZString	15
GUID	UBinary
TaxCode	ZString	8	If the address is a customer's, this is the sales tax code assigned to the address in Maintain Customers. Otherwise, field will be blank.
LastUpdateCounter	UBinary		This field helps to detect when the in-memory record is out of sync with the rest of the table.

What do you want to do next?

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