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

Database Reference Sybase 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
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