Pallet Rounding Rules using External Mappings

The following table describes how to define Pallet Rounding Rules for a specific location using External Mappings. Pallet Rounding Rules are used by the Transport Order Consolidation job type when creating a Shipment from a Transport Order Consolidation Group with an estimated pallet count.

The format of the Field Value is: minPallet,roundingFactor,minPallet2,roundingFactor2;...

Each rule specifies the minimum estimated pallet count to which it applies and a rounding factor. If the fractional portion of the estimated pallet amount is above the rounding factor, the pallet amount will be rounded up, otherwise it will be rounded down.

Entity Type	Entity Source	TM Entity ID	Field Name	Field Value
Shipping Location	Default	Provide the necessary TM Shipping Location ID in the Entity ID field for which you want to specify Pallet Rounding Rules.	PalletRoundingRules	Example: 0,.0,3,.1,5,.2 The above value defines that pallet counts between [0,3) should always be rounded up, pallet counts between [3,5) should be rounded down if the decimal portion is less than .1 and should be rounded up if the decimal portion is greater than .1, and pallet counts above 5 should be rounded down if the decimal portion is less than .2 and should be rounded up if the decimal portion is greater than .2. All values are numbers. Each number is separated by a comma. The odd indexed numbers are the pallet counts (0, 3, 5 in the example). These must be increasing in magnitude. The even indexed numbers are the rounding factors (.0, .1, .2 in the example). These must be in the range [0,1)

Entity Type

Entity Source

TM Entity ID

Field Name

Field Value

Shipping Location

Default

Provide the necessary TM Shipping Location ID in the Entity ID field for which you want to specify Pallet Rounding Rules.

PalletRoundingRules

Example:

0,.0,3,.1,5,.2

The above value defines that pallet counts between [0,3) should always be rounded up, pallet counts between [3,5) should be rounded down if the decimal portion is less than .1 and should be rounded up if the decimal portion is greater than .1, and pallet counts above 5 should be rounded down if the decimal portion is less than .2 and should be rounded up if the decimal portion is greater than .2.

All values are numbers. Each number is separated by a comma.

The odd indexed numbers are the pallet counts (0, 3, 5 in the example). These must be increasing in magnitude.

The even indexed numbers are the rounding factors (.0, .1, .2 in the example). These must be in the range [0,1)