Placement Export File Debtor Record

Latitude

Position

Col

Column Name

Format

Comment

Record Type

1-4

1

record_type

String (4)

Value = CD00 - CD99

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.

Account

14-43

3

account

String (30)

Unique number the creditor assigned to this account.

Name

44-73

4

name

String (30)

Customer name or business name. AIM formats customer names as last name, first name, middle initial. Business names use standard formatting.

Street 1

74-201

5

street1

String (128)

Debtor's street address line 1.

Street 2

202-329

6

street2

String (128)

Debtor's street address line 2.

City

330-349

7

city

String (20)

Debtor's city.

State

350-352

8

state

String (3)

Debtor's state.

Postal Code

353-362

9

zipcode

String (10)

Debtor's postal code.

Home Phone

363-392

10

home_phone

String (30)

Debtor's home phone.

Work Phone

393-422

11

work_phone

String (30)

Debtor's work phone.

SSN

423-431

12

ssn

String (9)

Debtor's SSN.

Mail Return

432

13

mail_return

String (1)

Y = Bad address

N = Good address

Other Name

433-462

14

other_name

String (30)

Debtor's other (or alias) name.

Date of Birth

463-470

15

date_of_birth

DateTime (CCYYMMDD)

Debtor's date of birth.

Job Name

471-500

16

job_name

String (30)

Name of debtor's employer.

Job Street1

501-628

17

job_street1

String (128)

Street address line 1 for debtor's employer.

Job Street2

629-756

18

job_street2

String (128)

Street address line 2 for debtor's employer

Job City, State, Postal Code

757-786

19

job_city_state_zipcode

String (30)

City, state, and postal code for debtor's employer

Spouse Name

787-816

20

spouse_name

String (30)

Name of debtor's spouse.

Spouse Job Name

817-846

21

spouse_job_name

String (30)

Name of spouse's employer.

Spouse Job Street1

847-974

22

spouse_job_street1

String (128)

Street address line 1 for spouse's employer.

Spouse Job Street2

975-1102

23

spouse_job_street2

String (128)

Street address line 2 for spouse's employer.

Spouse Job City, State, Postal Code

1103-1132

24

spouse_job_city_state_zipcode

String (30)

City, state, and postal code for spouse's employer.

Spouse Home Phone

1133-1162

25

spouse_home_phone

String (30)

Spouse's home phone.

Spouse Work Phone

1163-1192

26

spouse_work_phone

String (30)

Spouse's work phone.

Debtor ID

1193-1201

27

debtor_number

Integer (9)

Unique code that identifies the debtor.

County

1202-1251

28

county

String (50)

Debtor's county of residence.

Country

1252-1301

29

country

String (50)

Debtor's country of residence.

Attorney Name

1302-1351

30

attorney_name

String (50)

Attorney's name.

Attorney Firm

1352-1451

31

attorney_firm

String (100)

Name of attorney's firm.

Attorney Street1

1452-1579

32

attorney_street1

String (128)

Attorney's street address line 1.

Attorney Street2

1580-1707

33

attorney_street2

String (128)

Attorney's street address line 2.

Attorney City

1708-1757

34

attorney_city

String (50)

Attorney's city.

Attorney State

1758-1762

35

attorney_state

String (5)

Attorney's state

Attorney Postal Code

1763-1782

36

attorney_zipcode

String (20)

Attorney's postal code.

Attorney Phone

1783-1802

37

attorney_phone

String (20)

Attorney's phone number.

Attorney Fax

1803-1822

38

attorney_fax

String (20)

Attorney's fax number.

Attorney Notes

1823-2322

39

attorney_notes

String (500)

Attorney's notes.

ID 1

2323-2372

40

id1

String (50)

Identification number associated to a party on an account.

ID 2

2373-2422

41

id2

String (50)

Identification number associated to a party on an account.

PURN

2423-2472

42

purn

String (50)

Personal Unique Record Number. Alphanumeric code that an outside provider such as a credit bureau assigns to uniquely identify a person.

Attorney County

2473-2600

43

attorney_county

String (128)

Attorney's county.

Attorney Country

2601-2728

44

attorney_country

String (128)

Attorney's country.

Job County

2729-2778

45

job_county

String (50)

County for debtor's employer.

Job Country

2779-2828

46

job_country

String (50)

Country for debtor's employer.

Spouse Job County

2829-2878

47

spouse_job_county

String (50)

County for spouse's employer.

Spouse Job Country

2879-2928

48

spouse_job_country

String (50)

Country for spouse's employer.

Filler

2929-3000

49

Filler

String (72)

Filler for fixed file layout. Delimited expects reference.