Feedback

  • Contents
 

Assets Export File 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.

Related Topics

Assets Export File Layout

Export File Layouts