SC Visualizer — ESS Compiler

Supply Chain Visualizer

ESS Compiler

FSMA Rule 204

Step 1 · Source Files

Upload Source Files

📂

Click or drag & drop

Receiving · Shipping · Transformation

Step 2 · Search Criteria

Filter Records

Lot Code

Comma-separate multiple lot codes. Can be used alone or combined with other criteria. All matching lots are traced forward through the full chain.

Product / Commodity

Comma-separate multiple terms — matches any

Shipped From / Ship To

Date From

Date To

Step 3 · Compile & Export

Generate ESS

Receiving — Product Description · GTIN · Quantity · UOM · Lot Code · Shipped From Name + Address · TLC Source Name + Address + Reference · Date Received · Ref Doc

Shipping — Product Description · GTIN · Quantity · UOM · Lot Code · TLC Source Name + Address · Ship Date · Ship To Name + Address · Ref Doc

Transformation — Batch ID · Incoming Lot Code · Incoming Product · In Qty · In UOM · Incoming TLC Source Name + Address · New Lot Code · Output Product · Out Qty · Out UOM · Transform Date · Location Name + Address · Ref Doc

Fields blank in source remain blank in ESS.

Ready — upload source files to begin

📋

ESS Compiler · FSMA Rule 204

Upload one or more traceability source files, set search criteria, then click Compile ESS.

Sheet type (Receiving, Shipping, Transformation) is detected automatically from the sheet name and columns present. Each CTE is compiled separately and shown on its own tab. Fields blank in the source remain blank in the ESS.

ESS Results