Shipment

Contains the unique number identifying a specific shipment of goods within the system. This number will either be system generated or entered by the user.

Identifies the order number which relates to the goods delivered in the shipment.

This column will hold the bill of lading number associated with a shipment.

This column will hold the advance shipping notice number associated with a shipment.

This field contains the date the transfer or PO was shipped.

This field contains the date the transfer or PO is received.

This field contains the estimated arrival date of a vendor PO shipment. It is updated by EDIUP856. It is used for vendor/lead time analysis.

Indicates where the shipment was created in the system. Valid values for this field include: 0 - ASN Shipment 1 - Manual Shipment 2 - Autoship 3 - System 4 - System ASN 5 - System UCC-128 6 - ASN UCC-128.

Indicates the current status of the shipment. The valid values are: R - Received I - Input C - Cancelled E - Extracted V - Invoice Entered U - Unmatched (indicates a shipment w/ origin_code = 4 created in receipts upload process which has not been matched to either an electronically sent ASN or manually keyed ASN.

Status of the shipments invoice matching. Valid values are U for unmatched, P for partially matched, M for matched and C for closed (posted to AP or closed out by batch). This column will only be populated for PO shipments.

Date the shipment is completely matched to one or more invoices. This column will only be populated for PO shipments.

This field contains the location that the shipment will be delivered to.

This field indicates whether the to_loc value contains a Store, a Warehouse or an External Finisher. Valid values are S ,W and E.

For transfer and allocation shipments, this field will hold the location from which the shipment was sourced.

For transfer and allocation shipments, this field will hold the location type from which the shipment was sourced. This field indicates whether the from_loc value contains a Store, a Warehouse or an External Finisher. Valid values are S ,W and E.

Contains the courier that will deliver the shipment.

Contains the number of boxes associated with the shipment.

This field holds the transaction sequence number on the input file from the receiving PO or transfer process.

This field holds the transaction sequence number on the input file from the transfer shipment confirmation process.

Contains any miscellaneous comments about the shipment.

Shipment No of Parent shipment (Indicates that this is a Child Shipment). A Child shipment is created when an already matched shipment is updated with an adjustment quantity. The adjust quantity is created for the child shipment.

This identifies the importer/exporter assigned to the supplier. This will reference the WH.WH table and a foreign key created to reflect this.

Location type of the Bill_to_loc.

This contains a reference number for a document associated to the shipment (e.g. Fiscal Document ID for Brazilian based transactions)

This column holds the User id of the user who created the record.

This column holds the record creation date.

This column holds the last updated date of the record

This column holds the User id of the user who last updated the record.

The exchange rate used for the receipt posting between the PO and Location currencies on Approval/Transaction Date.