Available in Sage 50 Quantum Accounting.
Work Ticket Fields
The following field information is intended to assist those who design reports for Sage 50 using Crystal Reports.
Filename: WORKTKT.DAT
WORKTKT.DAT is the Work Tickets file. The information below is entered or displayed in the Work Tickets window, which tracks the progress and completion of assembly item builds. Each row represents an entire work ticket, including component information for all 300 possible components.
- To add Sage 50 Work Ticket fields to your Crystal reports, select WORKTKT.DAT.
Indexes and their uses
WORKTKT.DAT has ten indexes, as follows:
0 = Ordered by Work Ticket Primary Key (i.e., RecordNumber).
1 = Ordered by the user-assigned Reference number assigned to ticket.
2 = Ordered by Transaction Date, then user-assigned reference number, then by Primary Key of the assembly item being built.
3 = Ordered by reference number, then transaction date, then by Primary Key of the assembly item being built.
4 = Ordered by Primary Key of the assembly item being built
5 = Ordered by Primary Key of journal header entry that the ticket creates when closed.
6 = Ordered by Primary Key of the supervisor.
7 = Ordered by "closed" status, then transaction Date.
8 = Ordered by Transaction Date and then by Record Number.
9 = Ordered by GUID.
Fields
The following table shows the fields available in the WORKTKT.DAT file and includes the type and size in number of bytes of each field.
Field Name |
Type |
Size |
Comment |
---|---|---|---|
ItemRecordNumber |
Integer |
Item ID of the Assembly |
|
AssemblyRevNo |
Integer |
The revision of the Assembly being built on this ticket |
|
WorkTktInternalUse1 |
Integer |
Do not select or use this field. It is used by Sage 50 for internal reasons. |
|
Date |
Date |
The transaction date |
|
Number |
ZString |
20 |
Work Ticket number entered in the Work Ticket No. field in the Work Tickets window |
RecordNumber |
AutoIncrement |
Unique primary key; it will not change. |
|
QtyToBuild |
Float |
Number of this item you plan to build as entered in the Qty to Build field on the Work Tickets window. |
|
EmpRecordNumber |
Integer |
Employee ID of the supervisor of this work ticket |
|
Closed |
Integer |
The Close Ticket check box on the Work Tickets window |
|
DateNeededBy |
Date |
Date items on the work ticket are needed |
|
DateStarted |
Date |
Date work began on the work ticket |
|
TotalEstHours |
Float |
Number of hours estimated to complete the work ticket |
|
DateComplete |
Date |
Date work ticket was finished |
|
Note |
ZString |
250 |
The note attached to the work ticket. |
GUID |
UBinary |
GUID (Globally Unique Identifier) used for linking Work Tickets table. |
|
PostOrder |
Integer |
Foreign key into the JRNLHDR table. Links to the journal entry recording the completion of the assemblies. |
|
NoOfComponents |
Integer |
The number of component rows on this work ticket. |
|
WorkTktInternalUse2 WorkTktInternalUse3 |
Integer |
Do not select or use this field. It is used by Sage 50 for internal reasons. |
|
Comp#RecordNumber Where # = (1-300) |
Integer |
Foreign key into the LINEITEM table. Only rows where # is less than equal to NoOfComponents are used. |
|
Comp#QtyReq Where # is = (1-300) |
Float |
The number of this row’s components that are required to complete this ticket. Only rows where # is less than equal to NoOfComponents are used. |
|
Comp#ActHrs Where # is = (1-300) |
Float |
The number of hours that have been worked on this component to date. Only rows where # is less than equal to NoOfComponents are used. |
|
Comp#Finished Where # is = (1-300) |
Integer |
The Finished check box for each component. Only rows where # is less than equal to NoOfComponents are used. |
|
Comp#POCreated |
Integer |
This work ticket has already generated a purchase order. |
|
LastUpdateCounter |
Integer |
This increases incrementally when the record is changed. |