rst Table: State

Database Reference

rst Table: State

Indexes

Name	Segment 1
rst_idx0	st_s

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