Updated: 10/12/2009
Version: Control 4.4
Table Purpose, Usage, and Notes
The tracking information from Worldship and ShipManager can be (and usually is) exported into Cyrious Control. For security reasons, neither Worldship nor ShipManager are allowed to write directly to any of the Control database tables. A separate table is created that those applications write their information into. For UPS Worldship, this is that table.
Information on Table Data
The field names in this table are essentially all there is to the content of this table, the real functionality of this table is attained by using SQL triggers to update SQL Structure - TransHeaderUserField.
You can read more about how to set up UPS Shipping in setting_up_ups_worldship_integration.
Table Structure
~ Table.FieldName | ~ Data Type | ~ Description | ~ Links To | ||||
UPSShippingLog.OrderNumber | varchar(50) | ||||||
UPSShippingLog.ShipDate | varchar(50) | ||||||
UPSShippingLog.ShipperCharge | varchar(50) | ||||||
UPSShippingLog.TotalCharge | varchar(50) | ||||||
UPSShippingLog.TrackingNumber | varchar(50) | ||||||
UPSShippingLog.Weight | varchar(50) |
Related Tables
sql_structure_-_fedexshippinglog_table