rho Table: Historical Location
LeasePak Documentation Suite NETSOL website
LeasePak Database Objects

Database Reference Sybase DBMS

rho Table: Historical Location

Indexes

Name Segment 1 Segment 2 Segment 3 Segment 4 Segment 5
rho_idx0 st_s ct_s cy_s d_run_s t_run_s

    
Columns
Name DescriptionDatatype ¿? Allow Null
st_s
State code (RST.ST_S code)
char(2) no
ct_s
County location code
char(4) no
cy_s
City location code
char(4) no
d_run_s
Run date
datetime no
t_run_s
Run time
char(6) no
timestamp
Record modification stamp
timestamp yes
d_st_s
Effective date of rate change, state
datetime yes
d_ct_s
Effective date of rate change, county
datetime yes
d_cy_s
Effective date of rate change, city
datetime yes
p_st_rat_d
State rate
double precision yes
p_ct_rat_d
County rate
double precision yes
p_cy_rat_d
City rate
double precision yes
st_max_d
State maximum tax amount
double precision yes
ct_max_d
County maximum tax amount
double precision yes
cy_max_d
City maximum tax amount
double precision yes
p_ct_tran_rat_d
County transit rate
double precision yes
p_cy_tran_rat_d
City transit rate
double precision yes
p_st_rat_veh_sales_d
State rate for vehicle sales tax
double precision yes
p_st_oth_rat_veh_sales_d
State other rate for vehicle sales tax
double precision yes
p_ct_rat_veh_sales_d
County rate for vehicle sales tax
double precision yes
p_ct_tran_rat_veh_sales_d
County transit rate for vehicle sales tax
double precision yes
p_cy_rat_veh_sales_d
City rate for vehicle sales tax
double precision yes
p_cy_tran_rat_veh_sales_d
City transit rate for vehicle sales tax
double precision yes
p_st_rat_veh_use_d
State rate for vehicle use tax
double precision yes
p_st_oth_rat_veh_use_d
State other rate for vehicle use tax
double precision yes
p_ct_rat_veh_use_d
County rate for vehicle use tax
double precision yes
p_ct_tran_rat_veh_use_d
County transit rate for vehicle use tax
double precision yes
p_cy_rat_veh_use_d
City rate for vehicle use tax
double precision yes
p_cy_tran_rat_veh_use_d
City transit rate for vehicle use tax
double precision yes