3PACustomerUnitInformationFields Customerunit

Fields – Customer Unit

Fields

Field NameData TypeDescription, Example
CmfstringLightspeed Dealer Id
DealerIdstringInternal Dealer Identifier (intentionally left blank)
Unitheaderid(key)bigintUnique Internal ID for the customer unit
DateGathereddatetimeTime that record was updated from dealer
customeridintCustomer ID
ModelYearintYear of the unit – 4 characters – free form
MakestringMake of the unit – free form
ModelstringModel of the unit – free form
VINstringVIN of the unit – free form
ClassstringDealer specified class code for this unit
CodeNamestringCode name or popular identifier for this unit
LocationstringLocation of the unit – free form
StoreLocationstringStore name the unit is located
OdometerstringMileage of the unit – Mi of Km
HoursdecimalHours of the unit
CylindersintCylinder count of the unit
HPdecimalHorsepower of the unit
BodyStylestringBody style of the unit
ColorstringColor of the unit
ConditionstringUnit condition – free form
LengthdecimalLength of unit
HeightdecimalHeight of unit
WidthdecimalWidth of unit
DraftdecimalDistance between waterline and bottom of keel
BeamdecimalWidth at unit’s widest point
GVWRintGross Vehicle Weight Rating
GDWintGross Dry Weight
InteriorColorstringInside color of unit
ExteriorColorstringOutside color of unit
ManufacturerstringMaker of the unit
UnitTypestringFree form unit class
FloorLayoutstringFree form layout ID
FuelTypestringType of fuel unit takes
UnitNamestringFree form description of unit
HullConstructionstringFree form type of hull
UserDefined1stringDealer configurable additional field on unit
UserDefined2stringDealer configurable additional field on unit
UserDefined3stringDealer configurable additional field on unit
UserDefined4stringDealer configurable additional field on unit
UserDefined5stringDealer configurable additional field on unit
UserDefined6stringDealer configurable additional field on unit
UserDefined7stringDealer configurable additional field on unit
UserDefined8stringDealer configurable additional field on unit
UserDefined9stringDealer configurable additional field on unit
UserDefined10stringDealer configurable additional field on unit
UserDefined11moneyDealer configurable additional field on unit
UserDefined12moneyDealer configurable additional field on unit
UserDefined13moneyDealer configurable additional field on unit
UserDefined14moneyDealer configurable additional field on unit
UserDefined15moneyDealer configurable additional field on unit
UserDefined16intDealer configurable additional field on unit
UserDefined17intDealer configurable additional field on unit
UserDefined18intDealer configurable additional field on unit
UserDefined19intDealer configurable additional field on unit
UserDefined20intDealer configurable additional field on unit
UserDefined1descstringDescription of Dealer configurable additional field on unit
UserDefined2descstringDescription of Dealer configurable additional field on unit
UserDefined3descstringDescription of Dealer configurable additional field on unit
UserDefined4descstringDescription of Dealer configurable additional field on unit
UserDefined5descstringDescription of Dealer configurable additional field on unit
UserDefined6descstringDescription of Dealer configurable additional field on unit
UserDefined7descstringDescription of Dealer configurable additional field on unit
UserDefined8descstringDescription of Dealer configurable additional field on unit
UserDefined9descstringDescription of Dealer configurable additional field on unit
UserDefined10descstringDescription of Dealer configurable additional field on unit
UserDefined11descstringDescription of Dealer configurable additional field on unit
UserDefined12descstringDescription of Dealer configurable additional field on unit
UserDefined13descstringDescription of Dealer configurable additional field on unit
UserDefined14descstringDescription of Dealer configurable additional field on unit
UserDefined15descstringDescription of Dealer configurable additional field on unit
UserDefined16descstringDescription of Dealer configurable additional field on unit
UserDefined17descstringDescription of Dealer configurable additional field on unit
UserDefined18descstringDescription of Dealer configurable additional field on unit
UserDefined19descstringDescription of Dealer configurable additional field on unit
UserDefined20descstringDescription of Dealer configurable additional field on unit
trimcolorstringColor of unit trim
unitconditionstringCondition of unit
carbcompliancestringIs the carburetor compliant – free form
drivetypestringType of drive on unit – free form
enginecyclesstringNumber of cycles in engine
powertypestringType of power for engine
starttypestringType of start for unit
numacunitsintNumber of AC units
sleepcapacityintHow many does the unit sleep
barlengthintBar length
bladelengthintBlade length
cuttingwidthintCutting width
numslideoutsintNumber of slide outs
turningradiusstringTurning radius
GreywatertankcapacityintGrey water tank capacity
BlackwatertankcapacityintBlack water tank capacity
HitchtypestringType of hitch
AxlenumberintNumber of axles on the unit
AxlecapacityintCapacity of each axle
Cylinders2intNumber of cylinders in second engine
Cylinders3intNumber of cylinders in third engine
PropulsionstringType of engine propulsion
HitchdryweightmoneyDry weight of the unit (no cargo, fluids)
NumberofwheelsintNumber of wheels on the unit
WheelsizestringSize of the wheels on the unit
FuelcapacitymoneyAmount of fuel the unit can carry
FreshwatertankcapacityintFresh water tank capacity
MaxcarrycapacitymoneyRepresents either max passenger capacity or max cargo capacity
Engine1displacementstringDisplacement of engine 1
Engine2displacementstringDisplacement of engine 2
Engine3displacementstringDisplacement of engine 3
engine1namestringThe name of engine 1 free form text
HP2intHorsepower of engine 2
HP3intHorsepower of engine 3
HullnumberstringSerial number of the hull
PlatenostringPlate number of the unit
crsidstringAssociated CRS unit id

:::tip Best Practice It may make more sense to call this using customerid as a filter instead of pulling the entire data set. :::