Loan Ledger Record Data Entry Guidelines

The following table summarizes the data entry and edit requirements for each field on the Loan Ledger Record Information Entry/Update screen.


Field Name

Required?

Size/Format

Edits Performed (or Recommendations)

Ledger ID

n/a

n/a

Read-only field. This is the Ledger Record ID value.

Payment Link ID

n/a

n/a

Read-only field. This is the record ID of the corresponding Payment History record.

Trans ID

n/a

n/a

Read-only field. This is the Transaction ID value.

Loan Link ID

n/a

n/a

Read-only field. This is the record ID of the associated Loan record.

Cust Link ID

n/a

n/a

Read-only field. This is the record ID of the associated Borrower record.

GL Table Link ID

n/a

n/a

Read-only field. This is the record ID of the associated General Ledger Table record.

Ledger Account

Required

Select value from drop-down list

Value is from drop-down list.

Transaction Type

Required

4 alphanumeric characters

Valid values are: "PYMT", "LOAN", "RFND", and "CXnn" where 'nn' is the remainder of the Cancellation Type code (ex.: CXDI).

Transaction Sub Type

Required

4 alphanumeric characters.

Valid values are based on the supplied Transaction Type value, as shown in the following table:


Transaction Type

Transaction Sub Type

PYMT

CASH, CLOS, CHCK, CARD, LBOX, ADJ, REV, ACH

LOAN

EVEC, NLNC, NLEC, NVEC, RCVY, VOID

RFND

 

CXnn

Cancellation percentage

Transaction Date

Required

10 characters.

Format must be "mm/dd/yyyy".

Transaction Amount

Required

10 decimal characters.

Format must be 'nnnnnnnn.nn' . Can be negative.

Debit/Credit Flag

Required

Select value from drop-down list.

Value is from drop-down list.

GL Posted Date

Optional

10 characters.

Format must be "mm/dd/yyyy".

Comment

Optional

30 alphanumeric characters.

None

Archive Flag

Read-only on the update form if the record has not been deleted.

Select value from drop-down list

None.