mv_mvcancel_record
The mv_mvcancel_record table contains data for motor vehicle canceled registration.
Notes:
For information about interpreting Invision Motor Vehicle Registration MySQL Tables, see Understanding MySQL Tables.
To view other MySQL Tables, see the Invision Motor Vehicle Registration Database Overview.
For more information about a field, click the hyperlink in the Field column.
|
MySQL mv_mvcancel_record |
|
|
Field |
Type & Description |
|
CANCEL_ID |
KEY |
|
Set_Key |
|
|
VIN_ID |
|
|
Original_VIN_ID |
|
|
CADOL_OWNER_ID |
|
|
Effective_Date |
date|cyymmdd|C50,mm/dd/yyyy |
|
Expiration_Date |
date|cyymmdd|C50,mm/dd/yyyy |
|
Unit_Number |
|
|
Registration_Type |
|
|
Registration_Date |
date|cyymmdd|C50,mm/dd/yyyy |
|
Registration_Fee |
number|4.2 |
|
Registration_Flag |
|
|
Registration_Status |
|
|
Number_of_Axles |
number|2.0 |
|
Number_of_Tires |
number|3.0 |
|
Gross_Weight |
number|6.0 |
|
Net_Weight |
number|6.0 |
|
Tax_Receipt_Numbe |
number|9.0 |
|
Previous_Tax_Receipt_Number |
number|9.0 |
|
Sticker_Month |
number|2.0 |
|
Month_Sticker_Number |
number|4.0 |
|
Sticker_Year |
|
|
Year_Sticker_Number |
|
|
Export_Date |
date|cyymmdd|C50,mm/dd/yyyy |
|
VIN_Changed_Flag |
number|1.0 |
|
Reserve_Num_Fee_PD |
number|1.0 |
|
Vehicle_Year |
number|4.0 |
|
Mileage |
number|6.0 |
|
Base_Price |
number|6.0 |
|
Sale_Price |
number|6.2 |
|
Excise_Exempt_Flag |
|
|
Excise_Tax_Only |
|
|
Excise_Tax_Date |
date|cyymmdd|C50,mm/dd/yyyy |
|
Excise_Tax_Paid |
number|6.2 |
|
Excise_Step |
number|1.0 |
|
Transaction_Date |
date|cyymmdd|C50,mm/dd/yyyy |
|
Transaction_Time |
nds|timeII|hhmmss|hh:mm:ss |
|
Plate_Number |
|
|
Previous_Plate_Number |
|
|
Color_Code_1 |
|
|
Color_Code_2 |
|
|
Make_ID |
|
|
Model_ID |
|
|
Fuel_Type |
|
|
Camper_Trailer_Flag |
|
|
Transfer_Flag |
|
|
Fleet_Vehicle_Flag |
|
|
Title_Number |
|
|
Previous_Title_Number |
|
|
Previous_Title_State |
|
|
N_O_R_Plate_Flag |
|
|
Special_Request_Plate |
|
|
Emissions_Flag |
|
|
DOT_Number |
|
|
Veteran_Decal_Code |
|
|
Vanity_Plate_Flag |
|
|
CTA_Number_1 |
|
|
CTA_Number_2 |
|
|
Rental_Flag |
|
|
Sticker_Type |
|
|
Fee_Exempt_Flag |
|
|
Class_Code |
|
|
Sub_Class_Code |
|
|
Previous_Class_Code |
|
|
Previous_Sub_Class_Code |
|
|
Purge_Code |
number|1.0 |
|
Registered_Flag |
number|1.0 |
|
Town_Code |
|
|
Owner_1_Date_of_Birth |
date|cyymmdd|C50,mm/dd/yyyy |
|
Trust_Flag_1 |
|
|
Lease_Flag_1 |
|
|
Company_Name_1 |
|
|
Last_Name_1 |
|
|
First_Name_1 |
|
|
Middle_Initial_1 |
|
|
Suffix_1 |
|
|
Address_Line_1 |
|
|
Address_Line_2 |
|
|
City |
|
|
State |
|
|
Zip_Code |
|
|
Legal_Residence_City |
|
|
Legal_Residence_State |
|
|
Legal_Residence_Address |
|
|
Legal_Residence_Country_Code |
|
|
Legal_Residence_Geo_Code |
|
|
Owner_2_Date_of_Birth |
date|cyymmdd|C50,mm/dd/yyyy |
|
Trust_Flag_2 |
|
|
Lease_Flag_2 |
|
|
Company_Name_2 |
|
|
Last_Name_2 |
|
|
First_Name_2 |
|
|
Middle_Initial_2 |
|
|
Suffix_2 |
|
|
Part_Disabled_Vet |
|
|
Country_Code |
|
|
Owner_3_Date_of_Birth |
date|cyymmdd|C50,mm/dd/yyyy |
|
Trust_Flag_3 |
|
|
Lease_Flag_3 |
|
|
Company_Name_3 |
|
|
Last_Name_3 |
|
|
First_Name_3 |
|
|
Middle_Initial_3 |
|
|
Suffix_3 |
|
|
EIN |
|
|
DBA_Name |
|
|
Prior_Decal_Number |
number|6.0 |
|
Transaction_Type |
#|2.0 |
|
Decal_Year |
number|2.0 |
|
Decal_Number |
number|14.0 |
|
Excise_Exempt_Tag |
|
|
Sales_Price_Used |
|