Available in Sage 50 Premium Accounting and higher.
Change Order Details Fields
The following field information is intended to assist those who design reports for Sage 50 using Crystal Reports.
Filename: CODetail.DAT
The CODETAIL.DAT file contains the details from a change order for a job that uses phases. If the job does not use phases, the details from the change order are in the CHGORDER.DAT file. Change Orders are entered in Maintain>Job Costs>Change Orders.
- To add Sage 50 change order detail fields to your Crystal reports, select CODETAIL.DAT.
Indexes and Their Uses
ChgOrder.DAT has three indexes:
0 = By RecordNumber
1 = By GUID
2 = By CORecordNumber, then by PhaseRecordNumber, then by CostRecordNumber
Fields
The following table shows the fields available in the CODETAIL.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. |
|
CORecordNumber |
Integer |
This identifies the change order associated with the details and is linked to the CHGORDER.DAT file. |
|
PhaseRecordNumber |
Integer |
This identifies the phase record associated with the change order details and is linked to the PHASE.DAT file. |
|
CostRecordNumber |
Integer |
This identifies the cost code record associated with the change order details (if there is one) and is linked to the COST.DAT file. |
|
ChangeDescription |
Zstring |
250 |
Description for the changes for this job phase/cost code |
ChangeToUnits |
Float |
Change to the estimated number of units for this job phase/cost code |
|
ChangeToEstExpenses |
Float |
Change to the estimated expenses for this job phase/cost code |
|
ChangeToEstRevenues |
Float |
Change to the estimated revenues for this job phase/cost code |
|
GUID |
UBinary |
GUID (Globally Unique Identifier) used for linking the Change Order Details table. |
|
LastUpdateCounter |
This increases incrementally when the record is changed. |