CTMS 11.0 ER020-032: Difference between revisions

From Calidus HUB
VisualWikitext
No edit summary
No edit summary
Line 8: Line 8:
{{ERTableHeader}}
{{ERTableHeader}}
{{ERTableRow
{{ERTableRow
|DATA_ADM_SYSTEM_PARAM_333090.sql
|CUST_COST.fmx
|Data Script
|Customer Maintenance
|1.1
|2.99
|333090
|333089
|SCR-002 & 004
|SCR-001
|3
|3
|New forms for manually entering Stacks for specific customer.
|New BWSC screen for entering Agreements and generating C-TMS contracts
|Matthew Tipping
|Matthew Tipping
}}
}}
{{ERTableRow
{{ERTableRow
|BDM.fmx                       
|CT_CNT_AGREEMENT_333089.sql
|
|Create Table Script
|2.87
|1.2
|"
|"
|"
|"
Line 28: Line 28:
}}
}}
{{ERTableRow
{{ERTableRow
|LOCATION.fmx                 
|CT_CNT_AGREEMENT_AUDIT_333089.sql
|
|Create Table Script
|2.148
|1.1
|"
|"
|"
|"
Line 38: Line 38:
}}
}}
{{ERTableRow
{{ERTableRow
|AT_GEO_LOC_TYPE_333090.sql    
|CT_CNT_AGREEMENT_INDEX_333089.sql
|Alter Table Scripts
|Create Table Script
|1.1
|1.1
|"
|"
Line 48: Line 48:
}}
}}
{{ERTableRow
{{ERTableRow
|AT_GEO_LOCATION_333090.sql    
|CT_CNT_AGREEMENT_FORECAST_333089.sql
|Alter Table Scripts
|Create Table Script
|1.1
|1.1
|"
|"
Line 57: Line 57:
|"
|"
}}
}}
{{ERTableRow
{{ERTableRow
|CT_GEO_LOC_STORAGE_TYPE_333090.sql  
|CT_SEQ_CNT_AGREEMENT_333089.sql
|Create Table Scripts
|Create Table Script
|1.1
|1.1
|"
|"
Line 69: Line 68:
}}
}}
{{ERTableRow
{{ERTableRow
|CT_GEO_LOC_ENTRIES.sql        
|CT_SEQ_CNT_AGREEMENT_AUDIT_333089.sql
|Create Table Scripts
|Create Table Script
|1.1
|1.1
|"
|"
Line 78: Line 77:
|"
|"
}}
}}
{{ERTableRow
{{ERTableRow
|DATA_ADM_FORM_TAB_333090.sql  
|CT_SEQ_CNT_AGREEMENT_FORECAST_333089.sql
|Data Scripts
|Create Table Script
|1.1
|1.1
|"
|"
Line 90: Line 88:
}}
}}
{{ERTableRow
{{ERTableRow
|CT_GEO_LOC_ENTRIES_AUDIT_333090.sql
|AT_CNT_AGREEMENT_333089.sql
|Create Table Scripts
|Alter Table Script
|1.3
|1.1
|"
|"
|"
|"
Line 100: Line 98:
}}
}}
{{ERTableRow
{{ERTableRow
|CT_GEO_LOC_NOTE_TYPE_333090.sql
|CT_TMP_CNT_TIER_NAME_333089.sql
|Create Table Scripts
|Create Table Script
|1.2
|1.1
|"
|"
|"
|"
Line 110: Line 108:
}}
}}
{{ERTableRow
{{ERTableRow
|CT_GEO_LOC_INFORMATION_333090.sql
|AT_CNT_CHARGE_TIER_333089.sql
|Create Table Scripts
|Alter Table Script
|1.4
|1.1
|"
|"
|"
|"
Line 120: Line 118:
}}
}}
{{ERTableRow
{{ERTableRow
|TRG_GLE_BIU.sql
|CT_ACC_PRICE_INDEX_333089.sql
|Trigger
|Create Table Script
|1.1
|1.1
|"
|"
Line 130: Line 128:
}}
}}
{{ERTableRow
{{ERTableRow
|CT_SEQ_GLE_AUDIT_333090.sql  
|AGR.sql
|Create Table Scripts
|Package
|1.1
|1.1
|"
|"
Line 140: Line 138:
}}
}}
{{ERTableRow
{{ERTableRow
|TRG_GLE_AUDIT_BI.sql          
|TRG_CNT_AGREEMENT_AI.sql
|Trigger
|Trigger
|1.1
|1.1
Line 150: Line 148:
}}
}}
{{ERTableRow
{{ERTableRow
|T_GEO_LOCATION_LATLONG.sql    
|TRG_CNT_AGREEMENT_BIU.sql
|Trigger
|Trigger
|5.8
|1.1
|"
|"
|"
|"
Line 160: Line 158:
}}
}}
{{ERTableRow
{{ERTableRow
|ORION.mmx                     
|AT_ACC_ACCOUNT_333089.sql
|Orion Menu
|Alter Table Script
|1.39
|1.1
|"
|"
|"
|"
Line 170: Line 168:
}}
}}
{{ERTableRow
{{ERTableRow
|INVENTORY_MAN.fmx             
|AT_CNT_AGREEMENT_AUDIT_333089.sql
|Inventory Management
|Alter Table Script
|1.1
|1.1
|"
|"
Line 180: Line 178:
}}
}}
{{ERTableRow
{{ERTableRow
|DATA_ADM_FUNCTION_333090.sql  
|AT_2_CNT_AGREEMENT_333089.sql
|
|Alter Table Script
|1.1
|1.1
|"
|"
|"
|"
|"
}}
{{ERTableRow
|ORION.mmx
|Menu
|1.39
|"
|"
|"
|"
|"
}}
{{ERTableRow
|AGREEMENTS.fmx
|Agreements Maintenance
|2.3
|"
|"
|"
|"
Line 190: Line 208:
}}
}}
{{ERTableFooter}}
{{ERTableFooter}}
<table border="1px" width="100%">
<tr>
<td colspan="3" bgcolor="silver"><font size="2">'''New Access'''</font></td>
</tr>
<tr>
<td bgcolor="silver"><font size="2">'''Access Tab'''</font></td>
<td bgcolor="silver"><font size="2">'''Name'''</font></td>
<td bgcolor="silver"><font size="2">'''Description'''</font></td>
</tr>
<tr>
<td>Function</td>
<td>ALLOW_INVENTORY_UPDATE</td>
<td>Allow inventory data to be updated</td>
</tr>
</table>
<table border="1px" width="100%">
<tr>
<td colspan="4" bgcolor="silver"><font size="2">'''New Parameters'''</font></td>
</tr>
<tr>
<td bgcolor="silver"><font size="2">'''Parameter Name'''</font></td>
<td bgcolor="silver"><font size="2">'''Config Level'''</font></td>
<td bgcolor="silver"><font size="2">'''Setting Value'''</font></td>
<td bgcolor="silver"><font size="2">'''Result'''</font></td>
</tr>
<tr>
<td>GEO_LOCATION_STACK</td>
<td>Database</td>
<td>Y</td>
<td>Turns on the new stack functionality in the location form</td>
</tr>
<tr>
<td>GEO_DEFAULT_DEPOT</td>
<td>Database</td>
<td>STACK</td>
<td>Default depot for new locations</td>
</tr>
<tr>
<td>GEO_DEFAULT_COUNTRY</td>
<td>Database</td>
<td>GB</td>
<td>Default country for new locations.</td>
</tr>
<tr>
<td>MTS_LOCATION_USAGE</td>
<td>Database</td>
<td>AGREEMENT</td>
<td>Location usage to group locations</td>
</tr>
<tr>
<td>GEO_MIN_INVENTORY</td>
<td>Database</td>
<td>90</td>
<td>Minimum inventory threshold to generate warning</td>
</tr>
<tr>
<td>GEO_MAX_INVENTORY</td>
<td>Database</td>
<td>110</td>
<td>Maximum inventory threshold to generate warning</td>
</tr>
<tr>
<td>GEO_KEEP_LATLONG</td>
<td>Database</td>
<td>Y</td>
<td>Keep location Lat/Long when other values change</td>
</tr>
</table>


