---

LeasePak 5.1a Database Reference (Sybase)

Home • Table • Indexes

---

rlr Table: Vendor

Description	Column	Datatype
Vendor	dlr_s	char (9)
Sybase timestamp	timestamp	timestamp
Default application	def_app_s	char (10)
Vendor agreement date	d_agr_s	datetime
Financial statement date	d_fin_s	datetime
Vendor participation code	part_s	char (4)
Salesperson number	sales_s	char (4)
Activity status	stat_s	char (4)
Vendor type	vend_type_s	char (4)
Rate plan group	plan_s	char (4)
Remittance type code	remit_type_s	char (4)
Recourse type	rec_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)
Remittance name	rmt_nam_s	char (36)
Remittance address	rmt_add_s	char (36)
Remittance address 2	rmt_add2_s	char (36)
Remittance city	rmt_cty_s	char (25)
Remittance state	rmt_st_s	char (2)
Remittance zip code	rmt_zip_s	char (9)
Contact name 1	cont_nam1_s	char (36)
Contact title 1	cont_title1_s	char (25)
Contact name 2	cont_nam2_s	char (36)
Contact title 2	cont_title2_s	char (25)
Owner or manager name	own_s	char (36)
Authorization signature name	auth_sign_s	char (36)
Bad debt percentage	bad_debt_d	double precision
Default G/L only (Y/N)	gl_only_c	char (1)
Letter version code	lt_version_s	char (4)
PAP institution/ACH transit ID	inst_id_s	char (9)
PAP account number	payer_acct_s	char (17)
Prenotification sent (Y/N)	prenote_sent_c	char (1)
Date prenotification sent on	d_prenote_sent_on_s	datetime
ACH types (PPD/CCD)	ach_type_s	char (4)
Dealer tax identification number	dlr_tax_id_s	char (36)
Holdback amount allow	holdback_d	double precision
Actual holdback amount	holdback_bal_d	double precision
Alert switches (Y/N)	alrt_s	char (6)
Alert amount [1]	alrt_amt1_d	double precision
Alert amount [2]	alrt_amt2_d	double precision
Alert amount [3]	alrt_amt3_d	double precision
Alert amount [4]	alrt_amt4_d	double precision
Alert amount [5]	alrt_amt5_d	double precision
Alert amount [6]	alrt_amt6_d	double precision
Alert suspense override date	d_alrt_susp_ovr_s	datetime
Alert note	alrt_note_s	char (255)
Insurance percentage	p_ins_d	double precision
Insurance bank code	ins_bank_s	char (3)
Email address	email_s	char (50)
Maturing lease team	ml_team_s	char (4)
New application owner	new_own_s	char (3)

rlr Indexes:

Index name	Piece 1
rlr_idx0	dlr_s

---

Home • Table • Indexes

(c) Copyright 2004 McCue Systems, Inc.