YGC Import Record Type 30 - Financial Transaction

Field Code

Field Description

Field Type

Field Size

Start

End

RECORD_CODE

Value = 30.

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

RET_CODE

Return code that identifies the transaction. Valid values are:

1 = Standard Payment

3 = Settlement Payment (full or partial)

6 = Direct Payment

33-81 = Cost Disbursement (user-defined)

Numeric

2

68

69

PAY_DATE

Date the funds from the debtor cleared the receiver's bank.

Date

8

70

77

GROSS_PAY

Typically, the payment amount reported to the sender, which may not include statutory attorney fees awarded in some states.

Numeric

14.2

78

91

NET_CLIENT

Payment amount applied to the principal that AIM calculates fees against.

Numeric

14.2

92

105

CHECK_AMT

Actual amount going to the sender, typically the gross payment without the fees.

Numeric

14.2

106

119

COST_RET

Cost reimbursement to the sender. The scenario is that the receiver spent their own money on costs and the sender reimbursed them.

Numeric

14.2

120

133

FEES

Total of commissions and suit fees earned on this payment. You can split this amount among LINE2_7 (suit fees) and LINE2_8 (commissions).

Numeric

14.2

134

147

AGENT_FEES

If you forwarded the account to another attorney, the fees that co-counsel deducted.

Numeric

14.2

148

161

FORW_CUT

If the receiver remits to both sender and original creditor, the amount paid to the sender.

Numeric

14.2

162

175

COST_REC

Cost money that the receiver is recovering on this payment. If the receiver agreed not to give the sender invoices on costs, the receiver doesn't return the money to the sender.

Numeric

14.2

176

189

BPJ

Legal status of the account. Valid values are:

B = Before Suit

P = Post Suit

J = Post Judgment

Char

1

190

190

TA_NO

Unique identifier for this transaction.

Numeric

6

191

196

RMIT_NO

Unique identifier for the batch this transaction is in.

Numeric

6

197

202

LINE1_3

Statutory attorney fees recovered in this payment. Typically, these fees are state awarded and don't get remitted.

Numeric

14.2

203

216

LINE1_5

Remaining principal balance.

Numeric

14.2

217

230

LINE1_6

Typically, the same as GROSS_PAY.

Numeric

14.2

231

244

LINE2_1

Amount applied to the principal for this payment only, not the total of all principal payments.

Numeric

14.2

245

258

LINE2_2

Amount applied to interest for this payment only, not the total of all interest payments.

Numeric

14.2

259

272

LINE2_5

Not applicable for payments. Reports a cost disbursement, in which case it is the only dollar-value field populated besides LINE1_5. This record then serves as an invoice to the sender.

Numeric

14.2

273

286

LINE2_6

This field is for the rare situation in which the receiver receives payments for costs up front.

Numeric

14.2

287

300

LINE2_7

Suit fees earned on this payment. This MUST NOT EXCEED GROSS_PAY.

Numeric

14.2

301

314

LINE2_8

Commissions earned on this payment. This MUST NOT EXCEED GROSS_PAY.

Numeric

14.2

315

328

DESCR

There is no restriction here. Typical descriptions are payment, suit filed, audit, collection, or court costs.

Char

30

329

358

POST_DATE

Date the transaction posted into the service provider's system.

Date

8

359

366

REMIT_DATE

Date the receiver sent monies to the sender.

Date

8

367

374

TA_CODE

Type of payment or cost. Use an accounting or disbursement YGC status code.

Char

8

375

382

COMMENT

Description of this transaction. For payments, it can include the check number.

Char

25

383

407