{{ERTableHeader}}
{{ERTableHeader}}
{{ERTableRow
{{ERTableRow
|CUST_COST.fmx
|AT_SCH_ORD_333091.sql
|Customer Maintenance
|Alter Table Script
|2.99
|1.1
|333089
|333091
|SCR-001
|SCR-006
|3
|3
|New BWSC screen for entering Agreements and generating C-TMS contracts
|Added STACK based processing to the debrief process.
|Matthew Tipping
|Matthew Tipping
}}
}}
{{ERTableRow
{{ERTableRow
|CT_CNT_AGREEMENT_333089.sql
|AT_SCH_ORD_NON_CONFORM_333091.sql
|Create Table Script
|Alter Table Script
|1.2
|1.1
|"
|"
|"
|"
Line 292: Line 231:
}}
}}
{{ERTableRow
{{ERTableRow
|CT_CNT_AGREEMENT_AUDIT_333089.sql
|AT_SCH_ORDER_LINE_333091.sql
|Create Table Script
|Alter Table Script
|1.1
|1.1
|"
|"
Line 302: Line 241:
}}
}}
{{ERTableRow
{{ERTableRow
|CT_CNT_AGREEMENT_INDEX_333089.sql
|AT_SCH_TRIP_333091.sql
|Create Table Script
|Alter Table Script
|1.1
|1.1
|"
|"
Line 312: Line 251:
}}
}}
{{ERTableRow
{{ERTableRow
|CT_CNT_AGREEMENT_FORECAST_333089.sql
|AT_SCH_TRIP_STOP_333091.sql  
|Create Table Script
|Alter Table Script
|1.2
|"
|"
|"
|"
|"
}}
{{ERTableRow
|DATA_ADM_SYSTEM_PARAM_333091.sql
|Data Script
|1.1
|1.1
|"
|"
Line 322: Line 271:
}}
}}
{{ERTableRow
{{ERTableRow
|CT_SEQ_CNT_AGREEMENT_333089.sql
|DATA_ADM_SYSTEM_PARAM_CONFIG_333091.sql
|Create Table Script
|Data Script
|1.1
|1.1
|"
|"
Line 332: Line 281:
}}
}}
{{ERTableRow
{{ERTableRow
|CT_SEQ_CNT_AGREEMENT_AUDIT_333089.sql
|DATA_ORG_CUST_ORD_REV_CHG_TYPE_333091.sql
|Create Table Script
|Data Script
|1.1
|1.1
|"
|"
Line 342: Line 291:
}}
}}
{{ERTableRow
{{ERTableRow
|CT_SEQ_CNT_AGREEMENT_FORECAST_333089.sql
|TIU_TRIP_STATUS.sql          
|Create Table Script
|Trigger
|5.40
|"
|"
|"
|"
|"
}}
{{ERTableRow
|T_SCH_ORD_PNL.sql             
|Trigger
|5.9
|"
|"
|"
|"
|"
}}
{{ERTableRow
|TRIPDTL.fmx
|Trip Debrief Screen
|2.198
|"
|"
|"
|"
|"
}}
{{ERTableFooter}}
 
{{ERTableHeader}}
{{ERTableRow
|DATA_ADM_SYSTEM_PARAM_333090.sql
|Data Script
|1.1
|1.1
|333090
|SCR-002 & 004
|3
|New forms for manually entering Stacks for specific customer.
|Matthew Tipping
}}
{{ERTableRow
|BDM.fmx                       
|
|2.87
|"
|"
|"
|"
Line 352: Line 344:
}}
}}
{{ERTableRow
{{ERTableRow
|AT_CNT_AGREEMENT_333089.sql
|LOCATION.fmx                 
|Alter Table Script
|
|2.148
|"
|"
|"
|"
|"
}}
{{ERTableRow
|AT_GEO_LOC_TYPE_333090.sql    
|Alter Table Scripts
|1.1
|1.1
|"
|"
Line 362: Line 364:
}}
}}
{{ERTableRow
{{ERTableRow
|CT_TMP_CNT_TIER_NAME_333089.sql
|AT_GEO_LOCATION_333090.sql    
|Create Table Script
|Alter Table Scripts
|1.1
|1.1
|"
|"
Line 371: Line 373:
|"
|"
}}
}}
{{ERTableRow
{{ERTableRow
|AT_CNT_CHARGE_TIER_333089.sql
|CT_GEO_LOC_STORAGE_TYPE_333090.sql  
|Alter Table Script
|Create Table Scripts
|1.1
|1.1
|"
|"
Line 382: Line 385:
}}
}}
{{ERTableRow
{{ERTableRow
|CT_ACC_PRICE_INDEX_333089.sql
|CT_GEO_LOC_ENTRIES.sql        
|Create Table Script
|Create Table Scripts
|1.1
|1.1
|"
|"
Line 391: Line 394:
|"
|"
}}
}}
{{ERTableRow
{{ERTableRow
|AGR.sql
|DATA_ADM_FORM_TAB_333090.sql  
|Package
|Data Scripts
|1.1
|1.1
|"
|"
Line 402: Line 406:
}}
}}
{{ERTableRow
{{ERTableRow
|TRG_CNT_AGREEMENT_AI.sql
|CT_GEO_LOC_ENTRIES_AUDIT_333090.sql
|Trigger
|Create Table Scripts
|1.1
|1.3
|"
|"
|"
|"
|"
}}
{{ERTableRow
|CT_GEO_LOC_NOTE_TYPE_333090.sql
|Create Table Scripts
|1.2
|"
|"
|"
|"
|"
}}
{{ERTableRow
|CT_GEO_LOC_INFORMATION_333090.sql
|Create Table Scripts
|1.4
|"
|"
|"
|"
Line 412: Line 436:
}}
}}
{{ERTableRow
{{ERTableRow
|TRG_CNT_AGREEMENT_BIU.sql
|TRG_GLE_BIU.sql
|Trigger
|Trigger
|1.1
|1.1
Line 422: Line 446:
}}
}}
{{ERTableRow
{{ERTableRow
|AT_ACC_ACCOUNT_333089.sql
|CT_SEQ_GLE_AUDIT_333090.sql  
|Alter Table Script
|Create Table Scripts
|1.1
|1.1
|"
|"
Line 432: Line 456:
}}
}}
{{ERTableRow
{{ERTableRow
|AT_CNT_AGREEMENT_AUDIT_333089.sql
|TRG_GLE_AUDIT_BI.sql          
|Alter Table Script
|Trigger
|1.1
|1.1
|"
|"
Line 442: Line 466:
}}
}}
{{ERTableRow
{{ERTableRow
|AT_2_CNT_AGREEMENT_333089.sql
|T_GEO_LOCATION_LATLONG.sql    
|Alter Table Script
|Trigger
|1.1
|5.8
|"
|"
|"
|"
Line 452: Line 476:
}}
}}
{{ERTableRow
{{ERTableRow
|ORION.mmx
|ORION.mmx                    
|Menu
|Orion Menu
|1.39
|1.39
|"
|"
Line 462: Line 486:
}}
}}
{{ERTableRow
{{ERTableRow
|AGREEMENTS.fmx
|INVENTORY_MAN.fmx            
|Agreements Maintenance
|Inventory Management
|2.3
|1.1
|"
|"
|"
|"
|"
}}
{{ERTableRow
|DATA_ADM_FUNCTION_333090.sql 
|
|1.1
|"
|"
|"
|"
Line 472: Line 506:
}}
}}
{{ERTableFooter}}
{{ERTableFooter}}
<table border="1px" width="100%">
<tr>
<td colspan="3" bgcolor="silver"><font size="2">'''New Access'''</font></td>
</tr>
<tr>
<td bgcolor="silver"><font size="2">'''Access Tab'''</font></td>
<td bgcolor="silver"><font size="2">'''Name'''</font></td>
<td bgcolor="silver"><font size="2">'''Description'''</font></td>
</tr>
<tr>
<td>Function</td>
<td>ALLOW_INVENTORY_UPDATE</td>
<td>Allow inventory data to be updated</td>
</tr>
</table>
<table border="1px" width="100%">
<tr>
<td colspan="4" bgcolor="silver"><font size="2">'''New Parameters'''</font></td>
</tr>
<tr>
<td bgcolor="silver"><font size="2">'''Parameter Name'''</font></td>
<td bgcolor="silver"><font size="2">'''Config Level'''</font></td>
<td bgcolor="silver"><font size="2">'''Setting Value'''</font></td>
<td bgcolor="silver"><font size="2">'''Result'''</font></td>
</tr>
<tr>
<td>GEO_LOCATION_STACK</td>
<td>Database</td>
<td>Y</td>
<td>Turns on the new stack functionality in the location form</td>
</tr>
<tr>
<td>GEO_DEFAULT_DEPOT</td>
<td>Database</td>
<td>STACK</td>
<td>Default depot for new locations</td>
</tr>
<tr>
<td>GEO_DEFAULT_COUNTRY</td>
<td>Database</td>
<td>GB</td>
<td>Default country for new locations.</td>
</tr>
<tr>
<td>MTS_LOCATION_USAGE</td>
<td>Database</td>
<td>AGREEMENT</td>
<td>Location usage to group locations</td>
</tr>
<tr>
<td>GEO_MIN_INVENTORY</td>
<td>Database</td>
<td>90</td>
<td>Minimum inventory threshold to generate warning</td>
</tr>
<tr>
<td>GEO_MAX_INVENTORY</td>
<td>Database</td>
<td>110</td>
<td>Maximum inventory threshold to generate warning</td>
</tr>
<tr>
<td>GEO_KEEP_LATLONG</td>
<td>Database</td>
<td>Y</td>
<td>Keep location Lat/Long when other values change</td>
</tr>
</table>




