Value Translation Rules

 

These are implemented rules that check the current field's value for compatibility with all the field values above it. If it is not compatible, ShipGear changes it to a compatible value.

 

WorldShipâ Field Name

Rule

Message

Ship To Country

Determine meaning of country for subsequent rules (case independent):

if blank or "USA" or "UNITED STATES" or "U.S." or "US" or "U.S.A." then is domestic.

if "CANADA" or "CA" then is a Canadian destination.

Otherwise, it is an International destination.

 

Additional Handling (Select)

If ShipToCountry is Canada or International then set to "N"

Additional Handling only applies to domestic shipments

 

If PackageType <> "Package" then set to "N"

Additional Handling does not apply to UPS supplied packaging

Domestic Billing Option

If ShipToCountry is Canada or International then set to "N/A"

Not applicable for international shipments.

International Billing Option

If ShipToCountry is Domestic then set to "N/A"

Not applicable for domestic shipments.

COD Cashiers Check Money Order Only (Select)

If CODOption is "N" then set to "N"

COD Option must be "Y".

COD (Select)

If CODGuaranteedIndicator is "Y" then set to "Y"

Must be "Y" when COD Guaranteed is "Y"

Delivery Confirmation (Select)

If ShipToCountry is Canada or International, set to "N"

Not allowed for international shipments.

 

If ReturnServiceOption is "Y", set to "N"

Not allowed with Return Service Option = "Y"

 

if DeliveryConfirmationAdultSignatureRequired or DeliveryConfirmationSignatureRequired is "Y", set then this must be set.

The Adult Signature and Signature work in tandem with this flag.

 

If CODOption = "Y", and DeliveryConfirmationAdultSignatureRequired is "N", set to "N"

Only Adult allowed with COD shipments.

 

If ServiceType_Domestic = "Next Day Air Early AM", set to "N"

Not allowed with "NEXT DAY EARLY AM

 

If DeliveryConfirmationSignatureRequired = "Y", set to "Y"

Must set option flag if Delivery Confirmation Signature Required is "Y"

Delivery Confirmation Signature Required (Select)

If DeliveryConfirmationOption = "N", set to "N"

Not applicable if Delivery Confirmation Option flag is "N"

 

If ShipToCountry is Canada or International, set to "N"

Not allowed for international shipments

 

If ReturnServiceOption is "Y", set to "N"

Not allowed with Return Service Option = "Y"

 

If CODOption = "Y", set to "N"

Not allowed with COD shipments.

 

If ServiceType_Domestic = "Next Day Air Early AM", set to "N"

Not allowed with NEXT DAY EARLY AM

Delivery Confirmation Adult Signature Required (Select)

If DeliveryConfirmationOption = "N", set to "N"

Not applicable if Delivery Confirmation Option flag is "N"

 

If ShipToCountry is Canada or International, set to "N"

Not allowed for international shipments

 

If ReturnServiceOption is "Y", set to "N"

Not allowed with Return Service Option = "Y"

 

If DeliveryConfirmationOption = "Y" and CODOption = "Y", set to "Y"

Not allowed with COD shipments.

 

If ServiceType_Domestic = "Next Day Air Early AM", set to "N"

Not allowed with NEXT DAY EARLY AM

Documents Only (Select)

If ShipToCountry is domestic, set to "N"

Not applicable for domestic shipments.

HAZMAT/DG (Select)

If ShipToCountry is Canada or International, set to "N"

Not allowed for international shipments.

Insured Value (Select)

If Insured Value Amount is mapped and is 0.0, set to "N".

(if not mapped, user may want to use default Insured Value Amount in WorldShipâ)"

Insured Value Amount must be greater than 0.

Oversize (Select)

If PackageType <> "Package", set to "None"

Not applicable for current Package Type.

 

If ShipToCountry is domestic and ServiceType_Domestic <> "Ground", set to "None"

Only applicable for Ground service.

 

If ShipToCountry is Canada and ServiceType_Domestic <> "Standard", set to "None"

Only applicable for Standard service to Canada

Package Quantum View Notify 1 (Select)

If PackageShipNotification1Type = "Email" and PackageShipNotification1FaxEmail_Email is blank, set to "N".

Email address is blank

Package Quantum View Notify 2 (Select)

If PackageShipNotification2Type = "Email" and PackageShipNotification2FaxEmail_Email is blank, set to "N".

Email address is blank

Shipment Quantum View Notify 1 (Select)

If ShipmentShipNotification1Type = "Email" and ShipmentShipNotification1FaxEmail_Email is blank, set to "N".

Email address is blank

