Earnings Summary Wage Fields

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

Filename: ESWAGE.DAT

ESWAGE.DAT is the earnings summary wage file. It contains the hours and pay for a defined pay type for the 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 ESWAGE.DAT.

Indexes and their uses

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

0 = ByEarnSummWage_EarnSummGUIDRateNum – Used to retrieve the quarterly pay type information for an employee sorted by rate 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 summary wage record is associated with
RateNumber	Integer	Identifies the pay type
Hours	Decimal	The quarterly summary hours for the pay type
Pay	Decimal	The quarterly summary payfor the pay type