View Full Version : Fields Reference for ShipRush for SQL Database

03-14-2012, 09:05 AM
Hello all,

For ShipRush for SQL Database (both FedEx and UPS), I can't find which value need to be passed from our host to ShipRush to select collect “Service” and “PaymentType”. The document below doesn’t show which value ShipRush needs.


For example, to select FedEx Standard Overnight, I don’t know if I need pass a value as “FedEx Standard Overnight”, “FedEx Standard Overnight®”, “Standard Overnight” or any other special code.

Is there any full list of values to select "Service" and "PaymentType"? I would like to get for both FedEx and UPS.

Thank you!

03-14-2012, 09:29 AM
Here's the list of Service Names that SR is expecting:

As far as PaymentType, your best option to seeing those values is to open a blank form for FedEx then UPS
Change the paymenttype
Click the little SR icon upper left, save current shipment to template
Save it to the desktop
Open that .zpk file in notepad
Locate this value: <ShipmentChgType>

That should be what ShipRush is expecting


03-14-2012, 04:04 PM
Thank you for information. Shipping Service works well!

However, I'm still having a problem with "PaymentType". According to the template file, FEDEX Payment Types are as follows.
Sender = 'PRE'
Recipient = 'CBS'
Third Party = 'TPB'

If I pass 'CBS' to the ShipRush, I get the error message, "'CBS' is not a valid integer value. Please correct field "Payment Type" and retry."

It looks like I need pass a Integer. Do you know which number?

Thank you!

03-15-2012, 06:34 AM
Let me see.

Sender = 0
Recipient = 1
Third Party = 3

If those work, please let me know so we can update the helpfile with valid options for that function.


03-15-2012, 09:26 AM
After my test, it looks like the followings.

0 = default (UPS:Prepaid, FedEx:Sender))
1 = Freigt Collect (UPS only. If I use it for FedEx it will be default (Sender))
2 = Recipient (FedEx only. If I use it for UPS it will be default (Prepaid))
3 = Third Party (UPS & FedEx)

Thank you for your advice!

03-15-2012, 09:32 AM
Thank you for the update. I will try and get this added to the helpfile.