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 |