Field

Description

Order #

A unique number assigned by the system to identify an order.

Enter a valid order number to advance to the Work with Order Detail Reservations Screen. If you enter an invalid order number, you advance to the Scan by Order Number screen.

Numeric, 8 positions; optional.

Customer class

A code to identify a group of customers. You may direct offers to specific classes of customers or generate lists by customer class code. Enter a valid code to advance to the Scan Orders by Customer Class Screen.

Customer class codes are defined in and validated against the Customer Class file; see Customer Service Chapter 17: Setting Up the Customer Class File (WCCL).

Alphanumeric, 2 positions; optional.

Item/SKU

The code that represents the item/SKU. Enter a valid code (both item and SKU) to advance to the Work with Reservations by Item/SKU Screen.

Item: alphanumeric, 12 positions; optional.

SKU: alphanumeric, one 14 position field (full SKU) or three 4 position fields (split SKU); optional.

Field

Description

Shp (Ship to number)

A system-assigned number that represents the number of shipping addresses for the order.

Numeric, 3 positions; display-only.

Ln# (Line number)

A system-assigned detail line number on the order.

Numeric, 3 positions; display-only.

Item

A code used to identify a unit of inventory.

Alphanumeric, 12 positions; display-only.

COLR SIZE OTHR

A code used to further define the item.

Alphanumeric, one 14-position field (full SKU) or three 4-position fields (split SKU); display-only.

Qty avail (Quantity available)

The quantity of the item that is available to sell in this warehouse. A negative number indicates the item is backordered.

The calculation for availability is: On hand quantity - Quantity reserved - Quantity protected - Pending transfers - Backordered quantity

This value takes into account only reservable locations.

Numeric, 7 positions; display-only.

Qty prot (Quantity protected)

The quantity of the item that can be reserved only through Interactive Reservation where inventory is dispersed manually, as in the case of large wholesale orders or preferred mail order customers.

The system uses this field to reserve the component items on a finished good work order if Use Work Order Processing (E37) is set to Y in the System Control file. See Warehousing Finished Good Work Order Processing (WWOR) for more information on work orders.

Numeric, 5 positions; display-only.

Qty open (Quantity open)

The total number of units that have not shipped.

Numeric, 5 positions; optional.

Qty rsrvd (Quantity reserved)

The quantity of the item that is set aside for existing orders. This field increases by immediate, batch, and interactive reservation and decreases by confirmation or pick void/reprint.

Numeric, 5 positions; optional.

Qty to reserve

The number of units of the item that you want to reserve for this order.

Numeric, 5 positions; required.

Field

Description

Order

A unique number assigned by the system to identify an order. Every order on the system is assigned an order number.

Numeric, 8 positions; display-only.

Ship-to number (Unlabeled field to the right of the order number)

A hyphen (-) separates this field from the Order # field. This value indicates the number of shipping addresses for the order. The system assigns a sequential ship-to number to every order. The first ship-to address is assigned the number 1.

Numeric, 3 positions; display-only.

Line number (Unlabeled field to the right of the ship-to number)

A hyphen (-) separates this field from the Ship-to field. The line number on the order. Up to 999 detail lines may be entered on an order. Order lines are presented in descending sequence so that the most recent order line displays first.

Numeric, 3 positions; display-only.

Status

The status of the order detail line.

Valid values:

• B = Express Bill

• C = Canceled

• E = Error

• H = Held

• S = Sold out

• X = Closed

• Blank = Open

Alphanumeric, 1 position; display-only.

Item

A code and description of the unit of inventory on an order detail line. If a SKUed item is displayed, the SKU information will also appear.

Alphanumeric, 12 positions; display-only.

Override warehouse

The code and description of the warehouse that supersedes the default warehouse, defined in the System Control file.

Numeric, 3 positions; display-only.

Backorder warehouse

The code and description of the warehouse that the order detail line was backordered from.

Numeric, 3 positions; display-only.

Backorder date

The date when the order detail line was printed on the backorder notification form. This form is sent to a customer when an order detail line is delayed in shipping.

Numeric, 6 positions; display-only.

Backorder reason

The reason an order detail line was backordered.

Alphanumeric, 25 positions; display-only.

