rcu Table: Customer
LeasePak Documentation Suite NETSOL website
LeasePak Database Objects

Database Reference Sybase DBMS

rcu Table: Customer

Indexes

Name Segment 1 Segment 2
rcu_idx0 cus_s  
rcu_idx1 par_cus_s cus_s

     
Columns
Name DescriptionDatatype ¿? Allow Null
cus_s
Customer number
char(9) no
timestamp
Record modification stamp
timestamp yes
def_app_s
Default application
char(10) yes
par_cus_s
Parent customer
char(9) no
d_fin_s
Financial statement date
datetime yes
d_drawdown_exp_s
Drawdown credit limit expiration date
datetime 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
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
phn_s
Phone number
char(10) yes
cont_nam_s
Contact name
char(36) yes
cont_title_s
Contact title
char(25) 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
drawdown_limit_d
Drawdown credit limit
double precision yes
appr_app_d
Acquisition cost - approved applications
double precision yes
first_cus_lse_s
First lease in customer
char(10) yes
last_cus_lse_s
Last lease in customer
char(10) yes
lt_version_s
Letter version code
char(4) yes
d_revolving_exp_s
Revolving credit limit expiration date
datetime yes
revolving_limit_d
Revolving credit limit
double precision 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
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
bus_phn_s
Business phone
char(10) yes
email_s
Email address
char(50) yes
pmt_hier_s
Payment hierarchy
char(4) yes
d_lup_s
Date of last update
datetime yes
t_lup_s
Time of last update
char(6) yes