CTMS 11.0 ER024-028: Difference between revisions

From Calidus HUB
(Created page with "<!-- MEDIA LANDSCAPE YES --> {{#vardefine:System|CTMS}} {{ERHeader |SystemVersion=CTMS 11.0 |ERNumber=ER024-028 }} {{ERTableHeader}} {{ERTableRow |DATA_ADM_SYSTEM_PARAM_342918....")
 
No edit summary
 
(3 intermediate revisions by the same user not shown)
Line 72: Line 72:
{{ERTableHeader}}
{{ERTableHeader}}
{{ERTableRow
{{ERTableRow
|
|DATA_ADM_SYSTEM_PARAM_342919.sql
|
|Data Script
|
|1.1
|
|342919
|
|JB-AMQKTC
|
|3
|
|Suppression of LOTS messages and reverse decodes for OTM.
|
|Jez Brookes
}}
}}
{{ERTableRow
{{ERTableRow
|
|INT_XML_OUT2.sql             
|
|Outbound XML messages
|
|5.250
|"
|"
|"
|"
Line 92: Line 92:
}}
}}
{{ERTableRow
{{ERTableRow
|
|INT_XML_IN.sql               
|
|Inbound XML messages
|
|5.165
|"
|"
|"
|"
Line 102: Line 102:
}}
}}
{{ERTableRow
{{ERTableRow
|
|TRG_SOL_XML.sql               
|
|Trigger
|
|5.40
|"
|"
|"
|"
|"
}}
{{ERTableRow
|TRG_STS_XML_OUT.sql           
|Trigger
|5.35
|"
|"
|"
|"
|"
}}
{{ERTableRow
|TRG_STS_XML.sql               
|Trigger
|5.21
|"
|"
|"
|"
|"
}}
{{ERTableRow
|TRG_SHA_LOTS.sql             
|Trigger
|5.5
|"
|"
|"
|"
|"
}}
{{ERTableRow
|TRG_SCH_TRIP_XML_INT.sql     
|Trigger
|5.30
|"
|"
|"
|"
|"
}}
{{ERTableRow
|TRG_SCH_ORD_LOTS.sql         
|Trigger
|5.11
|"
|"
|"
|"
|"
}}
{{ERTableRow
|TRG_SCH_ORD_LATE_REASON.sql   
|Trigger
|5.8
|"
|"
|"
|"
|"
}}
{{ERTableRow
|TRG_SCH_ORD_ITEMS_REASONS.sql 
|Trigger
|5.13
|"
|"
|"
|"
|"
}}
{{ERTableRow
|TRG_SCH_ORD_TO_LOTS.sql       
|Trigger
|5.5
|"
|"
|"
|"
|"
}}
{{ERTableRow
|TRG_SCH_ORD_NON_CONF_XML_INT.sql
|Trigger
|5.11
|"
|"
|"
|"
Line 113: Line 203:
{{ERTableFooter}}
{{ERTableFooter}}


<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>'LOTS_SEND_PLANNED</td>
<td>D/B</td>
<td>'Y'</td>
<td>Send update messages to LOTS whilst trip is till at status Planned</td>
</tr>
</table>
{{ERTableHeader}}
{{ERTableRow
|RESOURCE.fmx                 
|Resource Screen
|2.180
|342920
|JB-AMQKWQ
|3
|New OTM export.
|Jez Brookes
}}
{{ERTableRow
|DP_CSV_DHL.sql               
|Export Package
|1.16
|"
|"
|"
|"
|"
}}
{{ERTableRow
|DP_IMP_2.sql                 
|Import Package
|1.62
|"
|"
|"
|"
|"
}}
{{ERTableRow
|AT_RES_CARRIER_342920.sql     
|Alter Table Script
|1.1
|"
|"
|"
|"
|"
}}
{{ERTableRow
|CT_OTM_ORDER_EXPORTS_342920.sq
|Create Table Script
|1.1
|"
|"
|"
|"
|"
}}
{{ERTableRow
|DATA_1_REP_REPORT_342920.sql 
|Data Script
|1.1
|"
|"
|"
|"
|"
}}
{{ERTableRow
|DATA_2_REP_REPORT_PARAM_342920
|Data Script
|1.1
|"
|"
|"
|"
|"
}}
{{ERTableFooter}}


<noinclude>
<noinclude>
[[Category:{{#var:System}} ER]]
[[Category:{{#var:System}} ER]]
</noinclude>
</noinclude>

Latest revision as of 13:02, 15 June 2017


Aptean Logo.png


EMERGENCY RELEASE - CTMS 11.0


RELNOTE ER024-028


Module Program Name Ver Call/Iss Client Ref Pr'ty Remarks Reporter
DATA_ADM_SYSTEM_PARAM_342918.sql Data Script 1.1 342918 JB-AMQEYY 3 Changes to generic CSV order import (ORD_LINE_ITM) to accommodate the new OTM requirements. Jez Brookes
DP_IMP_2.sql Order Import 1.60 " " " " "
DATA_IMP_FIELD_342918.sql Data Script 1.1 " " " " "
AT_SCH_ORD_342918.sql Alter Table Script 1.1 " " " " "


New Parameters
Parameter Name Config Level Setting Value Result
IMP_OVERRIDE_SOURCE_REF Database 'OTM' To identify orders were generated from the OTM system and control additional functionality


Module Program Name Ver Call/Iss Client Ref Pr'ty Remarks Reporter
DATA_ADM_SYSTEM_PARAM_342919.sql Data Script 1.1 342919 JB-AMQKTC 3 Suppression of LOTS messages and reverse decodes for OTM. Jez Brookes
INT_XML_OUT2.sql Outbound XML messages 5.250 " " " " "
INT_XML_IN.sql Inbound XML messages 5.165 " " " " "
TRG_SOL_XML.sql Trigger 5.40 " " " " "
TRG_STS_XML_OUT.sql Trigger 5.35 " " " " "
TRG_STS_XML.sql Trigger 5.21 " " " " "
TRG_SHA_LOTS.sql Trigger 5.5 " " " " "
TRG_SCH_TRIP_XML_INT.sql Trigger 5.30 " " " " "
TRG_SCH_ORD_LOTS.sql Trigger 5.11 " " " " "
TRG_SCH_ORD_LATE_REASON.sql Trigger 5.8 " " " " "
TRG_SCH_ORD_ITEMS_REASONS.sql Trigger 5.13 " " " " "
TRG_SCH_ORD_TO_LOTS.sql Trigger 5.5 " " " " "
TRG_SCH_ORD_NON_CONF_XML_INT.sql Trigger 5.11 " " " " "


New Parameters
Parameter Name Config Level Setting Value Result
'LOTS_SEND_PLANNED D/B 'Y' Send update messages to LOTS whilst trip is till at status Planned


Module Program Name Ver Call/Iss Client Ref Pr'ty Remarks Reporter
RESOURCE.fmx Resource Screen 2.180 342920 JB-AMQKWQ 3 New OTM export. Jez Brookes
DP_CSV_DHL.sql Export Package 1.16 " " " " "
DP_IMP_2.sql Import Package 1.62 " " " " "
AT_RES_CARRIER_342920.sql Alter Table Script 1.1 " " " " "
CT_OTM_ORDER_EXPORTS_342920.sq Create Table Script 1.1 " " " " "
DATA_1_REP_REPORT_342920.sql Data Script 1.1 " " " " "
DATA_2_REP_REPORT_PARAM_342920 Data Script 1.1 " " " " "