Fields - ServiceDet
| 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 | bigint | |
| CommonInvoiceID | ||
| 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 the 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 |
| TotsubCost | money | Total cost of sublet work |
| TotsubSales | money | Total price of sublet work |
| Servicewriterid | bigint | DMS ID of service writer |
| 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 |
| Category | string | Category assigned to RO |
| Totalowed | money | Total amount due from customer including tax |
| promiseddate | date | Promise date of completion |
| Unit | array | Container for an array of Unit objects |
| ROSubletID | long | System generated ID of sublet item |
| Requestedqty | int | Amount of parts requested |
| Specialorderqty | int | Amount of parts special ordered |
| Promiseddate | date | Date promised to customer for RO completion |
| oemronumber | long | If the RO came from an RO lead, this is the RO number given by the lead provider |