Enlarge image | $ $ $ $ $ April 2017 Web-IMV Pounds 5/2/2016 12/31/2016 Purchased CDOR Taxation Division Original Record Meaning P O 150 FEIN 2016 4608 71000 42600 42600 28400 TESLA 357913579 20161231 20160502 MODEL S WILDER OXCART 1FDPB80C5TVA98981 CRAVIN STORMSOUR GWYNETH S FELLARROW Example File Values Notes SSN or FEIN (or ITIN?) Are these filing period specific? Always in pounds? This will be L,P,N,C to denote if the vehicle was Leased (L), Purchased (P), New (N), or Converted (C ) Dollar value of lease or MSRP Dollar value of the tax credit Dollar value of admin or processing Fee Dollar value of compensation provided to the vehicle purchaser/lessee for assignable credit Dollar value of vehicle MSRP less tax credit compensation Designation on if the record is original (O), amended (A), or Corrected (C ). Usually these work that amends will override originals and correcteds will override both. We can keep all these records and have the return logic handle which is the right one at the time, or we can develop a process to remove or archive unneeded entries as new ones come in. Innovative Motor Vehicle Tax Credit File Format XXXXXXXXX YYYYMMDD YYYYMMDD YYYY XXXXXXXXXXXXXXXXX X X Decode ID Type of Financing Entity ID of Financing Entity Filing Period Date of Purchase or Lease Vehicle Make Vehicle Model Vehicle Model Year VIN Vehicle Weight Type Indicator Value/MSRP Tax Credit Value Fee Compensation provided to purchaser Value less tax credit Name of Financing Entity Authorized Agent Name Purchaser Name Record Identifier Field IDType ID Period PurchaseDate Make Model ModelYear VIN Weight Type VehicleValue TaxCredit Fee Compensation ValueLessCredit FinancingName AgentName PurchaserName RecordIdentifier File should be a pipe (|) delimited flat (.txt) file File name should be unique, using the date is sufficient as long as we don't get more then one file per day. Example: IMVTCF20161103.txt Example file record: FEIN|357913579|20161231|20160502|TESLA|MODEL S|2016|1FDPB80C5TVA98981|4608|P|71000|42600|150|42600|28400|WILDER OXCART|CRAVIN ARNOLD STORMSOUR|GWYNETH S FELLARROW|O Position 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 |