- Contents
AIM Help
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). |