B/O (Back order)

A brief explanation of the reason an item is on backorder or unavailable for shipment.

Order Broker? If the detail line has been assigned to the Order Broker for fulfillment, the detail line is flagged as backordered and has a Printed quantity that is equal to the ordered quantity. In this case, the Drop ship flag for the order line is set to D. The backorder reason remains on the order line even after the line is fulfilled through the Order Broker. See Brokered Backorders for an overview.

Alphanumeric, 25 positions; display-only.

Ofr (Offer)

A code for the catalog, space or television advertisement from which you accept quotes and orders.

The offer defined for the quote or order controls how to calculate shipping and price items. However, if you override the offer for an item (if the customer is ordering from more than one catalog, for example), demand for the item is attributed to the offer associated with the item rather than the order. Demand represents the number and dollar value of orders placed against an offer.

Note: The system automatically overrides the offer for an item if Override Offer on Order Detail Line (D49) system control value is selected and the item is not sold in the offer used on the order.

Offers are defined in and validated against the Offer table. See Working with Offers (WOFR).

Alphanumeric, 3 positions; display-only.

Price

The per unit price of this item, after applying all discounts and repricing. This price reflects any coupon discount amount or dollar discount by offer or source if the Prorate Dollar Discounts and Coupons (D90) system control value is selected.

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

Pricing method (Unlabeled field directly below the Price field)

The method the system used to calculate the price of an item, such as special source pricing, quantity break by item (item/offer pricing), or price codes. See the Order Pricing Window for a listing of pricing methods.

Alphanumeric, 25 positions; display-only.

N/C (No charge)

This flag indicates whether the customer will be charged for the item.

Valid values:

• No Charge = The customer is not charged for the item.

• Priced = The customer is charged for the item.

Ovr (Price override reason code)

Represents the reason that the price of an item was changed or the customer was given the item at no charge. The system assigns a price override reason code when a free gift or promotional item is added to the order.

For quotes, the system assigns the price override reason code defined in the Price Override Reason for Quotes (K75) system control value to each detail line.

Price override reason codes are defined in and validated against the Price Override Reason Code table. See Establishing Additional Charge Codes (WADC).

Several system control values are available for the system to assign a price override reason code for different types of price overrides; see Setting Up Order Entry Values.

Numeric, 1 position; display-only.

Offer price

The item price as defined for the offer. If the order was subject to VAT and tax-inclusive pricing, in which any tax is included in the Hidden tax field rather than the Tax bucket on the order, the offer price presented here is the tax-inclusive offer price.

Note: When a price override reason applies to the order line (whether you enter an override reason manually, or if the system applies the override automatically), the override reason’s Override item offer price setting controls whether to use the regular offer price. See Overriding the Item/SKU Offer Price for a discussion.

Customer price group pricing: If you use Customer Price Group Pricing, the offer price represents the initial price of the item, based on the Price Type defined for the customer price group.

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

Pre-disc price (Pre-discount price)

The item price before applying any coupons or dollar discounts by source or offer, if the Prorate Dollar Discounts and Coupons (D90) system control value is selected, but after applying other discounts and repricing.

The system does not update this field if you change the customer's tax status at any point after entering the item. If you use tax-inclusive pricing, there may be cases where the system reprices items due to changes in a customer's tax exemption status, changing the shipping address to a VAT-exempt state, etc. In these cases, the pre-discount price may not correspond to the way the actual price was derived.

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

Duty

The amount of duty, if any, charged for the item. The system calculates duty based on the duty rates defined for the country of the ship-to address and the harmonize code defined for the item. See Setting Up the Country Table (WCTY).

Duty is included in the Handling bucket for the order.

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

Ship via

A code that identifies the carrier who delivers the merchandise.

Ship via codes are defined in and validated against the Ship Via table. See Working with Ship Via Codes (WVIA).

A ship via code appears here only if the ship via for the item is different from the ship via on the quote or order.

Numeric, 2 positions; display-only.

Extension

The total dollar amount for the item. Calculation is: Order Quantity x Item Price = Extension

The extension is based on the item selling price, after applying all discounts and repricing.

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

Discount method (Unlabeled field below the duty field)

The method, such as source code discount or order discount, that the system used to apply any discounting to the item price after applying any other pricing methods (but before applying a coupon amount or dollar discount by source or offer, if the Prorate Dollar Discounts and Coupons (D90) system control value is selected).

Alphanumeric, 25 positions; display-only.

Arr date (Arrival date)

