|
Service Deferred Repairs
This data object is used to display a list of all deferred repairs from the Fusion business system.
This information can be found in the Deferred Repair program within the Fusion business system.
Field Details…
| SQL Field Name | Column Description |
|---|---|
| AddDate | This field displays the date on which the deferred repair was added. |
| AddUser | This field displays the username that added the record. |
| CustomerName | This field displays the company name associated with the customer found in the deferred repair record. |
| CustomerNumber | This field displays the customer number associated with the unit occurrence found in the deferred repair record. |
| DeferredDate | This field displays the date for deferring the repair. |
| DeferredReason | This field displays the reason the deferred repair was created. |
| DeferringBranch | This field displays the branch where the deferred repair was created. |
| DeferringDepartment | This field contains the department of the task when it was deferred. This department will be copied into the repair order task when applied to an open repair order. If the set department is not valid for the branch applying the repair, the department will be set to the user’s login department. |
| DeferringRONumber | This field displays the repair order number assigned to the deferred repair. |
| DeferringTaskNumber | This field displays the task number assigned to the repair order for the deferred repair. |
| DeferringUser | This field displays the user name that deferred the repair. |
| ExpectedExpirationDate | This field displays the expiration date for the deferred repair. |
| InServiceDate | This field displays the in service date of the unit. |
| LastUpdateDate | This field displays the date on which the deferred repair was last updated. |
| LastUpdateUser | This field displays the username that last updated the record. |
| OfficePhone | This field displays the customer’s office phone number. |
| RepairGroup | This field displays the unique value indicating a repair group in the database. |
| RepairGroupDescription | This field displays the unique value indicating a repair group description in the database. |
| RepairType | This field displays the description of a particular repair type. |
| RepairTypeDescription | This field displays the unique value indicating a repair type description in the database. |
| Ship-toAddress1 | This field displays the Ship-To Address line 1 of the customer. |
| Ship-toAddress2 | This field displays the Ship-To Address line 2 of the customer. |
| Ship-toCity | This field displays the Ship-To City of the customer. |
| Ship-toCountry | This field displays the Ship-To Country of the customer. |
| Ship-toCounty | This field displays the Ship-To County of the customer. |
| Ship-toPostalCode | This field displays the Ship-To Postal Code of the customer. |
| Ship-toRegion | This field displays the Ship-To Region of the customer. |
| UnitMake | This field displays the unit’s make. |
| UnitModel | This field displays the unit’s model. |
| UnitNumber | This field displays the ID number of a unit attached the deffered repair record. |
| UnitYear | This field displays the unit’s year. |
| Vin | This field displays the Vehicle Identification Number. |
Service Unit Meter History
This data object is used to display all meter readings for units captured within the Fusion business system.
Field Details…
| SQL Field Name | Column Description |
|---|---|
| AddDate | This field displays the date on which the meter reading was added. |
| AddUser | This field displays the username that added the record. |
| AverageDailyUsage | This field displays the average meter traveled per day. |
| CustomerNumber | This field displays the identifying number attached to a customer. |
| Erroneous | This field displays if the meter reading is flagged as Errouneous. |
| Estimate | This field displays if the meter reading is flagged as an Estimate. |
| LastUpdateDate | This field displays the date on which the meter reading was last updated. |
| LastUpdateUser | This field displays the username that last updated the record. |
| Make | This field displays the make of a unit attached to a given meter reading. |
| MeterDate | This field displays the date of the meter reading. |
| MeterReading | This field displays the meter reading of the given unit. |
| MeterSource | This field displays the source of the meter reading. |
| MeterTransactionType | This field displays the transaction type generated by the system for the meter reading. |
| MeterType | This field displays the unit’s meter type (gallons, hours, kilometers, etc.). |
| Model | This field displays the model of a unit. |
| ModelYear | This field displays the year in which a unit was produced. |
| CompanyName | This field displays the company name of the owning customer assigned to the unit. |
| UnitNumber | This field displays the identification number of the unit. |
| Vin | This field displays the Vehicle Identification Number. |
Service Open Barcode Time
This data object is used to display all open bar code time in the Fusion business system.
This information can be found in the Bar Code Time Entry program within the Fusion business system.
Field Details…
| SQL Field Name | Column Description |
|---|---|
| ApplicationName | This field displays the application through which the Barcode Time transaction was added. |
| AddApplicationNumber | This field displays the add application number associated with open barcode time. |
| AddDate | This field displays the date on which the time record was added. |
| AddUser | This field displays the user name that added the record. |
| BranchCode | This field displays the branch associated with the time record. |
| CompletionTime | This field displays the time task was completed. |
| Department | This field displays the department associated with a Time Record. |
| ElapsedTime | This field displays the time that has elapsed on a task. |
| ElapsedTime_FH | This field displays the current amount of time the user has been clocked. |
| LastUpdate | This field displays the date the record was last updated. |
| UpdateUser | This field displays the user name of the individual who made the update. |
| RemainingTime | This field subtracts the closed and open time worked on the RO task from the RO task Billing hours. If the RO task is set to use Book hours as the bill hours, then the closed and open time will be subtracted from the book hours. If the billing hours on the task is 0 then this field will be blank. |
| RepairOrderNumber | This field displays the number attached to a repair order. |
| RepairType | This field displays the description of a particular repair type. |
| RepairTypeDescription | This field displays the unique value indicating a repair type description in the database. |
| Shift | This field displays the shift code for a technician, if any. |
| ShiftDescription | This field displays the description for a technician’s shift. |
| TaskNumber | This field displays the number attached to a given task. |
| TechnicianName | This field displays the technician’s name. |
| TechnicianNumber | This field displays the number assigned to a technician. |
| TimeIn | This field displays the time in which a technician clocked in. |
| UpdateApplicationName | This field displays the last application through which the Barcode Time transaction was updated. |
| UpdateApplicationNumber | This field displays the update application number associated with open barcode time. |
Service Preventive Maintenance
This data object is used to display all preventive maintenance information.
This information can be found in the Preventive Maintenance Service Due program within the Fusion business system.
Field Details…
| SQL Field Name | Column Description |
|---|---|
| AddDate | This field displays the date on which the PM record was added. |
| AddUser | This field displays the user that added the PM record for the unit. |
| AverageDailyUsage | This field displays the average meter traveled per day. If the value returned is larger than 750, then the value will be defaulted to 750 in the data returned to allow for calculations in the data object to return correctly. |
| UnitType | This field displays the unit type for a unit requiring / receiving preventive maintenance. |
| CompanyName | This field displays the company name of the owning customer associated with the unit. |
| CompanyShopPhone | This field displays the shop phone number of the units owning customer. |
| ContractCompanyName | This field displays the Company name of the customer the unit is active on contract with. |
| ContractCustomerContact | This field displays the primary contact of the customer the unit is active on contract with. |
| ContractCustomerShopPhone | This field displays the shop phone number of the customer the unit is active on contract with. |
| ContractNumber | This field displays the number attached to a contract. |
| LastMeterDate | This field displays the date of the meter reading on the last time preventive maintenance was performed. |
| LastMeterReading | This field displays the meter reading on the last time preventive maintenance was performed. |
| CustomerNumber | This field displays the identifying number attached to a customer. |
| CustomerAddress | This field displays the billing customer’s street address. |
| CustomerBaseBranch | This field displays the base branch for a given customer. |
| CustomerCity | This field displays the billing customer’s city. |
| CustomerCountry | This field displays the billing customer’s country. |
| CustomerPostalCode | This field displays the billing customer’s postal code. |
| CustomerRegion | This field displays the billing customer’s region or state. |
| GraceDays | This field displays the overage day allottment for the PM code. These days will be added to the Next Date Due to help determine whether the unit should be due for service or not. |
| GraceMeter | This field displays the overage meter allotment for the PM code. This meter amount will be added to the Next Meter Due to help determine whether the unit should be due for service or not. |
| LastInvoiceNumber | This field displays the last invoice done for a unit that contained a PM job. |
| LastInvoiceDate | This field displays the date on which an account was last invoiced. |
| LastRepairOrder | This field displays the most recent repair order on which preventive maintenance was done. |
| LastPMROBranch | This field displays the last branch that completed a PM Service for the Unit. |
| LastUpdate | This field displays the date on which the PM schedulee was last updated. |
| LastUpdateUser | This field displays the user to last update PM for the unit. |
| IsLeaseRentalCustomer | This field displays whether or not a customer is a customer in lease/rental. |
| Make | This field displays the make of a unit attached to a PM record. |
| PMBasis | This field displays the units meter type; hours, miles, kilometers, etc. |
| Model | This field displays the model of a unit. |
| UnitYear | This field displays the unit’s year. |
| PMDateNextDue | This field displays the date on which a unit is next due for service. |
| PMNextMeterDue | This field displays the meter reading at which a unit will next be due for preventive maintenance. |
| RONumber | This field displays the Repair Order associated with the PM schedule. |
| TaskDescription | This field displays the description of the task. |
| OpenPMROBranch | This field displays the open branch that has an open RO for PM Service for the Unit. |
| Ownership | This field displays the unit’s owner. |
| OwningCustomerContact | This field dislays the primary contact of the units owning customer. |
| PMDescription | This field displays the preventive maintenance description. |
| PMCode | This field displays the preventive maintenance interval schedule for services. |
| PMTimeInterval | This field displays the specific date on which a unit will be due for service. |
| PMLastCompletionDate | This field displays the last date on which the preventive maintenance was performed. |
| PMLastCompletionMeter | This field displays the meter reading on the last time preventive maintenance was performed. |
| PMMeterInterval | This field displays the number of (hours, miles, kilometers) that will pass before a unit is due for service again. |
| PMRepairTypeCode | This field displays the repair type associated with the preventive maintenance code. |
| PMRepairTypeDescription | This field displays the repair type description associated with the preventive maintenance code. |
| RODateOpened | This field displays the date on which a repair order was opened. |
| PMServiceDue14Days | This field displays whether or not a unit has preventive maintenance due within 14 days. |
| PMServiceDue21Days | This field displays whether or not a unit requires preventive maintenance within 21 days. |
| PMServiceDue7Days | This field displays whether or not a unit has preventive maintenance due within 7 days. |
| PMServiceDueFlag | This field displays whether or not a unit has preventive maintenance due immediately. |
| ROStatus | This field displays the description of the current status associated with a repair order, if any. |
| IsScheduled | This field displays whether or not preventive maintenance is scheduled. |
| ServiceBranch | This field displays the branch which performed preventive maintenance service. |
| StartingDate | This field displays the starting date for preventive maintenance. |
| StartingMeter | This field displays the starting meter for a unit on a contract. |
| TaskNumber | This field displays the number attached to a given task. |
| TaskClockedOnTechnicians | This field displays the names and associated numbers of any technicians currently clocked on to a repair order task. |
| UnitIndicator | This field displays the type of unit (sales, service, lease/rental, etc.). |
| UnitNumber | This field displays the unit number of the unit attached to the PM schedule. |
| VIN | This field displays the Vehicle Identification Number. |
Service Repair Order Quote Details
This data object is used to display the detail line items with pricing and costing information for Repair Order Quotes from the Fusion business system. Join to Repair Order Quote Task to view the task level information and then to Repair Order Quote Header to view the header level information for the given repair order quote.
Field Details…
| SQL Field Name | Column Description |
|---|---|
| AddDate | This field displays the date on which the given detail item was added to the given repair order quote. |
| AddUser | This field displays the user name of the user who added the given detail item to the given repair order quote. |
| AverageCost | This field displays the cost or average cost or, if average cost is zero, the replacement cost of the given detail item on the given repair order quote. |
| BackorderPriority | This field displays the backorder priority flag that was entered when the given part for which backorder is necessary was added to the repair order quote. |
| BillingCompanyName | This field displays the company name of the billing customer on the given repair order quote. |
| BillingCustomer | This field displays the customer number of the billing customer on the given repair order quote. |
| BinLocation | This field displays the bin location of the given part on the repair order quote. |
| Branch | This field displays the branch in which the given repair order quote 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 quote. |
| CalculatedPrice | This field displays the price of the given detail item on the given repair order quote before override price is taken into consideration. |
| ControlNumber | This field displays the control number associated with the given 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 quote 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 quote. |
| 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 quote. |
| 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 quote was created. |
| Division | This field displays the division in which the given repair order quote was created. |
| EHCCharge | This field displays the total amount for the environmental handling charge on the given repair order quote. |
| EHCCode | This field displays the code for the environmental handling charge added to the given part on the repair order quote. |
| EHCDescription | This field displays the description of the environmental handling charge added to the given part on the repair order quote. |
| ExtendedAverageCost | This field displays the extended average cost (average cost * quantity) of the given detail item on the given repair order quote. |
| ExtendedPrice | This field displays the extended price (price * quantity or hourly rate * quantity) of the given detail item on the given repair order quote. |
| ExtendedReplacementCost | This field displays the extended replacement cost (replacement cost * quantity) of the given detail item on the given repair order quote. |
| ExtendedSellingCost | This field displays the extended selling cost (selling cost * quantity) of the given detail item on the given repair order quote. |
| FillingBranch | This field displays the filling branch of the given part on the repair order quote. |
| InsideSalesperson | This field displays the user name of the salesperson responsible for the potential sale of the given part on the repair order quote. |
| IsInventory | This field displays whether the given detail item is a part in inventory. |
| Item | This field displays the part number, technician number, or an identifying description of the given repair order quote detail item. |
| ItemDescription | This field displays a description of the given repair order quote 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 detail item was last updated on the given repair order quote. |
| LastUpdateUser | This field displays the user name of the user who last updated the given detail item on the given repair order quote. |
| Message | This field displays the message entered at the time the part or miscellaneous charge was added to the repair order quote. |
| Method | This field displays the method, manual or percentage, of the given miscellaneous charge on the repair order quote. |
| IsNoCharge | This field displays whether the given part detail record was added to the repair order quote at no charge. |
| OEMPrice | This field displays the selling price for the customer of the given 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. |
| OutsideSalesperson | This field displays the user name of the outside salesperson associated with the customer on the given repair order quote. |
| OverridePrice | This field displays the override price entered for the part or miscellaneous charge at the time it was added to the repair order quote. |
| 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 quote. |
| OwningCompanyName | This field displays the company name of the owning customer on the given repair order quote. |
| OwningCustomer | This field displays the customer number of the owning customer on the given repair order quote. |
| 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 quote. |
| 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 quote. |
| PartType | This field displays the part type of the given part on the given repair order quote. |
| IsPartialFill | This field displays whether the given part detail record on the repair order quote will be 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 quote. |
| IsPolicyAdjustment | This field displays whether the given part on the repair order quote is for policy adjustment. |
| Price | This field displays the price or hourly rate of the given detail item on the given repair order quote. |
| ProductClass | This field displays the product class associated with the given miscellaneous charge on the repair order quote. |
| 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 will be pulled from inventory for the given repair order quote. |
| Quantity | This field displays the quantity of the given detail item included on the given repair order quote. |
| ReferenceMPO | This field displays the reference MPO associated with the given part or miscellaneous charge. |
| RepairOrderNumber | This field displays the repair order number of the given repair order quote. |
| ReplacementCost | This field displays the cost or replacement cost of the given detail item on the given repair order quote. |
| SerialNumber | This field displays the serial number of the given part on the repair order quote. |
| SerialStockType | This field displays the serial stock type associated with the given part on the repair order quote. |
| Supplier | This field displays the supplier of the given part on the given repair order quote. |
| TaskNumber | This field displays the task number that the given repair order quote detail item is associated with. |
| TransactionType | This field displays the transaction type for the given repair order quote detail item. |
| UnitNumber | This field displays the unit number of the unit that is being quoted to be serviced on the given repair order quote. |
| UnitOfMeasure | This field displays the units in which the given part on the repair order quote is sold. |
| UnitStockNumber | This field displays the stock number of the unit that is being quoted to be serviced on the given repair order quote. |
| IsWarranty | This field displays whether the given part on the repair order quote is considered warranty. |
| Weight | This field displays the weight of the given part on the repair order quote. |
Service Repair Order Quote Header
This data object is used to display the header records for all quoted repair orders in Fusion, and contains one record for each quote with summary information about the repair order included. This data object can be joined to Repair Order Quote Task and then to Repair Order Quote Details in order to view the detail information on the quote.
This information can be found in the repair order application in Fusion.
Field Details…
| SQL Field Name | Column Description |
|---|---|
| AddDate | This field displays the date on which the given repair order quote was added to the system. |
| ArrivalDateTime | This field displays the date on which the unit first arrived for service. |
| AuthorizationNumber | This field displays the credit authorization number associated with the given repair order quote, from the billing customer tab in the repair order application. |
| BillingCompanyName | This field displays the company name of the billing customer associated with the given repair order quote. |
| BillingContactName | This field displays the name of the contact associated with the billing customer associated with the given repair order quote. |
| BillingCustomerAccountStatus | This field displays the current status of the customer account for the billing customer associated with the given repair order quote. |
| BillingCustomerAddress | This field displays the street address of the billing customer associated with the given repair order quote. |
| BillingCustomerCity | This field displays the city of the billing customer associated with the given repair order quote. |
| BillingCustomerCountry | This field displays the country of the billing customer associated with the given repair order quote. |
| BillingCustomerCounty | This field displays the county of the billing customer associated with the given repair order quote. |
| BillingCustomerIndustryType | This field displays the industry type of the billing customer associated with the given repair order quote. |
| BillingCustomerNumber | This field displays the customer number of the billing customer associated with the given repair order quote. |
| BillingCustomerPostalCode | This field displays the postal code of the billing customer associated with the given repair order quote. |
| BillingCustomerRegion | This field displays the region of the billing customer associated with the given repair order quote. |
| IsBillingCustomerWarranty | This field displays whether the billing customer associated with the given repair order quote is a warranty customer. |
| BillingCustomerWorkPhone | This field displays the work phone number for the billing customer associated with the given repair order quote. |
| BillingHomePhone | This field displays the home phone number of the contact associated with the billing customer associated with the given repair order quote. |
| Branch | This field displays the branch in which the given repair order quote was created. |
| CompanyName | This field displays the company name of the unit owning customer associated with the given repair order quote. |
| CompletionDate | This field displays the date on which the given repair order quote was completed. |
| ContactHomePhone | This field displays the home phone number of the contact associated with the unit owning customer associated with the given repair order quote. |
| ContactName | This field displays the name of the contact associated with the unit owning customer associated with the given repair order quote. |
| ContactWorkPhone | This field displays the work phone number of the contact associated with the unit owning customer associated with the given repair order quote. |
| CreditReserve | This field displays the credit reserve amount associated with the given repair order quote. |
| CustomerAccountStatus | This field displays the current status of the customer account for the unit owning customer associated with the given repair order quote. |
| CustomerAddress | This field displays the street address of the unit owning customer associated with the given repair order quote. |
| CustomerBaseBranch | This field displays the base branch that the unit owning customer on the given repair order quote is associated with. |
| CustomerCity | This field displays the city of the unit owning customer associated with the given repair order quote. |
| CustomerEmailAddress | This field displays the email address provided for the customer on the given repair order quote. |
| CustomerIndustryType | This field displays the industry type of the unit owning customer associated with the given repair order quote. |
| CustomerNumber | This field displays the customer number of the unit owning customer associated with the given repair order quote. |
| CustomerPhone | This field displays the phone number for the unit owning customer associated with the given repair order quote. |
| CustomerPONumber | This field displays the customer purchase order number for the customer associated with the given repair order quote. |
| CustomerPostalCode | This field displays the postal code of the unit owning customer associated with the given repair order quote. |
| CustomerRegion | This field displays the region of the unit owning customer associated with the given repair order quote. |
| IsCustomerWarranty | This field displays whether the unit owning customer associated with the given repair order quote is a warranty customer. |
| Department | This field displays the department in which the given repair order quote was created. |
| Division | This field displays the division in which the given repair order quote was created. |
| FollowUpEmailFlag | This field displays whether the given repair order quote requires a follow up email. |
| LastUpdateDate | This field displays the date on which the given repair order quote was last updated in the system. |
| LastUpdateUser | This field displays the username of the user who last updated the given repair order quote. |
| LPONumber | This field displays the local purchase order number associated with the given repair order quote. |
| OriginalRONumber | This field displays the repair order number from the original repair order for repair orders that were created from another repair order. |
| PaymentMethod | This field displays the method by which the quoted repair order will be paid by the billing customer, if followed through. |
| PromisedDateTime | This field displays the date on which the given repair order quote was promised to be completed. |
| QuoteAge | This field displays the age (current date - open date) of the given repair order quote. |
| QuoteOpenDate | This field displays the date on which the given repair order quote was opened. |
| QuoteStatus | This field displays the user defined status of the given repair order quote. |
| QuoteTaskCount | This field displays the number of tasks that are associated with the given repair order quote. |
| RemoteApplication | This field displays the name of the remote application that the given repair order quote was created by. |
| RemoteEstimateID | This field displays the estimate id passed in during the creation of the given repair order quote by a remote application. |
| RepairOrderNumber | This field displays the repair order number associated with the given quote. |
| ROPromisedDays | This field displays the days left until the given repair order quote should be completed (promised date - current date). |
| ROPromisedHours | This field displays the hours left until the given repair order quote should be completed (promised date - current date). |
| SalesTaxSetting | This field displays whether sales tax will be applied to the given repair order quote based on the local tax body or the tax body associated with the billing customer. |
| Salesperson | This field displays the salesperson associated with the given repair order quote, from the billing customer tab in the repair order application. |
| ServiceWriter | This field displays the username of the user who created the given repair order quote. |
| TaxBody | This field displays the tax body associated with the given repair order quote. |
| TaxStatus | This field displays the tax status associated with the given repair order quote. |
| TotalEHCCharges | This field displays the total amount quoted to the customer for EHC charges on the given repair order. |
| TotalLaborCharges | This field displays the total amount quoted to the customer for labor on the given repair order. |
| TotalLaborCost | This field displays the total cost of the quoted labor on the given repair order. |
| TotalMiscellaneousCharges | This field displays the total amount quoted to the customer for miscellaneous charges on the given repair order. |
| TotalMiscellaneousChargesCost | This field displays the total cost of the quoted miscellaneous charges on the given repair order. |
| TotalPartsAverageCost | This field displays the total average cost of the quoted parts on the given repair order. |
| TotalPartsCharges | This field displays the total amount quoted to the customer for parts on the given repair order. |
| TotalPartsReplacementCost | This field displays the total replacement cost of the quoted parts on the given repair order. |
| TotalPartsSellingCost | This field displays the total selling cost of the quoted parts on the given repair order. |
| TotalROAverageCost | This field displays the total cost of all quoted charges on the given repair order (average cost for parts). |
| TotalROCharges | This field displays the total amount quoted to the customer on the given repair order. |
| TotalROReplacementCost | This field displays the total cost of all quoted charges on the given repair order (replacement cost for parts). |
| TotalROSellingCost | This field displays the total cost of all quoted charges on the given repair order (selling cost for parts). |
| TotalSalesTax | This field displays the total sales tax quoted on the given repair order. |
| UnitCharacteristicType | This field displays the characteristic type of the unit on the given repair order quote. |
| UnitECMReading | This field displays the ECM meter reading recorded for the unit at the time of the given repair order quote. |
| UnitInServiceDate | This field displays the date on which the unit on the given repair order quote first went into service. |
| UnitMake | This field displays the make of the unit on the given repair order quote. |
| UnitMeterReading | This field displays the meter reading recorded for the unit at the time of the given repair order quote. |
| UnitMeterType | This field displays the unit of measure associated with the meter reading for the unit on the given repair order quote. |
| UnitModel | This field displays the model of the unit on the given repair order quote. |
| UnitNumber | This field displays the unit number associated with the given repair order quote, owned by the unit owning customer. |
| UnitSerialNumber | This field displays the serial number of the unit on the given repair order quote. |
| UnitVIN | This field displays the Vehicle Identification Number associated with the unit on the given repair order quote. |
| UnitYear | This field displays the year of the unit on the given repair order quote. |
Service Repair Order Quote Task
This data object is used to display the task information and task level totals for Repair Order Quotes from the Fusion business system. Join to Repair Order Quote Detail to view the detail item(s) on the given task or to Repair Order Quote Header to view the overall totals for the quote.
Field Details…
| SQL Field Name | Column Description |
|---|---|
| AddDate | This field displays the date on which the given task was added to the given repair order quote. |
| AddUser | This field displays the username of the user who added the given task to the given repair order quote. |
| AlternateBillingCompanyName | This field displays the company name for the alternate billing customer on the given task on the given repair order quote. |
| AlternateBillingCustomer | This field displays the identifying code for the alternate billing customer on the given task on the given repair order quote. |
| IsAlwaysPayBillingHours | This field displays whether the technician should be paid based on the billing hours on the given task on the given repair order quote. |
| BillingCompanyName | This field displays the company name for the billing customer on the given repair order quote. |
| BillingCustomer | This field displays the identifying code for the billing customer on the given repair order quote. |
| BillingHours | This field displays the number of hours which the customer will be billed for on the given task on the given repair order quote. |
| BookHours | This field displays an alternate number of hours which the customer will be billed for on the given task on the given repair order quote, and are typically suggested from the OEM for a given repair. |
| Branch | This field displays the branch in which the given repair order quote was created. |
| CalculatedLaborRate | This field displays the labor rate which will be paid (override labor rate if there is one, labor rate if not) if the quoted work on the given task on the given repair order quote is performed. |
| CallBackDays | This field displays the number of days which should be allowed for callback after the time of service on the given repair order quote. |
| CauseComment | This field displays the cause comment entered on the details tab of the given task on the given repair order quote. |
| ComebackReason | This field displays the reason entered to explain why the same unit has come back in to have a repeat repair performed. |
| IsComebackRepair | This field displays whether the work being quoted on the given task is a comeback repair, meaning that a similar repair was performed on the same unit in the recent past. |
| ComplaintComment | This field displays the complaint comment entered on the details tab of the given task on the given repair order quote. |
| CorrectionComment | This field displays the correction comment entered on the details tab of the given task on the given repair order quote. |
| Department | This field displays the department in which the given repair order quote was created. |
| Division | This field displays the division in which the given repair order quote was created. |
| EHCCharges | This field displays the total amount that the EHC charges on the given task will cost the customer on the given repair order quote. |
| LaborAccounting | This field displays the accounting code which should be used for the labor postings for the given task on the given repair order quote. |
| LaborQuote | This field displays the total amount that the labor for the given task is quoted to cost the customer (based on the Quotes group box on the given task). |
| LaborRate | This field displays the default labor rate for the work being quoted on the given task on the given repair order quote. |
| LaborRateCode | This field displays the identifying code for the labor rate associated with the work being quoted on the given task on the given repair order quote. |
| LaborRateCodeDescription | This field displays the description for the labor rate associated with the work being quoted on the given task on the given repair order quote. |
| LaborTotal | This field displays the total amount that will be billed for the labor on the given task on the given repair order quote (based on the billing or book hours and the labor rate on the given task). |
| LastUpdateDate | This field displays the date on which the given task was last updated on the given repair order quote. |
| LastUpdateUser | This field displays the username of the user who last updated the given task on the given repair order quote. |
| MiscellaneousCharges | This field displays the total price for the miscellaneous charges added to the given task on the given repair order quote. |
| MiscellaneousChargesCost | This field displays the total cost for the miscellaneous charges added to the given task on the given repair order quote. |
| OverrideLaborRate | This field displays the override labor rate, entered at the time of task creation, for the work being quoted on the given task on the given repair order quote. |
| OverrideTaxStatus | This field displays the override tax status entered on the given task on the given repair order quote. |
| OwningCompanyName | This field displays the company name for the owning customer on the given repair order quote. |
| OwningCustomer | This field displays the identifying code for the owning customer on the given repair order quote. |
| PartsAccounting | This field displays the accounting code which should be used for the parts postings for the given task on the given repair order quote. |
| PartsActual | This field displays the total actual price for the parts added to the given task on the given repair order quote. |
| PartsAverageCost | This field displays the total average cost of the parts on the given task on the given repair order quote. |
| PartsQuote | This field displays the total amount that the parts for the given task are quoted to cost the customer. |
| PartsReplacementCost | This field displays the total replacement cost of the parts on the given task on the given repair order quote. |
| PartsSellingCost | This field displays the total selling cost, based on the company costing method set up in Fusion, of the parts on the given task on the given repair order quote. |
| PartsTotal | This field displays the total amount that will be billed for the parts on the given task on the given repair order quote. |
| RepairGroup | This field displays the identifying code for the repair group associated with the work being quoted on the given task on the given repair order quote. |
| RepairGroupDescription | This field displays the description for the repair group associated with the work being quoted on the given task on the given repair order quote. |
| RepairOrderNumber | This field displays the repair order number of the given repair order quote. |
| RepairType | This field displays the identifying code for the repair type associated with the work being quoted on the given task on the given repair order quote. |
| RepairTypeDescription | This field displays the description for the repair type associated with the work being quoted on the given task on the given repair order quote. |
| SRTCodes | This field displays a list of the Standard Repair Time codes added to the given task on the given repair order quote. |
| TaskDepartment | This field displays the department that the given task on the given repair order quote is associated with (can differ from the department from the repair order quote header). |
| TaskNumber | This field displays the task number of the given task on the given repair order quote. |
| TaskStatus | This field displays the status of the given task on the given repair order quote. |
| TotalActual | This field displays the total actual price for the parts and miscellaneous charges added to the given task on the given repair order quote. |
| TotalAverageCost | This field displays the total cost of the parts and miscellaneous charges quoted on the given task, using the average cost for parts. |
| TotalPrice | This field displays the total amount that will be billed for the parts, labor, and miscellaneous charges on the given task on the given repair order quote. |
| TotalReplacementCost | This field displays the total cost of the parts and miscellaneous charges quoted on the given task, using the replacement cost for parts. |
| TotalSellingCost | This field displays the total cost of the parts and miscellaneous charges quoted on the given task, using the company inventory costing method from Fusion for parts. |
| UnitNumber | This field displays the unit number for the unit being quoted for service on the given repair order quote. |
| IsUseBookHours | This field displays whether the book hours on the given task on the given repair order quote should be used when billing, rather than billing hours. |
| VMRSCode | This field displays the VMRS code entered for the given task on the given repair order quote. |
| VMRSCodeDescription | This field displays the description for the VMRS code entered for the given task on the given repair order quote. |
| VMRSFailure | This field displays the VMRS failure description entered for the given task on the given repair order quote. |
| VMRSReason | This field displays the VMRS reason description entered for the given task on the given repair order quote. |
| VMRSTask | This field displays the VMRS task description entered for the given task on the given repair order quote. |
Service Repair Types
This data object is used to return all repair type information.
This information can be found in the Repair Type program within the Fusion business system.
Field Details…
| SQL Field Name | Column Description |
|---|---|
| AddDate | This field displays the Date and Time the given repair type was last updated in the system. |
| AddUser | This field displays the user name that added the record. |
| AlwaysPayIncentive | This field displays whether or not the company always pays an incentive to the technician. |
| BillingHours | This field displays the billing hours of the task in which technician time is committed to. |
| BookHours | This field displays the book hours associated with a given RO task. |
| CallBackdays | This field displays the number of days that must pass before a task is flagged to be followed up on. |
| CauseComment | This field displays the cause comments associated with a given task. |
| ComplaintComment | This field displays the complaint comments associated with a repair task. |
| CorrectionComment | This field displays the correction comments associated with the repair type. |
| InActive | This field displays whether or not a given repair type is set to inactive. |
| LaborQuote | This field displays the labor quote assigned to a task. |
| LaborQuoteType | This field displays the quote type for labor for the given repair type. |
| LaborRateCode | This field displays values which drive labor rate for a task. |
| LastUpdateDate | This field displays the Date and Time the given repair type was added to the system. |
| UpdateUser | This field displays the user name of the individual who made the update. |
| MaximumComebackDays | This field displays the maximum number of days a repair can be brought in for comeback. |
| NoAutoCharges | This field displays whether or not auto charges may occur. |
| IsNonBillable | This field displays whether or not the repair type is nonbillable. |
| OverrideTaxStatus | This field displays the tax status of a given repair order (taxable, exempt, etc.). |
| PartsQuote | This field displays the parts quote assigned to a task. |
| PartsQuoteType | This field displays the quote type for parts for the given repair type. |
| PayOnlyGreaterIncentive | This field displays whether or not the company is only paying the greater incentive to the technician. |
| PerformComebackCheck | This field displays whether or not a comeback check is required. |
| PrintAllMiscChargeDetail | This field displays whether or not all miscellaneous charge detail is printed. |
| PrintLaborDetail | This field displays whether or not the parts labor is printed. |
| PrintPartsDetail | This field displays whether or not the parts detail is printed. |
| PrintTaskSubtotals | This field displays whether or not the task subtotals are printed. |
| PrintTasktotalOnly | This field displays whether or not only task totals are printed. |
| RepairGroup | This field displays the unique value indicating a repair group in the database. |
| RepairGroupDescription | This field displays the unique value indicating a repair group description in the database. |
| RepairGroupMaximumComebackDays | This field displays whether or not a comeback check is required based on the repair group the given repair type is associated with. |
| RepairGroupPerformComebackCheck | This field displays the maximum number of days the repair group can that the given repair type can be brought in for comeback. |
| RepairType | This field displays the description of a particular repair type. |
| RepairTypeDescription | This field displays the unique value indicating a repair type description in the database. |
| VMRSCode | This field displays a code used to track equipment and maintenance. |
| VMRSCodeDescription | This field give a brief description of the VMRS code. |
| VMRSTask | This field defines what type of work is required by the VMRS code. |
| WorkMixCategory | This field displays the Work Mix Category (Competitive, Maintenance, or Standard) associated with the repair type. |