GATE 1 • SHA-256 & BUSINESS-ID DEDUPLICATION
Cryptographic File Hash & Composite Business-Key Guard
Computes source SHA-256 and checks UNIQUE(workspace_id, customer_code, po_number) to mark duplicates duplicate_skipped.
DETERMINISTIC BLOCKING OVER PROBABILISTIC GUESSING
The 5 Deterministic Quarantine Gates, ANSI X12 355 Table & Epicor P21 SISM Mapping
OrderAirlock never uses an LLM to guess an unrecognized SKU, invent a missing UOM conversion factor, or override a contract price variance.
Authority Dossier · OrderAirlock Operations (
support@orderairlock.com · security@orderairlock.com)GATE 2 • CUSTOMER-SCOPED SKU ALIAS RESOLUTION
Strict Per-Customer Namespace Isolation
Matches (workspace_id, customer_code, part_alias), then internal_sku, then upc_gtin, or blocks with block_unknown_sku.
GATE 3 • ANSI X12 DATA ELEMENT 355 UOM PACK ARITHMETIC
Case, Box, Per-100 (C), and Per-1000 (M) Fastener & PVF Conversion
Normalizes buyer units to ANSI X12 355 codes (CS, BX, M, C, EA) and computes converted_base_qty = raw_qty * factor.
GATE 4 • CONTRACT PRICE-BAND & MARGIN FLOOR VERIFICATION
Catching Each-Price vs. Case-Price Traps Before ERP Import
Compares raw_unit_price / factor against contract rates and margin floors, catching 10 CS @ $0.18 EA price traps.
GATE 5 • LINE-EXTENSION MATH & CASE-PACK MULTIPLE CHECK
Two-Cent Extension Tolerance & Order Multiple Enforcement
Enforces abs((raw_qty * raw_unit_price) - raw_line_total) <= $0.02 and (converted_base_qty % order_multiple_qty) === 0.
ANSI X12 355 & EPICOR PROPHET 21 SISM COMPILER SPECIFICATION
Standard Unit Normalization & Zero-API-License Epicor P21 SISM (epicor_p21_sism)
| Raw Buyer PO String | Normalized ANSI X12 355 Code | Wholesale Trade Meaning |
|---|---|---|
| ea, each, pc, pcs, unit | EA | Individual discrete unit (ERP base unit) |
| cs, case, cases, ctn, carton | CS | Master case pack (e.g. 12 EA, 24 EA, 250 EA) |
| bx, box, boxes | BX | Inner box pack (e.g. 25 EA, 100 EA) |
| c, hundred, per 100, 100-pk | C | Fastener hundred-weight / 100-count lot (factor = 100) |
| m, thousand, per 1000, 1000-pk | M | Fastener thousand-count lot (factor = 1000) |
| ft, feet, lf / lb, lbs | FT / LB | Dimensional length/weight (quarantined if SKU is discrete EA) |