- ContentsQuick LinksAccount Analysis landing page Accounting landing page AIM help AIM Receiver help Arrangements landing page Batch Processing landing page Custodian help Dashboard help Data Exchange landing page Dialer Campaigns landing page Exchange Manager help Invoices help Latitude help Latitude Console help Letter Console help Letters landing page Link Console help List Builder help Portfolio Manager help Reporting Console help Reporting landing page WorkFlow Designer help Work Queues landing page
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. |