Placement Export File Auto Collateral Record

Latitude

Position

Col

Column Name

Format

Comment

Record Type

1-4

1

record_type

String (4)

Value = CACO

File Number

5-13

2

file_number

Integer (9)

Unique number assigned to each account placed. Use this value for all data sent to AIM.

Collateral Year

14-22

3

CollateralYear

Integer (9)

Vehicle model year.

Make

23-50

4

Make

String (28)

Vehicle manufacturer.

Model

51-78

5

Model

String (28)

Vehicle model.

VIN

79-108

6

VIN

String (30)

Vehicle Identification Number.

Addons

109-308

7

Addons

String (200)

Optional features on the vehicle.

Color

309-328

8

Color

String (20)

Color of the vehicle.

Collateral Miles Hours

329-338

9

CollateralMilesHours

String (10)

Number of miles or hours on the vehicle.

Miles Hours

339-347

10

MilesHours

Integer (9)

Number of miles or hours on the vehicle.

Collateral Damaged

348

11

CollateralDamaged

String (1)

Lien holder considers the vehicle damaged.

Collateral Totaled

349

12

CollateralTotaled

String (1)

Lien holder considers the vehicle totalled.

Condition Description

350-649

13

ConditionDescription

String (300)

Description of the condition of the vehicle.

Sell Collateral

650

14

SellCollateral

String (1)

Lien holder intends to sell the vehicle for collateral.

Ignition Key Number

651-660

15

IgnitionKeyNumber

String (10)

Number that identifies the ignition key.

Other Key Number

661-670

16

OtherKeyNumber

String (10)

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

Tag Decal State

671-672

17

TagDecalState

String (2)

State listed on the vehicle's license plate.

Tag Decal Number

673-682

18

TagDecalNumber

String (10)

Vehicle's license plate number.

Tag Decal Year

683-691

19

TagDecalYear

Integer (9)

Vehicle's license plate year.

Title Position

692-700

20

TitlePosition

Integer (9)

Position of the title (for example, original, duplicate).

Title State

701-702

21

TitleState

String (2)

State listed on the vehicle's titled.

Have Title

703

22

HaveTitle

String (1)

Indicates whether your organization has the title.

Dealer Code

704-733

23

DealerCode

String (30)

Dealer's license number.

Legal Code

734-743

24

LegalCode

String (10)

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

Volume Date

744-751

25

VolumeDate

DateTime (CCYYMMDD)

Finance Charge Due

752-763

26

FinanceChargeDue

Decimal (12)

Finance charge due on the loan.

Late Charge Due

764-775

27

LateChargeDue

Decimal (12)

Late charge due on the loan.

Dealer Endorsement Code

776-785

28

DealerEndorsementCode

String (10)

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

Dealer Reserve Charge Back

786-797

29

DealerReserveChargeback

Decimal (12)

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

Termination Date

798-805

30

TerminationDate

DateTime (CCYYMMDD)

Termination date of the loan contract.

Termination Effective Date

806-813

31

TerminationEffectiveDate

DateTime (CCYYMMDD)

Date the termination of the loan contract became effective.

Fair Market Value

814-825

32

FairMarketValue

Decimal (12)

Amount the vehicle would sell for on the open market.

Purchase Amount

826-837

33

PurchaseAmount

Decimal (12)

Purchase amount the vehicle.

Manufacturing Code

838-846

34

ManufacturingCode

Integer (9)

Code that identifies the vehicle manufacturer.

MSRP

847-858

35

MSRP

Decimal (12)

Manufacturer Suggested Retail Price.

Series Identifier

859-867

36

SeriesIdentifier

Integer (9)

Series code that identifies the vehicle.

Title Status

868-876

37

TitleStatus

Integer (9)

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

Filler

877-3000

38

Filler

String (2124)

Filler for fixed file layout.