Recovering Business Rules as Cascade Lookups for Enterprise Field Prediction
Organizations: Technische Universität Darmstadt, Darmstadt, Germany
Abstract
Enterprise sales-order systems rely on manually maintained configuration rules to determine fields such as payment terms, shipping points, and sales ownership. When these rules are incomplete or stale, operators must enter values by hand, and downstream errors spread into billing, logistics, and reporting. This paper studies whether missing or outdated rules can be recovered from historical transactions instead of being relearned as opaque statistical patterns. We introduce a knowledge-graph-guided workflow in which an LLM agent proposes candidate business keys, meaning column combinations such as customer and document type, validates them through SQL profiling, and compiles the resulting evidence into deterministic cascade lookups. The LLM is used only during offline rule discovery. At inference time, prediction is a transparent key lookup with no model-serving requirement. Experiments on enterprise sales-order prediction and public relational benchmarks show that cascades are most effective when fields follow stable business rules, while learned graph models remain preferable when prediction depends on temporal or neighborhood patterns. Drift analysis further turns residual errors into diagnostics for configuration maintenance. Code and data: https://github.com/Fireblossom/CascadER.
Figures & tables
| Field | Level | Downstream consequence of error |
|---|---|---|
| CustomerPaymentTerms | Header | Incorrect invoice due dates and early/late payment disputes |
| SalesGroup | Header | Misattributed revenue reporting and incorrect commission assignment |
| SalesOffice | Header | Distorted regional sales analytics |
| HeaderIncoterms | Header | Wrong allocation of shipping risk and cost between buyer and seller |
| ShippingCondition | Header | Suboptimal carrier selection and delivery delays |
| ItemIncoterms | Item | Per-line risk allocation inconsistent with contract |
| Method | PayTrm | Sales Grp. | Hdr Inc. | Item Inc. | ShipCond | ShipPt | Plant | Sales Off. | Avg |
|---|---|---|---|---|---|---|---|---|---|
| Majority Class | 0.23 | 0.05 | 0.62 | 0.62 | 0.41 | 0.54 | 0.59 | 0.99 | 0.51 |
| XGBoost [ 1 ] | 0.57 | 0.51 | 0.70 | 0.70 | 0.68 | 0.95 | 0.99 | 0.99 | 0.76 |
| LightGBM [ 11 ] | 0.10 | 0.02 | 0.73 | 0.73 | 0.51 | 0.28 | 0.61 | 0.99 | 0.50 |
| CatBoost [ 18 ] | 0.44 | 0.16 | 0.81 | 0.80 | 0.71 | 0.80 | 0.99 | 0.99 | 0.71 |
| CARTE [ 12 ] | 0.62 | 0.46 | 0.77 | 0.75 | 0.74 | 0.97 | 0.99 | 0.99 | 0.79 |
| AutoGluon [ 4 ] | 0.52 | 0.34 | 0.78 | 0.78 | 0.74 | 0.98 | 0.99 | 0.99 | 0.77 |
| Target Field | Ours (Acc) | GNN (Acc) |
|---|---|---|
| CustomerPaymentTerms | 82.86% | 37.47% |
| SalesGroup | 70.00% | 15.76% |
| HeaderIncoterms | 77.22% | 62.23% |
| ItemIncoterms | 77.15% | 69.36% |
| ShippingCondition | 69.56% | 56.85% |
| ShippingPoint | 98.65% | 98.39% |
| Field | Schema-only | Restricted KG | |
|---|---|---|---|
| Plant | 76.6% | 99.5% | +22.9 |
| ShippingPoint | 67.0% | 78.9% | +11.9 |
| HeaderIncoterms | 69.1% | 73.0% | +3.8 |
| ItemIncoterms | 69.1% | 72.9% | +3.8 |
| ShippingCondition | 56.6% | 59.3% | +2.6 |
| SalesGroup | 68.9% | 71.0% | +2.2 |
| Dataset | Task | Classes | Ours (Val) | GNN (Val) | Ours (Test) | GNN (Test) |
|---|---|---|---|---|---|---|
| rel-arxiv | author-cat. | 53 | 52.8% | 52.6% | 50.3% | 50.7% |
| rel-stack | badges-cls. | 3 | 77.6% | 80.0% | 79.3% | 82.8% |
Tabular Prediction
Tabular prediction uses structured rows and columns to forecast labels, values, risks, and outcomes from data.
See all 112 papers