Placement Export File Account Record

Latitude

Position

Col

Column Name

Format

Comment

Record Type

1-4

1

record_type

String (4)

Value = CACT

Number

5-13

2

file_number

Integer (9)

Unique number assigned to each account placed (zero padded). Use this value for all data sent to AIM.

Account

14-43

3

account

String (30)

Account number that the creditor assigned to this account.

Current1

44-55

4

principal*

Decimal (12)

Principal amount placed with the agency.

Current2

56-67

5

interest*

Decimal (12)

Interest amount placed with the agency.

Current3

68-79

6

other3*

Decimal (12)

Other monies placed with the agency.

Current4

80-91

7

other4*

Decimal (12)

Other monies placed with the agency.

Current5

92-103

8

other5*

Decimal (12)

Other monies placed with the agency.

Current6

104-115

9

other6*

Decimal (12)

Other monies placed with the agency.

Current7

116-127

10

other7*

Decimal (12)

Other monies placed with the agency.

Current8

128-139

11

other8*

Decimal (12)

Other monies placed with the agency.

Current9

140-151

12

other9*

Decimal (12)

Other monies placed with the agency.

CLIDLC

152-159

13

last_charge

DateTime (CCYYMMDD)

Last date this account had a charge posted.

CLIDLP

160-167

14

last_paid

DateTime (CCYYMMDD)

Last date this account had a payment posted.

UserDate1

168-175

15

userdate1

DateTime (CCYYMMDD)

User-defined data. For more information, see your agency coordinator.

UserDate2

176-183

16

userdate2

DateTime (CCYYMMDD)

User-defined data. For more information, see your agency coordinator.

UserDate3

184-191

17

userdate3

DateTime (CCYYMMDD)

User-defined data. For more information, see your agency coordinator.

OriginalCreditor

192-221

18

original_creditor

String (30)

Original creditor for this account.

LastInterest

222-229-

19

last_interest

DateTime (CCYYMMDD)

Date that interest was last posted to this account.

LastInterestRate

230-241

20

interest_rate

Decimal (12)

Interest rate applied to this account.

CustDivision

242-271

21

customer_division

String (30)

Agency-defined data.

CustDistrict

272-301

22

customer_district

String (30)

Agency-defined data.

CustBranch

302-331

23

customer-branch

String (30)

Agency-defined data.

ID1

332-361

24

id1

String (30)

User-defined ID column.

ID2

362-391

25

id2

String (30)

User-defined ID column.

DeskID

392-401

26

desk

String (10)

Desk ID of placing creditor.

CustomerID

402-408

27

customer

String (7)

Code that identifies the placing creditor.

ChargeOffDate

409-416

28

chargeoffdate

DateTime (CCYYMMDD)

Date the client charged off the account.

DelinquencyDate

417-424

29

delinquencydate

DateTime (CCYYMMDD)

Date the account became delinquent.

Lastpaidamt

425-436

30

last_paid_amount

Decimal (12)

Last payment amount to the creditor.

ContractDate

437-444

31

contractdate

DateTime (CCYYMMDD)

Date the debtor signed the contract.

clidlp

445-452

32

clidlp

DateTime (CCYYMMDD)

Last payment date the client recorded.

clidlc

453-460

33

clidlc

DateTime (CCYYMMDD)

Last date the client charged the account.

clialp

461-472

34

clialp

Decimal (12)

Last amount paid that the client recorded.

clialc

473-484

35

clialc

Decimal (12)

Last amount the client charged.

Previous Creditor

485-534

36

previous_creditor

String (50)

Previous creditor for the account.

Purchased Date

535-542

37

purchaseddate

DateTime (CCYYMMDD)

Date the agency purchased the account.

Customer ID

543-552

38

customer_alphacode

String (10)

Code that identifies the client.

Customer Company

553-602

39

customer_company

String (50)

Name of the company.

Customer Name

603-652

40

customer_name

String (50)

Name of the client.

AIM Investor Group Name

653-702

41

AIM_InvestorGroupName

String (50)

Name of the investor group.

AIM Seller Group Name

703-752

42

AIM_SellerGroupName

String (50)

Name of the seller group.

Filler

753-3000

36

Filler

String (2248)

Filler for fixed file layout.