Collateral Table

Field Name

Description

Length

Data Type

Parent Table and Field

Import Types

ID

Code that Latitude assigned to identify the auction record in Latitude.

4

Integer

None

NB, M

AccountID

Code that identifies the Latitude account associated to the piece of collateral.

4

Integer

Master/Number

NB, M

Sequence

Client internal identifier for each piece of collateral

30

VarChar

None

NB, M

Description

Description of the vehicle.

150

VarChar

None

NB, M

CollateralYear

Vehicle model year.

4

Integer

None

NB, M

Make

Vehicle manufacturer.

28

VarChar

None

NB, M

Model

Vehicle model.

28

VarChar

None

NB, M

VIN

Vehicle Identification Number.

30

VarChar

None

NB, M

Addons

Optional features on the vehicle.

200

VarChar

None

NB, M

Color

Color of the vehicle.

20

VarChar

None

NB, M

CollateralMilesHours

Number of miles or hours on the vehicle.

10

VarChar

None

NB, M

MilesHours

Indicates whether the vehicle usage is measured in miles or hours.

4

Integer

None

NB, M

CollateralDamaged

Indicates whether the lienholder considers the vehicle damaged.

1

Bit

None

NB, M

CollateralTotaled

Indicates whether the lienholder considers the vehicle totaled.

1

Bit

None

NB, M

ConditionDescription

Description of the condition of the vehicle.

300

VarChar

None

NB, M

CollateralDrivable

Indicates whether the vehicle is drivable.

1

Bit

None

NB, M

SellCollateral

Indicates whether the lienholder intends to sell the vehicle for collateral.

1

Bit

None

NB, M

IgnitionKeyNumber

Number that identifies the ignition key.

10

VarChar

None

NB, M

OtherKeyNumber

Number that identifies an extra vehicle key, such as the valet key.

10

VarChar

None

NB, M

TagDecalState

State listed on the vehicle's license plate.

2

Char

None

NB, M

TagDecalNumber

Vehicle's license plate number.

10

VarChar

None

NB, M

TagDecalYear

Vehicle's license plate year.

4

Integer

None

NB, M

TitlePosition

Type of title (for example, original, duplicate).

2

SmallInt

None

NB, M

TitleState

State listed on the vehicle's title.

2

Char

None

NB, M

HaveTitle

Indicates whether your organization has the vehicle's title.

1

Bit

None

NB, M

LienOnFile

Indicates whether a lien is on file with the state.

1

Bit

None

NB, M

TitleRequestedDate

Indicates the date the lienholder requested the vehicle's title from the state.

8

DateTime

None

NB, M

TitleReceivedDate

Indicates the date the lienholder received the vehicle's title from the state.

8

DateTime

None

NB, M

RepoTitleOrderedDate

Date the lienholder ordered a repossession title for the vehicle.

8

DateTime

None

NB, M

RepoTitleReceivedDate

Date the lienholder received the repossession title for the vehicle.

8

DateTime

None

NB, M

RepoTitleSendToAuctionDate

Date the lienholder sent the vehicle's repossession title to the auction house.

8

DateTime

None

NB, M

Comment

Other information regarding the vehicle's title.

300

VarChar

None

NB, M

DealerCode

Dealer's license number.

30

VarChar

None

NB, M

LegalCode

Legal code that grants the lienholder or credit agency the right to repossess the vehicle when the borrower defaults on the loan or lease agreement.

10

VarChar

None

NB, M

VolumeDate

N/A

8

DateTime

None

NB, M

FinanceChargeDue

Finance charge due on the loan.

8

Money

None

NB, M

LateChargeDue

Late charge due on the loan.

8

Money

None

NB, M

DealerEndorsementCode

Code that identifies the dealer's auto-broker endorsement.

10

VarChar

None

NB, M

DealerReserveChargeBack

Amount the finance company charged back to the dealer for early payoff of a loan.

8

Money

None

NB, M

TerminationDate

Termination date of the loan contract.

8

DateTime

None

NB, M

TerminationEffectiveDate

Date the termination of the loan contract became effective.

8

DateTime

None

NB, M

FairMarketValue

Amount the vehicle would sell for on the open market.

8

Money

None

NB, M

PurchaseAmount

Purchase amount of the vehicle.

8

Money

None

NB, M

ManufacturingCode

Code that identifies the vehicle manufacturer.

4

Integer

None

NB, M

MSRP

Manufacturer Suggested Retail Price.

8

Money

None

NB, M

NADA

The vehicle's National Association of Automobile Dealers blue book value.

8

Money

None

NB, M

BalanceAtRepo

Balance due on the vehicle or lease at time of repossession.

8

Money

None

NB, M

GLEntryDate

Date the lienholder posted the surplus or deficiency amount in the General Ledger.

8

DateTime

None

NB, M

SeriesIdentifier

Series code that identifies the vehicle.

4

Integer

None

NB, M

TitleStatus

Status of the vehicle's title (for example, salvage, rebuilt, junk).

4

Integer

None

NB, M

ReplevinOrderDate

Date the lienholder ordered the recovery.

8

DateTime

None

NB, M

ReplevinFiledDate

Date the lienholder scheduled the recovery.

8

DateTime

None

NB, M

ReplevinStatus

Status of the recovery.

80

VarChar

None

NB, M

DeliveredReleasedTo

Person to whom the repossession agent delivered or released the vehicle.

4

Integer

None

NB, M

Disposition

Disposition of the vehicle after repossession (for example, delivered to auction, stored, sold).

50

VarChar

None

NB, M

PersonalItems

Personal items that the vehicle contains.

200

VarChar

None

NB, M

HasPersonals

Indicates whether the vehicle contains personal items.

1

Bit

None

NB, M

HasKeys

Indicates whether the vehicle has keys.

1

Bit

None

NB, M

PoliceNotifiedDate

Date the recovery agency notified the police of intent to recover the vehicle.

8

DateTime

None

NB, M

OdometerType

Type of odometer, such as digital or analog.

40

VarChar

None

NB, M

DMV

Department of Motor Vehicles.

4

Integer

None

NB, M

KeyType

Type of ignition key, such as single or double cut.

20

VarChar

None

NB, M

Created

Date the collateral was first created

DateTime

None

NB, M

CreatedBy

User who created the collateral

   100

VarChar

None

NB, M

Updated

Date the collateral was last update

DateTime

None

NB, M

UpdatedBy

User who last updated the collateral

100

VarChar

None

NB, M