EPI Consignments Table

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

EPI_CONSIGNMENT_ID

NUMBER(10,0)

A unique key. Populated via an INSERT from the Oracle sequence EPI_CONSIGNMENT_ID_SEQ.

EPI_CONSIGNMENT_STATUS

NUMBER(2,0)

Consignment status:

  • 5 – Rate Shopped

  • 10 – Open

  • 20 – Pending Close

  • 30 – Marking Ready

  • 40 – Creating Manifest

  • 90 – Closed

  • 99 – Cancelled

FACILITY_ID

NUMBER(10,0)

Facility in which the LPN is packed.

ORDER_ID

NUMBER(10,0)

ORDER_ID of the associated DO.

DMC_NBR

VARCHAR2(50)

'DMC' Consignment reference number returned from Metapack Delivery Manager.

CARRIER_CODE

NUMBER(12,0)

Carrier ID

CARRIER_SERV_ID

VARCHAR2(50)

Maps to the carrier 'service group' in Metapack Delivery Manager.

TRACKING_NUMBERS

VARCHAR2(2000)

Comma-delimited list of tracking codes.

For a single oLPN Consignment, an example might be 5820198234575317. For a multi-oLPN, it might be 5820198234575317, 5820198234575318 after the second oLPN was packed.

IS_CUSTOMDOC_REQ

VARCHAR2(1)

Determines whether or not the Consignment is international and requires a commercial invoice: ‘1’ = commercial invoice is required; ‘0’ = it is not required.

EPI_END_OF_DAY_ID

VARCHAR2(100)

End of day ID

CREATED_DTTM

TIMESTAMP(6)

SYSDATE on which the Consignment was first added.

LAST_UPDATED_DTTM

TIMESTAMP(6)

SYSDATE on which the Consignment was last updated.