https://calidusassist.adcservices.apteancloud.com/calidus-assist/OBS/index.php?action=history&feed=atom&title=WMS_810_ER017-019 2026-07-03T20:05:05Z 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_ER017-019&diff=2815&oldid=prev 2016-02-03T15:05:09Z

<p>Created page with &quot;&lt;!-- MEDIA LANDSCAPE YES --&gt; {{#vardefine:System|WMS}} {{ERHeader |SystemVersion=WMS 810 |ERNumber=ER017-019 }} {{ERTableHeader}} {{ERTableRow |DATA_ORS_MASTER_DATA_331938.sql ...&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=ER017-019<br /> }}<br /> <br /> {{ERTableHeader}}<br /> {{ERTableRow<br /> |DATA_ORS_MASTER_DATA_331938.sql<br /> |Data Script<br /> |4.1<br /> |331938<br /> |PJ-A4NGVD<br /> |3<br /> |A database script will insert 5 new columns to the ORS extracts:<br /> <br /> 1. INVENTORY (STOCK): 13. To Transit<br /> <br /> 2. INVENTORY (PALLET): 46. Receipt Date<br /> <br /> 3. INVENTORY (PALLET): 47. Area Code<br /> <br /> 4. STK_DTL (HEADER): 9. Owner Code<br /> <br /> 5. INBOUND (HEAD): 20. GRN Owner Code<br /> <br /> The 'Receipt Date' can be used to select a range of values for the selection criteria.<br /> <br /> 1. INVENTORY has 'To Transit' for the STOCK level onwards.<br /> <br /> 2. INVENTORY has 'Receipt Date' and 'Area Code' for the PALLET level onwards.<br /> <br /> 3. INBOUND has 'GRN Owner Code' for the HEAD level onwards.<br /> <br /> 4. STK_DTL has 'Owner Code' for the HEADER level.<br /> <br /> The extracted data will be included as described above.<br /> |Paul Jarvis<br /> }}<br /> {{ERTableRow<br /> |DATA_ORS_SQL_331938.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