Fields - OpenDealDetail

Field Name	Data Type	Description, Example
Cmf(key)	string	Lightspeed Dealer Identifier
DealerId	string	Internal Dealer Identifier (intentionally left blank)
DealId (key)	string	System generated unique identifier
DealNo	string	External DMS deal identifier
FinInvoiceID	int	Internal DMS deal identifier
FinanceDate	date	Date deal was finalized
OriginatingDate	date	Date deal was created
DeliveryDate	date	Date unit was delivered to customer
lastmodifieddate	datetime	Date deal record was last modified
salesmanid	string	DMS Id of salesperson
dealstate	string	State of the deal – Quote, Deal, Lead, Canceled Quote, Voided Deal, Inactive Deal
sourcetype	string	Lead type of source
clpremium	money	Price of CL on deal
clcost	money	Cost of CL on deal
ahpremium	money	Price of Accident & Health insurance on deal
ahcost	money	Cost of Accident & Health insurance on deal
CustID	string	DMS customer identifier
lienholder	string	Lien holder on the deal
lienaddressfirstline	string	Address of Lienholder
lienaddresssecondline	string	Address of Lienholder
liencity	string	City of Lienholder
lienzip	string	Zip of Lienholder
lienstate	string	State/Providence of Lienholder
AmtFinanced	money	Amount financed on deal
Term	int	Term of financing
Rate	money	Rate of financing
Payment	money	Monthly payment of financing
DaysToFirst	int	How many days until first payment
SalesmanName	string	Name of salesperson
totaldownpayment	money	Total monies received for down payment
fincharge	money	Financing charge
fincost	money	Cost of financing
cobuyercustid	string	In store identifier of co-buyer
cobuyername	string	Name of co-buyer
cobuyeraddr	string	Address of co-buyer
cobuyeraddr2	string	Additional address of co-buyer
cobuyercity	string	City of co-buyer
cobuyerstate	string	State of co-buyer
cobuyerzip	string	Zip code of co-buyer
cobuyercounty	string	County of co-buyer
cobuyerhomephone	string	Home phone of co-buyer
cobuyerworkphone	string	Work phone of co-buyer
cobuyercellphone	string	Cell phone of co-buyer
cobuyeremail	string	Email of co-buyer
cobuyerbirthdate	string	Birthdate of co-buyer
Salesman2name	string	Name of the second salesman on the deal
Salesman2id	int	ID of the second salesman on the deal
Salesmanfi1id	int	ID of the first F&I person on the deal
Salesmanfi1name	string	Name of the first F&I person on the deal
Salesmanfi2id	int	ID of the second F&I person on the deal
Salesmanfi2name	string	Name of the second F&I person on the deal
Salesman1split	money	Percentage of the deal that goes to the first salesman
Salesman2split	money	Percentage of the deal that goes to the second salesman
stagename	string	Description of deal’s current stage
source	string	Description of where the deal originated
totalcashprice	money	Total price of the unit, options, freight, prep, fees and extras, and tax
totalprevpymt	money	Total of all previous deposits
additionalpymttoday	money	Additional deposits required
deferredamt	money	Deferred payment amount used in financing
extra1amt	money	User defined amount field
balancetofinance	money	Balance prior to financing
totalofpayments	money	Balance after financing
addonrate	money	Additional interest rate on APR
aprbuyrate	money	APR buy rate
addonbuyrate	money	Additional interest on APR buy rate
balloonterm	money	Duration of balloon finance
balloonpayment	money	Calculated payment for balloon financing
ins1amt	money	Calculated insurance price from formula
ins1cost	money	Calculated insurance cost from formula
ins2amt	money	Calculated insurance price from formula
ins2cost	money	Calculated insurance cost from formula
ins3amt	money	Calculated insurance price from formula
ins3cost	money	Calculated insurance cost from formula
ins4amt	money	Calculated insurance price from formula
ins4cost	money	Calculated insurance cost from formula
ins5amt	money	Calculated insurance price from formula
ins5cost	money	Calculated insurance cost from formula
ins6amt	money	Calculated insurance price from formula
ins6cost	money	Calculated insurance cost from formula
insurancetaxtotal	money	Total sum tax calculated from insurance prices
femargin	money	Front end margin
bemargin	money	Back end margin
createdate	datetime	Date deal record was created
customerextraline	string	Dealer notes pertaining to deal
customernotes	string	Dealer notes pertaining to customer
salesmanusername	string	User name of deal sales person
fincostoverride	money	Dealer specified finance cost
isfincostoverride	boolean	Denotes if dealer is overriding finance cost
firstlienaddressfirstline	string	First address line of first lienholder
firstlienaddresssecondline	string	Second address line of first lienholder
firstliencity	string	City of first lienholder
firstlienzip	string	Zip code of first lienholder
firstlienstate	string	State/Prov of first lienholder
salestaxtotal	money	Sum of all tax under sales tax category
vehicletaxtotal	money	Sum of all tax under vehicle tax category
salesagent1	string	Name of first sales agent
salesagent2	string	Name of second sales agent
salesagent3	string	Name of third sales agent
salesagent1id	long	ID for the first sales agent
salesagent2id	long	ID for the second sales agent
salesagent3id	long	ID for the third sales agent
salesagent1username	string	Username of first sales agent
salesagent2username	string	Username of second sales agent
salesagent3username	string	Username of third sales agent
salesmanager	string	Name of sales manager
dealdescription	string	Dealer entered description of deal
lhphonenumber	string	Phone number of lien holder
Units	array	Container for an array of Unit objects
Trade	array	Container for an array of Trade objects
DealExtraLines	array	Container for an array of Deal Extra Line objects
DealProspect	array	Container for an array of Deal Prospect objects

Fields Opendealdetail Unit Example JSON Result