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.

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?