3PADealDetailFields Dealdetail Dealextralines

Fields – DealDetail.DealExtraLines

Field NameData TypeDescription, Example
DealerIdstringInternal Dealer Identifier (intentionally left blank)
DealNo (key)stringDeal (Worksheet) Number
DealUnitID (key)longDeal ID of the unit that the extra line corresponds to
FinInvoiceIDintDMS assigned ID of the deal when finalized – Corresponds to FinInvoiceID in DealDetail
LineNamestringExtra line description
ExtraLineNumber(key)stringNumber of extra line in deal
LineTypestringSpecifies front end FE or back end BE
AmountmoneyAmount on the extra line
CostmoneyCost of the extra line
TermintTerm of the extra line
arcustomerstringAR customer of unit extra line
apvendorstringAP vendor of unit extra line
mappingtypestringDescription of what the extra line maps to:
  • UNDEFINED
  • BATTERY_COVERAGE
  • BATTERY_FEE
  • CREDIT_CARD_FEES
  • DISCOUNT
  • DOC_AND_ADMIN_FEES
  • FREIGHT_SETUP_HANDLING
  • GAP
  • GIFT_CARDS
  • INSURANCE
  • LABOR
  • LENDER_FEES
  • LOYALTY_PROGRAMS
  • OEM_PROMOTIONS
  • OTHER
  • PAINT_AND_FABRIC
  • PREPAID_MAINTENANCE
  • ROADSIDE_ASSISTANCE
  • ROADSIDE_HAZARD
  • SECURITY
  • SERVICE_CONTRACT
  • SURFACE_PROTECTION
  • TAXES
  • TIRE_AND_WHEEL
  • TITLE_AND_REG_FEES
  • TRAVEL_ASSISTANCE