EST 05695722 WREQ0130528 Ford Inbound Interface Changes

STATEMENT OF WORK CHANGE REQUEST ESTIMATE

Client	DHLT	Project	AA	Site	-
Client Reference	WREQ0130528	Aptean Reference	05695722	Estimate Version	0.01
Prepared By	A N Walker			Estimate Date	15/08/2025
Invoice Reference	-			Priority	-
Customer	Ford			System Version	12.48

Client Request

Ford are introducing a new SAP system and a new inbound interface format. Copy of the Ford specification attached. We will use DHL Link to translate the message to a more standard inbound format or use a one to one interface. The plan is to capture the same data as current Please note that this request is linked to the outbound tracking request on WREQ0127859. We need to ensure we have all the information that we need for the tracking.

Aptean Solution

The Ford Inbound Orders EDI process currently: Finds the order Stores the items and contents onto standard EDI tables Then processes them to update the order Adds Items Adds contents Generates lines The process does not currently update or store the individual shipment IDs for each order on each item. The process will be modified to: Change the mapping of the header elements Store the order references as new order reference FORD_SHIPMENT_ID. Use an optional EDI parameter VERSION, to control whether this is using the old or new versions of the import file. An implementation script will be created to create the new parameters and references. Note: This process will support both versions of the EDI formats provided, but not at the same time, so the implementation must be a controlled swap-over. The process will be modified to add a VERSION parameter. If this is explicitly set to "1", then the process will run the old import. Otherwise, this will run the new import specified here. The fields used for the header information will be modified as follows: Old Format (v1) - New Format (v2) Shipment (shipment_id attribute) - FreightOrderId shipping_location - InitialSourceLocation carrier - CarrierID truck_license_plate - TruckLicensePlateID seal_number - N/A shipping_date - DateAndTime shipto_location - ArrivalLocation N/A - LogisticalExecutionStatus Note: It is assumed that the data content is not changing, just the labels. If this is not the case, the estimate must be revisited. Note: It is assumed that the structure of the pallets information is not changing (as no format has been provided). If this is not the case, the estimate must be revisited. The system parameter "ALLOW_MULTIPLE_ADD_REFS" should be set to "Y" for the appropriate cost centre. The process will be modified to store the order references from FreightOrderId as order references against the template order - there could be many. The system must be configured to allow multiple order references. DHL AA system is already

Cost Details
Activity	Hours	Rate per hour (£)	Cost (£ Exc. VAT)
Requirements	0.00	152.00	£0.00
Change Request Evaluation	6.00	152.00	£912.00
Functional Specification	7.50	152.00	£1,140.00
Technical Specification	0.00	152.00	£0.00
Development	37.50	152.00	£5,700.00
Testing and Release	7.50	152.00	£1,140.00
Implementation	0.00	152.00	£0.00
Project Management	12.00	152.00	£1,824.00
TOTAL	70.50		£10,716.00

Estimate excludes training, release to live and go live support.

Copyright © Aptean 2025. This estimate has an expiry date of 30 days from the specified Estimate Date. The information contained herein is supplied without liability for errors or omissions.