This data object is used to display all completed technician time records.

This information can be found in the Technician Time Search and the Time Entry Search applications in the Fusion business system.

URL

/frw/TechnicianTime

Field Details…

SQL Field Name Column Description
AddApplication This field displays the name of the application in Fusion that the given technician time record was created from.
AddApplicationNumber This field displays the identifying code of the application in Fusion that the given technician time record was created from.
AddDate This field displays the date on which the given technician time record was created in Fusion.
AddUser This field displays the username of the user that created the given technician time record in Fusion.
BarcodeDateIn This field displays the punch in date for the given technician time transaction.
BarcodeDateOut This field displays the punch out date for the given technician time transaction.
BarcodeTimeIn This field displays the punch in time for the given technician time transaction.
BarcodeTimeOut This field displays the punch out time for the given technician time transaction.
IsBase This field displays whether the given technician time transaction occurred at the base location and during the base shift for the given technician.
OT_BillCustomer This field displays whether the customer will be billed at an overtime rate for any overtime hours that occurred in the given technician time transaction.
TotalHours This field displays the total hours for the given billable time transaction.
IsBillingAdjustment This field displays whether the given time transaction is a billing adjustment.
BillingCompanyName This field displays the company name of the billing customer associated with the repair order on the given time transaction.
BillingCustomer This field displays the customer number of the billing customer associated with the repair order on the given time transaction.
BillingHours This field displays the billing hours for the task that the given technician time record is associated with.
BranchCode This field displays the branch in which the given time transaction occurred.
CombinedTotalHours This field displays the total hours for the given time transaction, whether it is billable or nonbillable.
IsCompleted This field displays whether the given time transaction has been completed.
Cost This field displays the unit cost of the given time transaction.
Department This field displays the department in which the given time transaction occurred.
IsEnterLaborInTotalHours This field displays whether the given time transaction was entered as total hours, rather than using the punch in/out fields.
ExtendedCost This field displays the total cost of the given time transaction.
ExtendedPrice This field displays the total price of the given time transaction.
HoursBilled This field displays the number of hours billed for the given time transaction.
HoursWorked This field displays the number of hours that were actively worked for the given time transaction.
IsInOutTime This field displays whether the given time transaction was entered using the punch in/out fields, rather than as total hours.
InvoiceNumber This field displays the invoice number of the repair order that the given time transaction is associated with.
Invoiced This field displays whether the repair order that the given time transaction is associated with has been invoiced.
LaborQuote This field displays the labor quote assigned to the task that the given time transaction is associated with.
LaborRate This field displays the hourly rate associated with the given time transaction.
LaborRateCode This field displays the identifying code for the labor rate associated with the given time transaction.
LastUpdate This field displays the date on which the given technician time record was last updated in Fusion.
UpdateUser This field displays the username of the user that last updated the given technician time record in Fusion.
IsManuallyUpdated This field displays whether the given time transaction has been updated outside of Barcode Time Transactions.
IsNonBillable This field displays whether the given time transaction is nonbillable.
NBExtendedCost This field displays the total cost of the nonbillable hours in the given time transaction.
NBOT_TotalCost This field displays the total cost of the nonbillable overtime hours in the given time transaction.
NBOT_TotalHours This field displays the number of nonbillable hours that are considered overtime in the given time transaction.
NBTotalHours This field displays the total hours for the given nonbillable time transaction.
OriginalRepairOrder This field displays the repair order number of the repair order that the given repair order was spun off from.
OTBillingTotal This field displays the total price of the overtime hours in the given time transaction.
OT_Cost This field displays the cost of the hours in the given time transaction that are considered overtime.
OT_RateMultLevelParamNum This field displays the cost level for the hours in the given time transaction that are considered overtime.
OTHourlyRate This field displays the price per hour for the overtime hours in the given time transaction.
OT_RateLevelParamNum This field displays the rate level for the overtime hours in the given time transaction.
OT_RateMultiplier This field displays the rate multiplier for the hours in the given time transaction that are considered overtime.
OT_TotalHours This field displays the total number of hours in the given time transaction that are considered overtime.
OwningCompanyName This field displays the company name of the owning customer associated with the repair order on the given time transaction.
OwningCustomer This field displays the customer number of the owning customer associated with the repair order on the given time transaction.
IsPayrollProcessed This field displays whether the given time transaction has been processed through payroll.
IsPolicyAdjustmentTransaction This field displays whether the given time transaction is a policy adjustment.
Price This field displays the unit price of the given time transaction.
RepairGroup This field displays the repair group that the given time transaction and repair task are associated with.
RepairGroupDescription This field displays the description of the repair group that the given time transaction and repair task are associated with.
RepairOrderNumber This field displays repair order number that the given time transaction is associated with.
RepairOrderStatus This field displays the status of the repair order that the given time transaction is associated with.
RepairTaskStatus This field displays the status of the repair task that the given time transaction is associated with.
RepairType This field displays the repair type of the task that the given time transaction is associated with.
RepairTypeDescription This field displays the description of the repair type of the task that the given time transaction is associated with.
IsSecondaryRO This field displays whether the given time transaction is associated with a secondary repair order.
Shift This field displays the shift during which the given time transaction occurred.
IsSubmittedforPayroll This field displays whether the given time transaction has been submitted to payroll.
TaskNumber This field displays the task number on the repair order that the given time transaction is associated with.
TechnicianFirstName This field displays the first name of the technician for the given time transaction.
TechnicianLastName This field displays the last name of the technician for the given time transaction.
TechnicianName This field displays the full name of the technician for the given time transaction.
TechnicianNumber This field displays the technician number of the technician for the given time transaction.
TotalHoursLessBillingAdjustments This field displays the total hours, without counting billing adjustments, for the given billable time transaction.
TotalOTCost This field displays the total cost of the overtime hours in the given time transaction.
UpdateApplication This field displays the name of the application in Fusion that the given technician time record was last updated from.
UpdateApplicationNumber This field displays the identifying code of the application in Fusion that the given technician time record was last updated from.
UseBookHours This field displays whether the given task is indicated to be billed based on book hours, rather than billing hours.
IsWarrantyTransaction This field displays whether the task that the given time transaction is associated with is a warranty transaction.