Job Fields

Job ID entered in Maintain Jobs window. This field is unique in the table and never changes.

This (internal) job field is used for linking purposes to other Sage 50 data tables. For more information, see Indexes and Their Uses above.

This field is unique in the table and never changes.

The description of the job entered in the Maintain Jobs window.

The start date entered for the job on the General tab of the Maintain Jobs window.

The end date entered for the job on the General tab of the Maintain Jobs window.

The projected end date entered for the job on the General tab of the Maintain Jobs window.

This identifies the customer ID selected in the "For Customer" field on the General tab of the Maintain Jobs window. This field is the link to the CUSTOMER.DAT file.

Internal note entered for this job. Notes are entered by clicking the Note toolbar button in the Maintain Jobs window.

The Inactive check box in the Maintain Jobs window. Valid choices include:

True = if the job record is inactive.

False = if the job record is active.

Job type entered on the General tab of the Maintain Jobs window.

Job supervisor on the General tab of the Maintain Jobs window.

Percentage complete entered on the General tab of the Maintain Jobs window.

True => if the job uses phases.

This flag is used to control the operation of the jobs Look-up control, in addition to being reported on. (Sage 50 Premium Accounting and higher)

Purchase order number associated with this job and entered on the General tab of the Maintain Jobs window. This field is not actually linked to purchase orders; it is simply a text field for your records.

Data entered in first job custom field.

About Job Custom Fields: Custom field data is entered on the Custom Fields tab of the Maintain Jobs window. Labels for job custom fields are set up on the Custom Fields tab of the Job Defaults window.

Note: To get the custom field names, you must use a custom formula. Tell me more about this.

Data entered in second job custom field.

Data entered in third job custom field.

Data entered in fourth job custom field.

Data entered in fifth job custom field.

GUID (Globally Unique Identifier) used as a linking field for the Projects (Jobs) table.

Retainage percent field from the job file. (Sage 50 Quantum Accounting)

Do not select or use this field. It is used by Sage 50 for internal reasons.

Job site address line 1

Job site address line 2

Job site city

Two letter abbreviation for job site state

Zip code of job site address

Country of job site

Billing Method of the job (Sage 50 Quantum Accounting).

Labor burden percent field from the job file (Sage 50 Quantum Accounting).

Indicates whether change orders have been applied to the job

True=change orders have been applied the job

False=no change orders have been applied to the job

The original estimated revenues amount for the job

The original estimated expenses amount for the job