- Contents
AIM Help
Placement Export File Auto Auction Record
Fixed record type = CAAU
Excel worksheet name = AutoAuction
Latitude |
Position |
Col |
Column Name |
Format |
Comment |
Record Type |
1-4 |
1 |
record_type |
String (4) |
Value = CAAU |
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. |
Bid Close Date |
14-21 |
4 |
BidCloseDate |
DateTime (CCYYMMDD) |
Date bidding on the vehicle closed. |
Collateral Appraiser Code |
22-26 |
5 |
CollateralAppraiserCode |
String (5) |
Code that identifies the appraiser. |
Buyer PO Number |
27-36 |
6 |
BuyerPONumber |
String (10) |
Buyer's purchase order number. |
Date Collateral Available for Sale |
37-44 |
7 |
DateCollateralAvailableforSale |
DateTime (CCYYMMDD) |
Date the vehicle became available for sale. |
Date Appraisal Received |
45-52 |
8 |
DateAppraisalReceived |
DateTime (CCYYMMDD) |
Date your organization received the appraisal. |
Inspection Date |
53-60 |
9 |
InspectionDate |
DateTime (CCYYMMDD) |
Date the appraiser inspected the vehicle. |
Date of Letter to Lien Holder1 |
61-68 |
10 |
DateofLettertoLienHolder1 |
DateTime (CCYYMMDD) |
Date your organization sent a letter to the first lien holder regarding auctioning of the vehicle. |
Date of Letter to Lien Holder2 |
69-76 |
11 |
DateofLettertoLienHolder2 |
DateTime (CCYYMMDD) |
Date your organization sent a letter to the second lien holder regarding auctioning of the vehicle. |
Date Repairs Completed |
77-84 |
12 |
DateRepairsCompleted |
DateTime (CCYYMMDD) |
Repair completion date. |
Date Repairs Ordered |
85-92 |
13 |
DateRepairsOrdered |
DateTime (CCYYMMDD) |
Repair order date. |
Date Repairs Approved |
93-100 |
14 |
DateRepairsApproved |
DateTime (CCYYMMDD) |
Repair approval date. |
Title Ordered Date |
101-108 |
15 |
TitleOrderedDate |
DateTime (CCYYMMDD) |
Date your organization ordered the vehicle title. |
Title Sent to Auction |
109-116 |
16 |
TitleSenttoAuction |
DateTime (CCYYMMDD) |
Date your organization sent the vehicle title to the auction house. |
Date Payment Received for Collateral |
117-124 |
17 |
DatePaymentReceivedforCollateral |
DateTime (CCYYMMDD) |
Date your organization received the payment from the auction house. |
Title Received Date |
125-132 |
18 |
TitleReceivedDate |
DateTime (CCYYMMDD) |
Date the auction house received the vehicle title. |
Date Collateral Sold |
133-140 |
19 |
DateCollateralSold |
DateTime (CCYYMMDD) |
Date the vehicle sold at auction. |
Date Appraisal Verified |
141-148 |
20 |
DateAppraisalVerified |
DateTime (CCYYMMDD) |
Appraisal verification date. |
Date Notice Sent to Guarantor |
149-156 |
21 |
DateNoticeSenttoGuarantor |
DateTime (CCYYMMDD) |
Date your organization sent a notice to the guarantor regarding auctioning of the vehicle. |
Date Notice Sent to Maker |
157-164 |
22 |
DateNoticeSenttoMaker |
DateTime (CCYYMMDD) |
Date your organization sent a notice to the lender regarding auctioning of the vehicle. |
Date Notice Sent to Other |
165-172 |
23 |
DateNoticeSenttoOther |
DateTime (CCYYMMDD) |
Date your organization sent a notice to another party regarding auctioning of the vehicle. |
Repair Description |
173-472 |
24 |
RepairDescription |
String (300) |
Description of the needed repairs. |
Collateral Repairs Needed |
473 |
25 |
CollateralRepairsNeeded |
String (1) |
Indicates whether the vehicle needs repair. |
Sell As Is or Repaired |
474 |
26 |
SellAsIsorRepaired |
String (1) |
Indicates whether the vehicle is selling in "as is" or "repaired" condition. |
Collateral Sale Price |
475-486 |
27 |
CollateralSalePrice |
Decimal (12) |
Amount the vehicle sold for. |
Collateral Stock Number |
487-506 |
28 |
CollateralStockNumber |
String (20) |
Stock number the auction house assigned to the vehicle. |
Repaired Value |
507-518 |
29 |
RepairedValue |
Decimal (12) |
Monetary value of the vehicle after repairs. |
Repair Comments |
519-818 |
30 |
RepairComments |
String (300) |
Comments regarding the repairs. |
Location |
819-918 |
31 |
Location |
String (100) |
Location of the auction house. |
Auction Expense |
919-930 |
32 |
AuctionExpense |
Decimal (12) |
Fees associated with auctioning the vehicle. |
Filler |
931-3000 |
33 |
Filler |
String (2684) |
Filler for fixed file layout. |