This article describes the overall process used by Cyrious to integrate shipping with Fed Ex. It expands on the [[:how_the_shipping_integration_works|]] article.

Using UDFs (Drop Ship option turned OFF / not enabled)

  - In Fed Ex, the order information is pulled from Control's database using the **ShipperInfo**  / **FedExShipperInfo**  view.
  - Once the shipment is processed, FedEx updates the **ShippingLog**  / **FedExShippingLog**  table with the processed information.
  - The database trigger **UpdateFedExUDF**  is fired when the S**hippingLog**  / **FedExShippingLog**  table is updated. The trigger updates the order UDF field values (stored in the **TransHeaderUserField**  table). View the table below for the all the fields that are updated.
  - **In Control, the order is opened and displays the changes made to the UDFs. **
**UDF Field Update (Drop Ship not enabled)**** **

This table shows the fields in the TransHeaderUserField database table that are updated after a shipment is processed through FedEx.

|**Field Name** |**Field Updated From** |
|TransHeaderUserField.FedEx_Actual_Price|ShippingLog.ActualPrice|
|TransHeaderUserField.FedEx_List_Price|ShippingLog.ListPrice|
|TransHeaderUserField.FedEx_Package_Weight|ShippingLog.Weight|
|TransHeaderUserField.FedEx_Shipment_Date|ShippingLog.ShipDate|
|TransHeaderUserField.FedEx_Tracking_Number|ShippingLog.TrackingNumber|

**Using UDFs (Drop Ship option turned ON)**

  - In Control, the Drop Ship option is checked and the ship to information is filled in and saved.
  - **In Fed Ex, the order and ship to information is pulled from Control's database using the **FedExShipperInfo** view.**
  - **Once the shipment is processed, FedEx updates the **FedExShippingLog** table with the processed information.**
  - **The database trigger **UpdateFedExUDF** is fired when the **FedExShippingLog** table is updated. The trigger updates the order UDF field values (stored in the **TransHeaderUserField** table). View the table below for the all the fields that are updated.**
  - In Control, the order is opened and displays the changes made to the UDFs.

**UDF Field Update (Drop Ship ON)** \\ This table shows the fields in the **TransHeaderUserField**  database table that are updated after a shipment is processed through FedEx.

|**Field Name** ||**Field Updated From** ||
|TransHeaderUserField.FedEx_Actual_Price||FedExShippingLog.ActualPrice||
|TransHeaderUserField.FedEx_List_Price||FedExShippingLog.ListPrice||
|TransHeaderUserField.FedEx_Package_Weight||FedExShippingLog.Weight||
|TransHeaderUserField.FedEx_Shipment_Date||FedExShippingLog.ShipDate||
|TransHeaderUserField.FedEx_Tracking_Number||FedExShippingLog.TrackingNumber||

**Using Shipment Items (Shipping Tab in Order Entry)**

  - In Control, a shipment item is created in the **Shipping Tab**  and the shipping information is filled in and saved.
  - In Fed Ex, the shipment information is pulled from Control's database using the **ShipperInfoForShipments**  view. The Look up Value can either be the shipment number or the order number.
  - Once the shipment is processed, FedEx updates the **FedExShippingLogForShipments**  table with the processed information. The database trigger **UpdateFedExShipment**  is automatically fired after this update.
  - The database trigger **UpdateFedExShipment**  updates the shipment field values (stored in the **Shipments**  table). View the table below for the all the fields that are updated.
  - **In Control, the order is opened and displays the changes made to the shipments. **
**Shipment Item Field Update**

 \\ This table shows the fields in the Shipments database table that are updated after a shipment is processed through FedEx.

|**Field Name** |**Field Updated From** |
|Shipments.ActualCost|FedExShippingLogForShipments.ActualPrice|
|Shipments.CarrierID|ShippingMethod.ID|
|Shipments.CarrierClassTypeID|ShippingMethod.ClassTypeID|
|Shipments.CarrierService|FedExShippingLogForShipments.ServiceType|
|Shipments.EstimatedCost|FedExShippingLogForShipments.ListPrice|
|Shipments.InsuredValue|FedExShippingLogForShipments.DeclaredValue|
|Shipments.IsShipped|Automatically set to TRUE|
|Shipments.Notes|FedExShippingLogForShipments.DeliveryInstructions|
|Shipments.NumberOfPackages|FedExShippingLogForShipments.NumberOfPackages|
|Shipments.PackageSize|FedExShippingLogForShipments.PackageType|
|Shipments.PackageWeight|FedExShippingLogForShipments.Weight|
|Shipments.ShipDate|FedExShippingLogForShipments.ShipDate|
|Shipments.TrackingNumber|FedExShippingLogForShipments.TrackingNumber|

FedEx updates the database directly and since there is no method to inform Control of the change, the order will not reflect the change if it being displayed during the FedEx processing. The display of the order must be closed and reopened for the changes to reflect.

Links

[[:include_componentbacklinks_pagefedex_integration_process_limit10|include component"backlinks" page"FedEx Integration Process" limit"10"]]

\\