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