The date the customer requested delivery of the item. The order date defaults in order entry.

Numeric, 6 positions (in user date format); display-only.

Source

The source code assigned to the detail line. A source code appears here only if:

• the Order Entry operator entered a source code at the line level, or

• the Use Source Code from Order Header When Creating Order Lines (D73) system control value is selected, or

• the Load Source from Mailing History (D20) system control value is selected and the offer entered on the detail line is not associated with the source code on the order header, and the system found an associated source code in the customer's mail history.

The source code at the line level controls demand and sales information/posting for that item, whereas the source code on the order controls how items are priced and freight is calculated.

Alphanumeric, 9 positions; display-only.

Exp ship date (Expected ship date)

For a backordered item: the date a purchase order containing this backordered item is expected.

For finished goods: The system uses this field for finished good items created through work order processing to indicate the date the finished good will be ready for sale if the Use Work Order Processing (E37) system control value is selected. See Finished Good Work Order Processing (WWOR) for more information on work orders.

For drop ship items, including brokered items: This date is displayed for drop ship items only if the Assign Drop Ship Expected Ship Date (I59) system control value is selected. See that system control value for more information.

Numeric, 6 positions (in user date format); display-only.

C/G (Coordinate group)

A number assigned to two or more items to ensure that they ship together.

Numeric, 2 positions; display-only.

Freight

The charge for shipping the item. This total does not include additional freight charges, and is blank if the freight is calculated for the entire order instead of item-by-item.

The system calculates freight charges based on the freight method defined for the source code on the order.

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

B/O whs (Backorder warehouse)

A code that identifies the warehouse assigned to ship a backordered item.

Note: This field appears only if there is a backordered quantity of the item, or if the order line has been assigned to the Order Broker for fulfillment as a brokered backorder. If the line is fulfilled through the Order Broker as a brokered backorder, the backorder warehouse remains on the order line. See Brokered Backorders for an overview.

Numeric, 3 positions; display-only.

G/W (Gift wrap)

A flag that identifies whether the item is gift wrapped.

Valid values are:

• Selected = Gift wrap the item.

• Unselected = Do not gift wrap the item.

S/H code (Special handling code)

Represents the type of special handling to be performed on the item. Special handling refers to any type of item personalization, such as monogramming, alterations, engraving, etc.

The item/SKU offer controls whether you can apply special handling to an item/SKU. See Special Handling Overview for more information.

Alphanumeric, 2 positions; display-only.

S/H charge (Special handling charge)

The dollar amount for special handling of the item. See Special Handling Overview for more information.

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

Future order

This flag indicates that the arrival date for the item is too far in the future to reserve stock. The item is reserved when the current date reaches the requested arrival date minus lead days for picking and shipping.

Valid values are:

• Selected = This is a future order; do not reserve inventory.

• Unselected = This is not a future order and is eligible for inventory reservation.

Warehouse

The warehouse shipping the item. Typically set to 0. Some reasons why an order line might be assigned to a specific warehouse:

• this is a retail pickup or delivery order assigned to a warehouse by the Order Broker

• the order line is a return created by entering a negative quantity in order entry

• the order line was express-billed

• you specified a warehouse override for the order or line when creating the order, either in interactive order entry or through the order API

Numeric, 3 positions; display-only.

Cancel date

The last date when the customer will accept receipt of this item. For quotes, this is the date the quote expires.

Items that have not shipped by the cancel date are included in the Order Cancellation List by Item; however, they are not canceled automatically. This gives you the opportunity to contact the customer and extend the delivery time.

Numeric, 6 positions (in user date format); display-only.

Affect inv (Affect inventory)

If this flag is selected, it indicates that the system reserves the item and reduces inventory after a shipment.

Valid conditions are:

• Selected = Reserve the item and reduce inventory.

• Unselected = Do not affect inventory. This flag is unselected if the item is flagged as a non-inventory item.

Drop ship

A code that identifies the item as one that you do not typically stock in inventory, and which you must order from your vendor, who then ships the item(s) directly to the customer.

An item is defined as a drop ship item in the Item table, or can be identified as a drop ship item in order entry or maintenance.

Valid values are:

• D = Drop ship item.

• blank = Regular item.

Order Broker? If the order line has been assigned to the Order Broker for fulfillment (brokered backorder) or if the customer is picking up the order at a store location where the inventory is already available (store pickup), the Drop ship flag for the order line is set to D. In this case, the order line is flagged as B/O and it has a Printed quantity that is equal to the ordered quantity. See Brokered Backorders or Store Pickup Orders for an overview.

