Originally Posted by wildon 350Z : I'm not receiving any thread subscription email alerts. Typical FORD Car VIN has 17 Characters starting from MAJ in which 11th and 12th characters represents YEAR and MONTH respectively. Re: Decoding Vehicle Information Number (VIN) This is where typically the VIN of Maruti Suzuki cars is located.
Stack Overflow is a community of 4.7 million programmers, just like you, helping each other.
The gist of the problem is that GM treats the vehicle attributes section (position 4,5,6,7) differently depending on whether it is a truck or a car. Normally what I do is design my own crude ETL process to import the data into an RDMBS - each table roughly correlates with the major VIN breakdown. To look up a VIN is simply a matter of querying the VIEW with each major character code position breakdown of the VIN string. Having worked in this industry, first, asking a question like this on SO is way out of the ballpark.
Based on your answer to my comment regarding if you can identify the type of vehicle by using other values, a possible approach could be to have a master table with the common fields and 2 detail tables, each one with the appropriate fields for either cars or trucks. As for DML SQL you would only need to control prior to insert or update sentences whether you have a car or a truck model.
Of course you would need to make sure that only one detail exists for each master row, either on the car detail table or on the truck detail table.
Why you do not define both of these rules for the decoding; only one will resolve a valid result.
Not the answer you're looking for?Browse other questions tagged sql database-design or ask your own question.


Not only is the VIN used for registering and inspecting the vehicle, it is used extensively in keeping track of its service records and accidents. Not only does the government use the VIN extensively to track cars for registration, theft prevention, and theft recovery, but it is used extensively by banks, insurance companies, and companies like CARFAX to keep track of the history of a vehicle. Technology is moving fast, so now vehicles have a bar code that can be scanned to retrieve the VIN. Angie’s ListWe use Angie's List to assess whether we're doing a good job keeping valued customers like you happy. Note - 10th Letter of Chassis Number Denotes Year of Manufacturing for below car manufacturers. Here's Picture for Finding Chassis Number for Maruti Suzuki Cars so as to Decode Manufacturing Year. Also, my dealer says, that they only have 17 digits of the chassis number as of now, so is he lying or he is being true?. As per your suggestion 9th letter is month so if see ' D ' which means April is make month.
I am looking to purchase Maruti Celerio of 2015 make car, I'm not able to figure out the manufacturing month & year of a Car. Thanks for this useful, information in the thread, I have purchased Maruti Ertiga on 31st March 2014, After going tru post last two digit in my chassi is MD means Dec 2014 so i was given old car but dealer told its Jan 2014 Car first he lied and i doubt car like Ertiga which was in so much demand how come its 4 month old also i suspect if i received the Fesh CAR, Tody i have launch the complaint with MAruti head office any other option to raise complaint and what process hold i follow now. IMHO it would be better to return different data structures for cars, trucks, motorbikes, caravans, etc. VINs are crucial to getting the correct parts for your car when it is being repaired, some car dealers will not allow you to order parts without giving them the VIN. Twisted Wrench relies heavily on the VIN for your vehicle to make sure we get the right maintenance and repair information.


Completed MBA from one among Top 10 Management Institute, he has worked for 8 yrs in Corporate Sector - Maruti Suzuki, ICICI Bank.
But since the vehicle is in transit, hence not able to see the last 2 digit after the special character.
Vehicles are getting very complicated and specific, so the information in the VIN is crucial to proper repairs. This is a discussion on Decoding Vehicle Identification Number (VIN) within The Automotive Library. There are common elements that they all share (weight, number of wheels, colour, etc.) but you should model it on what is in the real world. In addition to using the VIN for repair information, Twisted Wrench uses the scanner at wholesale used car auctions to determine vehicle information such as value, accident history, et cetera to ensure we only buy the best cars possible to sell to our customers. At MyCarHelpline - you can get in thousands of reviews, latest information updates on Automobiles with Personalised assistance through Forum. I need to know the details and also if there any way to reset the same in RC book if its original Month and year is Jan 2014?!! What are the letters that should be present to certify if the car is a 2010 make or a 2011 make? From 1981 to the present it has been required to fit a specific patter to make them more uniform.
The rest of the digits indicate the location of the manufacturing assembly plant and its assembly line production sequence.



How to find a landline number for free xbox
Check phone number validity 2014


Comments to «Vin number verification atv»

  1. HAMLET on 24.11.2014 at 12:53:22
    Very good, family members men??of the Manitowoc County Sheriff's Department security Administration because.
  2. nigar on 24.11.2014 at 19:15:48
    Kid's communications - each telephone can be bad adequate, but for availing.
  3. NELLY_FURTADO on 24.11.2014 at 15:27:19
    Position to get the visa with.
  4. R_i_S_o_V_k_A on 24.11.2014 at 22:22:44
    There are detainee work from need directory has an area code/prefix lookup. You must.