Deal Fields (for Sold Vehicles)

Deal_No

Deal number of sold vehicle

SoldDate

Vehicle sold date

SoldOdometer

Odometer at time of vehicle sale

SoldTo

Name of buyer

LoanAcquisitionCostCur

Loan acquition cost

Margin

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

TotalCost

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

WarrProfit

Warranty profit

DaystoSell

Days on lot before vehicle sold

DealDateMonth

Month as a number of deal date

DealDateMonthName

Month of the deal date

DealDateYear

Numeric year of deal date

NU

New, Used, Wholesale, Consignment

Primary Fields

Axles

Axles

BaseCost

Base Cost (Inventory)

BottomLinePriceCur

Bottom line price

CostCode

Left 4 digits of VIN + Fixed 6 digit Base Cost

Chassis

Vehicle chassis manufacturer (RVs etc.)

Color

Exterior Color

Consignment

Is vehicle on consignment (1 = yes)

Cylinders

Number of cylinders

DateInInventory

Date vehicle arrived in inventory

DaysinInventory

Current days on lot

DaysinService

Days since vehicle was placed into service

Dealer

Dealership index number for multi-dealership setup

DealerField1

Optional field #1

DealerField2

Optional field #2

DealerField3

Optional field #3

DealerField4

Optional field #4

DealerField5

Optional field #5

DealerField6

Optional field #6

DealerInternal

Internal dealer information

DealerYesNo1

Optional Yes/No Field #1

DealerYesNo2

Optional Yes/No Field #2

DealerYesNo3

Optional Yes/No Field #3

DealerYesNo4

Optional Yes/No Field #4

Demo

Is vehicle demo unit (1=yes)

Description

Vehicle description

DontSendTF

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

DriveType

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

eBayBuyitNow

eBay buy it now price

eBayExtColor

eBay exterior color

eBayIntColor

eBay interior color

eBayReserve

eBay reserve price

eBayStartingBid

eBay starting bid amount

EngineMake

Engine make

ExcludedWebFeedsStr

List of web sites to exclude from web feed

FloorCost

Estimated floor costs

FloorPlan

Floor plan amount

FloorPlanID

Floor plan ID number

FloorPlanSource

Floor plan source

Fuel

Fuel type

GrossWt

Gross vehicle weight

InServiceDate

Inservice date

InspectionDate

Inspection date (NY)

InteriorColor

Interior color

Key

Vehicle key number (generally for new vehicles)

Length

Length

Liters

Engine size in liters

Make

Make

Model

Model

ModelNumber

Model number

MSRP

M.S.R.P.

NewUsed

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

Odometer

Odometer on arrival

OptionCost

Cost of vehicle options

OptionList

List of vehicle options

OptionPrice

Selling price of vehicle options

OrderDate

Order date for vehicle

OtherCost

Other vehicle costs

PAK

PAK cost

Passengers

Passengers

PicCount

Picture count

PriceSoldAt

Price the vehicle was sold for

RepairOrderCost

Total repair order costs

SellingPrice

Asking price of vehicle

SerialNum2

2nd serial number (RVs)

SerialNumber

Vehicle Identification Number

SoftOption

Soft option price (for leasing)

StockNumber

Stock Number

Style

Vehicle style

TagExpDate

Tag expiration date of plate with vehicle

TagNumber

Tag number of plate with vehicle

titleNumber

Title number

TitleStateStr

Title number state

Transmission

Transmission type and speeds

TrimLevel

Vehicle trim level

TrunkKey

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

Type

Car, Truck, VAN, SUV, etc.

UnladenWt

Unladen weight of vehicle

WarrantyDesc

Vehicle warranty description

WebDownPmt

Required down payment posted on web site

WebPmt

Payment to advertise on web site

WebPmtType

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

Year

Model Year

On Hold Fields

OnHold

Is vehicle on hold (1=yes)

OnHoldAgreementTF

On hold agreement exists (1=yes)

OnHoldCity

On hold city

OnHoldDate

Date vehicle was put on hold

OnHoldDeposit

On hold deposit

OnHoldEstDeliveryDate

Estimated delivery date of vehicle

OnHoldExpiresDate

On hold expiration date

OnHoldName

On hold name

OnHoldPhone

On hold phone

OnHoldSalesperson

On hold salesperson

OnHoldState

On hold state

OnHoldStreet

On hold street

OnHoldZip

On hold zip code

Supplier Fields

BoughtFrom

Where or who vehicle was purchased from

SupplierCity

City of supplier

SupplierPhoneNumber

Phone number of supplier

SupplierState

State of supplier

SupplierStreet

Street of supplier

SupplierZipCode

Zip Code of supplier