Alphanumeric, 1 position; display-only.

Priority

A number that controls the priority of order fulfillment on a backordered item. Priority codes range from 0-9, where:

• 0 = lowest priority

• 9 = highest priority

A value defaults to this field if a priority was entered or defaulted into the Pty (Priority) on the order header; and this field, in turn, defaults from the B/O priority (Backorder priority) field for the source code.

Numeric, 1 position; display-only.

Bypass rsv (Bypass reservation)

This flag controls whether the system reserves this item during Order Entry.

• If the Use OROB for Fulfillment Assignment (M31) system cotnrol value is selected, the system selects this flag for each order line sent to Order Broker for fulfillment assignment. See Brokered Backorders.

• If the Use OROB for Fulfillment Assignment (M31) system control value is unselected, items that bypass immediate reservation must be reserved using Interactive Reservation. See Working with Interactive Reservation (MIRV). You can define an item to bypass reservation in the Item table.

Valid values are:

• Selected = Bypass immediate reservation.

• Unselected = Do not bypass immediate reservation.

Regardless of the setting of this field, the system does not reserve items on quotes.

Page letter

Indicates the item was ordered by page/letter rather than item number. The page letter code consists of the page of the catalog where the item appears and its position on the page. Page/letter entry format is possible only if you have selected this format for Order Entry. The page/letter assignment is defined in the Item/Offer table. See Performing Initial Item Entry (MITM).

Example: Item C100 appears on page 52 of the winter preview catalog. It is the first item on the page. If using page/letter entry, you can select it as item W52A in Order Entry; however, the item appears as C100 on the order and prints as C100 on the pick slip.

Alphanumeric, 6 positions; display-only.

Cost override

The override to the item's cost, from order entry or order maintenance. You can override the cost of an item to manage the gross profit margin calculation. Gross profit margin is that amount of the price that exceeds your cost for the item.

A common application of cost override in order entry is when you receive cost information from a drop ship vendor, and you calculate a gross profit margin based on the vendor's statement of cost; the new cost information appears in this field.

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

G/W $ (Gift wrap price)

The dollar amount charged for gift wrapping an item, as defined in the Item/Offer or SKU/Offer record.

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

Add'l frt (Additional freight)

The dollar amount of shipper/item charges, as defined for the shipper and item at the Work with Ship Via/Item Screen.

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

Tax

Sales tax charged for the item, as calculated by the system. This is the extended tax amount; that is, the total tax for the entire quantity.

The total in the Tax bucket on the order may not equal the totals for each item if, for example the order is subject to tax on handling and/or freight, or due to rounding up or down to the nearest penny.

On orders subject to VAT and tax-inclusive pricing, any tax appears in the Hidden tax field. This amount is not included in the Tax bucket on the order totals.

Numeric, 7 positions with a 5-place decimal; display-only.

Tax override %

The tax rate for the tax.

Note: This field displays only if a Tax override rate is defined in the Order Detail table.

The system uses the following calculation to determine the tax override rate:

(tax amount /extended amount) x 100 = tax override rate

The system stores the tax rate for the tax override in the ODT Tax Override Rate field in the Order Detail table; the system uses the tax rate during Order Maintenence if you use the Discount Price window to apply a discount to a shipped item. Billing also uses this tax rate to create the credit invoice and calculate the tax credit amount using the new tax amount. See Discount Price Window (Applying a Discount to an Item) for an example.

Numeric, 7 positions with a 5-place decimal; display-only.

Hidden tax

The amount of any hidden tax attributed to the item. This field appears only if the Tax Included in Price (E70) system control value is selected, and a hidden tax amount appears only for orders and items subject to VAT and tax-inclusive pricing.

On orders using tax-inclusive pricing, you charge a different, higher price for an item than an orders subject to conventional tax. Also, any tax amount is not calculated in the standard way and included in the Tax bucket on the order; instead, a hidden tax amount is calculated based on the information you have defined for the customer's country or the item itself, and this amount is “hidden” on the order detail line; this tax is not visible to the customer. Unlike the item tax included in the Tax field, described above, the hidden tax is a unit amount, not an extended amount; you must multiply the hidden tax amount by the item quantity to arrive at the extended hidden tax amount for the order line.

