https://calidusassist.adcservices.apteancloud.com/calidus-assist/OBS/index.php?action=history&feed=atom&title=Setting_up_WCS_for_CTMS
Setting up WCS for CTMS - Revision history
2026-07-01T17:38:33Z
Revision history for this page on the wiki
MediaWiki 1.39.8
https://calidusassist.adcservices.apteancloud.com/calidus-assist/OBS/index.php?title=Setting_up_WCS_for_CTMS&diff=15126&oldid=prev
Anw: Initial Creation
2025-12-23T11:46:19Z
<p>Initial Creation</p>
<p><b>New page</b></p><div>This page shows the basic interface tables that should be set up to enable WCS within CTMS. Note that OAQ tables and functionality must also be setup - this is not covered here, but should already be present in any CTMS database.<br />
<br />
<br />
==APP_QUEUE==<br />
{| class="wikitable"<br />
! ID!! AGENT!! RECEIVER!! ACTION!! STATE!! DISABLE_FOR_NEXT_LISTENER_RUN!! JOB_ID!! HANDLER!! HANDLER_DEF<br />
|-<br />
|QCM1|| AG_AUTO|| MTS|| || L|| || 1845|| L|| L<br />
|-<br />
|QMC|| AG_AUTO|| WCS|| || || X|| || || <br />
|}<br />
<br />
<br />
==APP_REC==<br />
{| class="wikitable"<br />
! REC_TYPE!! REC_NAME!! QUEUE_ID!! APP_PROCESS!! ACTIVE<br />
|-<br />
|405|| TY_WCS_SUPP_TRIP_ACCEPT|| QMC|| dp_rdt_auto.send_wcs_supp_trip_accepted|| Y<br />
|-<br />
|404|| TY_WCS_ORD_PREADV|| QMC|| dp_rdt_auto.send_wcs_ord_preadvice|| Y<br />
|-<br />
|804|| TY_WCS_ORD_CONF|| QCM1|| dp_rdt_auto.recvd_wcs_ord_conf|| Y<br />
|-<br />
|421|| TY_WMS_LOC_CD|| QMC|| || Y<br />
|-<br />
|821|| TY_WCS_LOCCHECK|| QCM1|| dp_rdt_internal.recvd_wcs_loccheck|| Y<br />
|-<br />
|442|| TY_TMS_TRIP_LOAD|| QMC|| dp_rdt_fast_load.send_wcs_trip_load|| Y<br />
|-<br />
|441|| TY_TMS_ITEM_LOAD|| QMC|| dp_rdt_fast_load.send_wcs_item_load|| Y<br />
|-<br />
|432|| TY_WMS_TRIP_PREADV|| QMC|| dp_rdt_preadvice.send_wcs_trip_preadv|| Y<br />
|-<br />
|431|| TY_WMS_MANIFEST_PREADV|| QMC|| dp_rdt_preadvice.send_wcs_manifest_preadv|| Y<br />
|-<br />
|841|| TY_WCS_FAST_LOAD_CONF|| QCM1|| dp_rdt_fast_load.recvd_wcs_fast_load_conf|| Y<br />
|-<br />
|833|| TY_WCS_COMP_UNLOAD|| QCM1|| dp_rdt_fast_unload.recvd_wcs_comp_unload|| Y<br />
|-<br />
|832|| TY_WCS_UNPLANNED_LOAD|| QCM1|| dp_rdt_fast_unload.recvd_wcs_unplanned_load|| Y<br />
|-<br />
|831|| TY_WCS_FAST_UNLOAD|| QCM1|| dp_rdt_fast_unload.recvd_wcs_fast_unload|| Y<br />
|-<br />
|851|| TY_WCS_ITEM_ENQUIRY|| QCM1|| dp_rdt_auto.recvd_wcs_item_enquiry|| Y<br />
|-<br />
|472|| TY_WCS_NEW_DEPOT|| QMC|| dp_rdt_auto.send_wcs_new_depot|| Y<br />
|-<br />
|471|| TY_WCS_DU_TYPES|| QMC|| dp_rdt_auto.send_wcs_media|| Y<br />
|-<br />
|451|| TY_WCS_ITEM_RESPONSE|| QMC|| || Y<br />
|-<br />
|433|| TY_WMS_MANIFEST_DELETE|| QMC|| dp_rdt_preadvice.send_wcs_manifest_delete|| Y<br />
|-<br />
|861|| TY_WCS_TRIP_ENQUIRY|| QCM1|| dp_rdt_auto.recd_wcs_trip_enquiry|| Y<br />
|-<br />
|461|| TY_WCS_TRIP_RESPONSE|| QMC|| dp_rdt_auto.send_wcs_trip_enquiry|| Y<br />
|-<br />
|473|| TY_WCS_ASSET_ORIGIN|| QMC|| dp_rdt_auto.send_asset_origin|| Y<br />
|-<br />
|852|| TY_WCS_ASSET_CREATION|| QCM1|| dp_rdt_auto.recvd_wcs_asset_creation|| Y<br />
|}<br />
<br />
<br />
==APP_AGENT==<br />
Add your depot and link to agent above<br />
<br />
{| class="wikitable"<br />
! DEPOT!! AGENT!! Q_SCHEMA!! PRIMARY_AGENT<br />
|-<br />
|DHLMIDD|| AG_AUTO|| MTS_OWNER|| N<br />
|}<br />
<br />
<noinclude><br />
[[Category:WCS]]<br />
[[Category:CTMS]]<br />
[[Category:Oracle]]<br />
</noinclude></div>
Anw