Database files updated by update programs

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