In tracking sales figures, such as in the Order Billing History table and on marketing reports, the system subtracts the hidden tax amount from the item price to determine sales dollars. For example, if the customer pays $10.00 for an item, but the hidden tax amount is $1.50, the system posts the sale as $8.50.

It is possible for the hidden tax for an item to exceed the price you charge the customer if you have defined hidden tax for the item as an amount rather than a percentage of the item price, and you sell the item at a considerable discount or as a free gift.

An item may be exempt from tax, hidden tax, or both based on exemptions defined for the order, customer, state, or item. See Working with Customer Tax Status for more information on tax exemptions. See Setting Up the Zip/City/State (Postal Code) Table (WZIP) for more information on how the system determines how to apply tax or hidden tax to an order.

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

Quantity

A series of item status fields updated by the system.

Valid values are:

Reserved Quantity

The number of units for which stock has been reserved. This number is reduced when items are canceled, confirmed, or unreserved using Interactive Reservation.

Reserved Date

The date when the units were reserved. This date remains blank for items flagged as a non-inventory item.

Printed Quantity

The number of units for which pick slips have been printed. This number is reduced if the pick ticket is voided or when shipment of the item is confirmed.

Printed Date

The date when the pick slip was printed.

Shipped

The number of units that have shipped. This quantity is negative for returns created by entering a negative quantity in order entry.

Returned

The number of units that the customer has returned. This quantity is zero for returns created by entering a negative quantity in order entry.

Canceled

The number of units that have been canceled.

Sold Out

The number of units that are sold out.

Number: numeric, 5 positions, display-only.

Order Broker? If the order line has been assigned to the Order Broker for fulfillment (brokered backorder) or if the customer is picking up the order at a retail location where the inventory is already available (store pickup), the order line is flagged as backordered and has a Printed quantity here that is equal to the ordered quantity. In this case, the Drop ship flag for the order line is set to D until the order line is fulfilled and the Printed quantity is reduced. See Brokered Backorders or Store Pickup Orders for an overview.

Order #

The order number and ship to number associated with the hyperlink.

Order#: Numeric, 8 positions; display-only.

Ship to#: Numeric, 3 positions; display-only.

Line #

A number the system assigns to each item as it is added to the order.

Numeric, 3 positions; display-only.

Item-SKU\

description

The item and SKU code, followed by the description of the item and SKU. The description field displays up to 52 positions; however, if the SKU description is truncated, you can display the rest by putting your cursor in the field and advancing it to the right.

Item: alphanumeric, 12 positions; display-only.

SKU: alphanumeric, three 4-position fields; display-only.

Item description: alphanumeric, 40 positions; display-only.

SKU description: alphanumeric, 40 positions; display-only.

Special handling

Represents the type of special handling that applies to an item. Special handling refers to any type of item personalization, such as monogramming, alterations, engraving, etc.

The item/SKU offer controls whether the item is eligible for special handling. See Special Handling Overview for more information.

The information is defined in the Additional Charges Code table. See Establishing Additional Charge Codes (WADC).

Numeric, 2 positions; display-only.

Charge

The charge for special handling of an item. See Special Handling Overview for more information.

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

Handling information

Free-form instructions about how to customize the item.

These fields might be blank if, for example, you use the special handling format only to add a charge to the Handling bucket on the order. The Suppress S/H window field for the additional charge code allows you to suppress the automatic display of the special handling screen in order entry if you use a special handling code for this purpose.

Alphanumeric, 30 positions each line; display-only.

Special format

Represents the type of special handling that applies to an item. Special handling refers to any type of item personalization, such as monogramming, alterations and emblems. Special handling codes are defined in and validated against the Additional Charge Code table. See Special Handling Overview for more information.

Numeric, 2 positions; display-only.

Charge

The charge associated with the special handling applied to this item. See Special Handling Overview for more information.

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

Label

A special handling option defined for this custom special handling format.

Alphanumeric, 15 positions; display-only.

Input

The response selected for each special handling option available in the custom special handling format.

These fields might be blank if, for example, you use the special handling format only to add a charge to the Handling bucket on the order. The Suppress S/H window field for the additional charge code allows you to suppress the automatic display of the special handling screen in order entry if you use a special handling code for this purpose.

Alphanumeric, 45 positions; display-only.

Charge (Optional charge)

The charge associated with an option in the custom special handling format. This charge is added to the Handling bucket of the order totals.

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

Order line

This field includes the customer number, ship-to number, and the order detail line number, each separated by a hyphen (-).

Numeric, 3 positions; display-only.

Qty ordered (Quantity ordered)

