mv_mvcash_rapidrenewal
The mv_mvcash_rapidrenewal table contains data for rapid renewal vehicle receipt transactions.
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.
|
mv_mvcash_rapidrenewal Table |
|
|
Field |
Type & Description |
|
VIN_ID |
KEY |
|
Row_Index |
REC|number|7.0 |
|
Step |
number|1.0 |
|
Transaction_Date |
date|cyymmdd|C50,mm/dd/yyyy |
|
Transaction_Time |
nds|timeII|hhmmss|hh:mm:ss |
|
Mileage |
number|6.0 |
|
State_Rate |
number|7.2 |
|
State_Credit |
number|7.2 |
|
State_Transfer |
number|7.2 |
|
Excise_Tax |
number|7.2 |
|
Excise_Credit |
number|7.2 |
|
Credit_Number |
number|8.0 |
|
Local_Transfer_Fee |
number|7.2 |
|
Local_Fee |
number|7.2 |
|
Effective_Date |
date|cyymmdd|C50,mm/dd/yyyy |
|
Expiration_Date |
date|cyymmdd|C50,mm/dd/yyyy |
|
Sticker_Month |
number|2.0 |
|
Month_Sticker_Number |
number|2.0 |
|
Sticker_Year |
|
|
Year_Sticker_Number |
|
|
Mobile_Home_R_E_Flag |
number|2.0 |
|
Decal_Year |
number|2.0 |
|
Decal_Number |
number|6.0 |
|
Check_Amount_1 |
number|12.2 |
|
Check_Number_1 |
|
|
Check_Amount_2 |
number|12.2 |
|
Check_Number_2 |
|
|
Cash_Received |
number|12.2 |
|
Registration_Form_Number |
number|9.0 |
|
Cash_Receipt_Number |
number|14.0 |
|
Cancel_Flag |
number|1.0 |
|
Post_Flag |
number|2.0 |
|
Posting_User |
|
|
Priority_Code_1 |
number|2.0 |
|
Priority_Code_2 |
number|2.0 |
|
Priority_Code_3 |
number|2.0 |
|
Dupe_Flag |
number|1.0 |
|
Original_Receipt_Number |
number|6.0 |
|
Duplicate_Fee_Code |
|
|
Duplicate_Fee |
number|2.2 |
|
Duplicate_Local_Fee |
number|2.2 |
|
Original_Date |
date|cyymmdd|C50,mm/dd/yyyy |
|
Other_Credit |
number|12.2 |
|
Excise_Tax_Date |
date|cyymmdd|C50,mm/dd/yyyy |
|
Class_Code |
|
|
Sub_Class_Code |
|
|
Registration_Type |
|
|
Registration_Type |
|
|
Transaction_Type |
#|2.0 |
|
Excise_Tax_Only |
|
|
Transfer |
|
|
O_N_R_Plate |
|
|
Clerk_Init |
|
|
Rate_Code |
|
|
Double_Single |
|
|
Plate_Number |
|
|
Title_Application_Number |
|
|
Surviving_Spouse |
|
|
Info_Reason_Codes |
|
|
Gift_Cert_Number |
|
|
Info_Reason_Other |
|
|
Special_Request_Plate |
|
|
Mileage_Type |
|
|
Adjustment_Fee |
number|12.2 |
|
Adjustment_Form_Print |
|
|
Adjustment_Clerk_Initials |
|
|
Paragraph_Line_1 |
|
|
Paragraph_Line_2 |
|
|
Paragraph_Line_3 |
|
|
Paragraph_Line_4 |
|
|
Paragraph_Line_5 |
|
|
Paragraph_Line_6 |
|
|
Paragraph_Line_7 |
|
|
Paragraph_Line_8 |
|
|
Fee_Code_1 |
|
|
Fee_Amount_1 |
number|12.2 |
|
Fee_Code_2 |
|
|
Fee_Amount_2 |
number|12.2 |
|
Fee_Code_3 |
|
|
Fee_Amount_3 |
number|12.2 |
|
Fee_Code_4 |
|
|
Fee_Amount_4 |
number|12.2 |
|
Fee_Code_5 |
|
|
Fee_Amount_5 |
number|12.2 |
|
Fee_Code_6 |
|
|
Fee_Amount_6 |
number|12.2 |
|
Fee_Code_7 |
|
|
Fee_Amount_7 |
number|12.2 |
|
Fee_Code_8 |
|
|
Fee_Amount_8 |
number|12.2 |
|
Fee_Code_9 |
|
|
Fee_Amount_9 |
number|12.2 |
|
Fee_Code_10 |
|
|
Fee_Amount_10 |
number|12.2 |
|
Cancel_Clerk_Init |
|
|
Cancel_Type |
|
|
Cancel_Reason |
|
|
Cancel_Date |
date|cyymmdd|C50,mm/dd/yyyy |
|
Cancel_Time |
nds|timeII|hhmmss|hh:mm:ss |
|
Prior_Decal_Number |
number|6.0 |
|
Excise_Exempt_Tag |
|
|
Set_Key |
|
|
Dealer_Sales |
|
|
CTA_Number_1 |
|
|
CTA_Number_2 |
|
|
Sales_Tax_Exempt |
|
|
Previous_Plate_Number |
|
|
Previous_Class_Code |
|
|
Previous_Sub_Class_Code |
|
|
Booster_ID |
|
|
Delta |
|