rmf Table: Loan
LeasePak Documentation Suite NETSOL website
LeasePak Database Objects

Database Reference Oracle DBMS

rmf Table: Loan

Child Tables

Name Description
rmfp Loan Payment Schedule

Indexes

Name Segment 1 Segment 2
rmf_idx0 fin_inst_s loan_s

     
Columns
Name DescriptionDatatype ¿? Allow Null
fin_inst_s
Financial institution
CHAR(4) no
loan_s
Loan number
CHAR(7) no
stamp_l
Record modification stamp
NUMBER(10) no
por_s
Portfolio
CHAR(2) yes
d_inc_s
Inception date
DATE yes
d_act_s
Activity date
DATE yes
d_loan_acc_s
Loan accrued to date
DATE 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]
VARCHAR2(80) yes
commt2_s
Comments [2]
VARCHAR2(80) yes
pmt_l
Number of payments accrued
NUMBER(10) yes
loan_trm_l
Loan term
NUMBER(10) yes
p_int_d
Interest rate / APR
NUMBER(15,5) yes
orig_d
Original amount
NUMBER(15,2) yes
down_d
Down payment
NUMBER(15,2) yes
cur_prn_d
Current principal balance
NUMBER(15,2) yes
int_cur_d
Current month interest
NUMBER(15,2) yes
int_ytd_d
Interest Y-T-D
NUMBER(15,2) yes
int_prv_d
Interest previous year
NUMBER(15,2) yes
int_ltd1_d
Interest L-T-D
NUMBER(15,2) yes
loan_org_d
Original cost of attached assets
NUMBER(15,2) yes