CSV files that update programs create

The update programs create Comma-Separated Value (CSV) files. They are created during Phase One. These are the purposes that CSV files serve:

  • Serve as an audit file and contain all of the records that were purged from the database.

  • Let you view and perform additional analysis on the purged records (can be read by many PC software programs, including spreadsheets).

  • Provide a historical record. If necessary, you can rebuild database records from the contents of a CSV file.

You can find these CSV files in this directory:

For UNIX, the directory is:

$LAWDIR/ productline /work

For Windows, the directory is:

%LAWDIR%\ productline \work

For IBMi, the directory is:

LAWDIR/productline /work

This table lists the CSV files that are created by each of the update programs:

Update program CSV file names
RQ Orphan Record Check (RQ430)

For UNIX/Windows:

  • RQ430/COCOMP.process-id

  • RQ430/REQLINE.process-id

  • RQ430/WHDEMNDDTL.process-id

  • RQ430/MMDIST.process-id

  • RQ430/RQLINEDTL.process-id

  • RQ430/WHDEMAND.process-id

  • RQ430/POINTERFAC.process-id

  • RQ430/REQHEADER.process-id

For IBMi:

  • RQ430/DBWHCKT.process-id

  • RQ430/DBRQRLN.process-id

  • RQ430/DBWHWDD.process-id

  • RQ430/DBPOMMD.process-id

  • RQ430/DBRQRQD.process-id

  • RQ430/DBWHWDM.process-id

  • RQ430/DBPOPIF.process-id

  • RQ430/DBRQRQH.process-id
OE Orphan Check - Report and Update (OE430)

For UNIX/Windows:

  • OE430/COCOMP.process-id

  • OE430/COLINE.process-id

  • OE430/COLINEUOM.process-id

  • OE430/COMISC.process-id

  • OE430/OEORDCMNT.process-id

  • OE430/WHDEMAND.process-id

  • OE430/WHDEMNDDTL.process-id

For IBMi:

  • OE430/DBWHCKT.process-id

  • OE430/DBOECOL.process-id

  • OE430/DBOECOU.process-id

  • OE430/DBOECMC.process-id

  • OE430/DBOEOOC.process-id

  • OE430/DBWHWDM.process-id

  • OE430/DBWHWDD.process-id
WO Orphan Check - Report and Update (WO430)

For UNIX/Windows:

  • WO430/WHDEMAND.process-id

  • WO430/WHDEMNDDTL.process-id

  • WO430/WOBRDN.process-id

  • WO430/WOBYPROD.process-id

  • WO430/WODETAIL.process-id

  • WO430/WOITEM.process-id

For IBMi:

  • WO430/DBWHWDM.process-id

  • WO430/DBWHWDD.process-id

  • WO430/DBWOWBN.process-id

  • WO430/DBWOWOB.process-id

  • WO430/DBWOWOD.process-id

  • WO430/DBWOWOI.process-id
PO Orphan Record Check (PO430)

For UNIX/Windows:

  • PO430/ICTRANSDTL.process-id

  • PO430/PURCHORDER.process-id

  • PO430/PORECEIVE.process-id

  • PO430/WHDEMAND.process-id

  • PO430/MMDIST.process-id

  • PO430/POLINE.process-id

  • PO430/PORECLINE.process-id

  • PO430/POAOCDTL.process-id

  • PO430/POAOCSPRD.process-id

  • PO430/MMUAVAL.process-id

  • PO430/POAUDIT.process-id

  • PO430/PORECADJHD.process-id

  • PO430/PORECADJLN.process-id

  • PO430/POLINEPVT.process-id

  • PO430/POLINESRC.process-id

  • PO430/POMESSAGE.process-id

  • PO430/POTRANSDTL.process-id

  • PO430/PORETURNHD.process-id

  • PO430/PORETURNLN.process-id

  • PO430/RECAOCDTL.process-id

  • PO430/POPLIUF.process-id

For IBMi:

  • PO430/DBICICD.process-id

  • PO430/DBPOPCR.process-id

  • PO430/DBPOPOR.process-id

  • PO430/DBWHWDM.process-id

  • PO430/DBPOMMD.process-id

  • PO430/DBPOMMD.process-id

  • PO430/DBPOPRL.process-id

  • PO430/DBPOPAO.process-id

  • PO430/DBPOPSP.process-id

  • PO430/DBPOMUA.process-id

  • PO430/DBPOPAU.process-id

  • PO430/DBPOPJH.process-id

  • PO430/DBPOPJL.process-id

  • PO430/DBPOPLP.process-id

  • PO430/POLINESRC.process-id

  • PO430/DBPOPOM.process-id

  • PO430/DBPOPOT.process-id

  • PO430/DBPOPTH.process-id

  • PO430/DBPOPTL.process-id

  • PO430/DBPOREC.process-id

  • PO430/DBPOUFN.process-id
WH Orphan Check - Report and Update (WH430)

For UNIX/Windows:

  • WH430/WHDEMNDDTL.process-id

  • WH430/WHSHIPCOMP.process-id

  • WH430/WHSHIPLINE.process-id

  • WH430/WHSHLAUD.process-id

  • WH430/WHSHLDTL.process-id

  • WH430/COCOMP.process-id

  • WH430/WHDEMAND.process-id

For IBMi:

  • WH430/DBWHWDD.process-id

  • WH430/DBWHWHC.process-id

  • WH430/DBWHWHL.process-id

  • WH430/DBWHWHA.process-id

  • WH430/DBWHWHD.process-id

  • WH430/DBWHCKT.process-id

  • WH430/DBWHWDM.process-id