Minerva ALMV02 – Loans – File Layout

File Layouts File Layouts Minerva ALMV02 - Loans - File Layout

 

Position Start Position End Description Field
1 1 Loan L LOLGRP
2 2 Comma
3 14 Account and Suffix LOACCT/LOSUFF
15 15 Comma
16 17 Loan Type LOTYPE
18 18 Comma
19 27 Current Balance LOCBAL
28 28 Comma
29 37 Total Principle (This Month) Calculated
38 38 Comma
39 43 Interest Rate LORATE
44 44 Comma
45 45 Loan Category Code LOSECR
46 46 Comma
47 56 Open Date LODATO
57 57 Comma
58 58 Comma
59 67 Total Interest Paid Calculated
68 68 Comma
69 77 Interest Due Calculated
78 78 Comma
79 87 Total Add-Ons (History) Calculated
88 88 Comma
89 97 Total Principle Calculated
98 98 Comma
99 99 If an (F) a (1) is hard coded, otherwise a (2) is used-Fixed Rate vs. Variable LOFXVR
100 100 Comma
101 105 Delinquent Days Calculated
106 106 Comma
107 115 Delinquent Amount Calculated
116 116 Comma
117 118 Loan Type, Purpose Code or Security Code depending on type of run LOTYPE/LOPURP/ LOSECR
119 119 Comma
120 121 Security Code LOSECR
122 122 Comma
123 124 Purpose Code LOPURP
125 125 Comma
126 133 Credit Limit LOCLIM
134 134 Comma
135 136 Branch Code LOBRCH
137 137 Comma
138 139 Branch Code LOBRCH
140 140 Comma
141 142 Branch Code LOBRCH
143 143 Comma
149 158 Maturity Date LOMATD
159 159 Comma
160 169 Open Date LODATO
170 170 Comma
171 171 If blank, will hard code a (1), otherwise a (2) is hardcoded. ENPLOY