Assets Import File Record

Latitude

Position

Col

Column Name

Format

Comment

Record Type

1-4

1

Record_Type

String (4)

Value = AAST

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

Assets_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 the agency or attorney verified the asset value.

Asset Lien Value Verified Flag

316

11

Asset_Lien_Value_Verified_Flag

String (1)

Indicates whether the agency or attorney verified the lien value.