Attachment 7 - Sample Data File Types - DOR Motor Vehicle.xlsx

This is a sample data file specification document for the Missouri Department of Revenue's Motor Vehicle Daily Output file from JetPay, supporting the State of Missouri's Statewide E-Payment Services contract opportunity. The file details the technical structure and data format requirements for processing motor vehicle transactions through the JetPay payment system. The specification defines three record types: Header Records containing identification and processing date information; Detail Records containing transaction-level data including notice numbers, renewal amounts, donations (Blind Donation and WWII Donation), JetPay fees, payment card type indicators (e-check, Mastercard, Visa, or American Express), DMV-specific fees (processing fee, organ donor fund, reissuance fee, and late fees), and process dates; and Footer Records containing summary information with transaction counts, total amounts, dates, and divider markers for file validation.

The data file structure utilizes fixed-position fields with specified character lengths and data types to ensure consistent transfer and processing of motor vehicle payment transactions. All monetary amounts are recorded in standard currency format ($$$$$$CC), dates are formatted as CCYYMMDD, and the file incorporates validation elements through footer records that provide transaction counts and total amounts. This technical specification establishes the standardized format for daily reconciliation and reporting of motor vehicle revenue collected through the JetPay electronic payment processing system, enabling accurate tracking and allocation of revenues to appropriate state funds and fee categories.