YGC Import Record Type 38 - Reconciliation

Field Code

Field Description

Field Type

Field Size

Start

End

RECORD_CODE

Value = 38.

Char

2

1

2

FILENO

Latitude file number.

Char

10

3

12

FORW_FILE

Customer account number in Latitude.

Char

20

13

32

MASCO_FILE

Internal file number of the receiver (agency or law firm) working the account.

Char

15

33

47

FIRM_ID

YGC ID for the attorney record in AIM.

Char

10

48

57

FORW_ID

You've Got Claims ID in Latitude.

Char

10

58

67

DPLACED

Account placement date.

Date

8

68

75

DEBT_NAME

Primary debtor's name. The format is Lastname/Firstname.

Char

30

76

105

CRED_NAME

Name of the creditor company. You can use CRED_NAME2 for overflow.

Char

30

106

135

D1_BAL

Dollar amount of the principal due.

Numeric

14.2

136

149

IDATE

Ddate the system last calculated interest on the debt.

Date

8

150

157

IAMT

Dollar amount of total interest accrued.

Numeric

14.2

158

171

IDUE

Dollar amount of interest due as of IDATE, which may not equal IAMT.

Numeric

14.2

172

185

PAID

Total dollar amount already paid toward the debt.

Numeric

14.2

186

199

COST_BAL

Current administrative costs incurred for the account.

Numeric

14.2

200

213

DEBT_CS

Debtor's city and state, formatted as City ST or City,ST. For example, Linden NJ or Linden,NJ.

Char

23

214

236

DEBT_ZIP

Debtor's postal code. It can accommodate the four-digit extension without the hyphen.

Char

9

237

245

CRED_NAME2

Overflow field for CRED_NAME.

Char

25

246

270

COMM

Commission percentage the sender determined that the receiver earns. This field doesn't have a set numeric format.

Char

4

271

274

SFEE

Percentage the receiver earns for the suit. This field doesn't have a set numeric format.

Char

4

275

278

RFILE

Code common to a set of accounts for the same debtor to allow you to work a parent account instead of each individual account.

Char

8

279

286

DEBT_CNTRY

Standard code for the debtor's country.

Char

3

287

289