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
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 | " | " | " | " | " |