Supply Chain & Retail EDI · Systems talking · Hours back · sample run · 61 ms

AS400 GreenScreen Extractor

Extracted 34 detail rows from 3 pages of ARAGE01R; 4 of 72 printed total figures disagree with the detail lines (largest difference $2,150.00) and 2 printed counts do not match.

Evidence · Spool file, column headings

CUST# CUSTOMER NAME INVOICE INV DATE DUE DATE BALANCE CURRENT DUE 1-30 DUE 31-60 DUE 61-90 OVER 90

Working

The 4 detail lines it covers add up to 2,750.00 + 1,980.25 + 5,400.00 + 760.00 = 10,890.25 for BALANCE. The subtotal prints 13,040.25, so it is 2,150.00 more than the detail.

Method

1Columns come from the dashed ruler under the headings: each column starts at its dash run and runs to the start of the next, so right-aligned numbers keep a trailing minus sign.

2Page headers: every line whose text (digits masked) matches a line of the page 1 header is skipped; 3 page(s) found, printed page numbers 1, 2, 3.

Photo: CDC, Unsplash

68 of 72

Totals checked · match the detail

Severity	Page	Line
Error	1	26
Error	1	26
Error	1	26

Reads

AS400 spool file text (132 columns)

Produces

Clean CSV and JSON tables, plus a Snowflake DDL (Detail rows (CSV), Detail rows and totals check (JSON), Snowflake DDL and COPY INTO)

Price

$3,000 / month, 30% to the referring partner

Your files

Read in memory for the session, never stored, never used to train a model.

Open on sample data Start the 14-day trial

Outputs are computed from your inputs and the tool's rules. Check them before you rely on them.