3PAServiceSummaryFields Servicesum

Fields – ServiceSum

Fields

Field NameData TypeDescription, Example
CmfstringLightspeed Dealer Identifier
DealerIdstringInternal Dealer Identifier (intentionally left blank)
ROHeaderID(key)intDMS internal identifier of RO
ROUnitID(key)intUnit identifier on the RO
ROJobID(key)intJob identifier on the RO
ronostringDMS external (customer facing) RO identifier
CommonInvoiceIdintDMS assigned ID of the repair order when cashiered
JobDescriptionstringFree form description of RO job
JobTitlestringFree form title of RO job
InternalJobbyte1 – Internal, 0 – Not internal
WarrantyJobbyte1 – Warranty, 0 – Not warranty
VINstringVIN of unit
MakestringMaker of the unit
ModelstringModel of the unit
YearstringModel year of the unit
CashieredDatedateDate RO was paid
PartsPricemoneyPrice of all parts on the RO
LaborPricemoneyPrice of all labor on the RO
shopsupplymoneyPrice of shop supplies on the RO
MiscPricemoneySum of all misc charges on the RO
custidstringDMS customer identifier

Notes

Notes:

  1. Use ROHeaderId or CashieredDate to determine changes
  2. ServiceSum displays the summary of each job on the repair order