Available in Sage 50 Premium Accounting and higher.

Time and Expense Ticket Fields

The following field information is intended to assist those who design reports for Sage 50 using Crystal Reports.

Filename: TICKET.DAT

The TICKET.DAT file contains default information about the your company's use of time and expense tickets.

To add Sage 50 time/expense ticket fields to your Crystal reports, select TICKET.DAT.

Indexes and Their Uses

TICKET.DAT has 16 keys, as follows:

0 = By Ticket Type, Ticket Date, and then Ticket Number

1 = By Ticket Type, Period, and then Ticket Number

2 = By Ticket Type, Period, Employee, and then Record Number

3 = By Ticket Type and then Ticket Number

4 = By Ticket Type and then Employee Record Number

5 = By Ticket Number

6 = By Ticket Type, EmpVendSel, Employee Record Number, and then Date

7 = By Used in Sales

8 = By Item ID

9 = By Ticket Type

10 = By Ticket Date

11 = By Employee Record Number

12 = By CustJobAdmSel and then by CustJobNum

13 = By Phase Number

14 = By Cost Number

15 = By GUID

Fields

The following table shows the fields available in the TICKET.DAT file and includes the type and size in number of bytes of each field.

Field Name

Type

Size

Comment

TicketNumber

ZString

20

Time ticket number.

Period

UBinary

This is an internal Sage 50 field that designates the number of the period.

TicketType

UBinary

Type of ticket. Valid values are:

0=Time

1=Expense

TicketDate

Date

Date the time/expense ticket was entered.

EmpVendSel

Integer

Designates whether the ticket is for an employee or vendor. Valid values are:

0=Employee

1=Vendor

EmpVendRecordNumber

Integer

Record number of the employee or vendor tracked by the ticket.

ActLineItemIdent

Integer

Designates whether this is an activity or charge item. Valid values are:

Time=Activity Item

Exp=Charge Item

CustJobAdmSel

Integer

Designates whether this ticket covers customer, job, or administrative costs. Valid values are:

1=Customer

2=Job

3=Administrative

CustomerRecordNumber

Integer

Customer record number (if CustJobAdmSel = 1).

ProjectRecordNumber

Integer

Job ID (if CustJobAdmSel = 2).

PhaseRecordNumber

Integer

Job phase ID (if CustJobAdmSel = 2).

CostRecordNumber

Integer

Cost code ID (if CustJobAdmSel = 2).

GUID

UBinary

GUID (Globally Unique Identifier) used for linking Time and Expense Tickets table.

PayLevel

Integer

Pay level name taken from the employee record.

TimedDuration

Integer

1

Setting of the Timed Duration option in Time Tickets.

1 (True) > Clock Entry

0 (False) > Manual Entry

Start_Hour

Integer

Start time (in hours).

Start_Minute

Integer

Start time (in minutes).

Start_Second

Integer

Start time (in seconds).

Start_AMPM

Integer

Start time, either AM or PM.

Valid values are:

1=AM

2=PM

End_Hour

Integer

End time (in hours).

End_Minute

Integer

End time (in minutes).

End_Second

Integer

End time (in seconds).

End_AMPM

Integer

End time, either AM or PM.

Valid values are:

1=AM

2=PM

Break_Duration_Hrs

Integer

Break time (in hours).

Break_Duration_Mins

Integer

Break time (in minutes).

Break_Duration_Secs

Integer

Break time (in seconds).

Duration_Hours

Integer

Total activity time (in hours).

Duration_Minutes

Integer

Total activity time (in minutes).

Duration_Seconds

Integer

Total activity time (in seconds).

DurationUnitQty

Float

Unit duration (hours.minutes) of the time ticket.

BillType

Integer

Billing type for the activity. Valid values are:

1=Employee

2=Activity Rate

3=Override Rate

4= Flat Fee

BillRateUnitPrice

Float

Billing rate corresponding to the chosen billing type.

BillStatus

Integer

Whether or not the activity is billable in current state. Valid values are:

1=Billable

2=Non-Billable

3=No Charge

4=Hold

BillAmount

Float

Total billable amount for applying ticket/expense to invoice.

CharMemo

ZString

253

Internal memo about the expense.

EmpReimbrsable

Integer

1

Setting of the Reimbursable to Employee check box.

1 (True) > Reimbursable

2 (False) > Not Reimbursable

AlreadyUsedInPayroll

Integer

1

Indicates whether ticket has been applied to employee paychecks.

1 (True) > Applied in Payroll

0 (False) > Not Applied.

AlreadyUsedInSales

Integer

Indicates whether ticket has been applied to invoice in Apply Tickets/Reimbursable Expenses.

0 = Not Applied; any other number indicates the PostOrder of the journal entry (the transaction number) in the applicable journal.

InternalMemo

ZString

160

Description for internal memo attached to ticket.

LastUpdateCounter

Integer

This increases incrementally when the record is changed.

What do you want to do next?