Field

Description

Date

The date this pick slip was printed.

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

Time

The time this pick slip was printed.

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

Billing batch

A system-generated batch number that is assigned to each pick slip run.

Numeric, 7 positions; optional.

Pick # range

Each pick slip is assigned a number; this field displays the range of pick slip numbers that were picked.

Numeric, 3 positions; display-only.

Total printed

The total number of pick slips that were printed, for each date.

Numeric, 3 positions; display-only.

Confrm (Confirmed)

The total number of pick slips that were shipped and billed, for each date.

Numeric, 3 positions; display-only.

Packd (Packed)

The total number of pick slips that were packed. This number is incremented by the Pick/Pack Verification program.

Numeric, 3 positions; display-only.

Void

The total number of pick slips that were voided.

Numeric, 3 positions; display-only.

Suspd (Suspended)

The total number of pick slips that have been suspended.

Numeric, 3 positions; display-only.

Outsd (Outstanding)

The total number of pick slips that have been suspended.

Numeric, 3 positions; display-only.

Field

Description

Billing batch #

A system-generated batch number that is assigned to each pick slip run.

Numeric, 7 positions; display-only.

Pick #

The system-assigned control number for this pick.

Numeric, 7 positions; display-only.

Printed

The date the pick was printed.

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

Confirmed

The date the pick was shipped and billed.

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

Status

The status of this pick.

Valid values:

A = Submitted to Async

B = Billing pending

C = Confirmed

D = Declined authorization

E = Async processing error

L = Waiting for carousel system

M = Submitted to PC manifest

O = Carryover

P = Packed

R = Reprinted

S = Suspended

V = Void

W = Waiting for authorization

Z = Authorized

3 = Post carousel

Blank = Open

Alphanumeric, 1 position; display-only.

Reprint

The pick control number that has been reprinted.

Numeric, 7 positions; display-only.

Field

Description

Control #

The control number assigned to a batch of picks.

Numeric, 7 positions; display-only.

Billing batch #

A system-generated batch number that is assigned to each pick slip run.

Numeric, 7 positions; display-only.

Pick status

The description of the pick's status.

Valid values:

A = Submitted to Async

B = Billing pending

C = Confirmed

D = Declined authorization

E = Async processing error

L = Waiting for carousel system

M = Submitted to PC manifest

O = Carryover

P = Packed

R = Reprinted

S = Suspended

V = Void

W = Waiting for authorization

Z = Authorized

3 = Post carousel

Blank = Open

Alphanumeric, 10 positions; display-only.

Generation type

The type of pick slip being generated.

Valid values:

Regular = no special requirements

Drop/Ship = requires drop ship processing

Special/Handling = includes special handling items

Master = includes all items in the pick slip run.

Alphanumeric, 10 positions; display-only.

Date/time last update

The date and time this pick was last changed. Printing the pick is considered to be a change.

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

By

The user who last updated this pick. Printing the pick is considered to be a change.

Alphanumeric, 10 positions; display-only.

Date/time printed

The date and time this pick was printed.

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

Date/time assigned (Picker)

The date and time this pick was assigned to a picker. Used in Pick/Pack Verification.

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

Date/time assigned (Packer)

The date and time this pick was assigned to a packer. Used in Pick/Pack Verification.

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

Picker/packer code

A code that represents an inventory picker or packer in your warehouse. Used in Pick/Pack Verification.

Alphanumeric, 3 positions; display-only.

Assigned packer

A code that identifies the packer assigned to this pick. Used in Pick/Pack Verification.

Alphanumeric, 3 positions; display-only.

# of labels

The total number of labels printed for this pick slip. This field is used in the following situations:

• If you decide to print multiple labels for this pick slip manually.

• If the system divides an order into multiple pick slips, each one will get a unique control number.

Numeric, 3 positions; display-only.

# of labels scanned

The total number of shipping labels scanned, or wanded, for this pick.

Numeric, 3 positions; display-only.

Cart batch #

The system-assigned number that represents the batch pick slip list for each cart. If the system determines that there is not enough bins in the cart to accommodate the batch, a new cart/batch number is created.

Numeric, 7 positions; display-only.

# of cartons

The number of cartons required to ship each order. Determined by the Cubing feature.

Numeric, 3 positions; display-only.

Pick zones (1-6)

The warehouse zone(s) on this pick slip. The System Control file value, Maximum Number of Zones (B41), defines the maximum number of zones (up to 6) on a pick slip.

Example of how pick zones are used:

