Feedback

  • Contents
 

Placement Export File Auto Auction Appraisal Record

Fixed record type = CAAA

Excel worksheet name = AutoAuctionAppraisal

Latitude

Position

Col

Column Name

Format

Comment

Record Type

1-4

1

record_type

String (4)

Value = CAAA

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.

ID

14-22

3

ID

Integer (9)

Code that identifies the vehicle.

Appraiser Code

23-32

4

AppraiserCode

String (10)

Code that identifies the appraiser.

Average Value

33-44

5

AverageValue

Decimal (12)

Average value of the vehicle.

Retail Value

45-56

6

RetailValue

Decimal (12)

Retail value of the vehicle.

Source Publication

57-86

7

AppraisalSourcePublication

String (30)

Source from which your organization obtained the appraisal (for example, Kelley Blue Book).

Appraisal Received

87-94

8

AppraisalReceivedDate

DateTime (CCYYMMDD)

Date your organization received the appraisal.

Filler

95-3000

9

Filler

String (2906)

Filler for fixed file layout.

Related Topics

Placements Export File Layout

Export File Layouts