Database files that update programs update

The update programs also update the database files. This table lists each program and the database files affected:

Update program Database files affected
RQ Orphan Record Check (RQ430)

For UNIX and Windows: COCOMP, MMDIST, REQHEADER, REQLINE, RQLINEDTL, WHDEMAND, WHDEMNDDTL, ACCOMMIT, ACCOMMITX, GLCOMMIT, GLCOMMITX, and POINTERFAC

For IBMi: DBWHCKT, DBPOMMD, DBRQRQH, DBRQRLN, DBRQRQD, DBWHWDM, DBWHWDD, DBACMIT, DBACMIX, DBGLGOT, DBGLGOX, and DBPOPIF

OE Orphan Check - Report and Update (OE430)

For UNIX and Windows: COCOMP, COLINE, COLINEUOM, COMISC, OEORDCMNT, WHDEMAND, and WHDEMNDDTL

For IBMi: DBWHCKT, DBOECOL, DBOECOU, DBOECMC, DBOEOOC, DBWHWDM, and DBWHWDD

WO Orphan Check - Report and Update (WO430)

For UNIX and Windows: WHDEMAND, WHDEMNDDTL, WOBRDN, WOBYPROD, WODETAIL, and WOITEM

For IBMi: DBWHWDM, DBWHWDD, DBWOWBN, DBWOWOB, DBWOWOD, and DBWOWOI

PO Orphan Record Check (PO430)

For UNIX and Windows: MMDIST, POAOCDTL, POAOCSPRD, POLINE, PORECEIVE, PORECLINE, PURCHORDER, WHDEMAND, ACCOMMIT, ACCOMMITX, GLCOMMIT, GLCOMMITX, MMUAVAL, POAUDIT, POLINEPVT, POLINESRC, POMESSAGE, POPLIUF, PORECADJHD, PORECADJLN, PORETURNHD, PORETURNLN, POTRANSDTL, and RECAOCDTL

For IBMi: DBPOMMD, DBPOPAO, DBPOPSP, DBPOPLI, DBPOPOR, DBPOPRL, DBPOPCR, DBWHWDM, DBACMIT, DBACMIX, DBGLGOT, DBGLGOX, DBPOMUA, DBPOPAU, DBPOPLP, DBPOPLS, DBPOPOM, DBPOUFN, DBPOPJH, DBPOPJL, DBPOPTH, DBPOPTL, DBPOPOT, and DBPOREC

WH Orphan Check - Report and Update (WH430)

For UNIX and Windows: WHDEMNDDTL, WHSHIPCOMP, WHSHIPLINE, WHSHLAUD, WHSHLDTL, COCOMP, WHDEMAND, and WHSHIPMENT

For IBMi: DBWHWDD, DBWHWHC, DBWHWHL, DBWHWHA, DBWHWHD, DBWHCKT, DBWHWDM, and DBWHWHS

RQ Document Integrity Check (RQ431)

For UNIX and Windows: REQHEADER, REQLINE, WHDEMAND, and WHDEMNDHDR

For IBMi: DBRQRQH, DBRQRLN, DBWHWDM, and DBWHWDH

OE Document Integrity Check - Report and Update (OE431)

For UNIX and Windows: CUSTORDER, WHDEMAND, WHDEMNDHDR, and COLINE

For IBMi: DBOECOR, DBWHWDM, DBWHWDH, and DBOECOL

WO Document Integrity Check - Report and Update (WO431)

For UNIX and Windows: WHDEMAND, WHDEMNDDTL, and WHDEMNDHDR

For IBM i: DBWHWDM, DBWHWDD, and DBWHWDH

PO Document Integrity Check (PO431)

For UNIX and Windows: PURCHORDER, WHDEMAND, and POLINE

For IBMi: DBPOPCR, DBWHWDM, and DBPOPLI

IT Document Integrity Check - Report and Update (WH431)

For UNIX and Windows: WHDEMAND

For IBMi: DBWHWDM

WH-IC Integrity Check - Report and Update (WH432)

For UNIX and Windows: COLINE, CUSTORDER, ITEMLOC, REQHEADER, REQLINE, WHDEMAND, WHDEMNDDTL, WHSHIPLINE, and WHSHLDTL

For IBMi: DBOECOL, DBOECOR, DBICITL, DBRQRQH, DBRQRLN, DBWHWDM, DBWHWDD, DBWHWHL, and DBWHWHD

WH-IC Detail Integrity Check - Report and Update (WH433)

For UNIX and Windows: ITEMLOC, ITSERIAL, SOHDETAIL, WHSHIPLINE, WHSHLDTL, and WHDEMNDDTL

For IBMi: DBICITL, DBICSER, DBICSDT, DBWHWHL, DBWHWHD, and DBWHWDD