Revision as of 15:35, 28 June 2016


Aptean Logo.png


EMERGENCY RELEASE - CTMS 11.0


RELNOTE ER020-032


Module Program Name Ver Call/Iss Client Ref Pr'ty Remarks Reporter
CUST_COST.fmx Customer Maintenance 2.99 333089 SCR-001 3 New BWSC screen for entering Agreements and generating C-TMS contracts Matthew Tipping
CT_CNT_AGREEMENT_333089.sql Create Table Script 1.2 " " " " "
CT_CNT_AGREEMENT_AUDIT_333089.sql Create Table Script 1.1 " " " " "
CT_CNT_AGREEMENT_INDEX_333089.sql Create Table Script 1.1 " " " " "
CT_CNT_AGREEMENT_FORECAST_333089.sql Create Table Script 1.1 " " " " "
CT_SEQ_CNT_AGREEMENT_333089.sql Create Table Script 1.1 " " " " "
CT_SEQ_CNT_AGREEMENT_AUDIT_333089.sql Create Table Script 1.1 " " " " "
CT_SEQ_CNT_AGREEMENT_FORECAST_333089.sql Create Table Script 1.1 " " " " "
AT_CNT_AGREEMENT_333089.sql Alter Table Script 1.1 " " " " "
CT_TMP_CNT_TIER_NAME_333089.sql Create Table Script 1.1 " " " " "
AT_CNT_CHARGE_TIER_333089.sql Alter Table Script 1.1 " " " " "
CT_ACC_PRICE_INDEX_333089.sql Create Table Script 1.1 " " " " "
AGR.sql Package 1.1 " " " " "
TRG_CNT_AGREEMENT_AI.sql Trigger 1.1 " " " " "
TRG_CNT_AGREEMENT_BIU.sql Trigger 1.1 " " " " "
AT_ACC_ACCOUNT_333089.sql Alter Table Script 1.1 " " " " "
AT_CNT_AGREEMENT_AUDIT_333089.sql Alter Table Script 1.1 " " " " "
AT_2_CNT_AGREEMENT_333089.sql Alter Table Script 1.1 " " " " "
ORION.mmx Menu 1.39 " " " " "
AGREEMENTS.fmx Agreements Maintenance 2.3 " " " " "


