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