Deal Fields (for Sold Vehicles)

Deal No

Deal number of sold vehicle

Sold Date

Vehicle sold date

Sold Odometer

Odometer at time of vehicle sale

Sold To

Name of buyer

LoanAcquisitionCostCur

Loan acquition cost

Margin

Margin = Selling Price - Base Cost - Option Cost - Other Cost - PAK

Total Cost

Total Cost = Base Cost + Option Costs + Other Costs + Repair Order Costs + PAK

Warranty Profit

Warranty profit

Days to Sell

Days on lot before vehicle sold

Deal Date Month

Month as a number of deal date

Deal Date Month Name

Month of the deal date

Deal Date Year

Numeric year of deal date

NU

New, Used, Wholesale or Consignment sale

Main Fields

Axles

Axles

Base Cost

Base Cost (Inventory)

BottomLinePriceCur

Bottom line price

Chassis

Vehicle chassis manufacturer (RVs etc.)

Color

Exterior Color

Consignment

Is vehicle on consignment (1 = yes)

Cylinders

Number of cylinders

Date in Inventory

Date vehicle arrived in inventory

Days in Inventory

Current days on lot

Days in Service

Days since vehicle was placed into service

Dealer

Dealership index number for multi-dealership setup

Dealer Field 1

Optional field #1

Dealer Field 2

Optional field #2

Dealer Field 3

Optional field #3

Dealer Field 4

Optional field #4

Dealer Field 5

Optional field #5

Dealer Field 6

Optional field #6

Dealer Internal

Internal dealer information

Dealer YesNo Field 1

Optional Yes/No Field #1

Dealer YesNo Field 2

Optional Yes/No Field #2

Dealer YesNo Field 3

Optional Yes/No Field #3

Dealer YesNo Field 4

Optional Yes/No Field #4

Demo=1

Is vehicle demo unit (1=yes)

Description

Vehicle description

Done Send to Web

Don't send vehicle to web (1=yes)

FWD,RWD,AWD or 4WD

Drive type (FWD,RWD,AWD,4WD)

eBay BuyitNow

eBay buy it now price

eBay Exterior Color

eBay exterior color

eBay Interior Color

eBay interior color

eBay Reserve

eBay reserve price

eBay Starting Bid

eBay starting bid amount

Engine Make

Engine make

Floor Plan

Floor plan amount

Floor Plan ID

Floor plan ID number

Floor Plan Source

Floor plan source

Fuel

Fuel type

Gross Weight

Gross vehicle weight

In Service Date

Inservice date

Inspection Date

Inspection date (NY)

Interior Color

Interior color

Key No

Vehicle key number (generally for new vehicles)

Length

Length

Liters

Engine size in liters

Make

Make

Model

Model

Model Number

Model number

MSRP

M.S.R.P.

New=0,Used=1

New or Used (New=0,Used=1,In Transit=2,Wholesale=3)

Odometer

Odometer on arrival

Option Cost

Cost of vehicle options

Option List

List of vehicle options

Option Price

Selling price of vehicle options

Order Date

Order date for vehicle

Other Cost

Other vehicle costs

PAK

PAK cost

Passengers

Passengers

PicCount

Picture count

Price Sold At

Price the vehicle was sold for

Repair Order Cost

Total repair order costs

Selling Price

Asking price of vehicle

Serial Number 2

2nd serial number (RVs)

VIN/Serial No

Vehicle Identification Number

Soft Option Price

Soft option price (for leasing)

Stock Number

Stock Number

Style

Vehicle style

Tag Exp

Tag expiration date of plate with vehicle

Tag/Plate No

Tag number of plate with vehicle

Title Number

Title number

title State

Title number state

Transmission

Transmission type and speeds

Trim Level

Vehicle trim level

Trunk Key

2nd key number (glove box or trunk if different)

Vehicle Type

Car, Truck, VAN, SUV, etc.

Unladen Weight

Unladen weight of vehicle

Warranty Description

Vehicle warranty description

Web Down Money

Required down payment posted on web site

Web Pmt

Payment to advertise on web site

Web Pmt Type

Payment type (weekly, monthly, bi-weekly, semi-monthly)

Year

Model Year

On Hold Information

On Hold

Is vehicle on hold (1=yes)

On Hold Agreement

On hold agreement exists (1=yes)

On Hold City

On hold city

On Hold Date

Date vehicle was put on hold

On Hold Deposit

On hold deposit

On Hold Est. Delivery Date

Estimated delivery date of vehicle

On Hold Expires Date

On hold expiration date

On Hold Name

On hold name

On Hold Phone

On hold phone

On Hold Salesperson

On hold salesperson

On Hold State

On hold state

On HOld Street

On hold street

On Hold Zip

On hold zip code

Supplier Information

Supplier

Where or who vehicle was purchased from

Supplier City

City of supplier

Supplier Phone Number

Phone number of supplier

Supplier State

State of supplier

Supplier Street

Street of supplier

Supplier Zip Code

Zip Code of supplier