ER CTMS 047-040: Difference between revisions

From Calidus HUB
VisualWikitext
No edit summary
No edit summary
Line 157: Line 157:
!Module !! Program Name !! Ver !! Call/Iss !! Client Ref !! Pr'ty !! Remarks
!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
|"
|"
|"
|"
|"
|"
|"
|"
|}
{| class="wikitable" border="1" width="100%"
|- bgcolor="silver"
!Module !! Program Name !! Ver !! Call/Iss !! Client Ref !! Pr'ty !! Remarks
|-
|-
|
|TRG_SCH_TRIP_XML_FLX.sql
|
|DB Trigger
|
|1.2
|
|"
|
|"
|
|"
|
|"
|-
|-
|
|DP_FLEXIPOD.sql
|
|DB Trigger
|
|1.4
|"
|"
|"
|"
Line 195: Line 416:
|"
|"
|}
|}




Revision as of 14:12, 24 April 2025


Aptean Logo.png


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 " " " "
Retrieved from ‘https://calidusassist.adcservices.apteancloud.com/calidus-assist/OBS/index.php?title=ER_CTMS_047-040&oldid=11729’