rst Table: State
LeasePak Documentation Suite NETSOL website
LeasePak Database Objects

Database Reference Oracle DBMS

rst Table: State

Indexes

Name Segment 1
rst_idx0 st_s

     
Columns
Name DescriptionDatatype ¿? Allow Null
st_s
State code (RST.ST_S code)
CHAR(2) no
stamp_l
Record modification stamp
NUMBER(10) no
st_nam_s
State name
VARCHAR2(20) yes
p_max_st_d
State maximum interest rate
NUMBER(15,5) yes
d_revision_s
Revision date
DATE yes
p_veh_new_d
Vehicle - new maximum interest rate
NUMBER(15,5) yes
p_veh_oth_new_d
Vehicle - other maximum interest rate
NUMBER(15,5) yes
p_veh_1yr_d
Vehicle - 1 year used maximum interest rate
NUMBER(15,5) yes
p_veh_2yr_d
Vehicle - 2 year used maximum interest rate
NUMBER(15,5) yes
p_veh_3yr_d
Vehicle - 3 year used maximum interest rate
NUMBER(15,5) yes
p_veh_4yr_d
Vehicle - 4 year used maximum interest rate
NUMBER(15,5) yes
p_veh_5yr_d
Vehicle - 5 year used maximum interest rate
NUMBER(15,5) yes
p_veh_6yr_d
Vehicle - 6 year used maximum interest rate
NUMBER(15,5) yes
p_veh_ov6_d
Vehicle - over 6 years used maximum interest rate
NUMBER(15,5) yes
trm_trm1_l
Term - term [1]
NUMBER(10) yes
trm_trm2_l
Term - term [2]
NUMBER(10) yes
trm_trm3_l
Term - term [3]
NUMBER(10) yes
trm_trm4_l
Term - term [4]
NUMBER(10) yes
trm_trm5_l
Term - term [5]
NUMBER(10) yes
trm_trm6_l
Term - term [6]
NUMBER(10) yes
p_trm_1yr1_d
Term - 1 year used maximum interest rate [1]
NUMBER(15,5) yes
p_trm_1yr2_d
Term - 1 year used maximum interest rate [2]
NUMBER(15,5) yes
p_trm_1yr3_d
Term - 1 year used maximum interest rate [3]
NUMBER(15,5) yes
p_trm_1yr4_d
Term - 1 year used maximum interest rate [4]
NUMBER(15,5) yes
p_trm_1yr5_d
Term - 1 year used maximum interest rate [5]
NUMBER(15,5) yes
p_trm_1yr6_d
Term - 1 year used maximum interest rate [6]
NUMBER(15,5) yes
p_trm_2yr1_d
Term - 2 year used maximum interest rate [1]
NUMBER(15,5) yes
p_trm_2yr2_d
Term - 2 year used maximum interest rate [2]
NUMBER(15,5) yes
p_trm_2yr3_d
Term - 2 year used maximum interest rate [3]
NUMBER(15,5) yes
p_trm_2yr4_d
Term - 2 year used maximum interest rate [4]
NUMBER(15,5) yes
p_trm_2yr5_d
Term - 2 year used maximum interest rate [5]
NUMBER(15,5) yes
p_trm_2yr6_d
Term - 2 year used maximum interest rate [6]
NUMBER(15,5) yes
p_trm_3yr1_d
Term - 3 year used maximum interest rate [1]
NUMBER(15,5) yes
p_trm_3yr2_d
Term - 3 year used maximum interest rate [2]
NUMBER(15,5) yes
p_trm_3yr3_d
Term - 3 year used maximum interest rate [3]
NUMBER(15,5) yes
p_trm_3yr4_d
Term - 3 year used maximum interest rate [4]
NUMBER(15,5) yes
p_trm_3yr5_d
Term - 3 year used maximum interest rate [5]
NUMBER(15,5) yes
p_trm_3yr6_d
Term - 3 year used maximum interest rate [6]
NUMBER(15,5) yes
p_trm_4yr1_d
Term - 4 year used maximum interest rate [1]
NUMBER(15,5) yes
p_trm_4yr2_d
Term - 4 year used maximum interest rate [2]
NUMBER(15,5) yes
p_trm_4yr3_d
Term - 4 year used maximum interest rate [3]
NUMBER(15,5) yes
p_trm_4yr4_d
Term - 4 year used maximum interest rate [4]
NUMBER(15,5) yes
p_trm_4yr5_d
Term - 4 year used maximum interest rate [5]
NUMBER(15,5) yes
p_trm_4yr6_d
Term - 4 year used maximum interest rate [6]
NUMBER(15,5) yes
p_trm_5yr1_d
Term - 5 year used maximum interest rate [1]
NUMBER(15,5) yes
p_trm_5yr2_d
Term - 5 year used maximum interest rate [2]
NUMBER(15,5) yes
p_trm_5yr3_d
Term - 5 year used maximum interest rate [3]
NUMBER(15,5) yes
p_trm_5yr4_d
Term - 5 year used maximum interest rate [4]
NUMBER(15,5) yes
p_trm_5yr5_d
Term - 5 year used maximum interest rate [5]
NUMBER(15,5) yes
p_trm_5yr6_d
Term - 5 year used maximum interest rate [6]
NUMBER(15,5) yes
p_trm_6yr1_d
Term - 6 year used maximum interest rate [1]
NUMBER(15,5) yes
p_trm_6yr2_d
Term - 6 year used maximum interest rate [2]
NUMBER(15,5) yes
p_trm_6yr3_d
Term - 6 year used maximum interest rate [3]
NUMBER(15,5) yes
p_trm_6yr4_d
Term - 6 year used maximum interest rate [4]
NUMBER(15,5) yes
p_trm_6yr5_d
Term - 6 year used maximum interest rate [5]
NUMBER(15,5) yes
p_trm_6yr6_d
Term - 6 year used maximum interest rate [6]
NUMBER(15,5) yes
p_trm_ov61_d
Term - over 6 years used maximum interest rate [1]
NUMBER(15,5) yes
p_trm_ov62_d
Term - over 6 years used maximum interest rate [2]
NUMBER(15,5) yes
p_trm_ov63_d
Term - over 6 years used maximum interest rate [3]
NUMBER(15,5) yes
p_trm_ov64_d
Term - over 6 years used maximum interest rate [4]
NUMBER(15,5) yes
p_trm_ov65_d
Term - over 6 years used maximum interest rate [5]
NUMBER(15,5) yes
p_trm_ov66_d
Term - over 6 years used maximum interest rate [6]
NUMBER(15,5) yes
p_trm_new1_d
Term - new maximum interest rate [1]
NUMBER(15,5) yes
p_trm_new2_d
Term - new maximum interest rate [2]
NUMBER(15,5) yes
p_trm_new3_d
Term - new maximum interest rate [3]
NUMBER(15,5) yes
p_trm_new4_d
Term - new maximum interest rate [4]
NUMBER(15,5) yes
p_trm_new5_d
Term - new maximum interest rate [5]
NUMBER(15,5) yes
p_trm_new6_d
Term - new maximum interest rate [6]
NUMBER(15,5) yes
p_trm_oth_new1_d
Term - other new maximum interest rate [1]
NUMBER(15,5) yes
p_trm_oth_new2_d
Term - other new maximum interest rate [2]
NUMBER(15,5) yes
p_trm_oth_new3_d
Term - other new maximum interest rate [3]
NUMBER(15,5) yes
p_trm_oth_new4_d
Term - other new maximum interest rate [4]
NUMBER(15,5) yes
p_trm_oth_new5_d
Term - other new maximum interest rate [5]
NUMBER(15,5) yes
p_trm_oth_new6_d
Term - other new maximum interest rate [6]
NUMBER(15,5) yes
bal_amt1_d
Balance - amount [1]
NUMBER(15,2) yes
bal_amt2_d
Balance - amount [2]
NUMBER(15,2) yes
bal_amt3_d
Balance - amount [3]
NUMBER(15,2) yes
bal_amt4_d
Balance - amount [4]
NUMBER(15,2) yes
p_bal_apr1_d
Balance - maximum APR per amount [1]
NUMBER(15,5) yes
p_bal_apr2_d
Balance - maximum APR per amount [2]
NUMBER(15,5) yes
p_bal_apr3_d
Balance - maximum APR per amount [3]
NUMBER(15,5) yes
p_bal_apr4_d
Balance - maximum APR per amount [4]
NUMBER(15,5) yes
days_to_letter_exp_l
Number of days to expiration after letter sent
NUMBER(10) yes
redeem_c
Able to redeem (Y/N)
CHAR(1) yes
tax_rate_s
Rate code
CHAR(4) yes
veh_tax_type_s
Vehicle tax type
CHAR(4) yes
eq_tax_type_s
Equipment tax type
CHAR(4) yes
ign_over_c
Ignore unit overrides (Y/N)
CHAR(1) yes
trd_tx_crd_c
Allow trade-in tax credit (Y/N)
CHAR(1) yes
st_tax_id_s
State tax identification number
VARCHAR2(36) yes
upf_ltr_code_s
Upfront letter code
CHAR(8) yes
mth_ltr_code_s
Monthly letter code
CHAR(8) yes
rate_chg_c
Tax rate change (Y/N)
CHAR(1) yes
country_s
Country code
CHAR(4) yes
geo_st_l
State geocode
  0  - if state is a non-Vertex state
  #  - if state is a Vertex state
  70 - if state is a Canadian province
