- Contents
AIM Help
Demographics Import File Phone Record
Delimited/fixed record type = AUPH
Excel worksheet name = PhoneRecord
|
Latitude |
Position |
Col |
Column Name |
Format |
Comment |
|
|
Record Type |
1-4 |
1 |
record_type |
String (4) |
Value = AUPH |
|
|
Debtor ID |
5–13 |
2 |
debtor_number |
Integer (9) |
Unique number assigned to each debtor record. Use this value for all data sent to AIM to identify the debtor. |
|
|
File Number |
14–22 |
3 |
file_number |
Integer (9) |
Unique number assigned to each account placed (zero padded). Use this value for all data sent to AIM. |
|
|
Phone Type |
23 |
4 |
phone_type |
Integer (1) |
1
= Home 3 = Cell |
4 = Fax 5 = Spouse Home 6 = Spouse Work |
|
New Number |
24-53 |
5 |
new_number |
String (30) |
Debtor's current phone number. |
|
|
Old Number |
54-83 |
6 |
old_number |
String (30) |
Debtor's previous phone number. |
|
|
Date Updated |
84-91 |
7 |
date_updated |
DateTime (CCYYMMDD) |
Date you updated the phone number. |
|
|
Filler |
92-628 |
8 |
Filler |
String (537) |
Filler for fixed file layout. Delimited expects reference. |
|