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|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]]