- Contents
AIM Help
Placement Export File Assets Record
Fixed record type = CAST
Excel worksheet name = Assets
Latitude |
Position |
Col |
Column Name |
Format |
Comment |
Record Type |
1-4 |
1 |
record_type |
String (4) |
Value = CAST |
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. Use this value for all data sent to AIM. |
Asset ID |
23-31 |
4 |
asset_id |
Integer (9) |
Code that identifies the asset. |
Asset Type ID |
32-40 |
5 |
asset_type_id |
Integer (9) |
Code that identifies the asset type. |
Asset Name |
41-90 |
6 |
asset_name |
String (50) |
Name of the asset. |
Asset Description |
91-290 |
7 |
asset_description |
String (200) |
Description of the asset. |
Asset Value |
291-302 |
8 |
asset_value |
Decimal (12) |
Value of the asset. |
Asset Lien Value |
303-314 |
9 |
asset_lien_value |
Decimal (12) |
Lien value of the asset. |
Asset Value Verified Flag |
315 |
10 |
asset_value_verified_flag |
String (1) |
Indicates whether a user verified the asset value. |
Asset Lien Value Verified Flag |
316 |
11 |
asset_lien_value_verified_flag |
String (1) |
Indicates whether a user verified the lien value. |
Filler |
317-3000 |
12 |
Filler |
String (2684) |
Filler for fixed file layout. |