https://calidusassist.adcservices.apteancloud.com/calidus-assist/OBS/index.php?action=history&feed=atom&title=WMS_810_ER018-039 2026-07-04T03:06:40Z Revision history for this page on the wiki MediaWiki 1.39.8 https://calidusassist.adcservices.apteancloud.com/calidus-assist/OBS/index.php?title=WMS_810_ER018-039&diff=3368&oldid=prev 2016-07-20T09:50:00Z

<p>Created page with &quot;&lt;!-- MEDIA LANDSCAPE YES --&gt; {{#vardefine:System|WMS}} {{ERHeader |SystemVersion=WMS 810 |ERNumber=ER018-039 }} {{ERTableHeader}} {{ERTableRow |TRG_INS_IAJD.sql |Trigger |4.22 ...&quot;</p> <p><b>New page</b></p><div>&lt;!-- MEDIA LANDSCAPE YES --&gt; <br /> {{#vardefine:System|WMS}}<br /> {{ERHeader<br /> |SystemVersion=WMS 810<br /> |ERNumber=ER018-039<br /> }}<br /> <br /> {{ERTableHeader}}<br /> {{ERTableRow<br /> |TRG_INS_IAJD.sql<br /> |Trigger<br /> |4.22<br /> |336462<br /> |Last activity date<br /> |3<br /> |Create new table WLE AUDIT<br /> <br /> When a pallet is amended, picked etc which is indicated by the creation of an INVENTORY AUDIT JOURNAL DETAIL record, a new WLE AUDIT record will be created. But unlike the audit table, when the pallet is removed from the system, the pallets WLE Audit record will be deleted.<br /> <br /> This table will allow the user to view the last date a pallet is 'touched' and the last audit type ie ADJ, PICK, SALE etc.<br /> <br /> This will allow users when running Inventory / Pallet ORS report to select pallet ranges and see the last touch date of the pallet.<br /> |Paul Reed<br /> }}<br /> {{ERTableRow<br /> |TRG_WARE_LOCATION_ENTRIES_BIR.sql<br /> |Trigger<br /> |4.12<br /> |&quot;<br /> |&quot;<br /> |&quot;<br /> |&quot;<br /> |&quot;<br /> }}<br /> {{ERTableRow<br /> |CT_WMS_AUDIT_336462.sql<br /> |Data Script<br /> |4.1<br /> |&quot;<br /> |&quot;<br /> |&quot;<br /> |&quot;<br /> |&quot;<br /> }}<br /> {{ERTableRow<br /> |DP_ORS_FUNCS_WMS.sql<br /> |ORS functions package<br /> |4.23<br /> |&quot;<br /> |&quot;<br /> |&quot;<br /> |&quot;<br /> |&quot;<br /> }}<br /> {{ERTableRow<br /> |DP_WMS_PROCS.sql<br /> |Generic WMS procedures package<br /> |4.4<br /> |&quot;<br /> |&quot;<br /> |&quot;<br /> |&quot;<br /> |&quot;<br /> }}<br /> {{ERTableRow<br /> |DATA_ORS_MASTER_DATA_336462.sql<br /> |Data Script<br /> |4.1<br /> |&quot;<br /> |&quot;<br /> |&quot;<br /> |&quot;<br /> |&quot;<br /> }}<br /> {{ERTableRow<br /> |CT_WLE_AUDIT_SEQ_336462.sql<br /> |Data Script<br /> |4.1<br /> |&quot;<br /> |&quot;<br /> |&quot;<br /> |&quot;<br /> |&quot;<br /> }}<br /> {{ERTableFooter}}<br /> <br /> <br /> &lt;noinclude&gt;<br /> [[Category:{{#var:System}} ER]]<br /> &lt;/noinclude&gt;</div>

StylesC