SmartFACT Databy SmartFACT

SMARTFACT DATA · FREE TIER

EDI cross-reference tables: keep partner codes mapped to your own codes

Updated

An EDI cross-reference table maps the codes a trading partner uses, such as their customer, location or carrier codes, to your own internal codes. ConfigSheets keeps those pairs in a maintained reference table: paste or edit rows, review each change before it is saved, look up an exact code and keep every saved version.

ConfigSheets query results listing each table that holds a row whose customer_sku is exactly ACME-00024, with its revision and rows
Searching for one exact code lists each table that holds it and the revision it is from.
EDI cross-reference tables: keep partner codes mapped to your own codes · 3:02 · Watch on YouTube

Keep partner and internal codes side by side

Put the trading partner's code and your own code in defined columns of one table, with the customer or supplier they belong to. Upload a sheet, use the grid, or paste rows straight from a spreadsheet with their header row.

Before anything is saved, the review compares the whole proposed table with the saved one and counts the rows added, changed, removed and left alone. Each save becomes a new version that records why the change was made.

ConfigSheets review of a pasted table: 2 added, 0 changed, 0 removed, 0 unchanged, with the added rows listed
The review totals every added, changed and removed row before the save.

Preserve exact identifiers

Codes are stored as text, so 0012 keeps its leading zeros. A lookup matches the exact value: ACME-00024 finds the tables that hold it, and acme-00024 is a different code that finds nothing.

What happens to a duplicate or empty code?

Every row carries its own identifier, and the key columns you match on must be filled in and unique, so a partner code can never point at two of your codes. A proposal that breaks the rule is refused in full; the saved version stays in use while you fix the draft.

ConfigSheets refusing a proposed table because two rows share the row identifier cp-001
Two rows with the same identifier stop the whole proposal, and the saved table stays as it was.

Connect your EDI software as an integration

SmartFACT products take the table from a saved version and review it before using it. The table does not reach your EDI software on its own: linking that software, or your EDI provider, is a paid integration, and we scope it with you and build it through data.smartfact.ai.

What SmartFACT Data does not do

  • EDI translation on its own. Converting EDI messages to or from your own formats is part of a paid integration.
  • EDI segments or message structure. The table holds code values only.
  • Validation of EDI messages. Its checks cover the table's own rows.
  • The EDI connection on its own. Sending or receiving messages, or connecting to a trading partner or EDI provider, is a paid integration scoped with you.

Common questions

Can ConfigSheets help with EDI mappings?

Yes: it keeps the customer, partner and internal codes behind a mapping, with every change checked and every version saved. Translating EDI messages and linking your EDI software or provider are paid integration work, scoped with you and built through data.smartfact.ai.

How do SmartFACT products receive the data?

Each receiving product reads a saved version, for example a LabelRules reference table or a KitProof job file, and reviews and accepts it before use. Other software joins through a paid integration scoped with you.

Start free at one station and pay when you grow. While SmartFACT is in early access, we set your first workflow up with you.

FREE TIER

Tell us what you need to bring into SmartFACT

Say what the data is, where it lives today and which SmartFACT products will use it, and we will agree a focused first step with you.

Start free

Free at one station. Set up with you while SmartFACT is in early access.

THE SMARTFACT SUITE

SmartFACT services
and free tools.

Automate factory decisions with rules you describe in plain English. Explore focused SmartFACT services, plus free tools for everyday checks. The free tools need no account.

Free tool

ScannerBench

See the text and key events your keyboard scanner sends. Compare them with the value you expected.

Test a scanner
Free tool

PrintBench

Print a known PDF, measure its reference marks and compare scans from the printed codes.

Check a print
Free tool

CardBench

Create 100 × 50 mm bin and rack cards with Code 128 or QR, from one record or a CSV.

Make bin cards
Free tool

CountBench

Count stock by location with a barcode scanner, compare it with a stock file and export the results.

Start a free count
Free tool

BarcodeBench

See exactly what a scanned barcode contains, with hidden characters shown and GS1 fields, check digits and dates explained.

Inspect a barcode
Free tool

MatchBench

Scan a reference and each label, see an exact match or the first difference, and download the results.

Start a free comparison
Free tool

TagBench

