Automotive Filters Attributes
Automotive filters cover engine oil, air, cabin air, fuel and water-separator, and transmission service, sold through warehouse distributors, jobbers and e-tailers to installers, fleets and DIY buyers. The record is half spec and half fitment: a filter is only correct for a given engine, so application rows matter as much as can dimensions.
The data is hard for a structural reason. Fitment travels in ACES, product information in PIES, from different systems on different schedules, rarely reconciled. One popular filter carries thousands of application rows against a VCdb that keeps moving, so a complete record quietly goes stale. The same filter also ships under several brands, each with its own numbering and datasheet layout.
Then the specs get dropped. Manufacturers publish by-pass setting, gasket O.D. and I.D., burst pressure and media on the part detail page. Distributor catalogs import the part number and the fitment and leave the rest in the PDF. What's left on the rail is a thread size and a picture of a can — with inches, millimetres and fractions sharing one column.