Time Ticket Register Fields (Import/Export)

Employee/

Vendor

Y

Y

Numeric (Whole) - Ticket recorded by. Valid numbers are 0 through 1, where 0=Employee and 1=Vendor.

If blank, import will assume value is 0 (Employee).

Recorded by ID

Y

Y

Alphanumeric - If Employee/Vendor=0, must be a valid employee ID. If Employee /Vendor=1, must be a valid vendor ID.

See Tips.

Ticket Number

Y

Y

Alphanumeric - Cannot be blank and must be unique.

See Tips.

Ticket Date

Y

Y

Date - Date of the transaction. Must be in ##/##/## (month/day/yr) format. Date must be in either the last closed fiscal year or the two currently open fiscal years.

Has been used in Sales/Invoicing

Y

Y

Boolean - TRUE if used in Sales/Invoicing, FALSE if unused in Sales/Invoicing.

Invoice Number Used

Y

N

Alphanumeric - Required if "Has been used in Sales/Invoicing"=TRUE. The number is based on the sales invoice number that uses this ticket. During import, if the sales invoice number referenced here does not exist in the Sage 50 Sales Journal, if the ticket is for a customer and does not match the customer on the sales invoice referenced, or if the ticket is for a job and the ticket job ID, phase, or cost code does not match the customer on the referenced sales invoice, an error will be issued. To avoid these errors, you must import the sales journal prior to ticket data.

If the ticket has not been assigned to an invoice, this field is blank.

Activity Item ID

Y

Y

Alphanumeric - must be a valid inventory item set up with Item Class=6 (activity item).

Customer/Job/

Adm

Y

Y

Numeric (Whole) - Ticket completed for. Valid numbers are 1 through 3, where 1=Customer, 2=Job, and 3=Administrative.

Completed For ID

Y

Y

Alphanumeric - If Customer/Job/Adm=1 (Customer), then must be a valid customer ID. If Customer/Job/Adm=2 (Job), then must be a valid job ID. If Customer/Job/Adm=3 (Administrative), field will be ignored.

This field is required if Customer/Job/Adm=1 or 2.

When importing any combination of jobs, phases, or cost codes, you must separate the items with commas and enclose the entire string with quotes. For example: "jobid,phase,costcode".

Pay Level

Y

N

Numeric (Whole) – Required if Employee/Vendor=0 (employee). This field represents the employee hourly or salary pay level (1-20) to associate with ticket. The pay level referenced must have a defined rate or the import will produce an error.

If the Employee/Vendor=1 (vendor), then the field must be blank.

Has been used in Payroll

Y

Y

Boolean - TRUE if time ticket used in payroll for employee set up with Hourly-Time Ticket Hours pay method. FALSE if not used in payroll.

Manual/Timed Option

Y

Y

Numeric (Whole) Manual time entry or Timed Duration options. Valid numbers are 0 and 1, where 0=Manual Timed Entry, and 1=Timed Duration.

Start Time

Y

N

Time - Starting manual time in HH:MM AM or PM format (i.e., 08:45 AM). This field is required if Manual/Timed Option=0 (Manual Time Entry). If Manual/Timed Option=1 (Timed Duration), this field is ignored.

End Time

Y

N

Time - Ending manual time in HH:MM AM or PM format (i.e., 08:45 AM). This field is required if Manual/Timed Option=0 (Manual Time Entry). If Manual/Timed Option=1 (Timed Duration), this field is ignored.

Break

Y

N

Time - Break during manual time duration in HH:MM format (i.e., 01:45). This field is not required if Manual/Timed Option=0 (Manual Time Entry). If Manual/Timed Option=1 (Timed Duration), this field is ignored.

Duration

Y

N

Time - Duration time in HH:MM format (i.e., 08:45). If Manual/Timed Option=1 (Timed Duration), this field must contain a value in the HH:MM format up to 23:59.

If Manual/Timed Option=0 (Manual Time Entry), then this field is ignored. The import will calculate the value based on Start Time, End Time, and Break.

Ticket Description for Invoicing

Y

N

Alphanumeric - Description for time ticket that could potentially be used as a line item description when applied to a sales invoice. Avoid using double quotes in description text.

Internal Memo

Y

N

Alphanumeric – Internal note for time ticket. Carriage returns and line feeds will be removed. Avoid using double quotes in memo text.

Billing Type

Y

Y

Numeric (Whole) - Billing Type for ticket. This is a required field. Valid numbers are 1 through 4, where 1=Employee Rate, 2=Activty Rate, 3=Override Rate, and 4=Flat Rate. If Employee/Vendor=1 (vendor), then Billing Type cannot be 1 (Employee Rate).

Billing Rate

Y

N

Numeric (Real) - Rate used to calculate billing amount based on duration. This field is required if Billing Type=1, 2, or 3. Values can be 0.00 to 999999999.99.

If Billing Type=4 (Flat Rate), then this field must be blank.

Billing Status

Y

Y

Numeric (Whole) - Billing status of time ticket. Valid numbers are 1 through 4, where 1=Billable, 2=Non-billable, 3=No Charge, and 4=Hold. If Has been used in Sales/Invoicing is true, then only 1=Billable and 3=No Charge are accepted. If Has been used in Sales/Invoicing is false, then values 1, 2, 3, and4 are accepted.

Unit Duration

N

N

Numeric (Real) – This is calculated by Sage 50 as the duration converted to decimal format. During import, this field will be ignored. Sage 50 will convert and add the field based on the imported Duration time.