Scan an item or location, note what needs attention, print a review tag and keep a review list.

Make a free tag
Free tool

FindBench

Load your own parts and locations CSV, scan a code and see every location it lists.

Start a free lookup
Free tool

ManifestBench

Check cartons, pallets or serial numbers against a list with a phone or scanner and see what is missing.

Start a free check
Free tool

FeedBench

Check CSV and JSON files exactly as written, preview a column mapping and compare two versions by key.

Check a file free
Free tool

CycleBench

Time work cycles and changeovers on a phone, record interruptions with reasons and download the results.

Start a free study
Free tool

OffcutBench

Label the offcuts on your rack, find a piece long enough before cutting new stock and record what you used.

Track offcuts free
Free tool

TraceBench

Load one or two CSV exports and follow a lot or serial forwards or backwards, with the row behind every link.

Start a free trace
Free tool

ReclaimBench

Record the parts recovered from each return, label them with a QR code, check them and record the unit each one goes into.

Track recovered parts free
Free tier

LabelRules

Describe label rules in plain English. Automatically select layouts, resolve customer codes and check each job before printing.

Explore LabelRules
Free tier

KitProof

Turn plain English component rules into automatic kit checklists, then check scans against the expected parts and quantities.

Explore KitProof
Free tier

WorkSteps

Turn plain English rules into automatic step selection for each unit, with required evidence and a record of completed work.

Explore WorkSteps
Free tier

FactorySpec

Apply approved product rules and calculations automatically to turn dimensions and options into manufacturing requirements.

Explore FactorySpec
Free tier

SmartFACT Data

Maintain reference tables with ConfigSheets or bring shop orders into SmartFACT through reviewed connectors. Check changes and deliver data to the products that use it.

Start free
Free tier

OrderRun

Turn plain English rules into automatic order checks and destination selection, with controlled production release.

Explore OrderRun
Early access

ParcelOffice

Scan the work order and the parcel choice to book the courier and print the labels. Approved plain English rules recommend or choose the parcel.

Explore ParcelOffice
Free tier

RefillFlow

Scan an empty container to send the right refill request to stores. Approved plain English rules set the stores queue, priority, ticket printer and escalation.

Explore RefillFlow
Free tier

RemnantRack

Label each offcut, find a suitable length before cutting new stock and record what you used. Approved plain English rules decide what to keep and where it goes.

Explore RemnantRack
Free tier

ToolCustody

Check a shared tool before handover, record who has it and keep damaged or overdue tools out of the next issue. Start free with one crib.

Explore ToolCustody
Free tier

StoresFlow

Receive, put away, reserve and issue stores material with barcode checks, keeping held, reserved and available stock apart. Start free with one stockroom.

Explore StoresFlow
Free tier

LotTrail

Follow a lot or serial number through the records your factory already keeps, with the source of each link and the gaps shown. Start free with two declared sources.

Explore LotTrail
Early access

CheckStation

Scan an identified unit to get its approved final-inspection checks, then record exact readings with their result, holds and release history.

Explore CheckStation
Free tier

ReclaimStation

Book returned units in, recover and label the usable parts, release them independently and record the unit each goes into. Start free with one product family.

Explore ReclaimStation
Free tool

GuidBench

Generate GUIDs, UUID v4 and v7, ULIDs and Nano IDs, format and download batches, or inspect a UUID in your browser.

Generate identifiers
Free tool

OctetBench

Inspect and edit text, hex, Base64 and binary bytes in your browser, reveal hidden characters and compare byte sequences.

Inspect some bytes
Free tool

PatternBench

Test JavaScript regular expressions in your browser, inspect matches and captures, preview replacements and check expected cases.

Test a pattern
Free tier

SmartFACT Purchasing

Collect purchase requests, approve supplier orders and track what is still to arrive. Start free at one site.

Explore Purchasing
Free tier

SmartFACT Automation

Describe, test, approve and audit the automation rules of every SmartFACT product in one place. Included with each product’s paid plan, or on its own.

Explore Automation
Help

SmartFACT Help

Step-by-step guides and interactive demonstrations for the SmartFACT suite. Read the instructions, watch a task or practise with real product screens and sample data.

Open SmartFACT Help