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