The total number of units ordered of the item.

Numeric, 5 positions; display-only.

Qty reserved (Quantity reserved)

The total number of units the system has reserved for this item. Reservation may occur immediately at Order Entry or in batch mode at designated intervals.

When reviewing item reservation fields, you may need to be aware that these conditions may prevent or delay reservation:

• Arrival date, when compared to today's date, is greater than the number of days specified in the Reservation Lead Days (B27) system control value.

• The item has been assigned a zone reservation code. Zone reservation coded items are not reserved in order entry; instead they are given a backorder status of Z and are reserved during pick generation.

• Bypass res (Bypass reservation) field in the Customer table or for the customer class (see Setting Up the Customer Class Table (WCCL)) is selected.

• Quantity ordered is greater than the quantity available to sell.

• Quantity ordered is greater than the Reserve quantity maximum value in the Item table

• Reservation freeze field in the item/SKU warehouse record is selected.

Numeric, 5 positions; display-only.

Cmp (Company)

The code for the company from which the item was reserved.

Numeric, 3 positions; display-only.

Whs (Warehouse)

The warehouse shipping the item. An item may be reserved across more than one warehouse if the Split Line Over Multi Whse (B19) system control value is selected.

Alphanumeric, 3 positions; display-only.

Reserved

The quantity reserved of the item.

Numeric, 5 positions; display-only.

Printed

The number of units for which a pick slip has been printed.

The system updates this field when it creates a pre-generated pick for the order line, incrementing this number by the quantity on the Pick Control Detail; see Applying Pick Slip Preparation to an Order.

Numeric, 5 positions; display-only.

Remaining (Quantity remaining)

The difference between the quantity reserved and the quantity printed.

The system updates this field when it creates a pre-generated pick for the order line, decreasing this number by the quantity on the Pick Control Detail; see Applying Pick Slip Preparation to an Order.

Numeric, 5 positions; display-only.

Date

The date the item was reserved.

Numeric, 6 positions (in user date format); display-only.

Time

The time the item was reserved.

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

Zone start date

The shipping start date for the zone date window; the date you intend to begin shipping this item to the geographic zone in which the ship-to address on this order is located.

Numeric, 6 positions, in user date format; display-only.

Zone end date

The shipping end date for the zone window; the last day you specify for shipping this item to this ship-to address.

Numeric, 6 positions, in user date format; display-only.

Arrival date

The date this item is scheduled to be shipped to the customer. This date is:

• the zone start date if the item was ordered prior to the zone season start date.

• the order date if the item was ordered between the zone season start date and zone end date, provided that:

- if you use Standard Zone Reservation Rules, the item was available or you took the order before the zone’s deferred cutoff date

- if you use Alternate Zone Reservation Rules, the item was available or had an open PO quantity

• otherwise, this date is the next season's zone start date from the zone reservation dates.

See Shipping Zone Reservation Overview for a complete discussion.

You can use an order line's Arrival date as a selection criterion in pick slip generation. For zone reservation coded inventory such as plant stock, this selection insures that the item will ship at a date suitable for planting at its destination.

Alphanumeric, 6 positions, in user date format; display-only.

Priority

Determines the sequence in which orders receive inventory in the Evaluate Backorders program and the Batch Reservation program. Zone reservation orders are reserved in one of these two programs.

Valid values are numbers in the range 0 - 9, where:

• 0 = Lowest priority

• 9 = Highest priority

If you have entered an override to the default Arrival date in order entry (other than the date of the order), the order Priority is 9 (Highest priority). Overriding the Arrival date for zone reservation orders insures that these orders are fulfilled before lower priority orders.

You can use an order's Priority as a selection criterion in pick slip generation.

Numeric, 1 position; display-only.

Season

A code identifying the season to which the date window applies.

Alphanumeric, 3 positions; optional.

Geo. zone (Geographic zone)

A code identifying the geographic zone to which the date window applies.

The country is divided into geographic zones which relate to relative weather conditions. Each of these zones have a different date window during which this item can be shipped.

See Creating and Maintaining Geographic Zones (WGZN).

Alphanumeric, 3 positions; optional.

Whse (Warehouse)

A code representing a warehouse containing the item.

Numeric, 3 positions; display-only.

Description

The description of the warehouse.

Alphanumeric, 30 positions; display-only.

Total avail (Total availability)

The quantity of the item available to sell.

Numeric, 7 positions; display-only.

Avail (Available)

