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

Database Reference Sybase DBMS

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
char(9) no
timestamp
Record modification stamp
timestamp yes
cus_s
Customer number
char(9) no
ym_bus_est_s
Year and month when business was established (YYYYMM)
char(6) yes
d_drawdown_exp_s
Drawdown credit limit expiration date
datetime yes
d_inco_s
Business incorporated date
datetime yes
ym_cur_own_s
Year and month when current owners took ownership (YYYYMM)
char(6) yes
d_birth_s
Date of birth
datetime yes
d_lst_mod_s
Last modification date
datetime yes
d_othr_lst_mod_s
Other address last modification date
datetime yes
d_bill_lst_mod_s
Billing address last modification date
datetime yes
d_lcus_s
Date custom outstanding last updated
  For use only by collection module
datetime yes
d_fin_stmt_s
Financial statement date
datetime yes
bus_typ_s
Type of business
char(4) yes
remit_s
Remittance address
char(4) yes
res_stat_s
Residence status (RES.STAT code)
char(4) yes
sic_s
SIC code
char(4) yes
sal_s
Salutation
char(4) yes
add_inc_src_s
Additional income source code
char(4) yes
marital_s
Marital status
char(4) yes
col_team_s
Collection team
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_long_s
Long name
char(125) yes
bus_phn_s
Business phone
char(10) yes
hom_phn_s
Home phone
char(10) yes
add_s
Address
char(36) yes
add2_s
Address 2
char(36) yes
cty_s
City
char(25) yes
st_s
State code (RST.ST_S code)
char(2) yes
zip_s
Zip code
char(9) yes
bus_desc_s
Business description
char(36) yes
short_cont_nam_s
Contact name
char(25) yes
cont_title_s
Contact title
char(25) yes
sig_nam_s
Signer name
char(25) yes
sig_title_s
Signer title
char(25) yes
bus_st_s
State where business incorporated
char(2) yes
tx_exempt_s
Tax exempt number
char(20) yes
lst_mod_init_s
Last modification initials
char(3) yes
othr_nam_s
Other address name
char(36) yes
othr_add_s
Other address
char(36) yes
othr_add2_s
Other address 2
char(36) yes
othr_cty_s
Other address city
char(25) yes
othr_st_s
Other address state
char(2) yes
othr_zip_s
Other address zip code
char(9) yes
othr_bus_phn_s
Other address business phone
char(10) yes
othr_home_phn_s
Other address home phone
char(10) yes
othr_note1_s
Other address note 1
char(36) yes
othr_note2_s
Other address note 2
char(36) yes
othr_id_s
Other address ID
char(9) yes
othr_lst_mod_init_s
Other address last modification initials
char(3) yes
bill_nam_s
Billing address name
char(36) yes
bill_add_s
Billing address
char(36) yes
bill_add2_s
Billing address 2
char(36) yes
bill_cty_s
Billing address city
char(25) yes
bill_st_s
Billing address state
char(2) yes
bill_zip_s
Billing address zip code
char(9) yes
bill_lst_mod_init_s
Billing address last modification initials
char(3) yes
col_init_s
Collector when removed from collection tracking
char(3) yes
age_l
Age
integer yes
res_yrs_l
Length of residence in years
integer yes
res_mon_l
Length of residence in months
integer yes
dependents_l
Number of dependents
integer yes
del_lse_l
Total # of delinquent leases
  See notes for col_gr_rec_d field
integer yes
othr_res_yrs_l
Other address years residing
integer yes
othr_res_mon_l
Other address months residing
integer yes
mon_pmt_d
Monthly payment
double precision yes
drawdown_limit_d
Drawdown credit limit
double precision yes
auto_lim_d
Auto-approval limit
double precision yes
add_inc_d
Additional income source amount
double precision yes
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.
double precision yes
col_net_out_d
Custom net outstanding
  See notes for col_gr_rec_d field
double precision yes
col_gr_out_d
Custom gross outstanding
  See notes for col_gr_rec_d field
double precision yes
del_amt_d
Total delinquent amount
  See notes for col_gr_rec_d field
double precision yes
appr_app_d
Acquisition cost - approved applications
double precision yes
lt_version_s
Letter version code
char(4) yes
col_stat_s
Collection status
char(4) yes
d_revolving_exp_s
Revolving credit limit expiration date
datetime yes
revolving_limit_d
Revolving credit limit
double precision yes
prenote_sent_c
Prenotification sent (Y/N)
char(1) yes
d_prenote_sent_on_s
Date prenotification sent on
datetime yes
ach_type_s
ACH type (ACH.TYP code)
  PPD - Consumer
  CCD - Corporate
  AUS - Australian WDE
  400 - Rent/lease (Canada)
