Demographics Import File Address Record

Latitude

Position

Col

Column Name

Format

Comment

Record Type

1-4

1

record_type

String (4)

Value = AUAD

Debtor ID

5–13

2

debtor_number

Integer (9)

Unique number assigned to each debtor record.

File Number

14–22

3

file_number

Integer (9)

Unique number assigned to each account placed in Latitude. Use this value for all data sent to AIM.

New Street 1

4

new_street1

String (128)

Debtor's new street address line 1.

New Street 2

151-278

5

new_street2

String (128)

Debtor's new street address line 2.

New City

6

new_city

String (30)

Debtor's new city.

New State

7

new_state

String (3)

Debtor's new state.

New ZIP Code

8

new_zipcode

String (10)

Debtor's new postal code.

Old Street 1

9

old_street1

String (128)

Debtor's previous street address line 1.

Old Street 2

10

old_street2

String (128)

Debtor's previous street address line 2.

Old City

11

old_city

String (30)

Debtor's previous city.

Old State

12

old_state

String (3)

Debtor's previous state.

Old ZIP Code

13

old_zipcode

String (10)

Debtor's previous postal code.

Date Updated

14

date_updated

DateTime (CCYYMMDD)

Date you updated the address. For Excel file, use date/time format (for example, 6/20/2008  10:30:00 AM).