- Contents
AIM Help
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. |