A pick slip with items to be picked in zones A, B, and D will not be included in the same batch as a pick slip with items to be picked in zones A, B, and R. However, a pick slip with items to be picked in zones A, B, and D will be included in the same batch as a pick slip with items to be picked in zones A and D.

Numeric, 3 positions; display-only.

Include on S/J

Y - Indicates that this pick slip should be included on the Sales Journal report.

N (or blank) - Indicates that this pick should not be included on the Sales Journal report.

Alphanumeric, 1 position; display-only.

# of lines

The number of items on the pick slip.

Numeric, 3 positions; display-only.

Ship via

The code that represents the carrier for this order. Can be overridden during order entry or pick slip generation. Validated against the Ship Via file. Working with Ship Via Codes (WVIA) for more information.

Numeric, 2 positions; display-only.

Hazard code

A user-defined code used to categorize an item as a hazardous material that requires special storage and/or handling. Validated against the Item Hazard file; see Chapter 3: Working with Hazardous Item Codes (WHAZ). This information is passed to TanData.

Numeric, 2 positions; display-only.

Warehouse

A code that represents the default warehouse. Validated against the Warehouse file.

Numeric, 3 positions; display-only.

Drop point

A code that represents a location to which merchandise will be shipped from your warehouse.

• Drop points are UPS facilities, typically.

• Drop points print as the return address on the pick slip and are the destination to which undeliverable packages are returned.

• Drop points are used in zone skipping.

Numeric, 3 positions; display-only.

Field

Description

Control #

The control number assigned to this batch of picks.

Numeric, 7 positions; display-only.

Reprinted control #

The control number assigned to the batch of picks that have been reprinted.

Numeric, 7 positions; display-only.

Merch

The total value of merchandise. This value is a total of the item price multiplied by the quantity ordered and does not include freight, additional charges, tax, or handling.

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

Freight

The total charge for shipping an order. This value does not include any additional charges associated with shipping the order. This value is based on the freight method defined for the source code on the order. The total may depend on the quantity or weight of items ordered, or on the dollar value of the order as a whole.

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

Add’l freight

The total dollar value for additional freight charges, above the order's regular shipping charges. This value is the total of the additional freight charges defined for the shipper(s). Additional freight charges are defined in the Ship Via file.

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

Add’l chgs

The total extra charges added to the order. Additional charges can be:

• Service charges, based on the dollar value of the merchandise,

• Additional shipping charges, or

• Guaranteed service charges.

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

Handling

The total charge for special handling or gift wrapping. This value is the full total of the handling charges for each item multiplied by the quantity ordered. The SKU/Offer file controls whether the item is eligible for special handling and the charge for special handling.

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

Tax

The total sales tax on the order. This value is based on the merchandise value. The system calculates sales tax for the order by multiplying the merchandise amount by the tax rate for the shipping destination. See Chapter 4: Entering Orders Using Header Format in the Order Entry manual for additional information.

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

GST

Canadian Goods and Services tax. A tax method is defined for each postal code to accommodate the varying tax requirements in each province, when shipping from Canada.

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

PST

Provincial Services tax. A tax method is defined for each postal code to accommodate the varying tax requirements in each province, when shipping from Canada.

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

Paid

The amount paid by the customer.

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

Total order

The sum of all charges including merchandise, freight, additional freight, tax, handling, and additional charges.

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

Due

The balance due. If this is a credit, the system displays the amount with CR beside the value. The amount due is calculated by subtracting the Paid amount from the Total Order amount.

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

PO #

The customer's purchase order number.

Alphanumeric, 15 positions; display-only.

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.

Customer #

A unique number assigned by the system to identify a customer. Every customer on the system is assigned a customer number.

Numeric, 9 positions; display-only.

Name

The name of the customer who placed the order.

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

Company name

The name of the company that placed the order.

Alphanumeric, 30 positions; display-only.

Address

The customer's street address.

Alphanumeric, 32 positions; display-only.

Apartment

The customer's apartment, suite, rural route, or floor number.

Alphanumeric, 10 positions; display-only.

City/St/Postal/Cntry

The city, state, postal zip code, and country where the customer receives mail or shipping. State codes are defined in and validated against the State file, which is accessible through the Work with Countries menu option; see Customer Service Chapter 14: Setting Up the Country File (WCTY).

Alphanumeric, 25 positions (city), 2 positions (state), 10 positions (postal code), 3 positions (country); display-only.

Delivery code

Identifies whether the customer is Business or Residential. This field is used to determine shipping charges.

Valid values:

B = Business

R = Residential

Alphanumeric, 1 position; display-only.

PO box?

This value indicates whether the shipper will deliver packages to a post office (P.O.) box. Any address in which P.O. Box or APO/FPO appears must be delivered to a post office box.