Shipment Quantum View Notify 2 (Select)

If ShipmentShipNotification2Type = "Email" and ShipmentShipNotification2FaxEmail_Email is blank, set to "N".

Email address is blank

Ship To Attention

If ShipToCompany is blank and ShipToAttention is not blank, move ShipToAttention value to ShipToCompany and clear ShipToAttention.

Ship To Attention to Ship To Company/Name

Ship To Company or Name

If ShipToCompany is blank and ShipToAttention is not blank, move ShipToAttention value to ShipToCompany and clear ShipToAttention.

Ship To Attention to Ship To Company/Name

Package Type

If OversizeIndicator = "Y", set to "Package"

Cannot be Oversize with package type xxx

 

If AdditionalHandlingOption = "Y", set to "Package"

Cannot have Additional Handling with package type xxx

 

If ServiceType_Domestic is "Ground", set to "Package"

Package type must be "Package" for Ground service

 

If ServiceType_Domestic is "3 Day Select", set to "Package"

Package type must be "Package" for 3 Day Select service

 

If ServiceType_International is "Expedited", set to "Package"

Package type must be "Package" for international Expedited service

 

If ServiceType_International is "Standard", set to "Package"

Package type must be "Package" for international Standard service.

 

If value is "UPS Tube" or "UPS Express Box" and ServiceType_Domestic is not one of: "Next Day Air Saver" or "Next Day Early AM" or "Next Day Air", set to "Package"

Package type xxx only allowed for Next Day services.

 

If value is "UPS 25 KG Box" or "UPS 10 KG Box" and ServiceType_International is not one of: "WorldWide Express" or "WorldWide Express Plus" then set to "Package"

Package type xxx only allowed for international Express services.

Return Service (Select)

If ShipToCountry is Canada or International then set to "N"

Not allowed for international shipments.

 

If BillingOption_Domestic is "Freight Collect", set to "N"

Return service option not allowed when billing is Freight Collect

 

If ServiceType_Domestic is one of "2nd Day Air AM", "Next Day Air Saver", or "Next Day Air Early AM", set to "N"

Return service option not allowed with service xxx.

Saturday Pickup (Select)

If ShipToCountry is Canada or International then set to "N"

Not allowed for international shipments

 

If ServiceType_Domestic is"Ground" or "3 Day Select ", set to "N"

Not allowed for service type of Ground or 3 Day Select

Saturday Delivery (Select)

If ServiceType_Domestic is not "Next Day Air" or "Next Day Air Early AM", set to "N"

Saturday delivery option only allowed with Next Day Air and Next Day Air Early AM services.

 

If ServiceType_International is not "WorldWide Express", set to "N"

Saturday delivery option only allowed with WorldWide Express service.

Domestic Service

If ShipToCountry is Canada or International, set to "N/A"

Not applicable for international shipments.

 

If SaturdayDeliveryOption = "Y" and not "Next Day Air" or "Next Day Air Early AM", set to "Next Day Air".

Only "Next Day Air" or "Next Day Air AM" allowed for Saturday Delivery.

 

If ShipToResidentialIndicator = "Y" and value is "2nd Day Air AM", set to "2nd Day Air"

2nd Day Air AM service not allowed to residential addresses.

 

If PackageType is "Letter" or "UPS Pak" and value is "Ground" or "3 Day Select", set to "2nd Day Air".

Package type xxx not allowed for yyy service.

 

If PackageType is "UPS Tube" or "UPS Express Box" and value is "Ground" or "3 Day Select" or "2nd Day Air" or "2nd Day Air AM", set to "Next Day Air"

Package type xxx not allowed for yyy service.

 

If DeliveryConfirmationOption = "Y" and value is "Next Day Air Early AM", set to "Next Day Air".

Next Day Air Early AM not allowed with Delivery Confirmation

 

if VerbalConfirmationOption = "Y", set to "Next Day Air Early AM"

Verbal Confirmation only applies to Next Day Air Early AM service.

International Service

If ShipToCountry is domestic, set to "N/A"

Not applicable for domestic shipments.

 

if PackageType <> "Package" and value is "Expedited" or "Standard", set to "WorldWide Express"

Package type xxx not allowed for yyy service.

Ship To Residential (Select)

If ServiceType_Domestic is "2nd Day Air AM", set to "N"

Residential not allowed with 2nd Day Air AM service

Verbal Confirmation (Select)

If ShipToCountry is Canada or International then set to "N"

Not applicable for international shipments.

 

If ServiceType_Domestic is not "Next Day Air Early AM", set to "N"

Only applies to Next Day Air Early AM service