Earnings Summary Payroll Fields

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

Filename: ESPRFLD.DAT

ESPRFLD.DAT is the earnings summary payroll field file. It contains the earnings for a payroll field by quarter. This information is useful for generating W2s and quarterly payroll tax return information.

To add Sage 50 employee fields to your Crystal reports, select ESPRFLD.DAT.

Indexes and their uses

The ESPRFLD.DAT file has one key, as follows:

0 = ByEarnSummGUIDFieldNumber – Used to retrieve the quarterly payroll field information for an employee sorted by field number

Field Name	Type	Comment
LastUpdateCounter	Integer	This is a counter that increases incrementally each time a record is modified.
EarningSummaryGUID	Ubinary	The quarter this payroll field summary record is associated with
FieldNumber	Integer	Identifies the payroll field 1-40 = Employee fields 41-80 = Company fields
Amount	Decimal	The quarterly summary amount for the payroll field