char(4) yes
inst_id_s
PAP institution/ACH transit ID
char(9) yes
payer_acct_s
PAP account number
char(17) yes
d_crd_exp_upd_s
Credit exposure, date last updated
datetime yes
t_crd_exp_upd_s
Credit exposure, time last updated
char(6) yes
crd_exp_tot_app_l
Credit exposure, total # of approved applications
integer yes
crd_exp_tot_lse_l
Credit exposure, total # of leases
integer yes
crd_exp_tot_del_l
Credit exposure, total # of delinquent leases
integer yes
crd_exp_gr_rec_d
Credit exposure, custom gross receivable
double precision yes
crd_exp_gr_outs_d
Credit exposure, custom gross outstanding balance
double precision yes
crd_exp_net_outs_d
Credit exposure, custom net outstanding balance
double precision yes
crd_exp_tot_apprv_d
Credit exposure, total approved acquisition cost
double precision yes
crd_exp_tot_exposure_d
Credit exposure, total exposure
double precision yes
crd_exp_tot_del_d
Credit exposure, total delinquent
double precision yes
crd_exp_del_cat1_d
Credit exposure, delinquent category 1
double precision yes
crd_exp_del_cat2_d
Credit exposure, delinquent category 2
double precision yes
crd_exp_del_cat3_d
Credit exposure, delinquent category 3
double precision yes
crd_exp_del_cat4_d
Credit exposure, delinquent category 4
double precision yes
d_co_crd_exp_upd_s
Co-lessee credit exposure, date last updated
datetime yes
t_co_crd_exp_upd_s
Co-lessee credit exposure, time last updated
char(6) yes
co_crd_exp_tot_app_l
Co-lessee credit exposure, total # of approved applications
integer yes
co_crd_exp_tot_lse_l
Co-lessee credit exposure, total # of leases
integer yes
co_crd_exp_tot_del_l
Co-lessee credit exposure, total # of delinquent leases
integer yes
co_crd_exp_gr_rec_d
Co-lessee credit exposure, custom gross receivable
double precision yes
co_crd_exp_gr_outs_d
Co-lessee credit exposure, custom gross outstanding balance
double precision yes
co_crd_exp_net_outs_d
Co-lessee credit exposure, custom net outstanding balance
double precision yes
co_crd_exp_tot_apprv_d
Co-lessee credit exposure, total approved acquisition cost
double precision yes
co_crd_exp_tot_exposure_d
Co-lessee credit exposure, total exposure
double precision yes
co_crd_exp_tot_del_d
Co-lessee credit exposure, total delinquent
double precision yes
co_crd_exp_del_cat1_d
Co-lessee credit exposure, delinquent category 1
double precision yes
co_crd_exp_del_cat2_d
Co-lessee credit exposure, delinquent category 2
double precision yes
co_crd_exp_del_cat3_d
Co-lessee credit exposure, delinquent category 3
double precision yes
co_crd_exp_del_cat4_d
Co-lessee credit exposure, delinquent category 4
double precision yes
hom_phn_type_s
Home phone type
char(4) yes
bus_phn_type_s
Business phone type
char(4) yes
last_phn_used_c
Last phone used
char(1) yes
delq_l
Number of times delinquent
integer yes
contract_st_s
Contract state
char(2) yes
pap_acct_type_s
PAP bank account type
char(4) yes
email_s
Email address
char(50) yes
stax_exempt_s
Sales/use tax exempt code
char(4) yes
tot_asm1_b_d
Total client assessment 1 billed
double precision yes
tot_asm1_p_d
Total client assessment 1 paid
double precision yes
tot_asm2_b_d
Total client assessment 2 billed
double precision yes
tot_asm2_p_d
Total client assessment 2 paid
double precision yes
tot_asm3_b_d
Total client assessment 3 billed
double precision yes
tot_asm3_p_d
Total client assessment 3 paid
double precision yes
due_l
Payment due day
integer yes
d_lup_s
Date of last update
datetime yes
t_lup_s
Time of last update
char(6) yes
act_stat_s
Activity status (STAT code)
char(4) yes
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
char(1) yes
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
char(1) yes
d_addr_conf_s
Address confirmation date
datetime yes
t_addr_conf_s
Address confirmation time
char(6) yes
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
char(1) yes