• Y indicates that the shipper will deliver packages to a post office box.

• N indicates that the shipper will not deliver packages to a post office box.

Alphanumeric, 1 position; display-only.

Field

Description

Line #

A system-assigned detail 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.

Item

A code that represents a unit of inventory on an order detail line.

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.

Quantity printed

The number of units of the item printed and the quantity which should be shipped.

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 #

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.

Seq # (Sequence number)

A number assigned to a warehouse location and used to verify the location number that is either entered, scanned, or system-loaded.

Numeric, 3 positions; display-only.

Control #

The control number assigned to a pick slip.

Numeric, 7 positions; display-only.

Line #

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 (assigned by the system).

Item

A code that represents a unit of inventory on the order detail line.

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.

Original print qty

The original quantity that was printed on the pick. This becomes important if the quantity on the pick is changed.

Numeric, 5 positions; display-only.

Qty printed

The number of units of the item printed and the quantity which should be shipped.

Numeric, 5 positions; display-only.

Qty packed

The number of units of the item packed and the quantity which should be shipped.

Numeric, 5 positions; display-only.

Qty ordered

The number of units of the item ordered.

Numeric, 3 positions; display-only.

Qty B/O (Quantity backordered)

The number of units of the item backordered.

Numeric, 3 positions; display-only.

Price

The system price of a single unit of the item. The price is assigned by the system, but may be overridden in Order Entry.

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

Extension

The total price of the order. This value is calculated by multiplying the Unit Price by the Quantity Shipped.

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

Special handling

The charge for special handling a single unit of the item. The SKU/Offer file controls whether the item is eligible for special handling and the charge for special handling.

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

Extension

The total special handling charges for the order. This value is calculated by multiplying the Special Handling charge by the Quantity Shipped.

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

Gift wrap

The charge for gift wrapping a single unit of the item. The SKU/Offer file controls whether the item is eligible for gift wrapping and the charge for gift wrapping.

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

Extension

The total gift wrapping charges for the order. This value is calculated by multiplying the Gift Wrap charge by the Quantity Shipped.

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

Freight

The total charge for shipping an order. This value does not include any additional charges associated with shipping the order. The system performs this calculation based on the freight method defined for the source code on the order. The total may depend on the quantity or weight of items ordered, or on the dollar value of the order as a whole.

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

Tax

The total sales tax on the order. This value is based on the merchandise value. The system calculates sales tax for the order by multiplying the merchandise amount by the tax rate for the shipping destination. See Customer Service Chapter 15: Setting Up the Postal Code File (WZIP) and Chapter 32: Working with Customer Tax Status.

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

GST (Canadian Goods and Services tax)

A federal-level tax that may apply to orders within Canada.

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

PST (Provincial Services tax)

A province-level tax that may apply to orders within Canada.

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

Line status

The status of the order detail line.

Valid values:

C = Cancel

H = Hold

Blank = Open

Alphanumeric, 1 position; display-only.

Backorder control

Specifies what action should be taken for this line.

Valid values:

C = Ship and cancel remainder

X = Backorder and cancel order

Blank = Ship and backorder the remainder.

Alphanumeric, 1 position; display-only.

Effect inventory (Effect on inventory)

This value indicates whether this order detail line affects the inventory count. For example, you may not want a mailer that is included in each shipment to be reflected in your actual inventory count.

Y - This order detail line affects inventory count.

N (or blank) - This order detail line does not affect inventory count.

Alphanumeric, 1 position; display-only.

Carton #

The number assigned to the carton by the system.

Numeric, 3 positions; display-only.

Cart bin #

The number assigned to the cart/bin by the system.

Numeric, 3 positions; display-only.

Requires special (Requires special handling)

This value indicates whether or not this order detail line requires special handling.

Y = This order detail line requires special handling.

N = This order detail line does not require special handling.

Alphanumeric, 1 position; display-only.

Field

Description

Whs

A code that represents the primary warehouse. Validated against the Warehouse file.

Numeric, 3 positions; display only.

Zone

The zone(s) in the warehouse that is used for this pick slip. You can have up to 6 zones on a pick slip. The Maximum Number of Zones (B41) system control value defines the maximum number of zones on a pick slip.

Numeric, 3 positions; display only.

Location

A code that represents a warehouse location where merchandise is stored. The warehouse location code can consist 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

Alphanumeric, 7 positions; display only.

Qty picked

The quantity of the item that has been picked from this warehouse.

Numeric, 3 positions; display only.

Cart batch

The batch pick slip list that is assigned to each cart.

Numeric, 7 positions; display only.