3PAOpenServiceDetailExample JSON Result

Example JSON Result

Results

[
    {
        "Cmf": "76156733",
        "DealerId": "",
        "ROHeaderID": 52862163,
        "rono": "302184",
        "ROMiscInvoiceID": null,
        "CommonInvoiceID": null,
        "Rostatus": 4,
        "CustID": 7588237,
        "datein": "2020-10-19T17:16:03.914",
        "closedate": "1000-01-01T00:00:00",
        "pudate": "1000-01-01T00:00:00",
        "lastmodifieddate": "2022-01-04T19:07:39.948",
        "datecreated": "2020-10-19T17:16:03.914",
        "shopsupply": 10.0,
        "MiscCharge1": 0.0,
        "MiscCharge2": 0.0,
        "MiscCharge3": 0.0,
        "MiscCharge4": 0.0,
        "ServiceWriterName": "CR Giteree",
        "ServiceWriterUserName": "SMP1",
        "ServiceWriterId": 685858665543887510,
        "TotsubCost": 0.0,
        "TotsubSales": 0.0,
        "category": null,
        "status": "Not Ready - Need to Special Order Parts",
        "Salestaxwarr": 0.0,
        "Salestaxmu": 0.0,
        "Salestaxnw": 0.0,
        "Totaltax": 0.0,
        "totalowed": 547.74,
        "promiseddate": "2020-10-19T17:16:03.914",
        "oemronumber": 12344556,
        "Unit": [
            {
                "DealerId": "",
                "ROUnitID": 52862164,
                "VIN": "",
                "Make": "Honda",
                "Model": "GL1800D",
                "Year": "2018",
                "Engineno": "",
                "Class": "M",
                "Odometer": 0,
                "unitonlot": true,
                "StockNumber": "",
                "manufacturer": "",
                "keyboardnumber": "",
                "modelname": "",
                "MajorUnitHeaderID": "5682166",
                "Job": [
                    {
                        "DealerId": "",
                        "ROJobID": 53219097,
                        "JobDescription": "",
                        "JobTitle": "Oil and Filter Change",
                        "InternalJob": 0,
                        "WarrantyJob": 0,
                        "ShopSupply": 8.18,
                        "misccharge1": "24.5300000",
                        "misccharge2": "0.00000000",
                        "misccharge3": "0.00000000",
                        "misccharge4": "0.00000000",
                        "status": "Not Ready - Need to Special Order Parts",
                        "partsonly": false,
                        "warrantyapproved": false,
                        "warrantyclaimnumber": "",
                        "recommendations": "",
                        "resolution": "",
                        "salestype": "CUSTOMER - TAX EXEMPT",
                        "technotes": "",
                        "internalwarrantynumber": null,
                        "failuredate": null,
                        "customercontentioncode": null,
                        "customercontention": null,
                        "problemcode": null,
                        "problemdescription": null,
                        "customitem1": null,
                        "customitem2": null,
                        "customitem3": null,
                        "customitem4": null,
                        "claimamountparts": null,
                        "claimamounthandling": null,
                        "claimamountlabor": null,
                        "claimamountsublet": null,
                        "claimamountfreight": null,
                        "claimamounttax": null,
                        "claimamounttotal": null,
                        "partsdeductiblealloc": null,
                        "subletdeductiblealloc": null,
                        "handlingdeductiblealloc": null,
                        "claimamountdeductible": null,
                        "claimamountdeductibletax": null,
                        "authorizationid": null,
                        "auth1": null,
                        "auth2": null,
                        "auth3": null,
                        "auth4": null,
                        "auth5": null,
                        "auth6": null,
                        "auth7": null,
                        "auth8": null,
                        "extrahours1": null,
                        "extrahours2": null,
                        "extrareason1": null,
                        "extrareason2": null,
                        "extralabordateclosed": null,
                        "previousrepairordernumber": null,
                        "previousinvoicenumber": null,
                        "previousinvoicedate": null,
                        "previoushours": null,
                        "previousodometer": null,
                        "claimtype": null,
                        "warrantystatus": "",
                        "isnonusmodel": null,
                        "failedpartnumber": null,
                        "carriernumber": null,
                        "carrierinvoicenumber": null,
                        "carrierinvoicedate": null,
                        "carrierdatefiled": null,
                        "controlsequencenumber": null,
                        "reasonfordelay": null,
                        "actiontaken": null,
                        "customerapproval": "APPROVED",
                        "Parts": [
                            {
                                "DealerId": "",
                                "ROPartID": 53219100,
                                "PartNumber": "YAM-1040 QT",
                                "PartDescription": "yamaha oil",
                                "SourceCode": "YA",
                                "Qty": 0,
                                "requestedqty": 3,
                                "specialorderqty": 0,
                                "Cost": 0.0,
                                "Price": 9.95,
                                "ExtPrice": 0.0,
                                "DiscountPrice": 0.0
                                },
                                {
                                "DealerId": "",
                                "ROPartID": 53219099,
                                "PartNumber": "11427721779",
                                "PartDescription": "OIL FILTER",
                                "SourceCode": "BM",
                                "Qty": 0,
                                "requestedqty": 1,
                                "specialorderqty": 0,
                                "Cost": 10.77,
                                "Price": 19.79,
                                "ExtPrice": 17.23,
                                "DiscountPrice": 17.23
                                }
                            ],
                            "Labor": [
                                {
                                "DealerId": "",
                                "ROLaborID": 53219098,
                                "JobDescription": "Oil and filter change",
                                "Hours": 1.5,
                                "Rate": 109.0,
                                "Total": 163.5,
                                "Actualhours": 0.0,
                                "TechnicianName": null,
                                "technicianusername": null,
                                "technicianid": null,
                                "jobcode": "",
                                "DiscountTotalCharge": 163.5,
                                "TotalCharge": 163.5,
                                "technicianrate": null,
                                "closetime": "1000-01-01T00:00:00"
                                }
                            ]
                        },
                        {
                        "DealerId": "",
                        "ROJobID": 52862165,
                        "JobDescription": "",
                        "JobTitle": "8K Service",
                        "InternalJob": 0,
                        "WarrantyJob": 0,
                        "ShopSupply": 0.0,
                        "misccharge1": "30.0000000",
                        "misccharge2": "0.00000000",
                        "misccharge3": "0.00000000",
                        "misccharge4": "0.00000000",
                        "status": "Ready to Work",
                        "partsonly": false,
                        "warrantyapproved": false,
                        "warrantyclaimnumber": "",
                        "recommendations": "",
                        "resolution": "",
                        "salestype": "CUSTOMER - TAX EXEMPT",
                        "technotes": "",
                        "internalwarrantynumber": null,
                        "failuredate": null,
                        "customercontentioncode": null,
                        "customercontention": null,
                        "problemcode": null,
                        "problemdescription": null,
                        "customitem1": null,
                        "customitem2": null,
                        "customitem3": null,
                        "customitem4": null,
                        "claimamountparts": null,
                        "claimamounthandling": null,
                        "claimamountlabor": null,
                        "claimamountsublet": null,
                        "claimamountfreight": null,
                        "claimamounttax": null,
                        "claimamounttotal": null,
                        "partsdeductiblealloc": null,
                        "subletdeductiblealloc": null,
                        "handlingdeductiblealloc": null,
                        "claimamountdeductible": null,
                        "claimamountdeductibletax": null,
                        "authorizationid": null,
                        "auth1": null,
                        "auth2": null,
                        "auth3": null,
                        "auth4": null,
                        "auth5": null,
                        "auth6": null,
                        "auth7": null,
                        "auth8": null,
                        "extrahours1": null,
                        "extrahours2": null,
                        "extrareason1": null,
                        "extrareason2": null,
                        "extralabordateclosed": null,
                        "previousrepairordernumber": null,
                        "previousinvoicenumber": null,
                        "previousinvoicedate": null,
                        "previoushours": null,
                        "previousodometer": null,
                        "claimtype": null,
                        "warrantystatus": "",
                        "isnonusmodel": null,
                        "failedpartnumber": null,
                        "carriernumber": null,
                        "carrierinvoicenumber": null,
                        "carrierinvoicedate": null,
                        "carrierdatefiled": null,
                        "controlsequencenumber": null,
                        "reasonfordelay": null,
                        "actiontaken": null,
                        "Parts": [],
                        "Labor": [
                            {
                                "DealerId": "",
                                "ROLaborID": 52862166,
                                "JobDescription": "8K MILE SERVICE",
                                "Hours": 2.7,
                                "Rate": 109.0,
                                "Total": 294.3,
                                "Actualhours": 0.0,
                                "TechnicianName": null,
                                "technicianusername": null,
                                "technicianid": null,
                                "jobcode": "13494",
                                "DiscountTotalCharge": 294.3,
                                "TotalCharge": 294.3,
                                "technicianrate": null,
                                "closetime": "1000-01-01T00:00:00"
                            }
                        ]
                    }
                ]
            }
        ]
    }
]

