- Contents
AIM Help
Placement Export File Auto Lease Record
Fixed record type = CALS
Excel worksheet name = AutoLease
|
Latitude |
Position |
Col |
Column Name |
Format |
Comment |
|
Record Type |
1-4 |
1 |
record_type |
String (4) |
Value = CALS |
|
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. |
|
Term Months |
14-23 |
3 |
TermMonths |
String (10) |
Length of the lease, in months. |
|
Maturity Date |
24-31 |
4 |
MaturityDate |
DateTime (CCYYMMDD) |
Date the lease matured. |
|
Effective Date |
32-39 |
5 |
EffectiveDate |
DateTime (CCYYMMDD) |
Date the lease became effective. |
|
Original Miles |
40-48 |
6 |
OriginalMiles |
Integer (9) |
Original mileage on the leased vehicle. |
|
Contract Miles |
49-57 |
7 |
ContractMiles |
Integer (9) |
Mileage allowed under the leasing contract. |
|
Purchase Miles |
58-66 |
8 |
PurchaseMiles |
Integer (9) |
Number of extra miles purchased. |
|
End of Term Miles |
67-75 |
9 |
EndofTermMiles |
Integer (9) |
Mileage at the end of the lease term. |
|
Residual |
76-87 |
10 |
Residual |
Decimal (12) |
Lease-end value of the vehicle. |
|
Contract Obligation |
88-99 |
11 |
ContractObligation |
Decimal (12) |
Total amount due under the lease agreement. This amount excludes the security deposit, sales tax, and any other fees and taxes paid to a third party. |
|
Security Deposit |
100-111 |
12 |
SecurityDeposit |
Decimal (12) |
Amount the lessee paid as a security deposit. |
|
Unpaid Months Payment |
112-123 |
13 |
UnpaidMonthsPayment |
Decimal (12) |
Number of months during the lease term that the lessee did not make a payment. |
|
Unpaid Tax |
124-135 |
14 |
UnpaidTax |
Decimal (12) |
Amount in unpaid taxes that the lessee owes. |
|
Excess Mileage |
136-147 |
15 |
ExcessMileage |
Decimal (12) |
Amount charged for each mile in excess of the mileage limit. |
|
Wear and Tear |
148-159 |
16 |
WearandTear |
Decimal (12) |
Total amount charged for wear and tear on the vehicle. |
|
Return Date |
160-167 |
17 |
ReturnDate |
DateTime (CCYYMMDD) |
Date the leasing agency received the vehicle. |
|
Excess Miles |
168-176 |
18 |
ExcessMiles |
Integer (9) |
Amount charged for each mile in excess of the mileage limit. |
|
Unused Miles |
177-185 |
19 |
UnusedMiles |
Integer (9) |
Number of unused contract and purchased miles. |
|
Inception Miles |
186-194 |
20 |
InceptionMiles |
Integer (9) |
Mileage at the beginning of the lease term. |
|
Mileage Credit |
195-206 |
21 |
MileageCredit |
Decimal (12) |
Amount credited for unused mileage. |
|
Minor Wear Charge |
207-218 |
22 |
MinorWearCharge |
Decimal (12) |
Amount charged for minor wear on the vehicle. |
|
Major Wear Charge |
219-230 |
23 |
MajorWearCharge |
Decimal (12) |
Amount charged for major wear on the vehicle. |
|
Disposal Assessed Amount |
231-242 |
24 |
DisposalAssessedAmount |
Decimal (12) |
Amount charged to dispose of the vehicle. |
|
Residual Gain Loss |
243-254 |
25 |
ResidualGainLoss |
Decimal (12) |
Difference between the residual value and the end-of-lease purchase price. |
|
End of Term Tax Assessed |
255-266 |
26 |
EndofTermTaxAssessed |
Decimal (12) |
Tax assessed at the end of the lease. |
|
Other Tax Assessed |
267-278 |
27 |
OtherTaxAssessed |
Decimal (12) |
Amount charged for other taxes (for example, property tax). |
|
Disposition Date |
279-286 |
28 |
DispositionDate |
DateTime (CCYYMMDD) |
Date the leasing agency determined the status of the returned vehicle. |
|
Inspection Received Date |
287-294 |
29 |
InspectionReceivedDate |
DateTime (CCYYMMDD) |
Date the leasing agency inspected the vehicle. |
|
Filler |
295-3000 |
30 |
Filler |
String (2706) |
Filler for fixed file layout. |