Available in Sage 50 Premium Accounting and higher.

Job Phases Fields

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

Filename: PHASE.DAT

The PHASE.DAT file contains job phases. Most of this information is entered or displayed in Sage 50's Maintain Phases window.

To add Sage 50 cost code fields to your Crystal reports, select PHASE.DAT.

Indexes and Their Uses

PHASE.DAT has seven indexes, as follows:

0 = By PhaseID. This field is unique; it cannot change. Use this key when sorting reports by PhaseID. Do not use this key to link phases to other tables.

1 = By PhaseRecordNumber. Use this key to link phases to other tables.

2 = By Description.

3 = By Inactive and then by PhaseID.

4 = By Inactive and then by Description.

5 = By Description with case.

6 = By GUID

Fields

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

Field Name	Type	Size	Comment
PhaseID	ZString	20	Phase ID entered in the Maintain Phases window.
PhaseRecordNumber	Integer	4	This (internal) phase field is used for linking purposes to other Sage 50 data files. For more information, see Indexes and Their Uses above.
PhaseDescription	ZString	30	Phase description entered in the Maintain Phases window.
CostType	ZString	20	Phase cost type selected in the Maintain Phases window. Valid entries are blank, Labor, Materials, Equipment, Subcontractor, and Other. If HasCostCodes = Yes, then this field is disabled (not available).
HasCostCodes	Integer	1	The Use Cost Codes check box in the Maintain Phases window. Valid choices include: 1 (True) = if the phase uses cost codes. 0 (False) = if the phase does not use cost codes.
PhaseIsInactive	Integer	1	The Inactive check box in the Maintain Phases window. Valid choices include: 1) True = if the phase record is inactive. False = if the phase record is active.
GUID	UBinary		GUID (Globally Unique Identifier) used for linking the Job Phases table.
LastUpdateCounter	Integer		This increases incrementally when the record is changed.

What do you want to do next?

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