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