Invision Motor Vehicle Registration MySQL Database Overview

The Invision Motor Vehicle Registration MySQL database is described with MySQL tables that contain the data definitions for information within the Invision Motor Vehicle Registration database.  You use the MySQL tables information (previously referred to as Record Tables), to create reports, queries or other projects using iKnowSys™ or third-party reporting tools.  When building the reports you will need to know the name of the MySQL Table that contains the information you want.  While you may be used to thinking in terms of file names, when using MySQL a file is referred to as a table.  See the list below to find the MySQL table name that contains the information that you are looking for.

Database Tables List

Below is information about the MySQL database tables within Invision Motor Vehicle Registration Workbench.

Note:  For information about interpreting the information in a MySQL Table, see Understanding MySQL Tables.

Motor Vehicle Registration MySQL Database Tables Information

MySQL Table Name

Information Provided

Motor Vehicle Registration Location

mv_mvbase

 

 

mv_mvboost_current

 

 

mv_mvcancel_record

 

 

mv_mvcash_daily

 

 

mv_mvcash_nextday

 

 

mv_mvcash_rapidrenewal

 

 

mv_mvclass_code

 

 

mv_mvclass_code_cmf

 

 

mv_mvclass_total

 

 

mv_mvcross

 

 

mv_mvctrl_hstseq

 

 

mv_mvctrl_ip_exp_elec_reg_export

 

 

mv_mvctrl_ip_exp_elec_reg_workfile

 

 

mv_mvctrl_ip_imp_elec_reg_import

 

 

mv_mvctrl_ip_imp_elec_reg_post

 

 

mv_mvctrl_ip_imp_rapidrenewal

 

 

mv_mvctrl_none_vinid

 

 

mv_mvctrl_post_seq

 

 

mv_mvctrl_receipt_post

 

 

mv_mvctrl_user_numbers

 

 

mv_mvcvt_destination

 

 

mv_mvcvt_destination_elec_reg

 

 

mv_mvcvt_source

 

 

mv_mvcvt_source_elec_reg

 

 

mv_mvdecal_current

 

 

mv_mvdecal_number

 

 

mv_mvexcept_adjustment1

 

 

mv_mvexcept_adjustment2

 

 

mv_mvexcept_booster

 

 

mv_mvexcept_cancel

 

 

mv_mvexp_elec_reg

 

 

mv_mvexp_elec_reg_header

 

 

mv_mvexp_elec_reg_workfile

 

 

mv_mvfee_code

 

 

mv_mvfee_profile

 

 

mv_mvfee_profile_process

 

 

mv_mvhist

 

 

mv_mvhist_cmf

 

 

mv_mvimp_elec_reg

 

 

mv_mvnext

 

 

mv_mvowner1_cmf

 

 

mv_mvowner2_cmf

 

 

mv_mvowner3_cmf

 

 

mv_mvplate_current

 

 

mv_mvplate_number

 

 

mv_mvreg_current

 

 

mv_mvreg_number

 

 

mv_mvreprint

 

 

mv_mvsrpc_current

 

 

mv_mvsrpc_number

 

 

mv_mvstick_current

 

 

mv_mvstick_number

 

 

mv_mvtable_classcodes

 

 

mv_mvtable_colors

 

 

mv_mvtable_fueltypes

 

 

mv_mvtable_geocodes

 

 

mv_mvtable_makes

 

 

mv_mvtable_models

 

 

mv_mvtable_operatorcodes

 

 

mv_mvtable_prioritycodes

 

 

mv_mvtable_reasoncodes

 

 

mv_mvtable_styles

 

 

mv_mvtable_vehicleyears

 

 

mv_mvtable_yearcodes

 

 

mv_mvtitle

 

 

mv_mvtrnst_current

 

 

mv_mvtrnst_number

 

 

mv_mvveh1_cmf

 

 

mv_mvveh2_cmf

 

 

mv_mvvehicle

 

 

mv_scf_analysis

 

 

mv_scf_mvchksum

 

 

mv_scf_mvexckey

 

 

mv_scf_mvform

 

 

mv_scf_mvgl

 

 

mv_scf_mvlpost

 

 

mv_scf_mvownnum

 

 

mv_scf_mvprint

 

 

mv_scf_mvreceipt

 

 

mv_scf_mvstate

 

 

mv_scf_rptcyc

 

 

mv_scf_rptdate

 

 

mv_scf_summadd

 

 

mv_scf_summhead

 

 

mv_scf_vetdecal

 

 

mv_scf_xxpass