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?