Data Integration Glossary Part 2: Master Data, Idempotency, Incremental Sync, Qimen, Waybill and More
Scope of Part 2
Where Part 1 covered integration forms and infrastructure, Part 2 focuses on ten terms at the business-object and engineering-mechanism boundary — the most frequently used, and most frequently misused, vocabulary in e-commerce, ERP and supply-chain integration projects.
The Terms
Master Data (MDM) — slowly-changing core business entities shared across systems (products, customers, suppliers). When every system maintains its own copy you get "one product, five codes." MDM answers: which system is authoritative, how codes are unified, and how changes propagate. It is the prerequisite for all business data integration — if master data is inconsistent, syncing orders and inventory faster just makes the errors more consistent.
Idempotency — arguably the most important engineering concept in integration. Retries, platform re-pushes and job re-runs all execute the same operation multiple times; idempotency makes repetition harmless. Implementation patterns: unique keys, state machines, dedup tables.
Incremental Sync vs Full Sync — incremental sync pulls only records with modified_time > watermark and is the daily workhorse; full sync pulls the entire dataset and serves initialization and periodic verification. The pairing hinges on watermark management and idempotent writes.
Qimen — the standard e-commerce warehousing API protocol defined by Taobao Open Platform / Cainiao: once both an ERP and a WMS implement the standard interfaces (delivery orders, inbound orders, inventory queries), they interoperate without custom development. For merchants, Qimen turns "switching WMS" from an integration project into configuration work; warehousing integration in the Alibaba ecosystem rarely bypasses it.
E-Waybill — online waybill-number allocation and print-template services from carriers: systems fetch tracking numbers and label templates via API, print and ship, with logistics traces flowing back automatically. It raises fulfillment efficiency and traceability by an order of magnitude versus handwritten labels.
OMS (Order Management System) — aggregates orders from all channels and drives fulfillment. WMS (Warehouse Management System) — manages inventory, locations and in-warehouse operations.
Safety Stock — buffer inventory held against demand and supply variability; a core parameter of replenishment models.
Three-Way Matching — the core financial control: purchase/sales order, goods receipt (or shipment) record, and invoice (platform statement) must corroborate each other in amount and quantity. In e-commerce the three documents are typically the platform order, the shipment record and the platform settlement statement — the main battlefield of AI-powered financial reconciliation.