rlo Table: Location
LeasePak Documentation Suite NETSOL website
LeasePak Database Objects

Database Reference Oracle DBMS

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)
CHAR(2) no
ct_s
County location code
CHAR(4) no
cy_s
City location code
CHAR(4) no
stamp_l
Record modification stamp
NUMBER(10) no
d_st_s
Effective date of rate change, state
DATE yes
d_ct_s
Effective date of rate change, county
DATE yes
d_cy_s
Effective date of rate change, city
DATE 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
NUMBER(15,5) yes
p_ct_rat_d
County rate
NUMBER(15,5) yes
p_cy_rat_d
City rate
NUMBER(15,5) yes
p_st_rat_o_d
Old state rate
NUMBER(15,5) yes
p_ct_rat_o_d
Old county rate
NUMBER(15,5) yes
p_cy_rat_o_d
Old city rate
NUMBER(15,5) yes
st_max_d
State maximum tax amount
NUMBER(15,2) yes
ct_max_d
County maximum tax amount
NUMBER(15,2) yes
cy_max_d
City maximum tax amount
NUMBER(15,2) yes
p_ct_tran_rat_d
County transit rate
NUMBER(15,5) yes
p_cy_tran_rat_d
City transit rate
NUMBER(15,5) yes
p_ct_tran_rat_o_d
Old county transit rate
NUMBER(15,5) yes
p_cy_tran_rat_o_d
Old city transit rate
NUMBER(15,5) 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
NUMBER(15,5) yes
p_st_oth_rat_veh_sales_d
State other rate for vehicle sales tax
NUMBER(15,5) yes
d_st_veh_sales_s
Effective date of rate change, state vehicle sales tax
DATE yes
p_ct_rat_veh_sales_d
County rate for vehicle sales tax
NUMBER(15,5) yes
p_ct_tran_rat_veh_sales_d
County transit rate for vehicle sales tax
NUMBER(15,5) yes
d_ct_veh_sales_s
Effective date of rate change, county vehicle sales tax
DATE yes
p_cy_rat_veh_sales_d
City rate for vehicle sales tax
NUMBER(15,5) yes
p_cy_tran_rat_veh_sales_d
City transit rate for vehicle sales tax
NUMBER(15,5) yes
d_cy_veh_sales_s
Effective date of rate change, city vehicle sales tax
DATE yes
p_st_rat_veh_use_d
State rate for vehicle use tax
NUMBER(15,5) yes
p_st_oth_rat_veh_use_d
State other rate for vehicle use tax
NUMBER(15,5) yes
d_st_veh_use_s
Effective date of rate change, state vehicle use tax
DATE yes
p_ct_rat_veh_use_d
County rate for vehicle use tax
NUMBER(15,5) yes
p_ct_tran_rat_veh_use_d
County transit rate for vehicle use tax
NUMBER(15,5) yes
d_ct_veh_use_s
Effective date of rate change, county vehicle use tax
DATE yes
p_cy_rat_veh_use_d
City rate for vehicle use tax
NUMBER(15,5) yes
p_cy_tran_rat_veh_use_d
City transit rate for vehicle use tax
NUMBER(15,5) yes
d_cy_veh_use_s
Effective date of rate change, city vehicle use tax
DATE yes
p_st_rat_veh_sales_o_d
Old state rate for vehicle sales tax
NUMBER(15,5) yes
p_st_oth_rat_veh_sales_o_d
Old state other rate for vehicle sales tax
NUMBER(15,5) yes
p_ct_rat_veh_sales_o_d
Old county rate for vehicle sales tax
NUMBER(15,5) yes
p_ct_tran_rat_veh_sales_o_d
Old county transit rate for vehicle sales tax
NUMBER(15,5) yes
p_cy_rat_veh_sales_o_d
Old city rate for vehicle sales tax
NUMBER(15,5) yes
p_cy_tran_rat_veh_sales_o_d
Old city transit rate for vehicle sales tax
NUMBER(15,5) yes
p_st_rat_veh_use_o_d
Old state rate for vehicle use tax
NUMBER(15,5) yes
p_st_oth_rat_veh_use_o_d
Old state other rate for vehicle use tax
NUMBER(15,5) yes
p_ct_rat_veh_use_o_d
Old county rate for vehicle use tax
NUMBER(15,5) yes
p_ct_tran_rat_veh_use_o_d
Old county transit rate for vehicle use tax
NUMBER(15,5) yes
p_cy_rat_veh_use_o_d
Old city rate for vehicle use tax
NUMBER(15,5) yes
p_cy_tran_rat_veh_use_o_d
Old city transit rate for vehicle use tax
NUMBER(15,5) yes