CTMS 11.0 ER025-007

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 UKMail 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 UKMail 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.