| 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 |