Job Estimates Fields

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

Filename: JOBEST.DAT

The JOBEST.DAT file contains job estimates. There is at most one record for any JobPhaseCostCode combination. Job estimates are entered in Sage 50's Maintain Jobs window.

To add Sage 50 job estimate fields to your Crystal reports, select JOBEST.DAT.

Indexes and Their Uses

JobEst.DAT has two indexes:

0 = ByJobPhaseCostCode

1 = By GUID

Fields

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

Field Name	Type	Comment
JobRecordNumber	Integer	This identifies the job record associated with the estimate and is linked to the PROJECT.DAT file.
PhaseRecordNumber	Integer	This identifies the phase record associated with the estimate (if there is one) and is linked to the PHASE.DAT file. (Sage 50 Premium Accounting and higher)
CostRecordNumber	Integer	This identifies the cost code record associated with the estimate (if there is one) and is linked to the COST.DAT file. (Sage 50 Premium Accounting and higher)
GUID	UBinary	GUID (Globally Unique Identifier) used for linking the Job Estimates table.
Units	Float	The number of phase or cost code units to apply to the job estimate. This field is only relevant if the job record uses phases or cost codes. (Sage 50 Premium Accounting and higher)
EstRevenue	Float	Total estimated revenue amount entered for this job record.
EstExpenses	Float	Total estimated expense amount entered for this job record.
LastUpdateCounter		This increases incrementally when the record is changed.

What do you want to do next?

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