ral Table: Lessee/Co-Lessee
LeasePak Documentation Suite NETSOL website
LeasePak Database Objects

Database Reference

ral Table: Lessee/Co-Lessee

Child Tables

Name Description
rale Lessee/Co-Lessee Employment

Indexes

Name Segment 1 Segment 2
ral_idx0 les_s  
ral_idx1 cus_s les_s


Columns
Name DescriptionDatatype ¿? Allow Null
les_s
Lessee number
Record modification stamp
cus_s
Customer number
ym_bus_est_s
Year and month when business was established (YYYYMM)
d_drawdown_exp_s
Drawdown credit limit expiration date
d_inco_s
Business incorporated date
ym_cur_own_s
Year and month when current owners took ownership (YYYYMM)
d_birth_s
Date of birth
d_lst_mod_s
Last modification date
d_othr_lst_mod_s
Other address last modification date
d_bill_lst_mod_s
Billing address last modification date
d_lcus_s
Date custom outstanding last updated
  For use only by collection module
d_fin_stmt_s
Financial statement date
bus_typ_s
Type of business
remit_s
Remittance address
res_stat_s
Residence status (RES.STAT code)
sic_s
SIC code
sal_s
Salutation
add_inc_src_s
Additional income source code
marital_s
Marital status
col_team_s
Collection team
def_por_s
Default portfolio
def_com_s
Default company
def_reg_s
Default region
def_off_s
Default office
nam_long_s
Long name
bus_phn_s
Business phone
hom_phn_s
Home phone
add_s
Address
add2_s
Address 2
cty_s
City
st_s
State code (RST.ST_S code)
zip_s
Zip code
bus_desc_s
Business description
short_cont_nam_s
Contact name
cont_title_s
Contact title
sig_nam_s
Signer name
sig_title_s
Signer title
bus_st_s
State where business incorporated
tx_exempt_s
Tax exempt number
lst_mod_init_s
Last modification initials
othr_nam_s
Other address name
othr_add_s
Other address
othr_add2_s
Other address 2
othr_cty_s
Other address city
othr_st_s
Other address state
othr_zip_s
Other address zip code
othr_bus_phn_s
Other address business phone
othr_home_phn_s
Other address home phone
othr_note1_s
Other address note 1
othr_note2_s
Other address note 2
othr_id_s
Other address ID
othr_lst_mod_init_s
Other address last modification initials
bill_nam_s
Billing address name
bill_add_s
Billing address
bill_add2_s
Billing address 2
bill_cty_s
Billing address city
bill_st_s
Billing address state
bill_zip_s
Billing address zip code
bill_lst_mod_init_s
Billing address last modification initials
col_init_s
Collector when removed from collection tracking
age_l
Age
res_yrs_l
Length of residence in years
res_mon_l
Length of residence in months
dependents_l
Number of dependents
del_lse_l
Total # of delinquent leases
  See notes for col_gr_rec_d field
othr_res_yrs_l
Other address years residing
othr_res_mon_l
Other address months residing
mon_pmt_d
Monthly payment
drawdown_limit_d
Drawdown credit limit
auto_lim_d
Auto-approval limit
add_inc_d
Additional income source amount
col_gr_rec_d
Custom gross receivable
  Notes:
  1. Used only by the collection module
  2. Calculated only for delinquent lessees
  3. Only accurate as of the last time EOP Sequential Updates
     and EOP Collection Initialization was run with the
     U1121 Collection switch on
  4. Set to 0 for non-delinquent lessees
  5. These notes also apply to the col_net_out_d,
     col_gr_out_d, del_amt_d, and del_lse_l fields.
col_net_out_d
Custom net outstanding
  See notes for col_gr_rec_d field
col_gr_out_d
Custom gross outstanding
  See notes for col_gr_rec_d field
del_amt_d
Total delinquent amount
  See notes for col_gr_rec_d field
appr_app_d
Acquisition cost - approved applications
lt_version_s
Letter version code
col_stat_s
Collection status
d_revolving_exp_s
Revolving credit limit expiration date
revolving_limit_d
Revolving credit limit
prenote_sent_c
Prenotification sent (Y/N)
d_prenote_sent_on_s
Date prenotification sent on
ach_type_s
ACH type (ACH.TYP code)
  PPD - Consumer
  CCD - Corporate
  AUS - Australian WDE
  400 - Rent/lease (Canada)
