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