ShipGear looks for key words or expected values in the QuickBooks field to determine a default value for the WorldShip field. The table below lists each field (under "WorldShipâ Field Name"). The next column (Raw Value Contains) contains the string or strings that must be contained in the financial system value; the Raw Value Contains column shows what the value must be equal to in order to get the resulting translated value (under "Default Translation"). The order of the rows in the table is the order in which rules are applied until a default is found.
|
WorldShipâ Field Name |
Raw Value Contains |
Default Translation |
|
Additional Handling (Select) |
"YES" or "TRUE" |
Y |
|
|
|
N |
|
Domestic Billing Option |
"CONS" |
Consignee Billed |
|
|
"COLL" or "REC" |
Freight Collect |
|
|
"3" or "THIRD" |
Bill to Third Party |
|
|
|
Prepaid |
|
International Billing Option |
"FOB" or "F.O.B" or "FREE ON BOARD" |
Free on Board |
|
|
"DUTY & TAX" or "SDT" or "DUTY AND TAX" or "SHIPPING" |
Shipping Duty & Tax |
|
|
"DUTY PAID" or "DDP" or "DELIVERY" |
Delivery Duty Paid |
|
|
"C&F" or "C AND F" or "COST AND" or "COST &" |
Cost and Freight |
|
|
"COLL" or "REC" |
Freight Collect |
|
|
|
Prepaid |
|
COD Cashiers Check Money Order Only (Select) |
"CASH" or "GUAR" |
Y |
|
|
"YES" or "TRUE" |
Y |
|
|
|
N |
|
Add Shipping Charges to COD Amount (Select) |
"YES" or "TRUE" |
Y |
|
|
|
N |
|
COD (Select) |
"COD" or "C.O.D" or "CASH ON D" |
Y |
|
|
"YES" or "TRUE" |
Y |
|
|
|
N |
|
Insured Value (Select) |
"YES" or "TRUE" |
Y |
|
|
|
N |
|
Delivery Confirmation (Select) |
"YES" or "TRUE" |
Y |
|
|
|
N |
|
Delivery Confirmation Signature Required (Select) |
"SIG" or "YES" or "TRUE" |
Y |
|
|
|
N |
|
Delivery Confirmation Adult Signature Required (Select) |
"ADULT" or "YES" or "TRUE" |
Y |
|
|
|
N |
|
Documents Only (Select) |
"YES" or "TRUE" |
Y |
|
|
|
N |
|
HAZMAT/DG (Select) |
"YES" or "TRUE" |
Y |
|
|
|
N |
|
Oversize (Select) |
("OS" or "OVER") and "2" |
2 |
|
|
("OS" or "OVER") |
1 |
|
|
|
None |
|
Package Quantum View Notify 1 Int'l Phone/Fax, Package Quantum View Notify 2 Int'l Phone/Fax, Shipment Quantum View Notify 1 Int'l Phone/Fax, Shipment Quantum View Notify 2 Int'l Phone/Fax |
"INT" |
Y |
|
Package Quantum View Notify 1 (Select), Package Quantum View Notify 2 (Select), Shipment Quantum View Notify 1 (Select), Shipment Quantum View Notify 2 (Select) |
"NOTIF" or "YES" or "TRUE" |
Y |
|
Package Quantum View Notify 1 (Select), Package Quantum View Notify 2 (Select), Shipment Quantum View Notify 1 (Select), Shipment Quantum View Notify 2 (Select) |
"FAX" |
Fax |
|
|
"EMAIL" |
|
|
Package Type |
"LTR" or "LET" |
UPS Letter |
|
|
"TUBE" |
UPS Tube |
|
|
"PAK" |
UPS Pak |
|
|
"BOX" |
UPS Express Box |
|
|
"25" |
UPS 25 KG Box |
|
|
"10" |
UPS 10 KG Box |
|
|
|
Package |
|
Return Service (Select) |
"RET" or "CT" or "CALL" or "YES" or "TRUE" |
Y |
|
|
|
N |
|
Return Service Type |
"PRINT" or "MAIL" |
Print and Mail |
|
|
"ONE" |
One Attempt |
|
|
"PRINT" |
Print Return Label |
|
|
"ELEC" |
Electronic Return Label |
|
|
|
Call Tag |
|
Saturday Delivery (Select), Saturday Pickup (Select) |
"SAT" or "YES" or "TRUE" |
Y |
|
|
|
N |
|
Domestic Service |
("RED" or "1" or "NEXT") and "SAV" |
Next Day Air Saver |
|
|
("RED" or "1" or "NEXT") and ("AM" or "A.M") |
Next Day Air Early AM |
|
|
"RED" or "1" or "NEXT |
Next Day Air |
|
|
"EARLY" |
Next Day Air Early AM |
|
|
("BLUE" or "2" or "SECOND") and ("AM" or "A.M") |
2nd Day Air AM |
|
|
"BLUE" or "2" or "SECOND" |
2nd Day Air |
|
|
"3" or "THREE" |
3 Day Select |
|
|
|
Ground |
|
International Service |
("AIR" or "EXPRESS" or "RED") and ("PLUS" or "+") |
WorldWide Express Plus |
|
|
"AIR" or "EXPRESS" or "RED" |
WorldWide Express |
|
|
"EXPEDITE" or "BLUE" |
Worldwide Expedited |
|
|
"STAN" or "STD" or "GROUND" |
Standard |
|
|
|
Worldwide Express |
|
Ship To Residential (Select) |
"RES" or "YES" or "TRUE" |
Y |
|
|
"COM" |
N |
|
|
|
N |
|
Verbal Confirmation (Select) |
"YES" or "TRUE" |
Y |
|
|
|
N |
|
Handling Charge (Select) |
"YES" or "TRUE" |
Y |
|
|
|
N |
|
Handling Charge Type |
"FLAT" |
Flat Rate |
|
|
|
Percentage |
|
Ship From Tax ID Type |
"SS" |
SSN |
|
|
"DUNS" |
DUNS |
|
|
|
EIN |