Bypass reservation

A code which indicates whether the item is flagged to bypass reservation in order entry.

Y = The item is flagged to bypass reservation in order entry.

N = The item is not flagged to bypass reservation in order entry.

Alphanumeric, 1 position; display-only.

Drop ship flag

This value indicates whether this item is an item that you typically do not stock in inventory; drop ship items must be ordered and shipped from your supplier (vendor).

These types of items are not generally available for Reservation. Orders with drop ship items will print a separate pick slip for forwarding to the vendor.

Additionally, drop ship items must be billed via a special drop ship billing program (because the vendor must notify you when the items have shipped so that you do not bill the customer before the merchandise is received).

D = Drop ship item

Blank = Regular item

Alphanumeric, 1 position; display-only.

Future order

Y = Indicates that this is a future order.

N (or blank) = Indicates that this is a current order.

How the system evaluates future orders:

1) The system adds today's date and the Reservation Lead Days (B27) (in the System Control file) and compares this value against the Arrival date on the order.

If the result is greater than the Arrival Date, the system:

• Considers the order to be a future order and inventory will not be reserved.

• Flags each detail line on a future order for future reservation.

2) Typically, you run the Evaluate Future Orders program each evening to evaluate each order detail line marked as a “future order.” The system adds today's date to the Reservation Lead Days value and compares the result against the order's Arrival Date. This comparison determines when inventory can be reserved for a future order. When the result is less than or equal to the Arrival Date, the “future order” flag will be removed from each detail line on the order and each line will be eligible for reservation.

Alphanumeric, 1 position; display-only.

Expected ship date

The date on which a purchase order that can fulfill this order line is expected. This date takes into account PO layering, where previously-backordered items will be fulfilled from new PO receipts, prior to new backordered lines. See Determining the Expected Ship Date.

System calculated date? The system calculates the expected ship date for backordered items that are not on any open purchase orders if the Calculate Expected Date in OE if No PO (J61) system control value is set to Y. The calculation updates the order detail record by adding the FTC -- # of Days for Items without Expected Ship Date (C71) system control value when you first add the item to the order, and again each time you run batch PO layering. See the Calculate Expected Date in OE if No PO (J61) system control value for a discussion.

Numeric, 6 positions (MMDDYY format); display-only.

Reserve date/time

The date and time that inventory was matched to this order detail line.

Numeric, 6 positions (MMDDYY, HHMMSS format); display-only.

Ordered

The number of units of this item on the order detail line.

Numeric, 5 positions; display-only.

Reserved

The number of units of the item reserved during the Reservation program. This program reserves stock for specific orders. Quantities may or may not have picks generated for them.

Numeric, 5 positions; display-only.

Printed

The number of units of the item, on this order detail line, for which pick slips have been produced.

Numeric, 5 positions; display-only.

Shipped

The quantity on this order detail line that has been shipped.

Numeric, 5 positions; display-only.

Canceled

The quantity on this order detail line that has been canceled.

Numeric, 5 positions; display-only.

Returned

The quantity on this order detail line that has been returned.

Numeric, 5 positions; display-only.

Sold out

The quantity on this order detail line that has been sold out.

Numeric, 5 positions; display-only.

Field

Description

Order

A unique number assigned by the system to identify an order. Every order on the system is assigned an order number.

Numeric, 8 positions; display-only.

Ship-to number (Unlabeled field to the right of the order number)

A hyphen (-) separates this field from the Order # field. This value indicates the number of shipping addresses for the order. The system assigns a sequential ship-to number to every order. The first ship-to address is assigned the number 1.

Numeric, 3 positions; display-only.

Line number (Unlabeled field to the right of the ship-to number)

A hyphen (-) separates this field from the Ship-to number. The line number on the order. Up to 999 detail lines may be entered on an order. Order lines are presented in descending sequence so that the most recent order line displays first.

Numeric, 3 positions; display-only.

Qty open (Quantity open)

The total number of units that have not been shipped. This includes quantity on backorder and quantity held. Future shipments and drop ships are not included in this number.

Numeric, 5 positions; display-only.

Qty rsrved (Quantity reserved)