Notes

RO Status

StateDescription
0Estimate
1New repair order
3Cancelled repair order
4Outstanding parts requests
5Outstanding parts special orders
6In process - parts assigned, but no labor
7In Process - labor assigned, but no parts
8In process - parts and labor assigned
9Partially completed
10Completed missing warranty information
11Completed (ready for cashiering)

Status

  • No Activity – RO has no parts, labor or sublet entries across all jobs.
  • Not Available – The “Unit on Lot” box is not checked for a unit on the RO.
  • Not Ready-Warranty Not Approved – The Warranty box is checked for the job and the Warranty Approved check box has not been checked.
  • Not Ready-Need to Special Order Parts – Parts not in stock requested and not yet invoiced to order.
  • Not Ready-Waiting for Parts to PO – Parts on Special Order invoice but not yet ordered.
  • Not Ready-Waiting, Parts Ordered – Parts on order, not received.
  • Special Order Received – Special order items received but not yet invoiced to RO.
  • Ready to Work – All parts are in stock or no parts requested. Note that a job will show Ready to Work if the requested parts are in inventory event though they are not yet invoiced.
  • Once a job reaches the Ready to Work status, the service manager knows it is ready to schedule and would add it to the service scheduler.
  • Scheduled – Job is scheduled for work on the Service Scheduler. Note that if the job was scheduled on a past date and has not been completed, the status reverts to Ready to Work.
  • Clocked-in Labor – Tech has clocked in on the job (any labor line on the job has a clock-in).
  • Clocked out Labor – Tech has clocked out on the current date.
  • Clocked out generally means it is time for the service writer to close the labor on the job.
  • If the labor is not closed the same day, or the job has been rescheduled the assumption is that more work is needed. The clock-out is ignored and whatever status is applicable is displayed.
  • Sublet – An unclosed Sublet line remains while other parts and labor are complete.
  • Labor Closed – Labor lines closed out on the job.
  • Labor Closed Parts Requested – Parts are still in requested status, available, and perhaps even installed, but not yet invoiced to the RO.
  • Ready to Cashier – All parts are taken and all Labor is closed out and sublet is complete. Note that all jobs must show Ready to Cashier to enable cashiering the repair order.
  • Cashiered – RO has been cashiered.