Purchase Order Maintenance Items Grid Columns

In Purchase Order Maintenance, after items selected for an order are accepted, they are listed in the Items grid on the Items tab. The following table lists the columns in the Items grid.

Column Name

Description

Line #

This column displays an internal line number assigned to each line item entered in the order.

Product Code

This column displays the product code for each line item.

Qty Ordered

This column displays the purchase quantity for each line item.

U/M

This column displays the purchase unit of measure for each line item.

Unit Cost

This column displays the unit cost for each line item.

Cost Adj

This column displays any adjustments (positive or negative) to the cost of each line item.

Extended Cost

This column displays the extended cost for each line item. It is the unit cost plus or minus any cost adjustment, times the quantity ordered.

Required Date

This column displays the date each line item is required, which defaults from the Main tab.

Product Name

This column displays the corresponding name for a line item, which can be changed from the default product name.

Search Name

This column displays the product search name.

Supplier Prod Code

This column displays the supplier’s code for the product.

Category

This column displays the product's category for each line item.

Cost Source

This column displays the cost source for each line item. One of the following values appears in this column:

  • Product - The unit cost defaulted to the cost from the active purchase cost matrix for the product and supplier.

  • Cost Class - The unit cost defaulted to the cost from the active purchase cost matrix for the cost class of the product/location and supplier.

  • Last Cost - The unit cost defaulted to the unit cost for the last purchase order for the selected product and supplier (even if the product was not received).

  • Manual - The unit cost was manually entered.

  • Manual-VAT - The unit cost (including VAT) was manually entered.

Unit Ext. Cost

This column displays the unit cost for a line item with additional charges.

Charge Total

This column displays any additional charges associated with a line item.

Total Item Cost

This column displays the extended cost for each line item. It is the unit cost plus or minus any cost adjustment, plus additional charges, times the quantity ordered.

Unit Weight

This column displays the unit weight for a line item. A default unit weight and weight unit of measure is stored in the product record, or can be added or adjusted in P/O Line Item Entry.

Extended Weight

This column displays the total weight for a line item.

Net Landed Cost

This column displays the unit extended cost plus additional charges on a shipment.

Selling Net Landed Cost

This column displays the unit extended cost plus additional charges on a shipment (in the default sales unit of measure).

Style

This column displays the style associated with the product. For information on setting up styles, see Style Maintenance.

 

Color

This column displays the color associated with the product. For information on setting up colors, see Color Maintenance.

Size

This column displays the size associated with the product. For information on setting up sizes, see Size Maintenance.

Ship Date

This column displays the ship date for each line item, which defaults from the Main tab.

Qty Received

This column displays the quantity received for each line item.

Rcpt. Cmp

The check box in this column is selected for each line item for which receiving is complete.

Total Weight

This column displays the total weight for each line item.

Weight U/M

This column displays the weight unit of measure for a line item. A default unit weight and weight unit of measure is stored in the product record, or can be added or adjusted in PO Line Item Entry.

Unit Volume

This column displays the unit volume for each line item. A default unit volume is stored in the product record, or can be added/adjusted in PO Line Item Entry.

Total Volume

This column displays the total volume for each line item.

Delivery

This column displays the delivery date, which defaults from the Main tab; this date is used for DRP (expected date to be delivered and available for sale) and for the Available to Promise Inquiry.

Volume U/M

This column displays the volume unit of measure for each line item. A default volume unit of measure is stored in the product record, or can be added/adjusted in PO Line Item Entry.

Qty Invoiced

This column displays the quantity invoiced for each line item.

Inv. Cmp

The check box in this column is selected for each line item for which invoicing is complete.

Project Number

This column displays the project number for each line item, which defaults from the Main tab.

Freight Free

The check box in this column is selected if the freight is free for the line item.

Shipper ID

This column displays the shipper ID for each line item, which defaults from the Main tab.

FOB

This column displays the FOB terms for each line item.

Delivery Time

This column displays the delivery time for each line item.

Country of Origin

This column displays the country of origin for each line item. This defaults from the supplier product record, or if that is blank, from the supplier record, or if that is blank, from the product record.

Entered Cost

This column displays the cost generated by the system or manually entered for each line item.

VAT-Inclusive Cost

This column displays the cost of the product being ordered for each line item, including VAT. This column is only available if Show is selected for the VAT Display Level field in Tax Control Maintenance.

VAT Rate

This column displays the VAT percentage for each line item, which is the rate for the VAT class associated with the line item. This column is only available if Show is selected for the VAT Display Level field in Tax Control Maintenance.

VAT Class Code

This column displays the VAT class used to calculate VAT for each line item that is VAT taxable. This defaults from the first VAT class found in the following hierarchy:

  1. product/location

  2. product

  3. country

This column is only available if Show is selected for the VAT Display Level field in Tax Control Maintenance.

Sales Order #

This column displays the sales order number associated with each line item (if the line item is for a drop-ship order).

Sales Order Line #

This column displays the sales order line number associated with each line item (if the line item is for a drop-ship order).

Customer PO #

This column displays the customer purchase order number associated with each line item.

Store ID

This column displays the store ID associated with each line item.

Cancelled

The check box in this column is selected if the line item is cancelled. This column is only available if the Audit Amendments check box is selected in Purchasing Control Maintenance.

Cancelled Reason Code

This column displays the purchase order line cancellation reason code for each line item that was cancelled. This column is only available if the Audit Amendments check box is selected in Purchasing Control Maintenance.

Cancelled Remark

This column displays remarks for cancelled line items. This column is only available if the Audit Amendments check box is selected in Purchasing Control Maintenance.

Cancelled by

This column displays the user ID of the user that cancelled each line item that was cancelled. This column is only available if the Audit Amendments check box is selected in Purchasing Control Maintenance.

Cancelled Date

This column displays the date when each cancelled line item was cancelled. This column is only available if the Audit Amendments check box is selected in Purchasing Control Maintenance.

Cancelled Time

This column displays the time when each cancelled line item was cancelled. This column is only available if the Audit Amendments check box is selected in Purchasing Control Maintenance.

Sales Contract Code

This field displays the sales contract code associated with each line item. For information on setting up sales contracts, see Sales Contract Maintenance.

Sales Contract Stage ID

This column displays the sales contract stage ID if the line item is associated with a sales contract stage.

Sales Contract Line Number

This field displays a sales contract line number for each line item that is associated with a sales contract line number.

Product Duty Basis

This column displays the total product duty basis for each line item.

Charge Duty Basis

This column displays the total purchase additional charge duty basis for each line item. This includes charges set up to be included in the duty basis.

Open Qty

This column displays the quantity that is not in a container and not received for each line item.

Unrounded Extended VAT

This column displays the unrounded extended VAT amount for each line item.

Extended VAT

This column displays the extended VAT amount for each line item.

Unrounded VAT Amount

This column displays the unrounded VAT amount for each line item.

VAT Amount

This column displays the amount of VAT for each VAT-taxable line item, which is equal to the VAT rate of the product/location multiplied by the sum of the cost and cost adjustment. This column is only available if Show is selected for the VAT Display Level field in Tax Control Maintenance.