The quantity of the item that is set aside for existing orders. This value increases by immediate, batch, or interactive reservation and decreases by confirmation or pick void/reprint.

Numeric, 5 positions; display-only.

Sold to

The name of the customer who placed the order. Validated against the Customer Sold-to file.

Alphanumeric, 15 positions (first name), 1 position (initial), 25 positions (last name); display-only.

Item

A code and description of the unit of inventory on an order detail line. If a SKUed item is displayed, the SKU information will also appear. Validated against the Item file.

Alphanumeric, 12 positions; display-only.

Whs (Warehouse)

A code for a warehouse that is associated with inventory for the item/SKU.

Warehouses associated with item/warehouse records for the item display on this screen. However, if the item is associated with a non-allocatable warehouse, the system only displays the non-allocatable warehouse if it is associated with the order type on the order; otherwise item/warehouse records for a non-allocatable warehouse do not display on this screen.

Warehouse codes are defined in and validated against the Warehouse file; see Warehousing Chapter 41: Creating and Maintaining Warehouses (WWHS).

Numeric, 3 positions; optional.

Warehouse name

A description of the default warehouse.

Alphanumeric, 12 positions; display-only.

Quantity available

The quantity of the item that is available to sell. A negative number indicates the item is backordered.

Numeric, 7 positions; display-only.

Quantity protected

The quantity of the item that can be reserved only through Interactive Reservation where inventory is dispersed manually, as in the case of large wholesale orders or preferred mail order customers.

The system uses this field to reserve the component items on a finished good work order if Use Work Order Processing (E37) is set to Y in the System Control file. See Warehousing Finished Good Work Order Processing (WWOR).

Numeric, 5 positions; display-only.

Qty to reserve (Quantity to reserve)

The number of units of this item that are to be reserved for this order.

Numeric, 5 positions; required.

Field

Description

Warehouse

A code that represents the default warehouse.

Numeric, 3 positions; display-only.

Item

A code and description of the unit of inventory on the order detail line. If a SKUed item is displayed, the SKU information will also appear.

Item: alphanumeric, 12 positions; display-only.

SKU: alphanumeric, 14 positions (full SKU), or three 4-position fields (split SKU); display-only.

Description: Alphanumeric, 30 positions, display-only.

Location

A user-defined code that represents a warehouse location where merchandise is stored. The warehouse location code can consists of a zone/aisle/shelf/bin combination, or it can be any user-defined code. The location code prints on picks slips and reports.

Example: The location A010201 indicates:

Zone Aisle Shelf Bin

A 01 02 01

See Warehousing Chapter 43: Creating and Maintaining Locations (WLOC).

Alphanumeric, 7 positions; display-only.

On hand

The actual on hand quantity for the item in this warehouse location.

Numeric, 7 positions; display-only.

Printed

The number of units currently “allocated” for this item in this warehouse location, determined by the number of picks generated for this location.

When determining locations to reserve during Reservation, the printed quantity is subtracted from the on hand quantity in this location to determine the quantity available for Reservation.

Numeric, 7 positions; display-only.

Field

Description

Item

The item code.

Alphanumeric, 12 positions; display-only.

SKU

A code that further identifies the item.

Alphanumeric, one 14 position field (full SKU) or three 4-position fields (split SKU); display-only.

Warehouse

The code and description of the default warehouse.

Numeric, 3 positions; display-only.

Reservation freeze

This value indicates whether the item or SKU in this warehouse is frozen. Valid values are:

Y = The item/SKU warehouse is frozen.

N = The item/SKU warehouse is not frozen.

If an item or SKU warehouse is frozen:

• Pick Slip Generation will ignore the item warehouse when determining where inventory should be picked to fulfill an order. See Introducing Pick Slip Generation.

• Inventory will not reserve during Order Entry. See Reviewing Reservation Types.

• Replenish Warehouses and Replenish Primary Locations will not replenish stock to or from the locations.

Alphanumeric, 1 position; display-only.

Economic order qty

The optimum ordering quantity for this item/SKU, based on a set of criteria such as: quantity, cost, etc. This value is used for inventory reporting purposes and by Purchasing.

Numeric, 7 positions; display-only.

Backorder qty

