The application discloses a five-level linkage penetration query method and
system for sales execution data in an industrial MES, and relates to the technical field of industrial
manufacturing execution system (MES)
data query and analysis. The application builds a five-level linkage penetration architecture from macroscopic aggregation to microscopic physical material details, designs an
automatic transmission mechanism for upper-level screening parameters, constructs a unified data accounting model with temporary tables as the pivot, realizes unique association of full-
link data through contract hash values, and introduces
database transaction control to ensure stable operation. The application solves the problems of scattered statistics, drilling difficulty, inefficient
traceability and different
caliber of traditional industrial enterprise sales execution data, realizes cross-module and multi-level full-link linkage penetration query, improves data
traceability efficiency by more than 90%, unifies the accounting
caliber of multiple modules, provides precise data support for fine management and efficient decision-making of enterprises, and is suitable for the sales execution
data management scene of industrial enterprise ERP / MES systems. The application has been completely applied in actual industrial ERP systems, can run stably in real production environment for a long time, and has mature
engineering value and industrialization popularization ability.