This data object is used to show all repair order task information.

This information can be found in the Repair Order program within the Fusion business system.

URL

/frw/RepairOrderTask

Field Details…

SQL Field Name Column Description
AlternateBillingCompanyName This field displays the company name of the alternate billing customer assigned to the task if one exists.
AlternateBillingCustomer This field displays the alternate billing customer assigned to the task if one exists.
BillToCompanyName This field displays the company name of the Bill To Customer the repair order was opened under.
BillToCustomer This field displays the customer number of the Bill To Customer the repair order was opened under.
Branch This field displays the branch associated with the repair order.
IsTaskAComebackRepair This field displays whether or not a task is a comeback repair
Department This field displays the department associated with a Repair Order.
Division This field displays the company division the Repair order associated with the given task was opened under.
InvoiceDate This field displays the date on which the invoice was created.
InvoiceNumber This field displays the invoice number the given task was invoiced on.
TaskLastUpdateUser This field displays the User who last updated the RO Task for the specific instance of the RO.
OwningCompanyName This field displays the company name of the Owning Customer the repair order was opened under.
OwningCustomer This field displays the customer number of the Owning customer the repair order was opened under.
RONumber This field displays the Repair order number the given task is associated with.
TaskAddDate This field displays the Add Date of the RO Task for the specific instance of the RO.
TaskAddUser This field displays the User who added the RO Task for the specific instance of the RO.
TaskAdjustmentTime This field displays the total amount of hours on the task flagged as a billing adjustment.
TaskAlwaysPayBillingHours This field indicates whether or not the technicians who worked on the task will always be paid the billing hours worked on the given task.
TaskBillingHours This field displays the number of hours that will be billed to a customer for a particular task.
TaskBookHours This field displays the estimated amount of time it will take to perform a task.
TaskCallBackDays This field displays the number of days allowed for comeback that has been assigned to the given Repair Order Task.
TaskCauseComment This field displays the cause comment entered for the given task.
IsTaskClockedON This field displays whether or not a technician is clocked on the given task.
TaskClockedOnTechnicians This field displays the names and associated numbers of any technicians currently clocked on to a repair order task.
TaskComebackReason This field displays the reason that a task was flagged for comeback.
TaskComplaintComment This field displays the complaint comment entered for the given task.
IsTaskCompleted This field displays whether or not a task is completed.
TaskCloseDate This field displays the date on which the given task was completed.
TaskCorrectionComment This field displays the correction comment entered for the given task.
TaskDefaultLaborRate This field displays the original labor rate to be charged on a given repair order task.
TaskDepartment This field displays the department associated with a repair order task.
TaskEffectiveLaborRate This field displays the given tasks effective labor rate (Task total labor divided by hours worked).
TaskEHCCharge This field displays the total amount of EHC charges that have been added to the given task.
TaskHoursBilled This field displays the total hours billed for the given Task.
TaskHoursWorked This field displays the total number of hours worked on any one task (Note if three technicians worked on one task, this would be the number of hours between the three).
TaskLaborAccounting This field displays the alternate labor accounting that has been assigned to the given task.
TaskLaborActual This field displays the total extended price of all labor charges on the given task that are not flagged as billing adjustments.
TaskLaborCost This field displays the total cost of all labor charges on the given task.
TaskLaborQuote This field displays the quoted amount for Labor charges assigned to the given repair order task.
TaskLaborRate This field displays the labor rate associated with a task.
TaskLaborRateCode This field displays the labor rate code assigned to the given task.
TaskLaborRateDescription This field displays the description of the labor rate code assigned to the given task.
TaskLastUpdateDate This field displays the Last Update Date of the RO Task for the specific instance of the RO.
TaskMiscellaneousCharges This field displays the total extended price of all miscellaneous charges that have been added to the given repair task.
TaskMiscellaneousChargesCost This field displays the total cost of all miscellaneous charges added to the given repair task.
TaskNumber This field displays the number attached to a given task.
TaskOpenTime This field displays the sum of all open time transactions for the given repair order task.
TaskOverrideLaborRate This field displays the labor rate override to be charged on a given repair order task.
TaskOverrideTaxStatus This field displays the override tax status that has been assigned to the given task.
TaskPartsAccounting This field displays the alternate parts accounting that has been assigned to the given task.
TaskPartsAverageCost This field displays the total average cost of all parts that have been added to the given repair order task.
TaskPartsQuote This field displays the quoted amount for parts for the given repair order task.
TaskPartsReplacementCost This field displays the total replacement cost of all parts on a repair order task.
TaskPartsSellingCost This field displays the selling cost of all parts that have been added to the given repair order task.
TaskRemainingHours This field displays the number of hours remaining for the given repair order task.
TaskRepairGroup This field displays the repair group assigned to a task.
TaskRepairGroupDescription This field displays the description of a given repair group.
TaskRepairType This field displays the Repair Type assigned to the given Repair Order Task.
TaskRepairTypeDescription This field displays the description of the Repair Type assigned to the given task.
TaskSRTCode This field displays the vendor’s SRT code associated with a task, if any.
TaskStatus This field displays the status of the given task.
TaskTechnicians This field displays the names and numbers of any technicians who are or have been clocked on to a specific task of a repair order.
TaskTotal This field diplays the total price of all charges added to the given task.
TaskTotalActual This field displays the total extended price of all charges add to the given task, less and charge flagged as a billing adjustment.
TaskTotalAverageCost This field displays the total average cost of all charges that have been added to the given repair order task.
TaskTotalCost This field displays the total cost of all charges added to the given task.
TaskTotalLabor This field displays the total extended price of all labor charges on the given task.
TaskTotalParts This field displays the total extended price of all parts charges on the given task.
TaskTotalReplacementCost This field displays the total replacement cost of a all charges that have been added to the given repair order task.
TaskTotalSellingCost This field displays the total of all parts selling cost on a particular repair task.
TaskTotalTimeWorked This field displays the total amount of hours worked on the given task  not including billing adjustments.
TaskUseBookHours This field displays whether or not the given task is flagged to use book hours instead of billing hours.
IsTaskWaiting This field displays “Yes” if a repair order is not flagged as completed and no one is currently clocked on.
IsTaskWaitingForParts This field displays whether or not the given task is waiting for parts.
UnitNumber This field displays the Unit number assigned to the repair order the given task is associated with.
VMRSCode This field displays the VMRS Code that has been assigned to the given Repair Order Task.
VMRSCodeDescription This field displays the description of the VMRS Code that has been assigned to the given Repair Order Task.
VMRSFailure This field displays the VMRS failure description the user has assigned to the given repair order task.
VMRSReason This field displays the VMRS reason description the user has assigned to the given repair order task.
VMRSTask This field displays the VMRS Task description that has been assigned to the given Repair Order Task.