| Name | Description | 
|---|---|
| rnon | Note Payment Schedule | 
| Name | Segment 1 | Segment 2 | Segment 3 | Segment 4 | Segment 5 | 
|---|---|---|---|---|---|
| rno_idx0 | por_s | com_s | reg_s | off_s | note_s | 
| rno_idx1 | len_s | note_s | |||
| rno_idx2 | note_s | ||||
| rno_idx3 | lse_s | note_s | |||
| rno_idx4 | unit_s | note_s | 
| Columns | |||
|---|---|---|---|
| Name | Description | Datatype ¿? | Allow Null | 
| por_s | Portfolio  | 
CHAR(2) | no | 
| com_s | Company  | 
CHAR(2) | no | 
| reg_s | Region  | 
CHAR(2) | no | 
| off_s | Office  | 
CHAR(3) | no | 
| note_s | Note attached to lease  | 
CHAR(10) | no | 
| stamp_l | Record modification stamp  | 
NUMBER(10) | no | 
| len_s | Lender  | 
CHAR(9) | no | 
| lse_s | Lease  | 
CHAR(10) | no | 
| unit_s | Asset  | 
CHAR(10) | no | 
| d_note_s | Note date  | 
DATE | yes | 
| d_com_s | Note commencement date  | 
DATE | yes | 
| d_boo_s | System booking date  | 
DATE | yes | 
| t_boo_s | System booking time  | 
CHAR(6) | yes | 
| d_mat_s | Maturity date  | 
DATE | yes | 
| d_att_s | Date note was attached to lease/asset  | 
DATE | yes | 
| d_lup_s | Date of last update  | 
DATE | yes | 
| t_lup_s | Time of last update  | 
CHAR(6) | yes | 
| d_act_s | Activity status date  | 
DATE | yes | 
| d_pmt_s | Next payment due date  | 
DATE | yes | 
| d_acc_s | Note accrued to date  | 
DATE | yes | 
| d_pay_s | Last payment date  | 
DATE | yes | 
| d_lst_s | Last payment due date  | 
DATE | yes | 
| d_eff_s | Effective date of last payment  | 
DATE | yes | 
| d_pyf_s | Date note was paid off  | 
DATE | yes | 
| t_pyf_s | Time note was paid off  | 
CHAR(6) | yes | 
| d_epf_s | Payoff effective date  | 
DATE | yes | 
| act_nt_s | Activity status  | 
CHAR(4) | yes | 
| acc_nt_s | Accrual method  | 
CHAR(4) | yes | 
| typ_nt_s | Note type  | 
CHAR(4) | yes | 
| fl_idx_s | Float index code  | 
CHAR(4) | yes | 
| bank_s | Bank account GL vector ' 1' - If multiple banks module is purchased ' ' - multiple banks module is not purchased  | 
CHAR(3) | yes | 
| due_lst_c | Payment due last accrual (Y/N)  | 
CHAR(1) | yes | 
| rem_allow_c | Removal allowed (Y/N)  | 
CHAR(1) | yes | 
| commt1_s | Comments [1]  | 
VARCHAR2(80) | yes | 
| commt2_s | Comments [2]  | 
VARCHAR2(80) | yes | 
| desc_s | Note description  | 
VARCHAR2(36) | yes | 
| pmt_l | Number of payments accrued  | 
NUMBER(10) | yes | 
| note_trm_l | Note term  | 
NUMBER(10) | yes | 
| due_l | Payment due day  | 
NUMBER(10) | yes | 
| pmt_prcd_l | Number of payments processed  | 
NUMBER(10) | yes | 
| p_int_rt_d | Interest rate  | 
NUMBER(15,5) | yes | 
| p_add_rt_d | Note rate add-on  | 
NUMBER(15,5) | yes | 
| p_min_rt_d | Float floor rate  | 
NUMBER(15,5) | yes | 
| p_max_rt_d | Float ceiling rate  | 
NUMBER(15,5) | yes | 
| org_d | Original principal amount  | 
NUMBER(15,2) | yes | 
| down_d | Down payment  | 
NUMBER(15,2) | yes | 
| cur_prn1_d | Current principal balance  | 
NUMBER(15,2) | yes | 
| int_car_d | Interest carry over  | 
NUMBER(15,2) | yes | 
| int_unpd_d | Interest unpaid  | 
NUMBER(15,2) | yes | 
| int_accr_cur_d | Interest accrued current month  | 
NUMBER(15,2) | yes | 
| int_ptd_d | Interest accrued period to date  | 
NUMBER(15,2) | yes | 
| int_ytd1_d | Interest Y-T-D  | 
NUMBER(15,2) | yes | 
| int_ltd_d | Interest paid L-T-D  | 
NUMBER(15,2) | yes | 
| int_prv1_d | Interest previous year  | 
NUMBER(15,2) | yes | 
| int_par_bk_d | Partial period interest at booking  | 
NUMBER(15,2) | yes | 
| int_par_pf_d | Partial period interest at payoff  | 
NUMBER(15,2) | yes | 
| base_amt_pf_d | Base payoff amount  | 
NUMBER(15,2) | yes | 
| outs_prn_pf_d | Principal outstanding at payoff  | 
NUMBER(15,2) | yes | 
| outs_int_pf_d | Interest outstanding at payoff  | 
NUMBER(15,2) | yes | 
| d_fund_s | Funding date  | 
DATE | yes | 
| int_perd_d | Interest per diem  | 
NUMBER(15,2) | yes | 
| bank_loan_s | Bank loan number  | 
CHAR(16) | yes | 
| gap_fee_d | Gap fee  | 
NUMBER(15,2) | yes | 
| sec_dep_d | Security deposit  | 
NUMBER(15,2) | yes | 
| res_for_chrg_bck_d | Reserve for charge backs  | 
NUMBER(15,2) | yes | 
| ser_fee_d | Service fee  | 
NUMBER(15,2) | yes | 
| sec_dep_bnk_code_s | Bank code for security deposit  | 
CHAR(4) | yes | 
| res_chrg_bck_bnk_code_s | Bank code for reserve for charge backs  | 
CHAR(4) | yes | 
| pre_pmt_res_bnk_code_s | Bank code for pre-payment reserve  | 
CHAR(4) | yes | 
| eqp_cost_d | Equipment cost  | 
NUMBER(15,2) | yes | 
| lse_fee_d | Lease fees  | 
NUMBER(15,2) | yes | 
| lse_numb_att_s | Lease number tied to note  | 
CHAR(10) | yes | 
| last_eoy_year_s | Last year (YYYY) for which Clear YTD Fields has run  | 
CHAR(4) | yes |