Shipment Sourcing
Internal Table Name: ShipmentSourcing
Use this Transportation Optimization table to define sites that can be used as sources for shipments that have no source defined. Select the site (or site group/filter), the destination locations (individual or group/filter) that the site(s) can source, and whether or not the Site-Destination combination adheres to a single sourcing rule (only one source per destination). If a Source-Destination combination has Single Source = "Yes", all shipments with the specified destination must be sourced from a single site. Shipment Sourcing records are not used as constraints, rather they determine which sources are eligible to serve specific destinations.
Source
Technology: TO
Table: ShipmentSourcing
Internal Name: SourceName
Type: Short Text (100)
Select the site (or site group/filter) that can be used as a source for shipments that currently have no source populated.
Destination
Technology: TO
Table: ShipmentSourcing
Internal Name: Destination Name
Type: Short Text (100)
Select the location(s) that can use the Source for shipments that currently have no source populated. The value can be a customer, customer group/filter, site or site group/filter.
Single Sourcing
Technology: TO
Table: ShipmentSourcing
Internal Name: SingleSourcing
Type: Bit
One of Yes, No. (Actual database values are 1,0.)
This column determines whether the source-destination combinations defined by Source and Destination must adhere to a single sourcing rule. If the value is "Yes", destinations can only be sourced by one site as defined in the Source column. If this value is "No" destinations can be sourced by multiple sites as defined in the Source column. In the case that a Destination value is used in multiple records that vary in their Single Sourcing value, those destinations will have single sourcing applied across all sources. For example, assume the following records:
Source | Destination | Single Source |
---|---|---|
DC_Atlanta | CZ_Raleigh | No |
DC_Richmond | CZ_Raleigh | No |
DC_Knoxville | CZ_Raleigh | Yes |
In this case, CZ_Raleigh will be single sourced by one of the 3 DCs.
Status
Technology: TO
Table: ShipmentSourcing
Internal Name: ShipmentSourcingStatus
Type: Short Text (25)
One of Include, Exclude.
Choose the status for the shipment sourcing record:
-
Include - This shipment sourcing record will be included in an optimization run.
-
Exclude - This shipment sourcing record will be excluded from an optimization run.
Default: Include
Last modified: Wednesday May 15, 2024