Adding new carriers to the Sterling Pierbridge Adaptor

Sterling Selling and Fulfillment Foundation can be easily configured to integrate with the Sterling Pierbridge Adaptor to support other carrier services.

About this task

Note: If you are performing an upgrade for an existing carrier that is not given as part of the factory setup, integration with the Sterling Pierbridge Adaptor will take place only after you perform the steps mentioned in the subsequent sections.

To add a new carrier to the Sterling Pierbridge Adaptor, perform the following steps:

Procedure

  1. From the YCS_GENERAL_CODES table, copy only those records that have the value of the CarrierAdapterImplKey column as PierbridgeAdaptor, and the Carrier Code can be any carrier.
  2. Insert all these records back into the YCS_GENERAL_CODES table, and change the Carrier Code to that of the new carrier that is to be added.

    The YCS_GENERAL_CODES table provides a translation of the Sterling Selling and Fulfillment Foundation XML attribute values to Pierbridge-specific values with respect to some of the attributes. Most of the attributes, such as Sunday Delivery Required, Residential Flag, and Consignee Country, are not specific to a particular carrier, and can be copied from any carrier. However, attributes such as Carrier Service Code are specific to each carrier, and such records must be modified with the appropriate AgileElite shipment server values.

  3. From the YFS_SCAC_ADAPTER_SUPPORT table, copy any record that has the value of the CarrierAdapterImplKey column as PierbridgeAdaptor, and the Carrier can be any carrier.
  4. Insert the record back into the YFS_SCAC_ADAPTER_SUPPORT table, and change the Carrier to that of the new carrier that is to be added.