The quantity of the item available in the designated warehouse.

Numeric, 7 positions; display-only.

B/O (Backorder)

The number of units that customers have ordered that are not available to be shipped.

Numeric, 7 positions; display-only.

Open PO (Open purchase orders)

The quantity of the item due for receipt on open purchase orders in the designated warehouse.

Numeric, 7 positions; display-only.

Price method

The method the system used to calculate the price of an item, but before applying an order-level discount, such as a source code discount percentage.

Valid values, and the corresponding code stored in the Order Detail table, are:

• 1 Coupon item price

• 2 Customer discount%

• 3 Contract price

• 4 Special source price

• 5 Column price

• 6 Quantity break price

• 7 Offer price

• A Repriced-prorated discount

• B Quantity Price Matrix Customer Override

• C Use item cost

• E Price code

• F Customer Price Group

• G BOGO

• I Repriced-qty break/item

• J Repriced Customer Price Group Best Price

• K Price table default

• L Price Table Level Ovr

• N No charge (with cost tracking; source code definition)

• O No charge/no cost (source code definition)

• R Price override (includes entering as no charge in Order Entry)

• T Price table premium

• U Upsell Item

• V Repriced-volume discount

• Y Price table

• X Qty Price Matrix

• Z Repriced-item category promotion

Alphanumeric, 1 position; display-only, assigned by the system.

No charge

This flag indicates if you selected the No charge field in Order Entry. Valid value:

Selected = Item price was overridden to no charge in Order Entry.

Add'l chg code (Additional charge code)

A code for the additional charge added to the item. Additional charges may be added because of the source code, the offer, special handling of an item, or for shipping a special item.

Additional charges are defined in and validated against the Additional Charges table. See Establishing Additional Charge Codes (WADC).

Alphanumeric, 1 position; display-only.

Original price

The offer price of the item before any discount is applied.

Customer price group pricing: If you use Customer Price Group Pricing, this price represents the initial price of the item, based on the Price Type defined for the customer price group.

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

Price

The price the customer is charged for a single unit of the item. This price differs from the original price if any discount or repricing applied.

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

Discount

The amount of the discount applied to the item. This field is not currently implemented.

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

Disc applied?

This code identifies whether a discount was applied to the order.

Valid values are:

• A = A discount percentage was entered on the order header screen, or a discount percentage was defined for the customer.

• B = A discount percentage was defined for the source code.

Alphanumeric, 1 position; display-only.

Freight charge

The freight override, if any, entered for this item on the order.

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

Spec handling (Special handling)

The special handling charge, if any, for the item.

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

Tax

The tax amount that applies to the item. See Tax.

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

GST (Goods and Services Tax)

The Canadian goods and services tax (GST) that applies to items shipping to Canada. If GST applies, the tax includes this amount.

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

PST (Provincial Services Tax)

The Provincial Services tax (PST) that applies to items shipping to Canada. If PST applies, the tax includes this amount.

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

Hidden tax

The amount of hidden tax for the each unit of the item.

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

Extension

The extended price of the item, calculated as: Item Price x Order quantity = Extended Price

An extended price does not appear for canceled items.

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

Affect Inv (Affect inventory)

A flag that determines whether the system reduces inventory when you sell the item.

Values are:

• Selected = Reduce inventory.

• Unselected = Do not affect inventory.

Bypass res (Bypass reservation)

A flag that determines whether the item bypasses immediate reservation, which means the item is not reserved during order entry.

• If the Use OROB for Fulfillment Assignment (M31) system control value is selected, the system selects this flag for each order line sent to Order Broker for fulfillment assignment. See Brokered Backorders.

• If the Use OROB for Fulfillment Assignment (M31) system control value is unselected, items that bypass immediate reservation must be reserved using Interactive Reservation. See Working with Interactive Reservation (MIRV). You can define an item to bypass reservation in the Item table.

Values are:

• Selected = Bypass immediate reservation.

• Unselected = Do not bypass reservation.

Canceled

The quantity of the item that has been canceled.

Numeric, 5 positions; display-only.

Ordered

The quantity of this item originally ordered.

Numeric, 5 positions; display-only.

Printed

The quantity of this item printed on a pick slip. This quantity is updated during pick slip generation and reduced when shipment is confirmed.

Numeric, 5 positions; display-only.

Reserved

The quantity of this item reserved currently.

Numeric, 5 positions; display-only.

Shipped

The quantity of this item shipped.

Numeric, 5 positions; display-only.

Sold out

