Feedback

  • Contents
 

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.

Related Topics

Equipment Export File Layout

Export File Layouts