https://calidusassist.adcservices.apteancloud.com/calidus-assist/OBS/index.php?action=history&feed=atom&title=CTMS_11.0_ER015-012CTMS 11.0 ER015-012 - Revision history2026-07-02T03:11:56ZRevision history for this page on the wikiMediaWiki 1.39.8https://calidusassist.adcservices.apteancloud.com/calidus-assist/OBS/index.php?title=CTMS_11.0_ER015-012&diff=1834&oldid=prevStylesC: CTMS ER2015-04-02T14:01:31Z<p>CTMS ER</p>
<p><b>New page</b></p><div><!-- MEDIA LANDSCAPE YES --> <br />
{{ERHeader<br />
|SystemVersion=CTMS 11.0<br />
|ERNumber=ER015-012<br />
}}<br />
<br />
{{ERTableHeader}}<br />
{{ERTableRow<br />
|AT_SCH_SHIP_PALL_ITEM_325610.sql<br />
|Alter Table Script<br />
|1.1<br />
|325610<br />
|324776<br />
|3<br />
|Performance Issues Have Been Noted MCS<br />
-<br />
<br />
The database script will add an index to the database<br />
table to enable a pallet to be found for an item more<br />
efficiently.<br />
<br />
The database view will use the new index to display<br />
the items for scanning in MCS more efficiently.<br />
<br />
The database trigger will not set the actual quantity<br />
of a trip item to 0 if it has only been scanned for an<br />
'FNR' reason code.<br />
|Emily Collins<br />
}}<br />
<br />
{{ERTableRow<br />
|V_MCS_TRIP_ITEM.sql<br />
|Database View<br />
|1.8<br />
|"<br />
|"<br />
|"<br />
|"<br />
|"<br />
<br />
}}<br />
<br />
{{ERTableRow<br />
|TRG_SCH_ORD_ITEMS_ACTUALS.sql<br />
|Trigger<br />
|1.5<br />
|"<br />
|"<br />
|"<br />
|"<br />
|"<br />
<br />
}}<br />
<br />
<br />
{{ERTableFooter}}</div>StylesC