LeasePak 5.3a Database Reference (Sybase)

Home • Table • Indexes

---

rcu Table: Customer

Description	Column	Datatype
Customer number	cus_s	char (9)
Sybase timestamp	timestamp	timestamp
Default application	def_app_s	char (10)
Parent customer	par_cus_s	char (9)
Financial statement date	d_fin_s	datetime
Drawdown credit limit expiration date	d_drawdown_exp_s	datetime
Collection team	col_team_s	char (4)
Default portfolio	def_por_s	char (2)
Default company	def_com_s	char (2)
Default region	def_reg_s	char (2)
Default office	def_off_s	char (3)
Long name	nam_long_s	char (125)
Address	add_s	char (36)
Address 2	add2_s	char (36)
City	cty_s	char (25)
State	st_s	char (2)
Zip code	zip_s	char (9)
Phone number	phn_s	char (10)
Contact name	cont_nam_s	char (36)
Contact title	cont_title_s	char (25)
Billing address name	bill_nam_s	char (36)
Billing address	bill_add_s	char (36)
Billing address 2	bill_add2_s	char (36)
Billing address city	bill_cty_s	char (25)
Billing address state	bill_st_s	char (2)
Billing address zip code	bill_zip_s	char (9)
Drawdown credit limit	drawdown_limit_d	double precision
Acquisition cost - approved applications	appr_app_d	double precision
First lease in customer	first_cus_lse_s	char (10)
Last lease in customer	last_cus_lse_s	char (10)
Letter version code	lt_version_s	char (4)
Revolving credit limit expiration date	d_revolving_exp_s	datetime
Revolving credit limit	revolving_limit_d	double precision
Credit exposure, date last updated	d_crd_exp_upd_s	datetime
Credit exposure, time last updated	t_crd_exp_upd_s	char (6)
Credit exposure, total # of approved applications	crd_exp_tot_app_l	integer
Credit exposure, total # of leases	crd_exp_tot_lse_l	integer
Credit exposure, total # of delinquent leases	crd_exp_tot_del_l	integer
Credit exposure, custom gross receivable	crd_exp_gr_rec_d	double precision
Credit exposure, custom gross outstanding balance	crd_exp_gr_outs_d	double precision
Credit exposure, custom net outstanding balance	crd_exp_net_outs_d	double precision
Credit exposure, total approved acquisition cost	crd_exp_tot_apprv_d	double precision
Credit exposure, total exposure	crd_exp_tot_exposure_d	double precision
Credit exposure, total delinquent	crd_exp_tot_del_d	double precision
Credit exposure, delinquent category 1	crd_exp_del_cat1_d	double precision
Credit exposure, delinquent category 2	crd_exp_del_cat2_d	double precision
Credit exposure, delinquent category 3	crd_exp_del_cat3_d	double precision
Credit exposure, delinquent category 4	crd_exp_del_cat4_d	double precision
Home phone type	hom_phn_type_s	char (4)
Business phone type	bus_phn_type_s	char (4)
Last phone used	last_phn_used_c	char (1)
Business phone	bus_phn_s	char (10)
Email address	email_s	char (50)

rcu Indexes:

Index name	Piece 1	Piece 2
rcu_idx0	cus_s
rcu_idx1	par_cus_s	cus_s

---

Home • Table • Indexes

 

LeasePak  Database Reference

©  by McCue Systems Incorporated. All rights reserved.

The information contained in this document is the property of McCue Systems, Inc. Use of the information contained herein is restricted. Conditions of use are subject to change without notice. McCue Systems, Inc. assumes no liability for any inaccuracy that may appear in this document; the contents of this document do not constitute a promise or warranty. The software described in this document is furnished under license and may be used or copied only in accordance with the terms of said license. Unauthorized use, alteration, or reproduction of this document without the written consent of McCue Systems, Inc. is prohibited.

Your document is loading...

This message should disappear within 5-15 seconds, depending on the size of the document and the speed of your connection to the Documentation Suite.

If you can still see this message after 20 seconds, try clicking the Refresh or Reload button on your Web browser.

If your document still does not load, refer to Document Load Troubleshooting for instructions on how to fix possible problems with either your Documentation Suite installation or Web browser setup.

If you do not have read access to the parent docsuite directory, you will not be able to load the Document Load Troubleshooting document. In this case, contact your network administrator for assistance.