This database table stores the Metapack Consignments. It enables multiple Consignments to be stored per DO if an order is shipped over more than one day, or in other exceptional circumstances.
Table 12. The EPI_Consignments Oracle database table
Column Name |
Type |
Description |
---|---|---|
|
|
A unique key. Populated via an |
|
|
Consignment status:
|
|
|
Facility in which the LPN is packed. |
|
|
|
|
|
'DMC' Consignment reference number returned from Metapack Delivery Manager. |
|
|
Carrier ID |
|
|
Maps to the carrier 'service group' in Metapack Delivery Manager. |
|
|
Comma-delimited list of tracking codes. For a single oLPN Consignment, an example might be |
|
|
Determines whether or not the Consignment is international and requires a commercial invoice: ‘1’ = commercial invoice is required; ‘0’ = it is not required. |
|
|
End of day ID |
|
|
|
|
|
|