Date

The date the pick slip was printed. This is the date for the first pick slip in the batch sorted in cart batch number, pick control number sequence.

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

Time

The time the pick slip was printed. This is the time for the first pick slip in the batch sorted in cart batch number, pick control number sequence.

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.

Cnfrm (Confirmed)

The total number of pick slips that were shipped and billed, for each date. This is the number of pick slips that are in a Confirmed (C) status.

Numeric, 3 positions; display-only.

Packd (Packed)

The total number of pick slips that were packed. This is the number of pick slips that are a Packed (P) status.

Numeric, 3 positions; display-only.

Void

The total number of pick slips that were voided. This is the number of pick slips that are in Void (V) status.

Numeric, 3 positions; display-only.

Suspd (Suspended)

The total number of pick slips that have been suspended. This is the number of pick slips that are in a Suspended (S) status.

Numeric, 3 positions; display-only.

Outsd (Outstanding)

The total number of pick slips that have been printed, but not yet confirmed. This is the number of pick slips that are in a Manifest (M) or Carryover (O) status.

Numeric, 3 positions; display-only.

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 (in user date format); display-only.

Confirmed

The date the pick was shipped and billed.

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

Status

The status of this pick.

Valid values:

• Open

• Submitted to async

• Billing pending

• Confirmed

• Declined authorization

• Async processing error

• Manifest submission

• CarryOver

• Packed

• Reprinted

• Suspended

• Void

• Waiting for Authorization

• Authorized

Optional.

Reprint

The pick control number that has been reprinted.

Numeric, 7 positions; display-only.

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:

• Open

• Submitted to async

• Billing pending

• Confirmed

• Declined authorization

• Async processing error

• Manifest submission

• CarryOver

• Packed

• Reprinted

• Suspended

• Void

• Waiting for Authorization

• Authorized

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.

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 (in user date format, HHMMSS format); display-only.

By

The process that created the Pick Control Header record. From the Last update by user field in the Pick Control Header table. See Creating Pre-Generated Picks for a list of processes.

Alphanumeric, 10 positions; display-only.

Date/time printed

The date and time this pick was printed.

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

Date/time assigned (Picker)

The date and time this pick was assigned to a picker. Not currently implemented.

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

Date/time assigned (Packer)

The date and time this pick was assigned to a packer. Not currently implemented.

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

Picker/packer code

A code that represents an inventory picker or packer in your warehouse. Not currently implemented.

Alphanumeric, 3 positions; display-only.

Assigned packer

A code that identifies the packer assigned to this pick. Not currently implemented.

Alphanumeric, 3 positions; display-only.

# of labels

The total number of labels printed for this pick slip. 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, 3 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 table 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

• Selected = Indicates that this pick slip should be included on the Sales Journal report.

• Unselected = Indicates that this pick should not be included on the Sales Journal report.

# 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. Validated against the Ship Via table.

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 table; see 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 table.

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.

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. 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. Does not include any additional charges associated with shipping the order. 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. The total of the additional freight charges defined for the shipper(s). Additional freight charges are defined in the Ship Via table.

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. The full total of the handling charges for each item multiplied by the quantity ordered. The SKU/Offer table 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. 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 Entering Orders 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 table, which is accessible through the Work with Countries menu option; see Setting Up the Country Table (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. Used to determine shipping charges.

Valid values:

• Business

• Residential

Display-only.

PO box?

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.

• Selected = the shipper delivers packages to post office boxes.

• Unselected = the shipper does not deliver packages to post office boxes.

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, three 4-position fields; display-only.

Quantity printed

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

Numeric, 5 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.

Ship-to #

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, three 4-position fields; 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. 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 table 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. 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 table 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. 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. 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. 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 Setting Up the Zip/City/State (Postal Code) Table (WZIP) and 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)

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.

• selected = This order detail line affects inventory count.

• unselected = This order detail line does not affect inventory count.

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)

Indicates whether or not this order detail line requires special handling.

• selected = This order detail line requires special handling.

• unselected = This order detail line does not require special handling.

Whs

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

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, 3 positions; display only.