Module Program Name Ver Call/Iss Client Ref Pr'ty Remarks Reporter
AT_SCH_ORD_333091.sql Alter Table Script 1.1 333091 SCR-006 3 Added STACK based processing to the debrief process. Matthew Tipping
AT_SCH_ORD_NON_CONFORM_333091.sql Alter Table Script 1.1 " " " " "
AT_SCH_ORDER_LINE_333091.sql Alter Table Script 1.1 " " " " "
AT_SCH_TRIP_333091.sql Alter Table Script 1.1 " " " " "
AT_SCH_TRIP_STOP_333091.sql Alter Table Script 1.2 " " " " "
DATA_ADM_SYSTEM_PARAM_333091.sql Data Script 1.1 " " " " "
DATA_ADM_SYSTEM_PARAM_CONFIG_333091.sql Data Script 1.1 " " " " "
DATA_ORG_CUST_ORD_REV_CHG_TYPE_333091.sql Data Script 1.1 " " " " "
TIU_TRIP_STATUS.sql Trigger 5.40 " " " " "
T_SCH_ORD_PNL.sql Trigger 5.9 " " " " "
TRIPDTL.fmx Trip Debrief Screen 2.198 " " " " "


Module Program Name Ver Call/Iss Client Ref Pr'ty Remarks Reporter
DATA_ADM_SYSTEM_PARAM_333090.sql Data Script 1.1 333090 SCR-002 & 004 3 New forms for manually entering Stacks for specific customer. Matthew Tipping
BDM.fmx 2.87 " " " " "
LOCATION.fmx 2.148 " " " " "
AT_GEO_LOC_TYPE_333090.sql Alter Table Scripts 1.1 " " " " "
AT_GEO_LOCATION_333090.sql Alter Table Scripts 1.1 " " " " "
CT_GEO_LOC_STORAGE_TYPE_333090.sql Create Table Scripts 1.1 " " " " "
CT_GEO_LOC_ENTRIES.sql Create Table Scripts 1.1 " " " " "
DATA_ADM_FORM_TAB_333090.sql Data Scripts 1.1 " " " " "
CT_GEO_LOC_ENTRIES_AUDIT_333090.sql Create Table Scripts 1.3 " " " " "
CT_GEO_LOC_NOTE_TYPE_333090.sql Create Table Scripts 1.2 " " " " "
CT_GEO_LOC_INFORMATION_333090.sql Create Table Scripts 1.4 " " " " "
TRG_GLE_BIU.sql Trigger 1.1 " " " " "
CT_SEQ_GLE_AUDIT_333090.sql Create Table Scripts 1.1 " " " " "
TRG_GLE_AUDIT_BI.sql Trigger 1.1 " " " " "
T_GEO_LOCATION_LATLONG.sql Trigger 5.8 " " " " "
ORION.mmx Orion Menu 1.39 " " " " "
INVENTORY_MAN.fmx Inventory Management 1.1 " " " " "
DATA_ADM_FUNCTION_333090.sql 1.1 " " " " "
New Access
Access Tab Name Description
Function ALLOW_INVENTORY_UPDATE Allow inventory data to be updated
New Parameters
Parameter Name Config Level Setting Value Result
GEO_LOCATION_STACK Database Y Turns on the new stack functionality in the location form
GEO_DEFAULT_DEPOT Database STACK Default depot for new locations
GEO_DEFAULT_COUNTRY Database GB Default country for new locations.
MTS_LOCATION_USAGE Database AGREEMENT Location usage to group locations
GEO_MIN_INVENTORY Database 90 Minimum inventory threshold to generate warning
GEO_MAX_INVENTORY Database 110 Maximum inventory threshold to generate warning
GEO_KEEP_LATLONG Database Y Keep location Lat/Long when other values change




New Screens
Suggested Menu Path Screen ID Screen Description


Registry/Rules Settings
Path & Name Setting Value Result


New Access
Access Tab Name Description


New Parameters
Parameter Name Config Level Setting Value Result
Warning Warning: A WCS Change is required with this release.
Retrieved from ‘https://calidusassist.adcservices.apteancloud.com/calidus-assist/OBS/index.php?title=CTMS_11.0_ER020-032&oldid=3270’