rlo Table: Location
LeasePak Documentation Suite NETSOL website
Home Search Help
LeasePak Database Objects
Return to Top

Database Reference

rlo Table: Location

Indexes

Name Segment 1 Segment 2 Segment 3
rlo_idx0 st_s ct_s cy_s
rlo_idx1 st_s cy_s ct_s


Columns
Name DescriptionDatatype ¿? Allow Null
st_s 
State code (RST.ST_S code)
ct_s 
County location code
cy_s 
City location code
 
Record modification stamp
d_st_s 
Effective date of rate change, state
d_ct_s 
Effective date of rate change, county
d_cy_s 
Effective date of rate change, city
st_rep_s 
State reporting code
ct_rep_s 
County reporting code
cy_rep_s 
City reporting code
p_st_rat_d 
State rate
p_ct_rat_d 
County rate
p_cy_rat_d 
City rate
p_st_rat_o_d 
Old state rate
p_ct_rat_o_d 
Old county rate
p_cy_rat_o_d 
Old city rate
st_max_d 
State maximum tax amount
ct_max_d 
County maximum tax amount
cy_max_d 
City maximum tax amount
p_ct_tran_rat_d 
County transit rate
p_cy_tran_rat_d 
City transit rate
p_ct_tran_rat_o_d 
Old county transit rate
p_cy_tran_rat_o_d 
Old city transit rate
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
p_st_rat_veh_sales_d 
State rate for vehicle sales tax
p_st_oth_rat_veh_sales_d 
State other rate for vehicle sales tax
d_st_veh_sales_s 
Effective date of rate change, state vehicle sales tax
p_ct_rat_veh_sales_d 
County rate for vehicle sales tax
p_ct_tran_rat_veh_sales_d 
County transit rate for vehicle sales tax
d_ct_veh_sales_s 
Effective date of rate change, county vehicle sales tax
p_cy_rat_veh_sales_d 
City rate for vehicle sales tax
p_cy_tran_rat_veh_sales_d 
City transit rate for vehicle sales tax
d_cy_veh_sales_s 
Effective date of rate change, city vehicle sales tax
p_st_rat_veh_use_d 
State rate for vehicle use tax
p_st_oth_rat_veh_use_d 
State other rate for vehicle use tax
d_st_veh_use_s 
Effective date of rate change, state vehicle use tax
p_ct_rat_veh_use_d 
County rate for vehicle use tax
p_ct_tran_rat_veh_use_d 
County transit rate for vehicle use tax
d_ct_veh_use_s 
Effective date of rate change, county vehicle use tax
p_cy_rat_veh_use_d 
City rate for vehicle use tax
p_cy_tran_rat_veh_use_d 
City transit rate for vehicle use tax
d_cy_veh_use_s 
Effective date of rate change, city vehicle use tax
p_st_rat_veh_sales_o_d 
Old state rate for vehicle sales tax
p_st_oth_rat_veh_sales_o_d 
Old state other rate for vehicle sales tax
p_ct_rat_veh_sales_o_d 
Old county rate for vehicle sales tax
p_ct_tran_rat_veh_sales_o_d 
Old county transit rate for vehicle sales tax
p_cy_rat_veh_sales_o_d 
Old city rate for vehicle sales tax
p_cy_tran_rat_veh_sales_o_d 
Old city transit rate for vehicle sales tax
p_st_rat_veh_use_o_d 
Old state rate for vehicle use tax
p_st_oth_rat_veh_use_o_d 
Old state other rate for vehicle use tax
p_ct_rat_veh_use_o_d 
Old county rate for vehicle use tax
p_ct_tran_rat_veh_use_o_d 
Old county transit rate for vehicle use tax
p_cy_rat_veh_use_o_d 
Old city rate for vehicle use tax
p_cy_tran_rat_veh_use_o_d 
Old city transit rate for vehicle use tax