- Contents
AIM Help
Equipment Export File Record
Fixed record type = CEQP
Excel worksheet name = Equipment
Latitude |
Position |
Col |
Column Name |
Format |
Comment |
Record Type |
1-4 |
1 |
record_type |
String (4) |
Value = CEQP |
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. |
Act# |
14-33 |
3 |
Act# |
String (20) |
Account number that the creditor assigned to this account. |
Collat_desc |
34-83 |
4 |
Collat_desc |
String (50) |
Description of the collateral item. |
Lic# |
84-113 |
5 |
Lic# |
String (30) |
License number. |
Vin# |
114-143 |
6 |
Vin# |
String (30) |
Vehicle identification number. |
Yr |
144-153 |
7 |
Yr |
String (10) |
Vehicle model year. |
Mk |
154-183 |
8 |
Mk |
String (30) |
Maker of the vehicle. |
Mdl |
184-203 |
9 |
Mdl |
String (20) |
Vehicle model. |
Ser |
204-223 |
10 |
Ser |
String (20) |
Series code that identifies the vehicle. |
Color |
224-243 |
11 |
Color |
String (20) |
Color of the vehicle. |
Key_CD |
244-263 |
12 |
Key_CD |
String (20) |
Ignition key number. |
Cond |
264-293 |
13 |
Cond |
String (30) |
Condition of the vehicle. |
Loc |
294-323 |
14 |
Loc |
String (30) |
Location of the vehicle. |
Tag# |
324-353 |
15 |
Tag# |
String (30) |
License plate number. |
Dlr# |
354-383 |
16 |
Dlr# |
String (30) |
Dealer number. |
PLN_CD |
384-413 |
17 |
PLN_CD |
String (30) |
|
Repo_DT |
414-428 |
18 |
Repo_DT |
String (15) |
Date the vehicle was repossessed. |
DSP_DT |
429-443 |
19 |
DSP_DT |
String (15) |
Disposition date. |
Ins |
444-473 |
20 |
Ins |
String (30) |
Inspection results. |
Prd_Cmplt# |
474-503 |
21 |
Prd_Cmplt# |
String (30) |
|
Val |
504-515 |
22 |
Val |
Decimal (12) |
Vehicle's fair market value. |
UCC_CD |
516-525 |
23 |
UCC_CD |
String (10) |
Uniform Commercial Code. |
Fil_Dt |
526-540 |
24 |
Fil_Dt |
String (15) |
|
Fil_Loc |
541-570 |
25 |
Fil_Loc |
String (30) |
|
X_Coll |
571-600 |
26 |
X_Coll |
String (30) |
|
LN# |
601-630 |
27 |
LN# |
String (30) |
Loan number. |
Rec_Mthd_CD |
631-650 |
28 |
Rec_Mthd_CD |
String (20) |
Code that identifies the method of recovery. |
Reas_CD |
651-680 |
29 |
Reas_CD |
String (30) |
Code that identifies the reason for recovery. |
Typ_CO_CD |
681-710 |
30 |
Typ_CO_CD |
String (30) |
|
DSP_CD |
711-740 |
31 |
DSP_CD |
String (30) |
Disposition code. |
DSP_ANAL |
741-770 |
32 |
DSP_ANAL |
String (30) |
|
Recovered |
771 |
33 |
Recovered |
String (1) |
Indicates whether the client recovered the equipment. |
RecoveredDate |
772-779 |
34 |
RecoveredDate |
DateTime (CCYYMMDD) |
Date the client recovered the equipment. |
Commissionable |
780 |
35 |
Commissionable |
String (1) |
Indicates whether the equipment is commissionable. |
WhenLoaded |
781-788 |
36 |
WhenLoaded |
DateTime (CCYYMMDD) |
Date a user added the equipment to Latitude. |
equipment_id |
789-797 |
37 |
equipment_id |
Integer (9) |
Code that identifies the equipment in Latitude. |