| Name | Description | 
|---|---|
| rmfp | Loan Payment Schedule | 
| Name | Segment 1 | Segment 2 | 
|---|---|---|
| rmf_idx0 | fin_inst_s | loan_s | 
| Columns | |||
|---|---|---|---|
| Name | Description | Datatype ¿? | Allow Null | 
| fin_inst_s | Financial institution  | 
char(4) | no | 
| loan_s | Loan number  | 
char(7) | no | 
| timestamp | Record modification stamp  | 
timestamp | yes | 
| por_s | Portfolio  | 
char(2) | yes | 
| d_inc_s | Inception date  | 
datetime | yes | 
| d_act_s | Activity date  | 
datetime | yes | 
| d_loan_acc_s | Loan accrued to date  | 
datetime | yes | 
| act_ln_s | Activity status  | 
char(4) | yes | 
| acc_ln_s | Accrual method  | 
char(4) | yes | 
| typ_ln_s | Loan type  | 
char(4) | yes | 
| recour_c | Recourse/non-recourse (R/N)  | 
char(1) | yes | 
| frst_unit_s | First asset in loan  | 
char(10) | yes | 
| last_unit_s | Last asset in loan  | 
char(10) | yes | 
| next_loan_s | Next loan for equipment  | 
char(11) | yes | 
| prev_loan_s | Previous loan for equipment  | 
char(11) | yes | 
| prim_num_s | Prime rate bank number  | 
char(4) | yes | 
| commt1_s | Comments [1]  | 
char(80) | yes | 
| commt2_s | Comments [2]  | 
char(80) | yes | 
| pmt_l | Number of payments accrued  | 
integer | yes | 
| loan_trm_l | Loan term  | 
integer | yes | 
| p_int_d | Interest rate / APR  | 
double precision | yes | 
| orig_d | Original amount  | 
double precision | yes | 
| down_d | Down payment  | 
double precision | yes | 
| cur_prn_d | Current principal balance  | 
double precision | yes | 
| int_cur_d | Current month interest  | 
double precision | yes | 
| int_ytd_d | Interest Y-T-D  | 
double precision | yes | 
| int_prv_d | Interest previous year  | 
double precision | yes | 
| int_ltd1_d | Interest L-T-D  | 
double precision | yes | 
| loan_org_d | Original cost of attached assets  | 
double precision | yes |