Fields – Unit/SoldUnit

Field Name	Data Type	Description, Example
Cmf	sting	Lightspeed Dealer Id
DealerId	sting	Internal Dealer Identifier (intentionally left blank)
MajorUnitHeaderId (key)	bigint	System identifier for major unit record
DateGathered	datetime	Nullable – current dealer system time
lastupdatedate	date	Last time the unit record was updated
StockNumber	string	Dealer specified unit identifier - non-unique
NewUsed	string	N = New, U = Used, C = Consigned, X = Undefined
ModelYear	int	Nullable - Year of the unit – 4 characters – free form
Make	string	Make of the unit – free form
Model	string	Model of the unit – free form
VIN	string	VIN of the unit – free form
Class	string	Dealer specified class code for this unit
CodeName	string	Code name or popular identifier for this unit – this is also the ‘Model Name’
Location	string	Physical location of the unit – free form
StoreLocation	string	Name of store the unit is located
Odometer	string	Mileage of the unit – Mi or Km
Hours	decimal	Nullable – hours of the unit
Cylinders	int	Nullable - Cylinder count of the unit
HP	decimal	Nullable - Horsepower of the unit
BodyStyle	string	Body style of the unit
Color	string	Color of the unit
Condition	string	Unit condition – free form
InvoiceDate	datetime	Nullable - Date invoice was associated to the unit
InvoiceAmt	money	Nullable - Cost of unit when it was associated to the invoice
PackAmt	money	Nullable - Pack amount
Holdback	money	Nullable - Holdback amount
FreightCost	money	Nullable - Freight cost of unit
DSRP	money	Nullable - Dealer Suggested Retail Price
laborprepamount	money	Price charged to customer for prep
laborprepcost	money	Cost to dealer for prep
MSRP	money	Nullable - Manufacturer Suggested Retail Price
OnHold	string	Deal Number or reason for hold – empty string if not on hold
PackageID	string	Nullable - Internal Package Identifier. To compute the total package price, aggregate all relevant price fields from units that share the same PackageID.
DateReceived	datetime	Nullable - Date when the unit arrived at dealership
Length	decimal	Nullable - Length of unit
Height	decimal	Nullable - Height of unit
Width	decimal	Nullable - Width of unit
Draft	decimal	Nullable - Distance between waterline and bottom of keel
Beam	decimal	Nullable - Width at unit’s widest point
GVWR	int	Nullable - Gross Vehicle Weight Rating
GDW	int	Nullable - Gross Dry Weight
InteriorColor	string	Inside color of unit
ExteriorColor	string	Outside color of unit
Manufacturer	string	Maker of the unit
UnitType	string	Free form unit class
FloorLayout	string	Free form layout ID
FuelType	string	Type of fuel unit takes
UnitName	string	Free form description of unit
HullConstruction	string	Free form type of hull
Comments	string	Free form text field
UnitStatus	string	Found in Unit: ‘blank’ = Available R = Requested O = On Order Found in SoldUnit: S = Sold T = Trade E = Rental P = Temp C = Create a Unit B = Base Unit X = Transferred M = CEM V= Voided
UserDefined1	string	Dealer configurable additional field on unit
UserDefined2	string	Dealer configurable additional field on unit
UserDefined3	string	Dealer configurable additional field on unit
UserDefined4	string	Dealer configurable additional field on unit
UserDefined5	string	Dealer configurable additional field on unit
UserDefined6	string	Dealer configurable additional field on unit
UserDefined7	string	Dealer configurable additional field on unit
UserDefined8	string	Dealer configurable additional field on unit
UserDefined9	string	Dealer configurable additional field on unit
UserDefined10	string	Dealer configurable additional field on unit
UserDefined11	money	Nullable - Dealer configurable additional field on unit
UserDefined12	money	Nullable - Dealer configurable additional field on unit
UserDefined13	money	Nullable - Dealer configurable additional field on unit
UserDefined14	money	Nullable - Dealer configurable additional field on unit
UserDefined15	money	Nullable - Dealer configurable additional field on unit
UserDefined16	int	Nullable - Dealer configurable additional field on unit
UserDefined17	int	Nullable - Dealer configurable additional field on unit
UserDefined18	int	Nullable - Dealer configurable additional field on unit
UserDefined19	int	Nullable - Dealer configurable additional field on unit
UserDefined20	int	Nullable - Dealer configurable additional field on unit
UserDefined1desc	string	Description of Dealer configurable additional field on unit
UserDefined2desc	string	Description of Dealer configurable additional field on unit
UserDefined3desc	string	Description of Dealer configurable additional field on unit
UserDefined4desc	string	Description of Dealer configurable additional field on unit
UserDefined5desc	string	Description of Dealer configurable additional field on unit
UserDefined6desc	string	Description of Dealer configurable additional field on unit
UserDefined7desc	string	Description of Dealer configurable additional field on unit
UserDefined8desc	string	Description of Dealer configurable additional field on unit
UserDefined9desc	string	Description of Dealer configurable additional field on unit
UserDefined10desc	string	Description of Dealer configurable additional field on unit
UserDefined11desc	string	Description of Dealer configurable additional field on unit
UserDefined12desc	string	Description of Dealer configurable additional field on unit
UserDefined13desc	string	Description of Dealer configurable additional field on unit
UserDefined14desc	string	Description of Dealer configurable additional field on unit
UserDefined15desc	string	Description of Dealer configurable additional field on unit
UserDefined16desc	string	Description of Dealer configurable additional field on unit
UserDefined17desc	string	Description of Dealer configurable additional field on unit
UserDefined18desc	string	Description of Dealer configurable additional field on unit
UserDefined19desc	string	Description of Dealer configurable additional field on unit
UserDefined20desc	string	Description of Dealer configurable additional field on unit
PartsDealerAddCost	money	Cost of Dealer Addition Parts
LaborDealerAddCost	money	Cost of Dealer Addition Labor
SubletDealerAddCost	money	Cost of Dealer Addition Sublet
PartsCustomerAddCost	money	Cost of Customer Addition Parts
LaborCustomerAddCost	money	Cost of Customer Addition Labor
SubletCustomerAddCost	money	Cost of Customer Addition Sublet
WebUnit	tinyint	1 – unit can be shown on website 0 – should not be shown
WebTitle	string	Short description to be displayed on website
WebDescription	string	Long description to be displayed on website (10000 characters)
WebPrice	money	Nullable - Price of unit to be displayed on website
WebPriceHidden	tinyint	Nullable - Flag to indicate dealer should be called for price
titlestatus	string	Status of unit title
trimcolor	string	Color of unit trim
unitcondition	string	Condition of unit
carbcompliance	string	Is the carburetor compliant – free form
drivetype	string	Type of drive on unit – free form
enginecycles	string	Number of cycles in engine
powertype	string	Type of power for engine
starttype	string	Type of start for unit
numacunits	int	Number of AC units
sleepcapacity	int	How many does the unit sleep
barlength	int	Bar length of chain saw
bladelength	int	Blade length of lawn mower
cuttingwidth	int	Cutting width of lawn mower
videourl	string	URL of video set in DMS
numslideouts	int	Number of slide outs
turningradius	string	Turning radius
flooredby	string	Who floored this unit
floorplan	string	What plan does this flooring have
planstartingdate	date	Nullable - Date of plan start
planendingdate	date	Nullable - Date of plan end
originalamt	money	Nullable - How much unit was floored for
originaldate	date	Nullable - When the unit was floored
curtailmentamt	money	Nullable - How much has been curtailed
curtailmentdate	date	Nullable - When the unit was curtailed
flooredbalance	money	Nullable - Amount left on unit flooring
Greywatertankcapacity	int	Nullable - Grey water tank capacity
Blackwatertankcapacity	int	Nullable - Black water tank capacity
Freight	money	Nullable - Amount dealer is charging customer from freight
Ordernumber	money	Dealer specified order number when the unit was created
Ordereta	money	Nullable - ETA of unit order
Estimatedsetupamt	string	Nullable - Estimated unit setup amount
Partsprepamount	datetime	Nullable - Price of parts prep
Partsprepcost	money	Nullable - Cost of parts prep
Discountpercentagefromdsrp	money	Dealer specified discount percentage against DSRP
Priceprotectionrebate	money	Price Protection Rebate from the manufacturer if retail changes for the dealer
Manufacturertocustomerrebate	money	Rebate to customer set from manufacturer
Manufacturertodealerrebate	money	Rebate to dealer set from manufacturer
Optionsamount	money	Price of options on unit
Optionscost	money	Nullable - Cost of options on unit
Hitchtype	string	Nullable - Type of hitch
Axlenumber	int	Number of axles on unit
Axlecapacity	int	Axle rating on unit
Cylinders2	int	Cylinder count on engine 2
Cylinders3	int	Cylinder count on engine 3
Propulsion	string	Nullable - Type of engine propulsion
Hitchdryweight	money	Dry weight of the unit (no fluids, cargo, passengers)
Numberofwheels	int	Number of wheels on the unit
Wheelsize	string	Size of wheels on the unit
Fuelcapacity	int	Quantity of fuel that the unit can hold
Freshwatertankcapacity	int	Nullable - Fresh water tank capacity
Maxcarrycapacity	money	Could be max passenger capacity or max cargo capacity
Engine1displacement	string	Displacement of engine 1
Engine2displacement	string	Displacement of engine 2
Engine3displacement	string	Displacement of engine 3
HP2	int	Horsepower rating of engine 2
HP3	int	Horsepower rating of engine 3
Marginprotectionamount	money	Dealer specified margin threshold
Manufacturerlistprice	money	Manufacturer specified price of unit
Dealerlistprice	money	Dealer specified price of unit
userdefinedamt1	decimal	Dealer defined field used for reporting
userdefinedamt2	decimal	Dealer defined field used for reporting
userdefinedamt3	decimal	Dealer defined field used for reporting
consignment	int	Flag that indicates the unit is on consignment
consignmentowner	string	Name of consignment unit owner
consignmentamount	decimal	Requested amount from consignment
tradedealid	bigint	If populated, then this unit was a trade
dealerbaseprice	decimal	Dealer price of unit before parts and labor
certified	boolean	Indicates this is a certified used unit
onholddate	date	Date when unit was put on hold
basecost	money	Dealer estimated base cost
basefreightcost	money	Dealer estimated freight cost
unitcostdiscount	money	Dealer estimated discount
manufacturer	string	Manufacturer of the unit
orderdate	date	Date the unit was ordered
chassisvin	string	VIN of the chassis
servicecontractamount	money	Amount of the service contract
Servicecontractterm	int	Term of the service contract
crsid	string	Associated CRS unit id
Oemestarrivaldate	Datetime	OEM estimated arrival date
MajorUnitSalesCategory	string	Dealer assigned sales category
PurchasedFrom	string	Name the unit was purchased from
totalActualCost	money	Convenience field – sums of invoiceamt + freightcost + partsprepcost + laborprepcost + PartsDealerAddCost + LaborDealerAddCost + SubletDealerAddCost + PartsCustomerAddCost + LaborCustomerAddCost + SubletCustomerAddCost
totalCost	money	Convenience field – sums of invoiceamt + freightcost+ partsprepcost+ laborprepcost
enginenumber1	string	Engine 1 free form text
enginenumber2	string	Engine 2 free form text
enginenumber3	string	Engine 3 free form text
engine1name	string	The name of engine 1 free form text
keynumber	string	Key Number free form text
Parts	array	Container for an array of Part objects
Labor	array	Container for an array of Labor objects
Options	array	Container for an array of Option objects
Images	array	Container for an array of Image objects
Npa Value Guide	array	Container for an array of Npa Value objects
Nada Value Guide	array	Container for an array of Nada Value objects
Black Book Value Guide	array	Container for an array of Black Book Value objects
Blue Book Value Guide	array	Container for an array of Blue Book Value objects

Fields Unit Parts Fields Unit Soldunit Appliances