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

Size

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?