Feedback

  • Contents
 

Demographics Import File Address Record

Delimited/fixed record type = AUAD

Excel worksheet name = AddressRecord

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

23-150

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

279-308

6

new_city

String (30)

Debtor's new city.

New State

309-311

7

new_state

String (3)

Debtor's new state.

New ZIP Code

312-321

8

new_zipcode

String (10)

Debtor's new postal code.

Old Street 1

322-449

9

old_street1

String (128)

Debtor's previous street address line 1.

Old Street 2

450-577

10

old_street2

String (128)

Debtor's previous street address line 2.

Old City

578-607

11

old_city

String (30)

Debtor's previous city.

Old State

608-610

12

old_state

String (3)

Debtor's previous state.

Old ZIP Code

611-620

13

old_zipcode

String (10)

Debtor's previous postal code.

Date Updated

621-628

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).

Related Topics

Demographics Import File Layout

Import File Layouts