The quantity of this item sold out.

Numeric, 5 positions; display-only.

Returned

The quantity of this item that the customer has returned.

Numeric, 5 positions; display-only.

Confirmed

The quantity of this item confirmed for shipment.

Numeric, 5 positions; display-only.

Arrival date

The date the customer wants to receive the item.

Numeric, 6 positions; display-only.

Cancel date

The date when the customer wants to cancel the item if it has not shipped.

Numeric, 6 positions; display-only.

Date printed

The date the last pick slip was printed for this item.

Numeric, 6 positions; display-only.

Date reserved

The date that inventory was reserved for the item.

Numeric, 6 positions; display-only.

Expected ship

The date the backordered item is expected to be available to ship. The expected ship date is cleared once you receive the item in Purchase Order Receiving.

Numeric, 6 positions; display-only.

Last BO date (Last backorder date)

The most recent date the system generated a backorder notice. A backorder notice is sent to the customer regarding a shipment delay on an item.

Numeric, 6 positions; display-only.

Entered date

The date the item was ordered.

Numeric, 6 positions; display-only.

Entered time

The time that the item was ordered.

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

Item

The item you are reviewing or adding to the order. The actual item code is listed, even if you ordered by alias.

Alphanumeric, 12 positions; display-only.

Item description (Unlabeled field to the right of the item code)

The first 30 positions of the description of the item.

Alphanumeric, 30 positions; display-only.

SKU code

The item's unique characteristics, such as its color or size. The SKU is listed, even for a SKU’d item, only if the item comments that display are associated with the SKU itself rather than the base item.

Alphanumeric, three 4-position fields; display-only.

SKU description (Unlabeled field to the right of the SKU)

The first 30 positions of the description of the SKU.

Alphanumeric, 30 positions; display-only.

Comments

The comments associated with the item or SKU. If there are any comments associated with the SKU ordered, the window displays these comments; otherwise, it displays any comments entered for the base item. The window displays only item comments whose Print code is set to Window.

The window displays up to 10 lines. A plus sign (+) indicates that there are additional lines. To review additional comment lines, select Next.

Alphanumeric, 50 positions each line; display-only.

All fields on this screen are display-only.

Order #

The order number and ship-to number.

Order number: numeric, 8 positions.

Ship-to number: numeric, 3 positions.

Line #

The line number on the order. There can be up to 999 detail lines on an order.

Numeric, 3 positions.

PO #

The purchase order number assigned by Order Management System when you process drop ship purchase orders.

Numeric, 7 positions.

Line #

The purchase order detail line number. There can be up to 999 detail lines on a purchase order.

Numeric, 3 positions.

Item

The item code and SKU code, if any.

Item code: alphanumeric, 12 positions.

SKU code: alphanumeric, three 4-position fields.

Description

The item description. The SKU description does not display.

Alphanumeric, 30 positions.

Orig exp ship date

(Original expected ship date)

The original due date on the purchase order.

The original expected ship date is calculated by adding the Lead days for the vendor item and the Drop Ship Lead Days (H36) to the order date; however, if the Arrival date on the order is later than this date, the Arrival date is used as the Original expected ship date.

A drop ship purchase order is not eligible for creation through the Selecting Vendors for Drop Ship Processing (MDSP) menu option until the current date plus the number of Lead days in the vendor item table equals or exceeds its due date.

Numeric, 6 positions, in user date format.

Revised exp ship date

The date, if any, sent by the vendor indicating when the merchandise will ship. If the vendor has not revised the Original expected ship date, the Revised expected ship date field is blank. If the vendor has revised the due date more than once, the most recent date sent is displayed here.

If the vendor revises the expected ship date, Order Management System adds a message to the detail history fields, below and displays the message in the Additional info field.

If the vendor subsequently removes the revised expected ship date from the PO line, the revised expected ship date is removed from this field, and Order Management System replaces the message entry.

Note: The revised expected ship date on a drop ship purchase order does not update the expected ship date on the order detail line. As a result, the expected ship date shown on the Display Order Detail Screen (Reviewing Order Line Detail) may differ from the revised expected ship date displayed in this field. The Expected ship date on the order detail line is updated by backorder card processing only. See Purchase Order Layering and Backorder Notifications.

Numeric, 6 positions, in user date format.

Drop ship status

The current status of the drop ship purchase order detail line.

Valid statuses are:

• Blank - the drop ship purchase order is not flagged to be processed by an integrated system. The Supplier Direct Fulfillment integration does not use a blank status.

