https://owl.unipharm.com/mediawiki/index.php?action=history&feed=atom&title=Information_Systems%3ATrigger_Programs 2026-09-01T12:14:48Z Revision history for this page on the wiki MediaWiki 1.35.4 https://owl.unipharm.com/mediawiki/index.php?title=Information_Systems:Trigger_Programs&diff=4049&oldid=prev 2016-07-07T16:57:56Z

<p></p> <p><b>New page</b></p><div>There are dozens of files that define an item (I counted – I came up with 70). Some of these files are date sensitive; which means there can be many records for a single item, but not all are effective. This makes it hard – maybe even impossible – to use some of this data in SQL or Query. So we created the consolidated item master file (XXITEMP). It is rebuilt every night, but would become inaccurate as soon as any item maintenance is done. So we put triggers on the more significant files, so that when they are changed XXITEMP is automatically updated. These programs, are in library UWDASWPRDS, file QRPGLESRC, and start with ‘TRG’. <br /> <br /> Because these programs are attached to files, they can only be compiled when those files are not in use. The trigger programs have to be detached from the files, compiled, then re-attached. Because this is such an awkward process, that has to be done at night, I have occasionally manually updated XXITEMP when a user makes a change using InfoNet. For example, NPN (natural product number)is an important field, so I manually update XXITEM when it is changed.<br /> <br /> Program File<br /> TRGCXITPRP CXITPRP Contract Item Prices<br /> TRGIXMARKP IXMARKP Item to Mark Up Class Links<br /> TRGIXPRICP IXPRICP Item Base Pricing<br /> TRGPXPRICP PXPRICP Promotional Item Pricing<br /> TRGSROPCR SROPCR Item Cross Reference<br /> TRGSROPRG SROPRG Item Master<br /> TRGSROPRX SROPRX Item Extended Description<br /> TRGSROSRO SROSRO Warehouse Balance<br /> TRGWHOLOC WHOLOC Location Definition<br /> <br /> [[Category: Custom Files and Processes]]</div>

Norwinu https://owl.unipharm.com/mediawiki/index.php?title=Information_Systems:Trigger_Programs&diff=897&oldid=prev 2015-10-26T20:25:39Z

<p>Created page with &quot;There are dozens of files that define an item (I counted – I came up with 70). Some of these files are date sensitive; which means there can be many records for a single it...&quot;</p> <p><b>New page</b></p><div>There are dozens of files that define an item (I counted – I came up with 70). Some of these files are date sensitive; which means there can be many records for a single item, but not all are effective. This makes it hard – maybe even impossible – to use some of this data in SQL or Query. So we created the consolidated item master file (XXITEMP). It is rebuilt every night, but would become inaccurate as soon as any item maintenance is done. So we put triggers on the more significant files, so that when they are changed XXITEMP is automatically updated. These programs, are in library UWDASWPRDS, file QRPGLESRC, and start with ‘TRG’. <br /> <br /> Because these programs are attached to files, they can only be compiled when those files are not in use. The trigger programs have to be detached from the files, compiled, then re-attached. Because this is such an awkward process, that has to be done at night, I have occasionally manually updated XXITEMP when a user makes a change using InfoNet. For example, NPN (natural product number)is an important field, so I manually update XXITEM when it is changed.<br /> <br /> Program File<br /> TRGCXITPRP CXITPRP Contract Item Prices<br /> TRGIXMARKP IXMARKP Item to Mark Up Class Links<br /> TRGIXPRICP IXPRICP Item Base Pricing<br /> TRGPXPRICP PXPRICP Promotional Item Pricing<br /> TRGSROPCR SROPCR Item Cross Reference<br /> TRGSROPRG SROPRG Item Master<br /> TRGSROPRX SROPRX Item Extended Description<br /> TRGSROSRO SROSRO Warehouse Balance<br /> TRGWHOLOC WHOLOC Location Definition</div>

Sheilav