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. |