Fields - OpenServiceDet
| Field Name | Data Type | Description, Example |
|---|---|---|
| Cmf | string | Lightspeed Dealer Identifier |
| DealerId | string | Internal Dealer Identifier (intentionally left blank) |
| ROHeaderID (key) | int | DMS internal identifier of RO |
| rono | string | DMS external (customer facing) RO identifier |
| ROMiscInvoiceID | DMS assigned ID of the repair order when cashiered | |
| CommonInvoiceID | DMS assigned ID of the repair order when cashiered | |
| Rostatus | int | Status identifier of the repair order – 0 = Estimate, 1 = New repair order – No activity at all, 3 = Canceled repair order, 4 = Outstanding parts requests, 5 = Outstanding parts special orders, 6 = In process – Parts assigned, no labor, 7 = In process – Labor assigned, no parts, 8 = In process – No parts or labor assigned 9 = Partially completed10 = Completed – Missing warranty info, 11 = Completed – Ready for cashiering 12 = Cancelled Estimate 13 = Waiting for Customer Approval 14 = Customer Declined |
| CustID | bigint | DMS customer identifier |
| datein | date | Date unit was brought in |
| closedate | date | Date RO work was finished |
| pudate | date | Date RO was paid |
| lastmodifieddate | datetime | Date when RO record was last modified |
| datecreated | date | Date when RO record was made |
| shopsupply | money | Amount charged to customer for shop supplies if settings dictate amount on header level |
| MiscCharge1 | money | Amount charged to customer for dealer defined charges if settings dictate amount on header level |
| MiscCharge2 | money | Amount charged to customer for dealer defined charges if settings dictate amount on header level |
| MiscCharge3 | money | Amount charged to customer for dealer defined charges if settings dictate amount on header level |
| MiscCharge4 | money | Amount charged to customer for dealer defined charges if settings dictate amount on header level |
| ServiceWriterName | string | Name of service writer |
| ServiceWriterUsername | string | DMS user name of service writer |
| ServiceWriterId | bigint | DMS ID of service writer |
| TotsubCost | money | Total cost of sublet work |
| TotsubSales | money | Total price of sublet work |
| Category | string | Category assigned to RO |
| Status | string | Status code of open RO |
| Salestaxwarr | money | Tax on warranty work |
| Salestaxmu | money | Tax on unit work |
| Salestaxnw | money | Tax on non-warranty work |
| Totaltax | money | Tax on entire service |
| Totalowed | money | Amount due from customer including tax |
| Promiseddate | date | Promise date of completion |
| oemronumber | long | If the RO came from and RO lead, this the RO number provided by the lead source |
| Unit | array | Container for an array of Unit objects |