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.

What do you want to do next?