Columns |
Name |
Description |
Datatype ¿? |
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 |
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 |
st_rep_s |
State reporting code |
char(4) |
yes |
ct_rep_s |
County reporting code |
char(4) |
yes |
cy_rep_s |
City reporting code |
char(4) |
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 |
p_st_rat_o_d |
Old state rate |
double precision |
yes |
p_ct_rat_o_d |
Old county rate |
double precision |
yes |
p_cy_rat_o_d |
Old 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_ct_tran_rat_o_d |
Old county transit rate |
double precision |
yes |
p_cy_tran_rat_o_d |
Old city transit rate |
double precision |
yes |
freeze_s |
Frozen rates (LOC.FREEZE code)
"Frozen" means that:
1. The LeasePak Vertex module [U0437] won't modify the
specified rates on the rlo row and lower jurisdictions.
2. The Location update [U0701] won't cascade the specified
rates from higher jurisdictions into the rlo row and
lower jurisdictions.
Note that the rates on an rlo row can always be manually
modified by [U0701] regardless of the setting of freeze_s.
Possible settings for freeze_s:
On a state row:
NONE - no rates are frozen
ST - state rates are frozen in the state and in
every county and city in the state
INCL - all rates are frozen in the state and in every
county and city in the state
On a county row:
NONE - no rates are frozen
ST - state rates are frozen in the county and in
every city in the county
CO - county rates are frozen in the county and in
every city in the county
STCO - state and county rates are frozen in the county
and in every city in the county
INCL - all rates are frozen in the county and in every
city in the county
On a city row:
NONE - no rates are frozen
ST - state rates are frozen
CO - county rates are frozen
CI - city rates are frozen
STCO - state and county rates are frozen
STCI - state and city rates are frozen
COCI - county and city rates are frozen
SCC - state, county, and city rates are frozen |
char(4) |
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 |
d_st_veh_sales_s |
Effective date of rate change, state vehicle sales tax |
datetime |
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 |
d_ct_veh_sales_s |
Effective date of rate change, county vehicle sales tax |
datetime |
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 |
d_cy_veh_sales_s |
Effective date of rate change, city vehicle sales tax |
datetime |
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 |
d_st_veh_use_s |
Effective date of rate change, state vehicle use tax |
datetime |
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 |
d_ct_veh_use_s |
Effective date of rate change, county vehicle use tax |
datetime |
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 |
d_cy_veh_use_s |
Effective date of rate change, city vehicle use tax |
datetime |
yes |
p_st_rat_veh_sales_o_d |
Old state rate for vehicle sales tax |
double precision |
yes |
p_st_oth_rat_veh_sales_o_d |
Old state other rate for vehicle sales tax |
double precision |
yes |
p_ct_rat_veh_sales_o_d |
Old county rate for vehicle sales tax |
double precision |
yes |
p_ct_tran_rat_veh_sales_o_d |
Old county transit rate for vehicle sales tax |
double precision |
yes |
p_cy_rat_veh_sales_o_d |
Old city rate for vehicle sales tax |
double precision |
yes |
p_cy_tran_rat_veh_sales_o_d |
Old city transit rate for vehicle sales tax |
double precision |
yes |
p_st_rat_veh_use_o_d |
Old state rate for vehicle use tax |
double precision |
yes |
p_st_oth_rat_veh_use_o_d |
Old state other rate for vehicle use tax |
double precision |
yes |
p_ct_rat_veh_use_o_d |
Old county rate for vehicle use tax |
double precision |
yes |
p_ct_tran_rat_veh_use_o_d |
Old county transit rate for vehicle use tax |
double precision |
yes |
p_cy_rat_veh_use_o_d |
Old city rate for vehicle use tax |
double precision |
yes |
p_cy_tran_rat_veh_use_o_d |
Old city transit rate for vehicle use tax |
double precision |
yes |