CTMS 11.0 ER020-032
From Calidus HUB
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:
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 |
