Fields - OpenDealDetail.Unit

Field Name	Data Type	Description, Example
DealerId	string	Internal Dealer Identifier (intentionally left blank)
DealUnitID (key)	long	Unit id on the deal
DealNo (key)	string	External DMS deal identifier
Newused	string	N – New, U - Used
Year	string	Model year of unit
Make	string	Maker of unit
Model	string	Model of unit
VIN	string	VIN of unit
unittype	string	Description of type of unit
Class	string	Dealer assigned class for unit
Unitprice	money	Price of the unit
UnitLength	number	Length of the unit
Width	number	Width of the unit
Height	number	Height of the unit
mucost	money	Cost of the unit
Freight	money	Price of freight
Freightcost	money	Cost of freight
Handling	money	Price of handling
Handlingcost	money	Cost of handling
Licfees	money	Price of licensing fees
LicFeesCost	money	Cost of licensing fees
Totaccy	money	Price of all accessories on deal
Totinstall	money	Price of installation
Tradeall	money	Trade allowance on deal
Tradeacv	money	Trade ACV
Accycost	money	Cost of accessories on unit
Installcost	money	Cost of installation
DateReceived	date	Date trade was received
servcont	money	Price of service contract
sccost	money	Cost of service contract
probliab	money	Price of Property Liability
plcost	money	Cost of Property Liability
PackAmt	money	Pack amount
Holdback	money	Holdback amount
docfees	money	Documentation Feeds
UnitSoldPrice	money	Unitprice+freight+handling-Tradeall+Traceacv+Totaccy+totinstall
UnitSoldCost	money	This is calculated outside of the DMS and intended as a convenience field. MUCost + FreightCost + HandlingCost + AccyCost + InstallCost
TotalPartsAmount	money	Sum(qty*price)
DaysInStore	int	(CurrentTime) – DateReceived displayed in days
UnitLine1	money	Amount from user configurable field
UnitLine2	money	Amount from user configurable field
UnitLine3	money	Amount from user configurable field
UnitLine4	money	Amount from user configurable field
UnitLine5	money	Amount from user configurable field
UnitLine6	money	Amount from user configurable field
UnitLine7	money	Amount from user configurable field
UnitLine8	money	Amount from user configurable field
UnitLine9	money	Amount from user configurable field
UnitLine10	money	Amount from user configurable field
UnitLine11	money	Amount from user configurable field
UnitLine12	money	Amount from user configurable field
UnitLine13	money	Amount from user configurable field
UnitLine14	money	Amount from user configurable field
UnitLine15	money	Amount from user configurable field
UnitLine16	money	Amount from user configurable field
UnitLine17	money	Amount from user configurable field
UnitLine18	money	Amount from user configurable field
UnitLine19	money	Amount from user configurable field
UnitLine20	money	Amount from user configurable field
UnitLine1cost	money	Amount from user configurable field
UnitLine2cost	money	Amount from user configurable field
UnitLine3cost	money	Amount from user configurable field
UnitLine4cost	money	Amount from user configurable field
UnitLine5cost	money	Amount from user configurable field
UnitLine6cost	money	Amount from user configurable field
UnitLine7cost	money	Amount from user configurable field
UnitLine8cost	money	Amount from user configurable field
UnitLine9cost	money	Amount from user configurable field
UnitLine10cost	money	Amount from user configurable field
UnitLine12cost	money	Amount from user configurable field
UnitLine11cost	money	Amount from user configurable field
UnitLine13cost	money	Amount from user configurable field
UnitLine14cost	money	Amount from user configurable field
UnitLine15cost	money	Amount from user configurable field
UnitLine16cost	money	Amount from user configurable field
UnitLine17cost	money	Amount from user configurable field
UnitLine18cost	money	Amount from user configurable field
UnitLine19cost	money	Amount from user configurable field
UnitLine20cost	money	Amount from user configurable field
Color	string	Color of unit
Odometer	string	Mileage of unit
stocknumber	string	Dealer made identifier of unit
deposit	money	Deposit put on deal
bodytype	string	Dealer description of the unit bodytype
enginenumber	string	Engine number as input by the dealer
cylinders	int	Number of cylinders in the engine
gvwr	money	Unit GVWR
fueltype	string	Type of fuel the unit takes
majorunitsalescategory	string	Category of unit on deal
servcontterm	int	Term of service contract
unitline4term	string	Currently set to 0
unitline5term	string	Currently set to 0
unitline6term	string	Currently set to 0
unitline10term	string	Currently set to 0
unitline11term	string	Currently set to 0
unitline12term	string	Currently set to 0
plateno	string	License plate number of unit
customerunitid	int	Set to the unit ID
packageid	long	Major unit header ID of unit
modelname	string	Alternate model name of unit
majorunitid	int	System identifier corresponds to majorunitheaderid record
manufacturer	string	Manufacturer of the unit
msrp	money	MSRP of the unit
Taxableamounttotal	money	Amount that can be taxed
taxpercent	money	Tax percent of the unit
salestaxpercent	money	Sales tax percent of the unit
vehicletaxpercent	money	Vehicle tax percent of the unit
Certified	boolean	Specified by dealer for certified used status
partscustomeraddtaxablecost	money	Sum of cost of parts added to the unit as customer add that are taxable
partscustomeraddnontaxablecost	money	Sum of cost of parts added to the unit as customer add that are non-taxable
partsdealeraddtaxablecost	money	Sum of cost of parts added to the unit as dealer add that are taxable
partsdealeraddnontaxablecost	money	Sum of cost of parts added to the unit as dealer add that are non-taxable
laborcustomeraddtaxablecost	money	Sum of cost of labor added to the unit as customer add that are taxable
laborcustomeraddnontaxablecost	money	Sum of cost of labor added to the unit as customer add that are non-taxable
labordealeraddtaxablecost	money	Sum of cost of labor added to the unit as dealer add that are taxable
labordealeraddnontaxablecost	money	Sum of cost of labor added to the unit as dealer add that are non-taxable
ManufacturerDealerRebate	money	Rebate to dealer set from manufacturer
PriceProtection	money	Price Protection Rebate from the manufacturer if retail changes for the dealer
YearEndDiscount	money	Discount on unit at the end of the year
isprimary	int	Indicator if the units is the primary vehicle of a package
primaryunitid	long	References the primary units DealUnitId if in a package
Parts	array	Container for an array of Part objects

Fields Opendealdetail Unit Parts Fields Opendealdetail