The quantity of the item needed to fill existing orders, which must be fulfilled through PO receipts.

Numeric, 7 positions; display-only.

Protected qty

The quantity of the item that can be reserved only through Interactive Reservation where inventory is dispersed manually, as in the case of large wholesale orders or preferred mail order customers.

The system uses this field to reserve the component items on a finished good work order if Use Work Order Processing (E37) is set to Y in the System Control file. See Warehousing Finished Good Work Order Processing (WWOR).

Numeric, 5 positions; display-only.

Min qty

The minimum on hand quantity for the item/SKU in this warehouse. This value is used to determine when the item should be re-ordered and by the Autostock Replenishment Program to determine when inventory should be transferred from one warehouse to another. See Warehousing Chapter 60: Creating a Warehouse Replenishment Request.

Numeric, 7 positions; display-only.

Reorder qty

The quantity of the item that should be ordered when inventory reaches the minimum stock level (defined in the Min Qty field). This value is used by Warehouse Replenishment.

Numeric, 7 positions; display-only.

Max qty

The maximum on hand quantity for the item/SKU in this warehouse. This value is used to determine when the item should be re-ordered and by the Autostock Replenishment Program to determine when inventory should be transferred from one warehouse to another.

Numeric, 7 positions; display-only.

Reserve qty

The quantity of the item/SKU that is set aside for existing orders. This value increases by immediate, batch, or interactive reservation and decreases by confirmation or pick void/reprint.

Numeric, 7 positions; display-only.

On hand qty

The actual on hand quantity for the item in this warehouse location.

Numeric, 7 positions; display-only.

S/H reserve qty

The quantity of this item in this warehouse that has been reserved and is undergoing some type of special handling, such as monogramming, hemming, etc.

This value is increased by the Reservation program. Items that are flagged with a special handling code in Order Entry or Order Maintenance increment this field following reservation. This value is decreased by Confirmation or Pick Void/Reprint.

Numeric, 7 positions; display-only.

On order qty

The quantity of this item due to be received in this warehouse through purchase orders. This value is increased by PO Entry and is decreased by PO Receiving.

This information helps the customer decide whether to order now or to cancel the order because of inventory unavailability.

Numeric, 7 positions; display-only.

Reserve transfer quantity

The quantity of the item that is earmarked for an inventory transfer as a result of the Autostock Replenishment by Warehouse program. This quantity cannot be used by the Reservation program to match inventory to new orders. See Warehousing Chapter 60: Creating a Warehouse Replenishment Request.

Numeric, 7 positions; display-only.

Cost of goods

This value represents the vendor cost at which this item in this warehouse was purchased. The cost of the item is updated when the item is confirmed for shipment. This value is used in item profitability analyses.

Numeric, 11 positions with a 2-place decimal; display-only.

Picks generated

The total number of pick slips generated for this item in this warehouse, life-to-date.

Numeric, 7 positions; display-only.

Dollars returned

The dollar value of all returns that have been entered to date for this item in this warehouse. This field is updated by the Return Authorization process when the return is accepted. This field is updated with the actual dollars returned based on the amount charged when the item was shipped.

Numeric, 11 positions with a 2-place decimal; display-only.

Units returned

The number of units of this item in this warehouse returned to date. This value is updated by the Return Authorization process when returns are entered and updated.

Numeric, 11 positions with a 2-place decimal; display-only.

Dollars sold

The actual dollars sold (shipped and billed) for this item/SKU to date. This field is updated with the actual merchandise dollars billed on the shipment, during Billing.

Numeric, 11 positions with a 2-place decimal; display-only.

Units sold

The number of sales for this item/SKU in this warehouse to date. This field is updated during Billing.

Numeric, 11 positions with a 2-place decimal; display-only.

Field

Description

Order

A unique number assigned by the system to identify an order. Every order on the system is assigned an order number.

Numeric, 8 positions; display-only.

Ship-to number (Unlabeled field to the right of the order number)

A hyphen (-) separates this field from the Order # field. This value indicates the number of shipping addresses for the order. The system assigns a sequential ship-to number to every order. The first ship-to address is assigned the number 1.

Numeric, 3 positions; display-only.