inst_id_s
PAP institution/ACH transit ID
payer_acct_s
PAP account number
d_crd_exp_upd_s
Credit exposure, date last updated
t_crd_exp_upd_s
Credit exposure, time last updated
crd_exp_tot_app_l
Credit exposure, total # of approved applications
crd_exp_tot_lse_l
Credit exposure, total # of leases
crd_exp_tot_del_l
Credit exposure, total # of delinquent leases
crd_exp_gr_rec_d
Credit exposure, custom gross receivable
crd_exp_gr_outs_d
Credit exposure, custom gross outstanding balance
crd_exp_net_outs_d
Credit exposure, custom net outstanding balance
crd_exp_tot_apprv_d
Credit exposure, total approved acquisition cost
crd_exp_tot_exposure_d
Credit exposure, total exposure
crd_exp_tot_del_d
Credit exposure, total delinquent
crd_exp_del_cat1_d
Credit exposure, delinquent category 1
crd_exp_del_cat2_d
Credit exposure, delinquent category 2
crd_exp_del_cat3_d
Credit exposure, delinquent category 3
crd_exp_del_cat4_d
Credit exposure, delinquent category 4
d_co_crd_exp_upd_s
Co-lessee credit exposure, date last updated
t_co_crd_exp_upd_s
Co-lessee credit exposure, time last updated
co_crd_exp_tot_app_l
Co-lessee credit exposure, total # of approved applications
co_crd_exp_tot_lse_l
Co-lessee credit exposure, total # of leases
co_crd_exp_tot_del_l
Co-lessee credit exposure, total # of delinquent leases
co_crd_exp_gr_rec_d
Co-lessee credit exposure, custom gross receivable
co_crd_exp_gr_outs_d
Co-lessee credit exposure, custom gross outstanding balance
co_crd_exp_net_outs_d
Co-lessee credit exposure, custom net outstanding balance
co_crd_exp_tot_apprv_d
Co-lessee credit exposure, total approved acquisition cost
co_crd_exp_tot_exposure_d
Co-lessee credit exposure, total exposure
co_crd_exp_tot_del_d
Co-lessee credit exposure, total delinquent
co_crd_exp_del_cat1_d
Co-lessee credit exposure, delinquent category 1
co_crd_exp_del_cat2_d
Co-lessee credit exposure, delinquent category 2
co_crd_exp_del_cat3_d
Co-lessee credit exposure, delinquent category 3
co_crd_exp_del_cat4_d
Co-lessee credit exposure, delinquent category 4
hom_phn_type_s
Home phone type
bus_phn_type_s
Business phone type
last_phn_used_c
Last phone used
delq_l
Number of times delinquent
contract_st_s
Contract state
pap_acct_type_s
PAP bank account type
email_s
Email address
stax_exempt_s
Sales/use tax exempt code
tot_asm1_b_d
Total client assessment 1 billed
tot_asm1_p_d
Total client assessment 1 paid
tot_asm2_b_d
Total client assessment 2 billed
tot_asm2_p_d
Total client assessment 2 paid
tot_asm3_b_d
Total client assessment 3 billed
tot_asm3_p_d
Total client assessment 3 paid
due_l
Payment due day
d_lup_s
Date of last update
t_lup_s
Time of last update
act_stat_s
Activity status (STAT code)
addr_type_c
Address type (B/D/M/P/S/Y/Z)
  B - Business address
  D - Data reporter default address
  M - Military address
  P - Bill payer service
  S - Secondary address
  Y - Consumer address
  Z - Unknown type
addr_stat_c
Address status (C/N/U/Z)
  C - Confirmed/verified address
  N - Not confirmed address
  U - Undeliverable address/returned mail
  Z - Unknown status
d_addr_conf_s
Address confirmation date
t_addr_conf_s
Address confirmation time
cb_business_c
Credit bureau business indicator (Y/N)
  Y - Report lessee to CB as a business
  N - Report lessee to CB as a non-business