CTMS 11.0 ER025-007: Difference between revisions
From Calidus HUB
No edit summary |
m (Text replacement - "[[Category:{{#var:System}} ER]]↵</noinclude>" to "[[Category:{{#var:System}} ER]]Category:ER CTMS 025 </noinclude>") |
||
| (5 intermediate revisions by one other user not shown) | |||
| Line 92: | Line 92: | ||
{{ERTableHeader}} | {{ERTableHeader}} | ||
{{ERTableRow | {{ERTableRow | ||
| | |CT_GAZ_UKMAIL_342369.sql | ||
| | |Create Table Script | ||
| | |1.1 | ||
| | |342369 | ||
| | |DS-ALBGDV | ||
| | |2 | ||
| | |The customer carrier will be integrated into C-TMS. | ||
| | |||
The gazetteer import process will need to be setup and imported using the format name 'Gazetteer UKMail'. | |||
Both the Postcode and Service files must be present for a new gazetteer to be imported successfully. | |||
The new system parameter CARR_GAZ_POSTCODE_FORMAT will need to store the gazetteer format(s) that provide the postcode without distinction between the outer and inner sections of the postode (e.g. 'Gazetteer DHL ESD'). | |||
The new tab pages, import processes and report will need to be authorised for the appropriate user groups. | |||
The carrier for the customer will need to be configured for its label and manifest formats, and tracking references. | |||
|Denis Starodubov | |||
}} | }} | ||
{{ERTableRow | {{ERTableRow | ||
| | |CT_GAZ_UKMAIL_SERVICE_342369.sql | ||
| | |Create Table Script | ||
| | |1.1 | ||
|" | |" | ||
|" | |" | ||
| Line 112: | Line 122: | ||
}} | }} | ||
{{ERTableRow | {{ERTableRow | ||
| | |CT_GAZ_UKMAIL_POSTCODE_342369.sql | ||
| | |Create Table Script | ||
| | |1.1 | ||
|" | |" | ||
|" | |" | ||
| Line 122: | Line 132: | ||
}} | }} | ||
{{ERTableRow | {{ERTableRow | ||
| | |CT_SEQ_GAZ_ID_UKMAIL_342369.sql | ||
| | |Create Table Script | ||
| | |1.1 | ||
|" | |" | ||
|" | |" | ||
| Line 132: | Line 142: | ||
}} | }} | ||
{{ERTableRow | {{ERTableRow | ||
| | |DATA_ADM_FORM_TAB_342369.sql | ||
| | |Data Script | ||
| | |1.1 | ||
|" | |" | ||
|" | |" | ||
| Line 142: | Line 152: | ||
}} | }} | ||
{{ERTableRow | {{ERTableRow | ||
| | |DATA_ADM_SYSTEM_PARAM_342369.sql | ||
| | |Data Script | ||
| | |1.1 | ||
|" | |" | ||
|" | |" | ||
| Line 152: | Line 162: | ||
}} | }} | ||
{{ERTableRow | {{ERTableRow | ||
| | |DATA_1_IMP_IMPORT_TYPE_342369.sql | ||
| | |Data Script | ||
| | |1.1 | ||
|" | |" | ||
|" | |" | ||
| Line 162: | Line 172: | ||
}} | }} | ||
{{ERTableRow | {{ERTableRow | ||
| | |DATA_2_IMP_FIELD_342369.sql | ||
| | |Data Script | ||
| | |1.1 | ||
|" | |" | ||
|" | |" | ||
| Line 172: | Line 182: | ||
}} | }} | ||
{{ERTableRow | {{ERTableRow | ||
| | |DATA_REP_REPORT_342369.sql | ||
| | |Data Script | ||
| | |1.1 | ||
|" | |" | ||
|" | |" | ||
| Line 182: | Line 192: | ||
}} | }} | ||
{{ERTableRow | {{ERTableRow | ||
| | |DATA_REP_REPORT_PARAM_342369.sql | ||
| | |Data Script | ||
| | |1.1 | ||
|" | |" | ||
|" | |" | ||
| Line 192: | Line 202: | ||
}} | }} | ||
{{ERTableRow | {{ERTableRow | ||
| | |DATA_RES_CARRIER_FORMATS_342369.sql | ||
| | |Data Script | ||
| | |1.1 | ||
|" | |" | ||
|" | |" | ||
| Line 202: | Line 212: | ||
}} | }} | ||
{{ERTableRow | {{ERTableRow | ||
| | |DATA_RES_CARRIER_FORMATS_MAP_342369.sql | ||
| | |Data Script | ||
| | |1.1 | ||
|" | |" | ||
|" | |" | ||
| Line 212: | Line 222: | ||
}} | }} | ||
{{ERTableRow | {{ERTableRow | ||
| | |DATA_RES_LABEL_FORMATS_342369. | ||
| | |Data Script | ||
| | |1.2 | ||
|" | |" | ||
|" | |" | ||
| Line 222: | Line 232: | ||
}} | }} | ||
{{ERTableRow | {{ERTableRow | ||
| | |TRG_GAZ_UKMAIL_BIU.sql | ||
| | |Trigger | ||
| | |1.1 | ||
|" | |" | ||
|" | |" | ||
| Line 232: | Line 242: | ||
}} | }} | ||
{{ERTableRow | {{ERTableRow | ||
| | |TRG_GAZ_UKMAIL_POSTCODE_BIU.sql | ||
| | |Trigger | ||
| | |1.1 | ||
|" | |" | ||
|" | |" | ||
| Line 242: | Line 252: | ||
}} | }} | ||
{{ERTableRow | {{ERTableRow | ||
| | |TRG_GAZ_UKMAIL_SERVICE_BIU.sql | ||
| | |Trigger | ||
| | |1.1 | ||
|" | |" | ||
|" | |" | ||
| Line 252: | Line 262: | ||
}} | }} | ||
{{ERTableRow | {{ERTableRow | ||
| | |DP_CARRIER.sql | ||
| | |Database package | ||
| | |1.59 | ||
|" | |" | ||
|" | |" | ||
| Line 262: | Line 272: | ||
}} | }} | ||
{{ERTableRow | {{ERTableRow | ||
| | |DP_IMP_GAZ.sql | ||
| | |Database package | ||
| | |1.7 | ||
|" | |" | ||
|" | |" | ||
| Line 272: | Line 282: | ||
}} | }} | ||
{{ERTableRow | {{ERTableRow | ||
| | |DP_INT_XML_CARPOD.sql | ||
| | |Database package | ||
| | |5.4 | ||
|" | |" | ||
|" | |" | ||
| Line 282: | Line 292: | ||
}} | }} | ||
{{ERTableRow | {{ERTableRow | ||
| | |DP_REPORTS.sql | ||
| | |Database package | ||
| | |5.44 | ||
|" | |" | ||
|" | |" | ||
| Line 292: | Line 302: | ||
}} | }} | ||
{{ERTableRow | {{ERTableRow | ||
| | |INT_XML_OUT2.sql | ||
| | |Database package | ||
| | |5.254 | ||
|" | |" | ||
|" | |" | ||
| Line 302: | Line 312: | ||
}} | }} | ||
{{ERTableRow | {{ERTableRow | ||
| | |IMPORTS_EXEC.fmx | ||
| | |Oracle Form | ||
| | |10.20 | ||
|" | |" | ||
|" | |" | ||
| Line 312: | Line 322: | ||
}} | }} | ||
{{ERTableRow | {{ERTableRow | ||
| | |RESOURCE.fmx | ||
| | |Oracle Form | ||
| | |2.186 | ||
|" | |" | ||
|" | |" | ||
| Line 322: | Line 332: | ||
}} | }} | ||
{{ERTableRow | {{ERTableRow | ||
| | |CARRIER_MANIFEST_UKMAIL.rep | ||
| | |Oracle Report | ||
| | |1.2 | ||
|" | |" | ||
|" | |" | ||
| Line 333: | Line 343: | ||
{{ERTableFooter}} | {{ERTableFooter}} | ||
<table border="1px" width="100%"> | |||
<tr> | |||
<td colspan="3" bgcolor="silver"><font size="2">'''Registry/Rules Settings'''</font></td> | |||
</tr> | |||
<tr> | |||
<td bgcolor="silver"><font size="2">'''Path & Name'''</font></td> | |||
<td bgcolor="silver"><font size="2">'''Setting Value'''</font></td> | |||
<td bgcolor="silver"><font size="2">'''Result'''</font></td> | |||
</tr> | |||
<tr> | |||
<td>CARR_GAZ_POSTCODE_FORMAT</td> | |||
<td>SYSTEM</td> | |||
<td> | |||
Description: | |||
'For which carrier gazetteer formats will the postcode in the file exclude spaces. (List delimited with semi-colons)' | |||
Result: | |||
If the gazetteer import format name is listed in this system parameter it means that the gazetteer file from the carrier will not include a space in the postcode to distinguish between the outer and inner sections of the postcode. | |||
This system parameter is expected to be used for ‘Gazetteer DHL ESD’ but it could apply to ‘Gazetteer Polarspeed’ too in the future. | |||
This system parameter will not apply to the ‘Gazetteer UKMail’ and ‘Gazetteer Yodel’ import format names because they include their own internal logic. | |||
</td> | |||
</tr> | |||
</table> | |||
<noinclude> | <noinclude> | ||
[[Category:{{#var:System}} ER]] | [[Category:{{#var:System}} ER]][[Category:ER CTMS 025]] | ||
</noinclude> | </noinclude> | ||
Latest revision as of 14:59, 14 July 2025
EMERGENCY RELEASE - CTMS 11.0
RELNOTE ER025-007
| Module | Program Name | Ver | Call/Iss | Client Ref | Pr'ty | Remarks | Reporter |
| AT_ORG_CUSTOMER_343745.sql | Alter table Script | 1.1 | 343745 | - | 3 | Added new cost centre parameter SHOW_FULL_ADDRESS which will allow printing of the full delivery address on labels, also the SHOW_CONTACT parameter to show contact details on the label, also a customer flag that will allow that customers orders to show the full delivery address on labels | Hayley Keegan |
| DATA_ADM_SYSTEM_PARAM_343745.sql | Data Script | 1.1 | " | " | " | " | " |
| DATA_ADM_SYSTEM_PARAM_CONFIG_343745.sql | Data Script | 1.1 | " | " | " | " | " |
| DATA_RES_LABEL_FORMATS_343745.sql | Data Script | 1.1 | " | " | " | " | " |
| DP_CARRIER.sql | Carrier Management | 1.58 | " | " | " | " | " |
| CUST_COST.fmx | Customer Maintenance form | 2.119 | " | " | " | " | " |
| LFS_LABEL.rep | Label Report | 1.20 | " | " | " | " | " |
| LFS_LABEL_MULTI.rep | Label Report | 1.8 | " | " | " | " | " |
| Module | Program Name | Ver | Call/Iss | Client Ref | Pr'ty | Remarks | Reporter |
| CT_GAZ_UKMAIL_342369.sql | Create Table Script | 1.1 | 342369 | DS-ALBGDV | 2 | The customer carrier will be integrated into C-TMS.
The gazetteer import process will need to be setup and imported using the format name 'Gazetteer UKMail'. Both the Postcode and Service files must be present for a new gazetteer to be imported successfully. The new system parameter CARR_GAZ_POSTCODE_FORMAT will need to store the gazetteer format(s) that provide the postcode without distinction between the outer and inner sections of the postode (e.g. 'Gazetteer DHL ESD'). The new tab pages, import processes and report will need to be authorised for the appropriate user groups. The carrier for the customer will need to be configured for its label and manifest formats, and tracking references. |
Denis Starodubov |
| CT_GAZ_UKMAIL_SERVICE_342369.sql | Create Table Script | 1.1 | " | " | " | " | " |
| CT_GAZ_UKMAIL_POSTCODE_342369.sql | Create Table Script | 1.1 | " | " | " | " | " |
| CT_SEQ_GAZ_ID_UKMAIL_342369.sql | Create Table Script | 1.1 | " | " | " | " | " |
| DATA_ADM_FORM_TAB_342369.sql | Data Script | 1.1 | " | " | " | " | " |
| DATA_ADM_SYSTEM_PARAM_342369.sql | Data Script | 1.1 | " | " | " | " | " |
| DATA_1_IMP_IMPORT_TYPE_342369.sql | Data Script | 1.1 | " | " | " | " | " |
| DATA_2_IMP_FIELD_342369.sql | Data Script | 1.1 | " | " | " | " | " |
| DATA_REP_REPORT_342369.sql | Data Script | 1.1 | " | " | " | " | " |
| DATA_REP_REPORT_PARAM_342369.sql | Data Script | 1.1 | " | " | " | " | " |
| DATA_RES_CARRIER_FORMATS_342369.sql | Data Script | 1.1 | " | " | " | " | " |
| DATA_RES_CARRIER_FORMATS_MAP_342369.sql | Data Script | 1.1 | " | " | " | " | " |
| DATA_RES_LABEL_FORMATS_342369. | Data Script | 1.2 | " | " | " | " | " |
| TRG_GAZ_UKMAIL_BIU.sql | Trigger | 1.1 | " | " | " | " | " |
| TRG_GAZ_UKMAIL_POSTCODE_BIU.sql | Trigger | 1.1 | " | " | " | " | " |
| TRG_GAZ_UKMAIL_SERVICE_BIU.sql | Trigger | 1.1 | " | " | " | " | " |
| DP_CARRIER.sql | Database package | 1.59 | " | " | " | " | " |
| DP_IMP_GAZ.sql | Database package | 1.7 | " | " | " | " | " |
| DP_INT_XML_CARPOD.sql | Database package | 5.4 | " | " | " | " | " |
| DP_REPORTS.sql | Database package | 5.44 | " | " | " | " | " |
| INT_XML_OUT2.sql | Database package | 5.254 | " | " | " | " | " |
| IMPORTS_EXEC.fmx | Oracle Form | 10.20 | " | " | " | " | " |
| RESOURCE.fmx | Oracle Form | 2.186 | " | " | " | " | " |
| CARRIER_MANIFEST_UKMAIL.rep | Oracle Report | 1.2 | " | " | " | " | " |
| Registry/Rules Settings | ||
| Path & Name | Setting Value | Result |
| CARR_GAZ_POSTCODE_FORMAT | SYSTEM |
Description: 'For which carrier gazetteer formats will the postcode in the file exclude spaces. (List delimited with semi-colons)' Result: If the gazetteer import format name is listed in this system parameter it means that the gazetteer file from the carrier will not include a space in the postcode to distinguish between the outer and inner sections of the postcode. This system parameter is expected to be used for ‘Gazetteer DHL ESD’ but it could apply to ‘Gazetteer Polarspeed’ too in the future. This system parameter will not apply to the ‘Gazetteer UKMail’ and ‘Gazetteer Yodel’ import format names because they include their own internal logic. |