Line number (Unlabeled field to the right of the ship-to number

A hyphen (-) separates this field from the Ship-to field. The line number on the order. Up to 999 detail lines may be entered on an order. Order lines are presented in descending sequence so that the most recent order line displays first.

Numeric, 3 positions; display-only.

Qty ordered

The number of units of this item ordered on this order line.

Numeric, 5 positions; display-only.

Qty reserved

The quantity of the item/SKU that is set aside for this order. This value increases by immediate, batch, or interactive reservation and decreases by confirmation or pick void/reprint.

Numeric, 7 positions; display-only.

Cmp (Company)

The company for which you are viewing records.

Numeric, 3 positions; display-only.

Whs (Warehouse)

A code that represents the warehouse from which the order line was reserved. Validated against the Warehouse file.

Numeric, 3 positions; display-only.

Quantity reserved

The quantity of the item/SKU that is set aside for this order. This value increases by immediate, batch, or interactive reservation and decreases by confirmation or pick void/reprint.

Numeric, 7 positions; display-only.

Quantity printed

The number of pick tickets that have printed for the order detail line.

Numeric, 5 positions; display-only.

Quantity remaining

This value is the difference between the Quantity reserved and the Quantity printed. Only records with a remaining quantity greater than zero will be selected.

Numeric, 5 positions; display-only.

Reservation date

The date the item on the order detail line was reserved.

Numeric, 6 positions (MMDDYY format); display-only.

Reservation time

The time the item on the order detail line was reserved.

Numeric, 6 positions (HHMMSS format); display-only.

Field

Description

Order #

A system-assigned code that represents a customer order number.

Numeric, 8 positions; optional.

Order date

The order processing date. This value defaults to the current date.

Numeric, 6 positions (MMDDYY format); optional.

Status

The status of the order detail line.

Valid values:

B = Express Bill

C = Canceled

E = Error

H = Held

S = Sold out

X = Closed

Blank = Open

Alphanumeric, 1 position; optional.

Type

A user-defined code that indicates how the order was received, such as mail order, telephone order, retail, etc.

Alphanumeric, 1 position; optional.

Field

Description

Item

A code and description for a unit of inventory on an order detail line. If a SKUed item is displayed, the SKU information will also appear.

Alphanumeric, 12 positions; display-only.

COLR SIZE OTHR

The SKU code; a code that further defines the item. The three elements are defined in the System Control file and validated against the SKU Element (1, 2, 3) files.

Alphanumeric, one 14 position field (full SKU) or three 4-position fields (split SKU); display-only.

Qty avail (Quantity available)

The quantity of the item that is available to sell in all warehouses. A negative number indicates the item is backordered.

The calculation for availability is: On hand quantity - Quantity reserved - Quantity protected - Pending transfers - Backordered quantity

This value takes into account only reservable locations.

Numeric, 7 positions; display-only.

Qty prot (Quantity protected)

The quantity of the item that can be reserved only through Interactive Reservation where inventory is dispersed manually, as in the case of large wholesale orders or preferred mail order customers.

The system uses this field to reserve the component items on a finished good work order if Use Work Order Processing (E37) is set to Y in the System Control file.

See Warehousing Finished Good Work Order Processing (WWOR), for more information on work orders.

Numeric, 5 positions; display-only.

Order #

A unique number assigned by the system to identify an order.

Numeric, 8 positions; optional.

Shp (Ship-to number)

This system-assigned number represents the number of shipping addresses for the order.

Numeric, 3 positions; optional.

Ln # (Line number)

A system-assigned detail line number on the order.

Numeric, 3 positions; optional.

Sold-to name

The name of the customer who placed the order. Validated against the Customer Sold-to file.

Alphanumeric, 15 positions (first name), 1 position (initial), 25 positions (last name); display-only.

Qty open

The number of units of this item that have not shipped.

Qty rsrvd (Quantity reserved)

The number of units of the item that are set aside for existing orders. This value increases by immediate, batch, or interactive reservation and decreases by confirmation or pick void/reprint.

Numeric, 5 positions; optional.

Qty to reserve

The number of units of this item that are to be reserved for this order.

Numeric, 5 positions; required.