Loan Maintenance - Financial Information Data Entry and Edit Guidelines

The following table summarizes the data entry and edit requirements for each field on the Loan Maintenance - Financial Information screen.

Field Name	Required?	Size/Format	Edits Performed (or Recommendations)
General Payment Information
Payment Method	N/A	N/A	Read-only field.
ACH ID	N/A	N/A	Read-only field.
Credit Card ID	N/A	N/A	Read-only field.
Due Date	Optional	10 characters.	Format must be "mm/dd/yyyy".
Grace Date	Optional	10 characters.	Format must be "mm/dd/yyyy".
Last Paid Date	Optional	10 characters.	Format must be "mm/dd/yyyy".
Archive Flag	Required	If updatable, select value from drop-down list	If the record has not been deleted, this field will be read-only. Value must be from drop-down list. Can "undelete" a record by setting this value to "N".
Payment Plan Information
Installments
Method	Required	Select value from drop-down list	Value must be from drop-down list.
Frequency	Required	Select value from drop-down list	Value must be from drop-down list.
Amount	Required	8 decimal characters.	Format must be "nnnnn.nn" .
Interest
Method	Required	Select value from drop-down list	Value must be from drop-down list.
Frequency	Required	Select value from drop-down list	Value must be from drop-down list.
Amount	Optional/Required	8 decimal characters.	Format must be "nnnnn.nn" . A value must be entered if the Interest Method is "Flat Dollar Amount". A value should not be entered if the Interest Method is not "Flat Dollar Amount".
Percentage	Optional/Required	5 decimal characters.	Format must be "nn.nn". A value must be entered if the Interest Method is "Percentage". A value should not be entered if the Interest Method is not "Percentage".
Late Charges
Method	Required	Select value from drop-down list	Value must be from drop-down list.
Frequency	Required	Select value from drop-down list	Value must be from drop-down list.
Amount	Optional/Required	8 decimal characters.	Format must be "nnnnn.nn" . A value must be entered if the Interest Method is "Flat Dollar Amount". A value should not be entered if the Interest Method is not "Flat Dollar Amount".
Percentage	Optional/Required	5 decimal characters.	Format must be "nn.nn". A value must be entered if the Interest Method is "Percentage". A value should not be entered if the Interest Method is not "Percentage".
Delay	Optional/Required	3 numeric characters.	Format is "nnn". A value should not be entered if the Late Charge Method is "No Late Charges".
Collection Costs
Method	Required	Select value from drop-down list	Value must be from drop-down list.
Amount	Optional/Required	8 decimal characters.	Format must be "nnnnn.nn" . A value must be entered if the Interest Method is "Flat Dollar Amount". A value should not be entered if the Interest Method is not "Flat Dollar Amount".
Percentage	Optional/Required	5 decimal characters.	Format must be "nn.nn". A value must be entered if the Interest Method is "Percentage". A value should not be entered if the Interest Method is not "Percentage".
Balance Details
Principal
Amount	Required	9 decimal characters.	Format must be "nnnnnn.nn" . Value entered cannot be less than Principal Balance, and cannot be less than zero.
Paid	Optional	9 decimal characters.	Format must be "nnnnnn.nn" .
Cancelled	Optional	9 decimal characters.	Format must be "nnnnnn.nn" . Value entered cannot be less than zero.
Defaulted	Optional	9 decimal characters.	Format must be "nnnnnn.nn" . Value entered cannot be less than zero.
Balance	Required	9 decimal characters.	Format must be "nnnnnn.nn" . Value entered cannot be more than Principal Amount.
Interest
Amount	Optional	9 decimal characters.	Format must be "nnnnnn.nn" . Value entered cannot be less than zero.
Paid	Optional	9 decimal characters.	Format must be "nnnnnn.nn" . Value entered cannot be less than zero.
Cancelled	Optional	9 decimal characters.	Format must be "nnnnnn.nn" . Value entered cannot be less than zero.
Defaulted	Optional	9 decimal characters.	Format must be "nnnnnn.nn" . Value entered cannot be less than zero.
Balance	Optional	9 decimal characters.	Format must be "nnnnnn.nn" . Value entered cannot be less than zero.
Late Charges
Amount	Optional	9 decimal characters.	Format must be "nnnnnn.nn" . Value entered cannot be less than zero.
Paid	Optional	9 decimal characters.	Format must be "nnnnnn.nn" . Value entered cannot be less than zero.
Cancelled	Optional	9 decimal characters.	Format must be "nnnnnn.nn" . Value entered cannot be less than zero.
Defaulted	Optional	9 decimal characters.	Format must be "nnnnnn.nn" . Value entered cannot be less than zero.
Balance	Optional	9 decimal characters.	Format must be "nnnnnn.nn" . Value entered cannot be less than zero.
Collection Costs
Amount	Optional	9 decimal characters.	Format must be "nnnnnn.nn" . Value entered cannot be less than zero.
Paid	Optional	9 decimal characters.	Format must be "nnnnnn.nn" . Value entered cannot be less than zero.
Cancelled	Optional	9 decimal characters.	Format must be "nnnnnn.nn" . Value entered cannot be less than zero.
Defaulted	Optional	9 decimal characters.	Format must be "nnnnnn.nn" . Value entered cannot be less than zero.
Balance	Optional	9 decimal characters.	Format must be "nnnnnn.nn" . Value entered cannot be less than zero.
Origination
Amount	Optional	9 decimal characters.	Format must be "nnnnnn.nn" . Value entered cannot be less than zero.
Paid	Optional	9 decimal characters.	Format must be "nnnnnn.nn" . Value entered cannot be less than zero.
Cancelled	Optional	9 decimal characters.	Format must be "nnnnnn.nn" . Value entered cannot be less than zero.
Defaulted	Optional	9 decimal characters.	Format must be "nnnnnn.nn" . Value entered cannot be less than zero.
Balance	Optional	9 decimal characters.	Format must be "nnnnnn.nn" . Value entered cannot be less than zero.