Job Fields

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

Filename: PROJECT.DAT

PROJECT.DAT is the jobs file. It has a record for every job. Most of the information below is entered or displayed in Sage 50's Maintain Jobs window.

  • To add Sage 50 job fields to your Crystal reports, select PROJECT.DAT.

Indexes and Their Uses

PROJECT.DAT has 15 keys, as follows:

0 = By JobID. You should use this index mostly for running reports sorted by JobID. It cannot be used to link to other tables.

1 = By JobRecordNumber. Use this index to link to other tables.

2 = By CustomerRecordNumber

3 = By Description

4 = By Inactive/Active and then by JobID

5 = By GUID

6 = By Inactive and then by Description

7 = By Type

8 = By Inactive and then by Type

9 = By Description

10 = By CustomField1

11 = By CustomField2

12 = By CustomField3

13 = By CustomField4

14 = By CustomField5

Fields

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

Field Name

Type

Size

Comment

JobID

ZString

20

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

JobRecordNumber

Integer

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.

JobDescription

ZString

30

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

StartDate

Date

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

EndDate

Date

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

ProjectedEndDate

Date

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

CustomerRecordNumber

Integer

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.

Note

ZString

2000

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

JobIsInactive

Logical

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.

JobType

String

8

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

Supervisor

String

30

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

PercentComplete

Float

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

HasPhases

Logical

1

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)

PONumber

ZString

20

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.

CustomField0

ZString

40

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.

CustomField1

ZString

40

Data entered in second job custom field.

CustomField2

ZString

40

Data entered in third job custom field.

CustomField3

ZString

40

Data entered in fourth job custom field.

CustomField4

ZString

40

Data entered in fifth job custom field.

JobGUID

Binary

16

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

RetainagePercent

Float

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

ProjectUnused1

ZString

39

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

Address Line 1

Zstring

30

Job site address line 1

Address Line 2

Zstring

30

Job site address line 2

City

Zstring

20

Job site city

State

Zstring

2

Two letter abbreviation for job site state

Zip

Zstring

12

Zip code of job site address

Country

Zstring

15

Country of job site

Billing Method

UBinary

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

Labor Burden Percent

Float

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

ChangeOrdersApplied

Logical

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

OriginalRevenue

Decimal

The original estimated revenues amount for the job

OriginalExpense

Decimal

The original estimated expenses amount for the job

StatusGUID

GUID

GUID (Globally Unique Identifier) used for linking Jobs table to the Tracking Status Codes table.

LastUpdateCounter

Integer

This increases incrementally when the job record is changed.

What do you want to do next?

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