rle Table: Lender
LeasePak Documentation Suite NETSOL website
LeasePak Database Objects

Database Reference Oracle DBMS

rle Table: Lender

Child Tables

Name Description
rlec Lender Credit Line

Indexes

Name Segment 1
rle_idx0 len_s

    
Columns
Name DescriptionDatatype ¿? Allow Null
len_s
Lender
CHAR(9) no
stamp_l
Record modification stamp
NUMBER(10) no
d_est_s
Relationship established date
DATE yes
d_stat_s
Status date
DATE yes
stat_s
Activity status
CHAR(4) yes
rmt_type_s
Remittance type
CHAR(4) yes
rec_s
Recourse type
CHAR(4) yes
lt_version_s
Letter version code
CHAR(4) yes
def_por_s
Default portfolio
CHAR(2) yes
def_com_s
Default company
CHAR(2) yes
def_reg_s
Default region
CHAR(2) yes
def_off_s
Default office
CHAR(3) yes
nam_s
Name
VARCHAR2(36) yes
add_s
Address
VARCHAR2(36) yes
add2_s
Address 2
VARCHAR2(36) yes
cty_s
City
VARCHAR2(25) yes
st_s
State code (RST.ST_S code)
CHAR(2) yes
zip_s
Zip code
CHAR(9) yes
phn_s
Phone number
CHAR(10) yes
rmt_nam_s
Remittance name
VARCHAR2(36) yes
rmt_add_s
Remittance address
VARCHAR2(36) yes
rmt_add2_s
Remittance address 2
VARCHAR2(36) yes
rmt_cty_s
Remittance city
VARCHAR2(25) yes
rmt_st_s
Remittance state
CHAR(2) yes
rmt_zip_s
Remittance zip code
CHAR(9) yes
cont_nam_s
Contact name
VARCHAR2(36) yes
cont_title_s
Contact title
VARCHAR2(25) yes
commt1_s
Comments [1]
VARCHAR2(80) yes
commt2_s
Comments [2]
VARCHAR2(80) yes
email_s
Email address
VARCHAR2(50) yes
d_lup_s
Date of last update
DATE yes
t_lup_s
Time of last update
CHAR(6) yes