www.HowardPowers.com
Resume addendum - EDI (MOBIL)
The PIP system receives all invoices from Mobil's central EDI which is also a mainframe system. Central EDI performs the capture, strips the envelope, converts all fields from delimited to fixed position and makes other, very minor, modifications. Central EDI then transfers invoices in this modified 810 and 811 format to GDG files. PIP performs group reads on the invoices, converts 811 invoices to 810 format, checks for required fields and adds each invoice to DB2 tables. The system stores EDI segments required for processing in its own internal variables. The system also stores all valid 810 segments in relational (and recursive) data base tuples using the 810 segment identifiers as keys (and foreign keys). This allows all 810 data on the invoice to be retrieved on-line for audit or review purposes with the 810 segment identifiers decoded via table entry into descriptive labels.
The PIP system allows up to three levels of looping for 810 invoices. Data commonly found in an invoice header include, single occurrences of the ST, BIG, CUR, and PER segments, one or more occurrences of the NTE, REF, ITD and DTM segments and occurrences of the header name loop segments. Data commonly found in the invoice summary include single occurrences of the TDS, CAD, CTT and SE segments and occurrences of the ITA loop. No recent invoices have included summary ISS segments and TXI segments within the ITA loop. Data commonly found in the baseline item detail loop include single occurrences of the IT1 and CAD segment, and one or more occurrences of the TXI, CTP, MEA, REF, PER, DTM segments. Within the baseline item detail loop occurrences of the service charge loop (both ITA and TXI segments), rare occurrences of the subline item detail loop (SLN segments only) and occurrences of the baseline name loop are typically found. No recent invoices have included base line item detail QTY, CUR, IT3, PWK, PKG, PO4, ITD, SDQ or PID (loop) segments.
The PIP system was scheduled for replacement by a customized SAP-EDI invoice processing module. This necessitated a significant (and high priority) effort on my part in support of the PW SAP implementation team. Typical tasks in this effort have been QMF queries on the volume of invoices containing certain segments and segment combinations used by specific vendors, and explanations of the logic used by PIP in processing certain segment types for various invoices. One PW consultant described my efforts and "instrumental" to the SAP Invoice Module implementation process.
"back to resume"07/14/98 Howard Powers
Page hits since 12/05/2000