Shipping: Fields for Writing Ship Info (1 of 2)

This feature is part of the Shipping Add-On, which is an additional module that enables ODBC-capable programs, such as FedEx Ship Manager or UPS WorldShip, to retrieve data from Big Business Server and to write data back.

This Solution describes using Fields available in the SHIPINFO table for writing data to Big Business Server. (6074)

When using the Shipping Add-On to import shipment information from Big Business Server, you can also have the shipping system automatically update the Sales Order with Shipment Infomation. Here are descriptions of the Fields in the SHIPINFO table.

UID - a unique identifier that is automatically set; Do not map to this field; it will be overwritten.

ShipmentDescription - the Description in the Shipment Information on the Sales Order. Map Service (Overnight, Ground, etc.) level, etc., as needed for reference.

ShipmentID - the Tracking Number in the Shipment Information on the Sales Order. Map the (Lead) Tracking Number.

SO_Number - the Sales Order Number to be updated. Map the Sales Order Number, or the posted data will be lost.

SO_ReplaceOtherChgs - use this field to overwrite the Other Charges (i.e. Freight) Field on the Sales Order. Map the value that you want to carry forward to the invoice.

SO_AddOtherChgs - an alternative to "Replace" above, this field _adds_ the value that you map to the current Other Charges.

Related:

(Next) Shipping: Fields for Writing Ship Info (2 of 2)

  Chapter 25 Shipping

Return to Help