---

LeasePak 5.1a Database Reference (Sybase)

Home • Table • Indexes

---

rlo Table: Location

Description	Column	Datatype
State	st_s	char (2)
County location code	ct_s	char (4)
City location code	cy_s	char (4)
Sybase timestamp	timestamp	timestamp
Effective date of rate change, state	d_st_s	datetime
Effective date of rate change, county	d_ct_s	datetime
Effective date of rate change, city	d_cy_s	datetime
State reporting code	st_rep_s	char (4)
County reporting code	ct_rep_s	char (4)
City reporting code	cy_rep_s	char (4)
State rate	p_st_rat_d	double precision
County rate	p_ct_rat_d	double precision
City rate	p_cy_rat_d	double precision
Old state rate	p_st_rat_o_d	double precision
Old county rate	p_ct_rat_o_d	double precision
Old city rate	p_cy_rat_o_d	double precision
State maximum tax amount	st_max_d	double precision
County maximum tax amount	ct_max_d	double precision
City maximum tax amount	cy_max_d	double precision
County transit rate	p_ct_tran_rat_d	double precision
City transit rate	p_cy_tran_rat_d	double precision
Old county transit rate	p_ct_tran_rat_o_d	double precision
Old city transit rate	p_cy_tran_rat_o_d	double precision

rlo Indexes:

Index name	Piece 1	Piece 2	Piece 3
rlo_idx0	st_s	ct_s	cy_s
rlo_idx1	st_s	cy_s	ct_s

---

Home • Table • Indexes

(c) Copyright 2004 McCue Systems, Inc.