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