ER CTMS 047-040
EMERGENCY RELEASE - CTMS 12.0
RELNOTE ER047-040
| Module | Program Name | Ver | Call/Iss | Client Ref | Pr'ty | Remarks |
|---|---|---|---|---|---|---|
| DP_CTMS_IMPORT.sql | API Database Package | 5.56 | 00645356 | SCR-CTMS-APOD-03557646-20 | 2 | Flexipod/APOD integration with CTMS.
The locations can be imported via the API process to include references for the Permit Number for the delivering depot, the Licence Number for the delivering depot, the Unitary Authority for the delivery location. The drop attributes for APOD can include the location references for the Permit Number for the delivering depot, the Licence Number for the delivering depot, the Unitary Authority for the delivery location, and the SIC Code for the customer of the order. Version 1.2 of IMPORT_CUSTOMER.xsd will be required. |
| Module | Program Name | Ver | Call/Iss | Client Ref | Pr'ty | Remarks |
|---|---|---|---|---|---|---|
| INT_XML_OUT2.sql | Outbound XML Interface Package | 5.349 | 00620918 | SCR-PORTAL-669852-58A-APOD | 2 | Flexipod/APOD integration with CTMS.
A new section for to include the JobReportName from APOD can be sent to Portal. Version 1.43 of LOTS TripOrder.xsd will be required. |
| Module | Program Name | Ver | Call/Iss | Client Ref | Pr'ty | Remarks |
|---|---|---|---|---|---|---|
| DATA_ADM_SYSTEM_PARAM_00620891.sql | Database Script | 1.1 | 00620891 | SCR-CTMS-669852-58 | 2 | Flexipod/APOD integration with CTMS.
The signature and the signatory details will be obtained from APOD and they will be stored in CTMS and passed to Portal TTM and included in the TIMI interface. Version 2.49 of TripOrder.xsd will be required. |
| DATA_IMP_DECODE_00620891.sql | Database Script | 1.1 | " | " | " | " |
| DATA_IMP_DECODE_ENTRY_00620891.sql | Database Script | 1.2 | " | " | " | " |
| Module | Program Name | Ver | Call/Iss | Client Ref | Pr'ty | Remarks |
|---|---|---|---|---|---|---|
| AT_INT_XML_ORD_DETAILS_620535.sql | Database Script | 1.1 | 620535 | SCR-CTMS-03557646-13 | 2 | Flexipod/APOD integration with CTMS
The total price of the order and the items can be set to send as attributes to APOD. Version 2.49 of TripOrder.xsd will be required. |
| AT_INT_XML_ORD_HEADER_620535.sql | Database Script | 1.1 | " | " | " | " |
| AT_SCH_ORD_620535.sql | Database Script | 1.1 | " | " | " | " |
| AT_SCH_ORD_ITEMS_620535.sql | Database Script | 1.1 | " | " | " | " |
| DATA_ADM_FUNCTION_620535.sql | Database Script | 1.1 | " | " | " | " |
| DATA_FLX_ATTRIBUTES_API_00620535.sql | Database Script | 1.1 | " | " | " | " |
| DP_CTMS_IMPORT.sql | API Database Package | 5.55 | " | " | " | " |
| ORDERS_WIDE.fmx | Orders Form | 1.62.1.1 | " | " | " | " |
| Module | Program Name | Ver | Call/Iss | Client Ref | Pr'ty | Remarks |
|---|---|---|---|---|---|---|
| AT_GEO_LOCATION_00322441.sql | DB Script | 1.1 | 484373 | SCR-CTMS-03557646-12 | 2 | Flexipod/APOD integration with CTMS.
Version 2.49 of TripOrder.xsd will be required. Version 1.4.1.1 of DP_FLEXIPOD will be released to the 19c databases. The system parameters will need to be set to enable the API methods via the proxy server. The EDI processes will be required for the following API methods: Add: FLEXIPOD_OUT List Pending Manifest Updates: FLEXIPOD_SENDLISTPENDING External System Updates (When active): FLEXIPOD_IN Read Drop (When active): FLEXIPOD_PROCESS_READDROP Decodes will be created to add codes: FLX_DEPOT FLX_RESULT_CODES FLX_STATUS_CODES A script will be run for the STS databases to create the attributes. |
| AT_RES_CARRIER_00484373.sql | DB Script | 1.1 | " | " | " | " |
| CT_FLEXIPOD_STAGING_00484373.sql | DB Script | 1.1 | " | " | " | " |
| CT_FLEXIPOD_STAGING_LISTPENDINGMANIFESTS_00484373.sql | DB Script | 1.1 | " | " | " | " |
| CT_FLEXIPOD_STAGING_READDROP_00484373.sql | DB Script | 1.1 | " | " | " | " |
| CT_FLEXIPOD_WEB_AUDIT_00484373.sql | DB Script | 1.1 | " | " | " | " |
| CT_FLX_ATTRIBUTES_API_00484373.sql | DB Script | 1.2 | " | " | " | " |
| CT_FLX_JSON_IN_00484373.sql | DB Script | 1.2 | " | " | " | " |
| CT_SEQ_CALL_REF_00484373.sql | DB Script | 1.1 | " | " | " | " |
| CT_SEQ_FLEXIPOD_WEB_AUDIT_00484373.sql | DB Script | 1.1 | " | " | " | " |
| CT_SEQ_FLX_JSON_00484373.sql | DB Script | 1.1 | " | " | " | " |
| CT_SEQ_FLX_SHIPPING_UNIT_00484373.sql | DB Script | 1.1 | " | " | " | " |
| CT_SEQ_FLX_STAGING_SEQ_00484373.sql | DB Script | 1.1 | " | " | " | " |
| CT_SEQ_TRACK_REF_00484373.sql | DB Script | 1.1 | " | " | " | " |
| DATA_ADM_LOG_PROG_NAME_00484373.sql | DB Script | 1.1 | " | " | " | " |
| DATA_ADM_SYSTEM_PARAM_00484373.sql | DB Script | 1.2 | " | " | " | " |
| DATA_IMP_DECODE_00484373.sql | DB Script | 1.1 | " | " | " | " |
| TRG_BOOKING_REF_FLX.sql | DB Trigger | 1.2 | " | " | " | " |
| TRG_DELETE_FLX.sql | DB Trigger | 1.2 | " | " | " | " |
| TRG_FLEXIPOD_WEB_AUDIT.sql | DB Trigger | 1.1 | " | " | " | " |
| TRG_SCH_HAULAGE_FLX.sql | DB Trigger | 1.2 | " | " | " | " |
| TRG_SCH_ORD_ITEMS_FLX.sql | DB Trigger | 1.1 | " | " | " | " |
| TRG_SCH_ORD_ITEMS_CONTENT_FLX.sql | DB Trigger | 1.1 | " | " | " | " |
| TRG_SCH_ORD_REF_FLX.sql | DB Trigger | 1.1 | " | " | " | " |
| TRG_SCH_ORDER_LINE_FLX.sql | DB Trigger | 1.1 | " | " | " | " |
| TRG_SCH_TRIP_DRV_FLX.sql | DB Trigger | 1.2 | " | " | " | " |
| TRG_SCH_TRIP_STOP_XML_FLX.sql | DB Trigger | 1.1 | " | " | " | " |
| TRG_SCH_TRIP_XML_FLX.sql | DB Trigger | 1.2 | " | " | " | " |
| DP_FLEXIPOD.sql | DB Trigger | 1.4 | " | " | " | " |
Note: This release also covers 00645352 (SCR-03557646-14,15,16,17) & 00620875 (SCR-669852-16)
| New Parameters | |||
|---|---|---|---|
| Parameter Name | Config Level | Setting Value | Result |
| FLEXIPOD | SYSTEM | Y | Set to Y to indicate the FlexiPod interface is active |
| FLEXIPOD_ACID | SYSTEM | - | Flexipod acid |
| FLEXIPOD_BREAK_DROPS | SYSTEM | Y | Flexipod include breaks for the drops in the Add API call (Y/N) |
| FLEXIPOD_CARRIERS | SYSTEM | Y | Set to Y indicates the Carrier can control if a trip is sent to FlexiPod |
| FLEXIPOD_CLIENTNUM | SYSTEM | - | FleXipod ClientNum sent in interface |
| FLEXIPOD_DEPOTS | SYSTEM | Y | Set to Y indicates the Depot can control if a trip is sent to FlexiPod |
| FLEXIPOD_DIRECT | SYSTEM | Y | Set to Y to indicate the FlexiPod interface is direct and not using Route Execution |
| FLEXIPOD_DROP | SYSTEM | STOP-OMS | Determines the Drop level STOP-OMS or ITEM |
| FLEXIPOD_EXPIRY | SYSTEM | 14 | Sets the expiry date for the manifest as a number of days after the end of the trip. |
| FLEXIPOD_EXTERNALSYSTEMUPDATE | SYSTEM | Y | Flexipod process the External System Update messages in the API call (Y/N) |
| FLEXIPOD_FORCEITEMSCAN | SYSTEM | 0 | Force the items to be scanned separately: 0 to use the ScanLevel or 1 to force the scan by item. |
| FLEXIPOD_LISTPENDINGMANIFESTS | SYSTEM | Y | Flexipod process the List Pending Manifest Update messages in the API call (Y/N) |
| FLEXIPOD_MERGE_DROPS | SYSTEM | Y | Flexipod merge the orders on the drop in the Add API call (Y/N) |
| FLEXIPOD_PASSWORD | SYSTEM | - | FleXipod Webservice password |
| FLEXIPOD_PROXY | SYSTEM | - | Flexipod proxy server |
| FLEXIPOD_READDROP | SYSTEM | Y | Flexipod process the Read Drop messages in the API call (Y/N) |
| FLEXIPOD_SCAN_LEVEL | SYSTEM | 3 | 1,2 or 3 to indicate line or item level scanning |
| FLEXIPOD_SCAN_TYPE | SYSTEM | ITEMS | Contents and items |
| FLEXIPOD_SIGNATORY | SYSTEM | Y | Set to Y to store the SignedByName as the actual signatory as information for the order at its collection of delivery location |
| FLEXIPOD_SPLIT | SYSTEM | X | Are orders to be split? |
| FLEXIPOD_SYSTEM | SYSTEM | SYSID | FleXipod SYSTEM ID sent in interface |
| FLEXIPOD_TPCLIENTNUM | SYSTEM | - | FleXipod TPClientNum sent in interface |
| FLEXIPOD_USERCODE | SYSTEM | - | FleXipod webservice usercode |
| FLEXIPOD_USERNAME | SYSTEM | - | FleXipod webservice username |
| FLEXIPOD_WEBSERVICE_UI | SYSTEM | - | Flexipod webservice endpoint URL |
| FLEXIPOD_X_API_KEY | SYSTEM | - | Flexipod x-api-key for External System Update messages |
