Table shipping_log

Table shipping_log holds the information regarding item shipped. Most of this information is used by shipping manager to track, and monitor shipments.

Table Type: InnoDB

Field Type Default Description
id int (11) NOT NULL PRIMARY KEY - Auto increment field to hold unique ID
shipment_id int(11) 0 Holds the id assigned to a given shipment.
ref_id int(11) 0 Holds the reference for this shipment. Links to purchase_invoice_id field in table journal_main.
reconciled 0, 1 0 Indicates whether the shipment has been reconciled with the freight bill from the shipping company.
carrier varchar(16) NULL This is the carrier code as setup in the services/shipping/modules/ directory.
method varchar(8) NULL This is the coded method. All modules use the same coding scheme to indicate the method the item was shipped.
ship_date date 0000-00-00 The date the item was shipped.
deliver_date date 0000-00-00 The date the item is expected to arrive.
actual_date date 0000-00-00 The date the item actually arrived.
tracking_id varchar(32) NULL The carreir tracking/bill of lading number.
cost float 0 The actual cost of the shipment.
notes varchar(255) NULL Any notes associated with the shipment.