• Sent - the drop ship purchase order has been created in Order Management System and sent to Order Broker’s Supplier Direct Fulfillment module, but the integrating system has not yet acknowledged the purchase order. A purchase order line fulfilled through the Supplier Direct Fulfillment module might also be in this status if you have sent a cost change to Order Broker.

• Open - the drop ship purchase order line has been created in Order Broker module but not yet selected by the vendor for fulfillment. A purchase order line fulfilled through the Order Broker module might also be in this status if there have been updates to the purchase order, such as if the vendor has held and then released the line.

• In Process - the drop ship purchase order line has been selected (pulled or printed) by the vendor for fulfillment.

• Held - the drop ship purchase order line has been held by the vendor.

• Cancelled - the drop ship purchase order line has been cancelled.

• Shipped - the drop ship purchase order line has been shipped by the vendor, closing the purchase order line and order line.

• RA Sent - a return authorization has been created for the purchase order line and sent to an integrated system. Returns are not currently implemented through Order Broker’s Supplier Direct Fulfillment module.

• RA Cancelled - the RA has been cancelled. Returns are not currently implemented through Order Broker’s Supplier Direct Fulfillment module.

• Returned - the drop ship purchase order returned merchandise has been received and posted by the vendor. When the vendor posts a return, the return is received and credited (if not already credited) in Order Management System. Returns are not currently implemented through Order Broker’s Supplier Direct Fulfillment module.

• Invoiced - the vendor has submitted an invoice for the shipment.

Not changed when you send address change information to Order Broker’s Supplier Direct Fulfillment module.

Alphanumeric, 10 positions.

Additional info

The most recent text message sent from the vendor regarding the drop ship purchase order line. The vendor enters this message in Order Broker’s Vendor Portal.

Note: The message entry is required in Order Broker’s Vendor Portal.

Alphanumeric, 50 positions.

Date

The date the transaction was sent either from Order Broker to Order Management System, or from Order Management System to Order Broker.

Numeric, 6 positions, in user date format.

Time

The time the transaction was sent either from Order Broker to Order Management System, or from Order Management System to Order Broker.

Numeric, 6 positions, HH:MM:SS format.

Status

The status of the transaction when it was performed. This status is usually identical to the Drop ship status of the transaction when it was performed except in the case of PO cost updates or PO address changes, in which case the status is listed as:

• Change - for PO address changes sent to Order Broker.

• Cost Chg - for PO cost changes sent to Order Broker. This status and accompanying message displays only when you access this screen from PO Inquiry (MPOI).

Alphanumeric, 10 positions.

Description

The description of the transaction. System-generated descriptions are:

• Drop Ship PO created

• PO available to vendor

• Vendor selected PO for processing

• Vendor released PO

• Cancel request sent

• Cancel request confirmed

• Cancel request rejected

• Address change sent to vendor

• Cost change sent to vendor (displays only in PO Inquiry)

• Drop Ship PO confirmed on XX/XX/XX (date when the update was received in Order Management System; not necessarily the shipment date indicated by the vendor)

Vendor messages? In addition to system-generated messages, this field displays messages the vendor enters when updating the status of an order line in Order Broker’s Vendor Portal: The vendor is required to enter a reason message when putting an item on hold or revising the expected delivery date. The vendor can also enter a reason when releasing a line from hold, or independently of any of these changes. The screen displays the reason entered by the vendor for these activities.

No history? No history message is recorded when the vendor accepts or declines an address change, voids and reprints a pack slip, or enters a reason description in Order Broker without making any additional changes to the purchase order line.

Note: You can confirm shipment of a Order Broker drop ship purchase order through the Receiving Purchase Orders (PORC) menu option; however, this option is not recommended. Receiving the drop ship purchase order this way updates the status of the purchase order in Order Management System to X (Closed) but does not affect the status of the purchase order in Order Broker, and subsequent vendor actions for the purchase order are not recorded in Order Management System.

Alphanumeric, 33 positions.

Enter cancel reason

Enter the reason for cancelling the drop ship purchase order and click OK to submit a cancellation request.

Cancel reason codes are defined in and validated against the Cancel Reason table. See Establishing Cancel Reason Codes (WCNR).

The cancel reason code is saved in the P/O Detail Drop Ship Order table (PODTDS); if the cancellation is confirmed by the vendor, the system uses this reason code on the order detail line and the drop ship purchase order.

Numeric, 2 positions; required.