Available in Sage 50 Premium Accounting and higher.

Change Order Fields

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

Filename: CHGORDER.DAT

The CHGORDER.DAT file contains header information and the change order details for change orders for jobs that don't use phases. If the job on the change order uses phases, the details from the change order are in the CODETAILS.DAT file. Change Orders are entered in Maintain>Job Costs>Change Orders.

  • To add Sage 50 change order fields to your Crystal reports, select CHGORDER.DAT.

Indexes and Their Uses

ChgOrder.DAT has four indexes:

0 = By RecordNumber

1 = By GUID

2 = By JobRecordNumber, then by ChangeOrderID

3 = By JobRecordNumber, then by AppliedToJob, then by AppliedDateTime

Fields

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

Field Name

Type

Size

Comment

RecordNumber

Integer

The identity field for this table

ChangeOrderID

ZString

20

This identifies the change order. The same ID cannot be used more than once for the same job.

JobRecordNumber

Integer

This identifies the job record associated with the change order and is linked to the PROJECT.DAT file.

RequestDate

Date

The change order date

ChangeInSchedule

UtinyInt

Indicates that there is a change in schedule for the job

0=False

1=True

ProjectedEndDate

Date

The new projected end date for the job

ChangeNote

Zstring

2000

Notes for the change order

ChangeDescription

Zstring

250

Description for the changes when the job does not use phases

ChangeToEstExpenses

Float

Change to estimated expenses when the job does not use phases

ChangeToEstRevenues

Float

Change to estimated revenues when the job does not use phases

Approved

UtinyInt

Indicates that the change order has been approved

0=False

1=True

ApprovalDate

Date

The Approved Date for the change order

ApprovedBy

Zstring

30

Person who approved the change order

AppliedToJob

UtinyInt

Indicates that the job estimates have been updated by this change order

0=False

1=True

AppliedDateTime

UINT64

The UTC (Coordinated Universal Time also known as GMT-Greenwich Mean time) date and time when the job estimates were updated by this change order.

AppliedToTrx

UtinyInt

Indicates that the change order has been applied to a transaction.

0=False

1=True

IsInactive

UtinyInt

Do not use this field.

GUID

UBinary

GUID (Globally Unique Identifier) used for linking the Change Order table.

LastUpdateCounter

This increases incrementally when the record is changed.

What do you want to do next?