WMS 810 ER018-039

From Calidus HUB
Revision as of 11:50, 20 July 2016 by StylesC (talk | contribs) (Created page with "<!-- MEDIA LANDSCAPE YES --> {{#vardefine:System|WMS}} {{ERHeader |SystemVersion=WMS 810 |ERNumber=ER018-039 }} {{ERTableHeader}} {{ERTableRow |TRG_INS_IAJD.sql |Trigger |4.22 ...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)


Aptean Logo.png


EMERGENCY RELEASE - WMS 810


RELNOTE ER018-039


Module Program Name Ver Call/Iss Client Ref Pr'ty Remarks Reporter
TRG_INS_IAJD.sql Trigger 4.22 336462 Last activity date 3 Create new table WLE AUDIT

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.

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.

This will allow users when running Inventory / Pallet ORS report to select pallet ranges and see the last touch date of the pallet.

Paul Reed
TRG_WARE_LOCATION_ENTRIES_BIR.sql Trigger 4.12 " " " " "
CT_WMS_AUDIT_336462.sql Data Script 4.1 " " " " "
DP_ORS_FUNCS_WMS.sql ORS functions package 4.23 " " " " "
DP_WMS_PROCS.sql Generic WMS procedures package 4.4 " " " " "
DATA_ORS_MASTER_DATA_336462.sql Data Script 4.1 " " " " "
CT_WLE_AUDIT_SEQ_336462.sql Data Script 4.1 " " " " "