rcu Table: Customer

Database Reference

rcu Table: Customer

Indexes

Name	Segment 1	Segment 2
rcu_idx0	cus_s
rcu_idx1	par_cus_s	cus_s

Columns
Name	Description	Datatype ¿?	Allow Null
cus_s	Customer number
	Record modification stamp
def_app_s	Default application
par_cus_s	Parent customer
d_fin_s	Financial statement date
d_drawdown_exp_s	Drawdown credit limit expiration date
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
add_s	Address
add2_s	Address 2
cty_s	City
st_s	State code (RST.ST_S code)
zip_s	Zip code
phn_s	Phone number
cont_nam_s	Contact name
cont_title_s	Contact title
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
drawdown_limit_d	Drawdown credit limit
appr_app_d	Acquisition cost - approved applications
first_cus_lse_s	First lease in customer
last_cus_lse_s	Last lease in customer
lt_version_s	Letter version code
d_revolving_exp_s	Revolving credit limit expiration date
revolving_limit_d	Revolving credit limit
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
hom_phn_type_s	Home phone type
bus_phn_type_s	Business phone type
last_phn_used_c	Last phone used
bus_phn_s	Business phone
email_s	Email address
pmt_hier_s	Payment hierarchy
d_lup_s	Date of last update
t_lup_s	Time of last update