CTMS 11.0 ER020-032

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 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.3	"	"	"	"	"
CT_CNT_AGREEMENT_INDEX_333089.sql	Create Table Script	1.1	"	"	"	"	"
CT_CNT_AGREEMENT_FORECAST_333089.sql	Create Table Script	1.2	"	"	"	"	"
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.2	"	"	"	"	"
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
DATA_SCH_SOURCE_SYSTEM_333095.sql	Data Script	1.1	333095	SCR-018	3	New import for auditing only.	Matthew Tipping
DP_IMP_3.sql	New Imports Package	1.1	"	"	"	"	"
CT_IMP_LOAD_AUDIT_333095.sql	Create Table Script	1.1	"	"	"	"	"
CT_SEQ_IMP_FILE_ID_333095.sql	Create Table Script	1.1	"	"	"	"	"
IMP.sql	Imports Package	5.127	"	"	"	"	"
IMPORTS_EXEC.fmx	Imports Form	10.18	"	"	"	"	"
AT_RES_CARRIER_333095.sql	Alter table Script	1.1	"	"	"	"	"
RESOURCE.fmx	Resource Screen	2.162	"	"	"	"	"
CT_RES_TRAILER_PRODUCT_333095.sql	Create table Script	1.2	"	"	"	"	"
DATA_ADM_FORM_TAB_333095.sql	Data Script	1.1	"	"	"	"	"

Module	Program Name	Ver	Call/Iss	Client Ref	Pr'ty	Remarks	Reporter
AT_TIME_ZONE_MASTER_335395.sql	Alter Table Script	1.1	335395	-	3	Data segregation by cost centre phase 3 - business data maintenance (group names, location zones, time zones), resources (trailers), account maintenance (currency codes) and system configuration (Printers)	Julie Scott
AT_RES_TRAILER_335395.sql	Alter Table Script	1.1	"	"	"	"	"
AT_GEO_LOCATION_ZONE_335395.sql	Alter Table Script	1.1	"	"	"	"	"
AT_ACC_CURRENCY_335395.sql	Alter Table Script	1.1	"	"	"	"	"
BDM.fmx	Business Data Maintenance	2.89	"	"	"	"	"
RESOURCE.fmx	Resource Maintenance	2.164	"	"	"	"	"
SYS_CFG.fmx	System Configuration	2.11	"	"	"	"	"

Module	Program Name	Ver	Call/Iss	Client Ref	Pr'ty	Remarks	Reporter
RESOURCE.fmx	Resource Maintenance Form	2.161	335495	-	3	The following tab pages in the Resource Maintenance screen have been changed to prevent any duplicate records being entered: Carriers Carrier Groups Carrier Types Carrier Service Level Fixed Charges Service Types Trailer Types (in combination with temp/group) Loc Prd Conv Despatch Unit Types Standardised DUs RPEs The DU Type field for the despatch Unit Types cannot be edited so that it can be changed. The Standardised DU's will be saved upon entry, change or deletion automatically.	Terry Mann

Module	Program Name	Ver	Call/Iss	Client Ref	Pr'ty	Remarks	Reporter
RESOURCE.fmx	Resource Maintenance Form	2.163	336188	-	3	Main version for changes for branched version of the Resource Maintenance screen for log 335495.	Paul Roscoe

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