This data object is used to display all part, labor, and miscellaneous charge detail items on a given repair order.

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

URL

/frw/RepairOrderDetails

Field Details…

SQL Field Name Column Description
AddDate This field displays the date on which the given repair order detail item was added.
AddUser This field displays the user name of the user who added the given repair order detail item.
AverageCost This field displays the cost or average cost or, if average cost is zero, the replacement cost of the given repair order detail item.
BackorderPriority This field displays the backorder priority flag that was entered when the given part for which backorder was necessary was added to the repair order.
BillCustomerOT This field displays whether the customer will be billed extra for overtime hours on the given repair order.
IsBillingAdjustment This field displays whether the labor hours on the repair order have been adjusted for billing.
BillingCompanyName This field displays the company name of the billing customer on the given repair order.
BillingCustomer This field displays the customer number of the billing customer on the given repair order.
BinLocation This field displays the bin location of the given part on the repair order.
Branch This field displays the branch in which the given repair order was created.
CalculatedAgainst This field displays which value the specified percentage is applied to in order to determine the price of the given miscellaneous charge on the repair order.
CalculatedPrice This field displays the price of the given detail item before override price is taken into consideration.
ControlNumber This field displays the control number associated with the part or miscellaneous charge.
CoreClass This field displays the class of the core for the given exchange part.
CoreCost This field displays the cost of the core for the given exchange part.
CoreDescription This field displays the description of the core for the given exchange part.
CoreExtendedPrice This field displays the extended price (price * quantity) of the core for the given exchange part.
IsCoreNoCharge This field displays whether the core for the given exchange part was added to the repair order at no charge.
IsCoreOneLineTransaction This field displays whether the given exchange part and its core will appear as one line with a single transaction on the repair order.
CoreOverridePrice This field displays the override price entered for the core for the given exchange part at the time it was added to the repair order.
CorePartNumber This field displays the part number of the core for the given exchange part.
CorePrice This field displays the price of the core for the given exchange part.
CoreReferenceMPO This field displays the reference MPO associated with the core for the given exchange part.
CoreSupplier This field displays the supplier of the core for the given exchange part.
Department This field displays the department in which the given repair order was created.
Division This field displays the division in which the given repair order was created.
EHCCharge This field displays the total amount for the environmental handling charge on the given repair order.
EHCCode This field displays the code for the environmental handling charge added to the given part on the repair order.
EHCDescription This field displays the description of the environmental handling charge added to the given part on the repair order.
IsEnterLaborInTotalHours This field displays whether the quantity of hours on the given labor task were entered manually as a lump sum, rather than calculated by the times at which the technician clocked in and out.
ExtendedAverageCost This field displays the extended average cost (average cost * quantity) of the given repair order detail item.
Extended Price This field displays the extended price (price * quantity or hourly rate * quantity) of the given repair order detail item.
ExtendedReplacementCost This field displays the extended replacement cost (replacement cost * quantity) of the given repair order detail item.
ExtendedSellingCost This field displays the extended selling cost (selling cost * quantity) of the given repair order detail item.
FillingBranch This field displays the filling branch of the given part on the repair order.
InsideSalesperson This field displays the user name of the salesperson responsible for the sale of the given part on the repair order.
DateInvoiced This field displays the date on which the given repair order was invoiced.
InvoiceNumber This field displays the invoice number of the given invoiced repair order.
Item This field displays the part number, technician number, or an identifying description of the given repair order detail item.
ItemDescription This field displays a description of the given repair order detail item.
KitAssemblyTemplate This field displays an indicator of whether the part is a kit, assembly, or template. Note that this field is not used in Fusion at this time.
LastUpdateDate This field displays the date on which the given repair order detail item was last updated.
LastUpdateUser This field displays the user name of the user who last updated the given repair order detail item.
Message This field displays the message entered at the time the part or miscellaneous charge was added to the repair order.
Method This field displays the method, manual or percentage, of the given miscellaneous charge on the repair order.
IsNoCharge This field displays whether the given part detail record was added to the repair order at no charge.
OEMPrice This field displays the customer’s selling price of the part that was received from the OEM in a price verification.
OEMRebateAmount This field displays the rebate amount received from the OEM in a price verification that the cost of the transaction can be reduced by.
OTBillingTotal This field displays the total amount that will be billed as overtime (OT Hours * OT Hourly Rate) on the given labor task.
OTDescription This field displays the description of the overtime multiplier associated with the overtime hours on the given labor task.
OTHourlyCost This field displays the hourly cost of the overtime hours associated with the given labor task.
OTHourlyRate This field displays the hourly rate of the overtime hours associated with the given labor task.
OTHours This field displays the number of labor hours on the repair order that are considered overtime.
OTMultiplier This field displays the multiplier used to determine cost per hour for overtime hours.
OutsideSalesperson This field displays the outside parts salesperson associated with the customer on the given repair order.
OverridePrice This field displays the override price entered for the given detail item when it was added to the repair order (Parts and Misc Charges, at the time of input. Labor, at the time of task creation.).
OverrideTaxStatus This field displays the override tax status entered for the part or miscellaneous charge at the time it was added to the repair order.
OwningCompanyName This field displays the company name of the owning customer on the given repair order.
OwningCustomer This field displays the customer number of the owning customer on the given repair order.
PartActionFlag This field displays the part action flag selected when the given repair order detail item was selected to be added to the repair order.
PartStockNumber This field displays the stock number of the given part, which is used to uniquely identify a part that is tracked by serial number. Note that this field is not used in Fusion at this time.
PartTechnician This field displays the technician associated with the given part on the repair order.
PartType This field displays the part type of the given part.
IsPartialFill This field displays whether the given part detail record on the repair order was partially filled.
Percentage This field displays the percentage that is applied to a specified value to determine the price of the given miscellaneous charge on the repair order.
IsPolicyAdjustment This field displays whether the given part on the repair order is for policy adjustment.
Price This field displays the price at which the given detail item was sold (Override Price if there is one, Calculated Price if not).
ProductClass This field displays the product class associated with the given miscellaneous charge on the repair order.
ProductCode This field displays the product code associated with the given part, which indicates user defined groups of parts.
IsPulled This field displays whether the given part was pulled from inventory for the given repair order.
QuantityHours This field displays the quantity of the given repair order detail item included on the repair order.
RateLevelDescription This field displays the description of the labor rate being used for billing on the overtime hours associated with the given labor task.
ReferenceMPO This field displays the reference MPO associated with the part or miscellaneous charge.
RepairGroup This field displays the repair group associated with the given labor task.
RepairType This field displays the repair type associated with the given labor task.
ReplacementCost This field displays the cost or replacement cost of the given repair order detail item.
RONumber This field displays the repair order number of the given repair order.
ROStatus This field displays the current status of the given repair order.
SerialNumber This field displays the serial number of the given part on the repair order.
SerialStockType This field displays the serial stock type associated with the given part on the repair order.
Shift This field displays the shift code for the given technician.
Supplier This field displays the supplier of the given part.
TaskNumber This field displays the task number that the given repair order detail item is associated with.
TimeIn This field displays the date and time at which the technician clocked in.
TimeOut This field displays the date and time at which the technician clocked out.
TransactionType This field displays the transaction type for the given repair order detail item.
UnitNumber This field displays the unit number of the unit that is being serviced on the given repair order.
UnitOfMeasure This field displays the units in which the given part on the repair order is sold.
StockNumber This field displays the stock number of the unit that is being serviced on the given repair order.
IsWarranty This field displays whether the given part on the repair order is considered warranty.
Weight This field displays the weight of the given part on the repair order.