| Columns | 
| Name | 
Description | 
Datatype ¿? | 
Allow Null | 
| st_s | 
State code (RST.ST_S code)  | 
char(2) | 
no | 
| timestamp | 
Record modification stamp  | 
timestamp | 
yes | 
| st_nam_s | 
State name  | 
char(20) | 
yes | 
| p_max_st_d | 
State maximum interest rate  | 
double precision | 
yes | 
| d_revision_s | 
Revision date  | 
datetime | 
yes | 
| p_veh_new_d | 
Vehicle - new maximum interest rate  | 
double precision | 
yes | 
| p_veh_oth_new_d | 
Vehicle - other maximum interest rate  | 
double precision | 
yes | 
| p_veh_1yr_d | 
Vehicle - 1 year used maximum interest rate  | 
double precision | 
yes | 
| p_veh_2yr_d | 
Vehicle - 2 year used maximum interest rate  | 
double precision | 
yes | 
| p_veh_3yr_d | 
Vehicle - 3 year used maximum interest rate  | 
double precision | 
yes | 
| p_veh_4yr_d | 
Vehicle - 4 year used maximum interest rate  | 
double precision | 
yes | 
| p_veh_5yr_d | 
Vehicle - 5 year used maximum interest rate  | 
double precision | 
yes | 
| p_veh_6yr_d | 
Vehicle - 6 year used maximum interest rate  | 
double precision | 
yes | 
| p_veh_ov6_d | 
Vehicle - over 6 years used maximum interest rate  | 
double precision | 
yes | 
| trm_trm1_l | 
Term - term [1]  | 
integer | 
yes | 
| trm_trm2_l | 
Term - term [2]  | 
integer | 
yes | 
| trm_trm3_l | 
Term - term [3]  | 
integer | 
yes | 
| trm_trm4_l | 
Term - term [4]  | 
integer | 
yes | 
| trm_trm5_l | 
Term - term [5]  | 
integer | 
yes | 
| trm_trm6_l | 
Term - term [6]  | 
integer | 
yes | 
| p_trm_1yr1_d | 
Term - 1 year used maximum interest rate [1]  | 
double precision | 
yes | 
| p_trm_1yr2_d | 
Term - 1 year used maximum interest rate [2]  | 
double precision | 
yes | 
| p_trm_1yr3_d | 
Term - 1 year used maximum interest rate [3]  | 
double precision | 
yes | 
| p_trm_1yr4_d | 
Term - 1 year used maximum interest rate [4]  | 
double precision | 
yes | 
| p_trm_1yr5_d | 
Term - 1 year used maximum interest rate [5]  | 
double precision | 
yes | 
| p_trm_1yr6_d | 
Term - 1 year used maximum interest rate [6]  | 
double precision | 
yes | 
| p_trm_2yr1_d | 
Term - 2 year used maximum interest rate [1]  | 
double precision | 
yes | 
| p_trm_2yr2_d | 
Term - 2 year used maximum interest rate [2]  | 
double precision | 
yes | 
| p_trm_2yr3_d | 
Term - 2 year used maximum interest rate [3]  | 
double precision | 
yes | 
| p_trm_2yr4_d | 
Term - 2 year used maximum interest rate [4]  | 
double precision | 
yes | 
| p_trm_2yr5_d | 
Term - 2 year used maximum interest rate [5]  | 
double precision | 
yes | 
| p_trm_2yr6_d | 
Term - 2 year used maximum interest rate [6]  | 
double precision | 
yes | 
| p_trm_3yr1_d | 
Term - 3 year used maximum interest rate [1]  | 
double precision | 
yes | 
| p_trm_3yr2_d | 
Term - 3 year used maximum interest rate [2]  | 
double precision | 
yes | 
| p_trm_3yr3_d | 
Term - 3 year used maximum interest rate [3]  | 
double precision | 
yes | 
| p_trm_3yr4_d | 
Term - 3 year used maximum interest rate [4]  | 
double precision | 
yes | 
| p_trm_3yr5_d | 
Term - 3 year used maximum interest rate [5]  | 
double precision | 
yes | 
| p_trm_3yr6_d | 
Term - 3 year used maximum interest rate [6]  | 
double precision | 
yes | 
| p_trm_4yr1_d | 
Term - 4 year used maximum interest rate [1]  | 
double precision | 
yes | 
| p_trm_4yr2_d | 
Term - 4 year used maximum interest rate [2]  | 
double precision | 
yes | 
| p_trm_4yr3_d | 
Term - 4 year used maximum interest rate [3]  | 
double precision | 
yes | 
| p_trm_4yr4_d | 
Term - 4 year used maximum interest rate [4]  | 
double precision | 
yes | 
| p_trm_4yr5_d | 
Term - 4 year used maximum interest rate [5]  | 
double precision | 
yes | 
| p_trm_4yr6_d | 
Term - 4 year used maximum interest rate [6]  | 
double precision | 
yes | 
| p_trm_5yr1_d | 
Term - 5 year used maximum interest rate [1]  | 
double precision | 
yes | 
| p_trm_5yr2_d | 
Term - 5 year used maximum interest rate [2]  | 
double precision | 
yes | 
| p_trm_5yr3_d | 
Term - 5 year used maximum interest rate [3]  | 
double precision | 
yes | 
| p_trm_5yr4_d | 
Term - 5 year used maximum interest rate [4]  | 
double precision | 
yes | 
| p_trm_5yr5_d | 
Term - 5 year used maximum interest rate [5]  | 
double precision | 
yes | 
| p_trm_5yr6_d | 
Term - 5 year used maximum interest rate [6]  | 
double precision | 
yes | 
| p_trm_6yr1_d | 
Term - 6 year used maximum interest rate [1]  | 
double precision | 
yes | 
| p_trm_6yr2_d | 
Term - 6 year used maximum interest rate [2]  | 
double precision | 
yes | 
| p_trm_6yr3_d | 
Term - 6 year used maximum interest rate [3]  | 
double precision | 
yes | 
| p_trm_6yr4_d | 
Term - 6 year used maximum interest rate [4]  | 
double precision | 
yes | 
| p_trm_6yr5_d | 
Term - 6 year used maximum interest rate [5]  | 
double precision | 
yes | 
| p_trm_6yr6_d | 
Term - 6 year used maximum interest rate [6]  | 
double precision | 
yes | 
| p_trm_ov61_d | 
Term - over 6 years used maximum interest rate [1]  | 
double precision | 
yes | 
| p_trm_ov62_d | 
Term - over 6 years used maximum interest rate [2]  | 
double precision | 
yes | 
| p_trm_ov63_d | 
Term - over 6 years used maximum interest rate [3]  | 
double precision | 
yes | 
| p_trm_ov64_d | 
Term - over 6 years used maximum interest rate [4]  | 
double precision | 
yes | 
| p_trm_ov65_d | 
Term - over 6 years used maximum interest rate [5]  | 
double precision | 
yes | 
| p_trm_ov66_d | 
Term - over 6 years used maximum interest rate [6]  | 
double precision | 
yes | 
| p_trm_new1_d | 
Term - new maximum interest rate [1]  | 
double precision | 
yes | 
| p_trm_new2_d | 
Term - new maximum interest rate [2]  | 
double precision | 
yes | 
| p_trm_new3_d | 
Term - new maximum interest rate [3]  | 
double precision | 
yes | 
| p_trm_new4_d | 
Term - new maximum interest rate [4]  | 
double precision | 
yes | 
| p_trm_new5_d | 
Term - new maximum interest rate [5]  | 
double precision | 
yes | 
| p_trm_new6_d | 
Term - new maximum interest rate [6]  | 
double precision | 
yes | 
| p_trm_oth_new1_d | 
Term - other new maximum interest rate [1]  | 
double precision | 
yes | 
| p_trm_oth_new2_d | 
Term - other new maximum interest rate [2]  | 
double precision | 
yes | 
| p_trm_oth_new3_d | 
Term - other new maximum interest rate [3]  | 
double precision | 
yes | 
| p_trm_oth_new4_d | 
Term - other new maximum interest rate [4]  | 
double precision | 
yes | 
| p_trm_oth_new5_d | 
Term - other new maximum interest rate [5]  | 
double precision | 
yes | 
| p_trm_oth_new6_d | 
Term - other new maximum interest rate [6]  | 
double precision | 
yes | 
| bal_amt1_d | 
Balance - amount [1]  | 
double precision | 
yes | 
| bal_amt2_d | 
Balance - amount [2]  | 
double precision | 
yes | 
| bal_amt3_d | 
Balance - amount [3]  | 
double precision | 
yes | 
| bal_amt4_d | 
Balance - amount [4]  | 
double precision | 
yes | 
| p_bal_apr1_d | 
Balance - maximum APR per amount [1]  | 
double precision | 
yes | 
| p_bal_apr2_d | 
Balance - maximum APR per amount [2]  | 
double precision | 
yes | 
| p_bal_apr3_d | 
Balance - maximum APR per amount [3]  | 
double precision | 
yes | 
| p_bal_apr4_d | 
Balance - maximum APR per amount [4]  | 
double precision | 
yes | 
| days_to_letter_exp_l | 
Number of days to expiration after letter sent  | 
integer | 
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  | 
char(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  | 
integer | 
yes | 
| geo_ct_l | 
County geocode
  0 - if geo_st_l is not 70
  # - if geo_st_l is 70  | 
integer | 
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  | 
datetime | 
yes | 
| d_cand_prov_rate_change_s | 
Effective date of Canadian provincial tax rate change  | 
datetime | 
yes | 
| p_cand_fed_tax_rate_d | 
Canadian federal tax rate  | 
double precision | 
yes | 
| p_cand_fed_tax_rate_o_d | 
Canadian old federal tax rate  | 
double precision | 
yes | 
| p_cand_prov_tax_rate_d | 
Canadian provincial tax rate  | 
double precision | 
yes | 
| p_cand_prov_tax_rate_o_d | 
Canadian old provincial tax rate  | 
double precision | 
yes |