WMS 810 ER017-019

From Calidus HUB


Aptean Logo.png


EMERGENCY RELEASE - WMS 810


RELNOTE ER017-019


Module Program Name Ver Call/Iss Client Ref Pr'ty Remarks Reporter
DATA_ORS_MASTER_DATA_331938.sql Data Script 4.1 331938 PJ-A4NGVD 3 A database script will insert 5 new columns to the ORS extracts:

1. INVENTORY (STOCK): 13. To Transit

2. INVENTORY (PALLET): 46. Receipt Date

3. INVENTORY (PALLET): 47. Area Code

4. STK_DTL (HEADER): 9. Owner Code

5. INBOUND (HEAD): 20. GRN Owner Code

The 'Receipt Date' can be used to select a range of values for the selection criteria.

1. INVENTORY has 'To Transit' for the STOCK level onwards.

2. INVENTORY has 'Receipt Date' and 'Area Code' for the PALLET level onwards.

3. INBOUND has 'GRN Owner Code' for the HEAD level onwards.

4. STK_DTL has 'Owner Code' for the HEADER level.

The extracted data will be included as described above.

Paul Jarvis
DATA_ORS_SQL_331938.sql Data Script 4.1 " " " " "