NUMBER(10) yes
geo_ct_l
County geocode
  0 - if geo_st_l is not 70
  # - if geo_st_l is 70
NUMBER(10) yes
veh_tax_rpt_c
Separate vehicle tax disbursal report (Y/N)
CHAR(1) yes
veh_accrual_tax_rates_c
Rate-set to utilize in vehicle accruals (E/U/S/N)
  E - Equipment rental rates
  U - Vehicle use rates
  S - Vehicle sales rates
  N - None
CHAR(1) yes
veh_payoff_tax_rates_c
Rate-set to utilize in vehicle payoffs (E/U/S/N)
  E - Equipment rental rates
  U - Vehicle use rates
  S - Vehicle sales rates
  N - None
CHAR(1) yes
iso_st_s
ISO character state code
CHAR(3) yes
cand_fed_tax_type_s
Canadian federal tax type (CAND.FSTAX code)
  GST - Goods and Services tax
  HST - Harmonized sales tax
  ' ' - None
CHAR(4) yes
cand_prov_tax_type_s
Canadian provincial tax type (CAND.PSTAX code)
  PST - Provincial sales tax
  QST - Quebec sales tax
  RST - Retail sales tax
  ' ' - None
CHAR(4) yes
d_cand_fed_rate_change_s
Effective date of Canadian federal tax rate change
DATE yes
d_cand_prov_rate_change_s
Effective date of Canadian provincial tax rate change
DATE yes
p_cand_fed_tax_rate_d
Canadian federal tax rate
NUMBER(15,5) yes
p_cand_fed_tax_rate_o_d
Canadian old federal tax rate
NUMBER(15,5) yes
p_cand_prov_tax_rate_d
Canadian provincial tax rate
NUMBER(15,5) yes
p_cand_prov_tax_rate_o_d
Canadian old provincial tax rate
NUMBER(15,5) yes