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?

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