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