Field Name

Description

Usage

ENTERED_ON

Entered Date

The date the PO Line was entered into the system.  This is a system maintained date.

REV_DATE

Revision Date

The date the PO line was last edited.  This is a date that is updated by the system whenever the PO line is manually edited.

ORD_DATE

Order Date

The date the PO line was issued.  Defaulted by the system to the current date.

REQ_DATE

Required Date

The date that the goods are required.  The required date in the purchase order header can be defaulted to a specified number of days beyond the current date using a 248 parameter, and this date is defaulted into each line item entered for the purchase order.  Normally this date is set to the current date.  The system does not update this date after the purchase order line has been saved.

EST_SHIP_DATE

Estimated Shipment Date

The date on which the vendor will ship the item. The estimated ship date is defaulted by the system during PO entry based upon the current date + the lead days in the QVL record, or the Purchasing Lead days in the Inventory record for the item, if a QVL record is not present for the item/vendor.  The estimated ship date calculated by the system can also be updated manually or by EDI.

EST_ARRIVAL

Estimated Arrival Date

The date that the goods are expected to arrive at the receiving dock. The estimated arrival date is automatically calculated by the system based on the estimated shipment date plus the transit days from the Shipvia record for the shipment method selected on the purchase order. The estimated arrival date is defaulted by the system whenever the estimated ship date is edited.  The value calculated by the system can also be updated manually or by EDI.

ACT_SHIP_DATE

Actual Shipment Date

The actual date the goods were shipped by the vendor.  This date is filled in either by the operator or automatically by EDI software.

REC_DATE

Receipt Date

The date the goods were received in the warehouse.  The receiving program fills in the receipt date as the purchase order line is received.

CAN_DATE

Cancel Date

The date on which the PO line should be canceled if the item has not been shipped by the vendor.  This field is defaulted based on the value of the system parameter F248: POCANDAY which is added to the order date.  The system does not automatically use this date.  It is used mainly for identifying stale purchase orders on reports.