Message

source

alpha

25

CWDirect

target

alpha

25

CWintegrate

type

alpha

25

CWPickOut

date_created

numeric

8

time_created

numeric

6

PickHeader

Most of the attributes in the PickHeader element are derived from the Pick Control Header file (FLPCTH).

transaction_type

alpha

1

Indicates whether this is a pick slip or a request to void a pick slip. Valid values are:

A = Add: Pick slip

D = Delete: Void. Void requests include only the source, target, type, date_created, time_created, transaction_type, company, pick_nbr, and pick_status. See the Sample CWPickOut message (Void Pick Slip).

company

numeric

3

The company that generated the pick slip.

pick_nbr

numeric

7

The pick control number.

pick_status

alpha

1

The status of the pick slip. Possible statuses are:

M = manifest submission

V = void

Not included if you do not use PC manifesting.

nbr_labels

numeric

3

The number of labels printed on the pick slip, as specified by the Number of Pick Control Labels (D47) system control value.

billing_batch_nbr

numeric

7

The billing batch number assigned by the system to a group of pick slips.

date_printed

numeric

8

The date the pick slip was generated (YYYY-MM-DD format).

time_printed

numeric

8

The time the pick slip was generated (HH:MM:SS format).

cart_batch_nbr

numeric

3

The cart batch number, if any. See Using Cart/Bin Picking for an overview.

pick_zone1

alpha

1

The warehouse zone(s) containing items on the pick slip. See Sorting Pick Slips for more information on how the system uses warehouse zones when sorting pick slips.

pick_zone2

alpha

1

pick_zone3

alpha

1

pick_zone4

alpha

1

pick_zone5

alpha

1

pick_zone6

alpha

1

nbr_lines

numeric

3

The total number of separate lines on the pick slip, each for one or more units of an item.

gen_type

alpha

1

The type of pick slip generation. Possible types are:

R = regular

D = drop ship

S = special handling

M = master pick ticket

po_nbr

alpha

15

The purchase order number, if any, entered at the order header.

merch_amt

numeric

7.2

The total merchandise value of all items shipping on the pick slip, after applying any discounts or repricing. This total does not include backordered, held, or drop ship items, even if they are printed on the pick slip, if they are not included in this shipment. Also, this total does not include canceled or soldout items.

freight_amt

numeric

7.2

The total freight, if any, to charge for the shipment. The Prorate Freight Charges (D39) system control value controls whether to include the total order-level freight charge on the initial shipment if there is more than one shipment for an order.

addl_freight_amt

numeric

7.2

The total amount in the additional freight bucket, if any, for the shipment. The additional freight amount is included for every pick slip printed for the order.

addl_charge_amt

numeric

7.2

The total additional charge amount for the order ship-to. This can be a negative amount if an additional charge code was used to add a discount to the order.

hand_charge_amt

numeric

7.2

The total special handling charges for this shipment.

tax_amt

numeric

7.2

The total tax amount for this pick shipment.

gst_amt

numeric

7.2

The total Canadian GST (goods and services tax) amount, if any, for the shipment.

pst_amt

numeric

7.2

The total Canadian PST (provincial services tax) amount, if any, for the shipment.

amt_paid

numeric

11.2

The total amount prepaid against the order in prepaid pay types (payment category 1) and coupon/credit pay types (payment category 5). This amount is included for each pick slip for the order.

total_order_amt

numeric

11.2

The total value of the shipment, including merchandise, freight, additional freight, handling, tax, and additional charges.

Note: If the additional charge amount represents a discount, it is subtracted from the other amounts to produce the total order amount for the shipment.

balance_due_amt

numeric

11.2

The total amount of any refund due to the customer (positive amount) or balance due (negative amount).

first_pick

alpha

1

Indicates whether this is the first pick slip for a particular order detail line. Valid values are:

Y = This is the first pick slip for the order detail line

N = This is not the first pick slip for the order detail line

This flag is set to N only if you have previously shipped a partial quantity of an order detail line, and are now shipping an additional quantity for that line, but not making any initial shipments for any other order lines.

Example: An order includes an order detail line with a quantity of 10. Five of the units are reserved and five are backordered. The first pick slip includes the five reserved units. Subsequently, you receive a purchase order for the item and the remaining five units are reserved. If you print a pick slip for just those five units, then this flag is set to N; however, if the pick also includes a first shipment for another order detail line, this flag is set to Y.

alternate_pick_nbr

alpha

30

The PkMS control number as defined in the PkMS Pick # number assignment wheel. Used only if you use PkMS (the Use PkMS Interface Values (F31) system control value is Y).

If the Use PkMS Interface Values (F31) system control value is N and a value is defined in the UPS Identifier and Account Number (K57) system control value, the system populates this field with the UPS tracking number, if your unique pick program supports it. See this system control value for more information.

master_carton_nbr

numeric

7

If the pick slip is part of a master carton, this is the master carton pick slip number; otherwise, it is the same as the pick_nbr.

pending_invoice_nbr

numeric

7

Included only if the Generate Invoice Number at Pick Gen (H80) system control value is set to Y.

master_carton_pick

alpha

1

Indicates if this is a master pick slip, which displays the sold to customer’s name and address and the order totals across all ship to customers on the order. You can choose to generate a master pick slip for business to business (B2B) orders. Valid values are:

Y = This is a master pick slip

N = This is not a master pick slip

See Master Pick Slips for more information.

store_restock

alpha

1

Not currently implemented.

master_label_order

alpha

1

Indicates if this is part of a master label order. Valid values are:

Y = This is a part of a master label order (either the master pick slip itself, or an included pick slip)

N = This is not part of a master label order

See Master Pick Slips for more information.

order_nbr

numeric

8

The unique number identifying the order.

order_shipto_nbr

numeric

3

A number identifying the shipping address on the order. Set to 1 if there is only one shipping address.

sold_to_customer_nbr

numeric

9

The unique number identifying:

• the sold to customer receiving the order, if you added a recipient using F2 or F19 in order entry; otherwise,

• the sold to customer who placed the order

ship_to_customer_nbr

numeric

3

Not currently implemented.

The following ship-to name and address attributes are derived from:

• an order-level shipping address (F14), if any; otherwise,

• a permanent customer ship-to address (F7), if any, otherwise,

• a recipient customer (F2 or F19), if any, otherwise,

• a sold-to customer who placed the order.

For more information: See:

• Assigning an Order Shipping Address

• Using a Permanent Shipping Address

• Adding a Recipient Order

• Entering Orders Using Header Format

ship_to_prefix

alpha

3

ship_to_fname

alpha

15

ship_to_initial

alpha

1

ship_to_lname

alpha

25

ship_to_suffix

alpha

3

ship_to_company

alpha

30

ship_to_apt

alpha

10

ship_to_addr1

alpha

32

ship_to_addr2

alpha

32

ship_to_addr3

alpha

32

ship_to_addr4

alpha

32

ship_to_country

alpha

3

ship_to_country_name

alpha

30

ship_to_city

alpha

25

ship_to_state

alpha

2

ship_to_state_name

alpha

25

ship_to_postal_code

alpha

10

ship_to_delivery_code

alpha

1

ship_to_day_phone

alpha

14

ship_to_day_ext

alpha

4

ship_to_eve_phone

alpha

14

ship_to_eve_ext

alpha

4

ship_to_email_address

alpha

50

ship_via

numeric

2

The shipper specified at the order header, or applied during pick slip generation. See Working with Ship Via Codes (WVIA) for more information.

ship_via_desc

alpha

30

The description of the ship via.

drop_point

numeric

3

The drop point specified for the warehouse, or for the warehouse/ship via/SCF combination if you are using zone skipping. See the Work with Ship Via Indicia Screen for an overview.

indicia

alpha

30

The indicia number specified for the ship via indicia, if any. See the Work with Ship Via Indicia Screen.

indicia_desc

alpha

30

The first line of the indicia description if a ship via indicia applies. This is the Indicia description 1 field. See the Work with Ship Via Indicia Screen for more information.

whse

numeric

3

The warehouse shipping the item(s).

whse_company

numeric

3

The company associated with the warehouse. The whse_company may differ from the company if you use inventory sharing. See Inventory Sharing (A69) for an overview.

HAZ_Code

numeric

2

The hazard code, if any, assigned to the item(s) on the pick slip. Included only if all the items on the pick slip have the same hazard code. See Working with Hazardous Item Codes (WHAZ) for more information.

HAZ_Description

alpha

40

The description of the hazard code.

HAZ_Class

alpha

15

The Class specified for the hazard code.

HAZ_Label_type

alpha

15

The Label type specified for the hazard code.

msg_code

alpha

2

The Pick message code, if any, specified at the Pick Slip Generation (2 of 2) Screen, as set up through Working with Pick Slip Messages (WPSM).

Note: The text of the message is included in the PickHeaderMsg element only if there is also an order-level message flagged to print on the pick slip.

pick_weight

numeric

7.3

The total weight of items on the pick slip, calculated based on the per-unit ship weight of the item or SKU. See Performing Initial Item Entry (MITM) for more information.

pick_cube_size

numeric

11.2

The total cube size of items on the pick slip, calculated based on the per-unit cube factor of the item or SKU. See Performing Initial Item Entry (MITM) for more information.

reprint

alpha

1

Set to Y if this is a reprinted pick slip; otherwise, not included. See Reprinting and Voiding Pick Slips (WVRP) for more information.

reprint_pick_nbr

numeric

7

The original pick slip number for a reprinted pick slip.

pay_type

numeric

2

The code for the pay type on the order, as set up through Working with Pay Types (WPAY). If there is more than one payment method on the order, this attribute reads MULTIPLE PAY TYPES.

pay_type_desc

alpha

30

The description of the pay type on the order. Included only if there is just a single payment method on the order.

pay_category

numeric

1

The category of the pay type on the order. Included only if there is just a single payment method on the order.

Possible pay categories are:

• 1: Cash/Check

• 2: Credit Card (including stored value card, Bill Me Later, direct bank disbursement, or a debit card such as a Switch card)

• 3: A/R

• 4: COD

• 5: Coupon/Credit

CustomerSoldToAddress

Note: The sold-to name and address information below is identical to ship-to name and address information above unless the order uses an order-level shipping address (F14), permanent customer ship-to address (F7), or recipient customer (F2 or F19).

The information in this element is stored in the Customer Sold To file (OECSSL), Customer Sold To Extended file (CSTXNA) and Customer Sold To Phone # file (CSCSP#). See Creating and Updating Sold-to Customers (WCST) for more information.

company

numeric

3

sold_to_customer_nbr

numeric

9

sold_to_alternate_id

alpha

15

sold_to_prefix

alpha

3

sold_to_fname

alpha

15

sold_to_initial

alpha

1

sold_to_lname

alpha

25

sold_to_suffix

alpha

3

sold_to_company

alpha

30

sold_to_apt

alpha

10

sold_to_addr1

alpha

32

sold_to_addr2

alpha

32

sold_to_addr3

alpha

32

sold_to_addr4

alpha

32

sold_to_country

alpha

3

sold_to_country_name

alpha

30

sold_to_city

alpha

25

sold_to_state

alpha

2

sold_to_state_name

alpha

25

sold_to_postal_code

alpha

10

sold_to_delivery_code

alpha

1

sold_to_email_address

alpha

50

sold_to_email_status

alpha

2

sold_to_day_phone

alpha

14

sold_to_day_ext

alpha

4

sold_to_eve_phone

alpha

14

sold_to_eve_ext

alpha

4

sold_to_fax_phone

alpha

14

The third (fax or mobile) number. The Third Phone Number Type (L53) system control value determines whether the third phone number is labeled the Fax or Mobile number on screens and reports.

sold_to_fax_ext

alpha

4

The third (fax or mobile) number extension.

Originator

Note: Included only if there is an individual originator on the order.

The information in this element is stored in the Customer Individual file (CSCIPP). See Creating and Updating Individuals for more information.

company

numeric

3

sold_to_customer_nbr

numeric

9

individual_nbr

numeric

3

individual_prefix

alpha

3

individual_fname

alpha

15

individual_initial

alpha

1

individual_lname

alpha

25

individual_suffix

alpha

3

individual_day_phone

alpha

14

individual_day_ext

alpha

4

individual_eve_phone

alpha

14

individual_eve_ext

alpha

4

individual_fax_phone

alpha

14

The third (fax or mobile) number. The Third Phone Number Type (L53) system control value determines whether the third phone number is labeled the Fax or Mobile number on screens and reports.

individual_fax_ext

alpha

4

The third (fax or mobile) number extension.

individual_mail_stop

alpha

32

individual_email_address

alpha

50

individual_email_status

alpha

2

individual_customer_status

alpha

1

individual_date_of_birth

numeric

8

individual_user_field1

alpha

10

individual_user_field2

alpha

10

individual_user_field3

alpha

10

individual_user_field4

alpha

10

mail_code

alpha

3

mail_code_desc

alpha

40

call_code

alpha

3

call_code_desc

alpha

40

department

alpha

3

department_desc

alpha

30

position

alpha

3

position_desc

alpha

30

Placer

Note: The Placer element includes the same attributes as the Originator, and is included only if there is an individual placer on the order. See Creating and Updating Individuals for more information.

CustomerBillToAddress

Note: The bill-to customer information is included if a bill-to is assigned to the sold-to customer for the order, regardless of whether an A/R payment method is used on the order.

The information in this element is stored in the Customer Bill To file (CSCBIL), Customer Bill To Extended file (CBTXNA), and Customer Bill To Phone # file (CSCBT#). See Creating and Updating Bill-to Customers (WCBT) for more information.

company

numeric

3

bill_to_customer_nbr

numeric

7

bill_to_prefix

alpha

3

bill_to_fname

alpha

15

bill_to_initial

alpha

1

bill_to_lname

alpha

25

bill_to_suffix

alpha

3

bill_to_company

alpha

30

bill_to_apt

alpha

10

bill_to_addr1

alpha

32

bill_to_addr2

alpha

32

bill_to_addr3

alpha

32

bill_to_addr4

alpha

32

bill_to_city

alpha

25

bill_to_state

alpha

2

bill_to_state_name

alpha

25

bill_to_postal_code

alpha

10

bill_to_country

alpha

3

bill_to_country_name

alpha

30

bill_to_day_phone

alpha

14

bill_to_day_ext

alpha

4

bill_to_eve_phone

alpha

14

bill_to_eve_ext

alpha

4

bill_to_fax_phone

alpha

14

The third (fax or mobile) number. The Third Phone Number Type (L53) system control value determines whether the third phone number is labeled the Fax or Mobile number on screens and reports.

bill_to_fax_ext

alpha

4

The third (fax or mobile) number extension.

bill_to_email_address

alpha

50

bill_to_email_status

alpha

2

bill_to_delivery_code

alpha

1

OrderHeader

The information in this element is stored in the Order Header file (OEORDR) and the Order Header Extended file (OEOHEP). See Reviewing the Order Inquiry Header Screen.

transaction_type

alpha

25

Not currently implemented.

company

numeric

3

The company associated with the order generating the pick slip.

order_nbr

numeric

8

A unique number to identify the order.

order_status

alpha

1

Not implemented in the CWPickOut message.

nbr_recipients

numeric

3

The total number of shipping addresses on the order.

order_date

numeric

8

YYYY-MM-DD format.

entered_date

numeric

8

YYYY-MM-DD format.

entered_time

numeric

6

HH:MM:SS format.

freight_amt

numeric

7.2

Not currently implemented.

freight_balance_amt

numeric

7.2

Not currently implemented.

user_date

numeric

8

Not implemented in the CWPickOut message.

order_channel

alpha

1

Indicates the order channel, such as retail or e-commerce. Typically populated only for orders you receive from an external source, such as the generic order API or the e-commerce interface.

store_restock

alpha

1

Indicates whether the order is a retail store restock order.

The system automatically sets this field to Y when you create a retail store restock order in Working with Retail Store Restock (WRSR).

Valid values are:

Y = This is a retail Store restock order

N = This is not a retail store restock order

email_confirm_date

numeric

8

YYYY-MM-DD format. Included only when the system has generated an automatic email confirmation. See When Does the System Generate an Email Notification?

The confirmation can consist of an actual email message, or it can be the Outbound Email XML Message (CWEmailOut).

bill_to_customer_nbr

numeric

7

Included if a bill-to account is assigned to the sold-to customer.

user_hold_reason

alpha

2

Not implemented in the CWPickOut message.

system_hold_reason

alpha

2

Not implemented in the CWPickOut message.

sold_to_customer_nbr

numeric

9

A unique number to identify the sold-to customer who placed the order.

membership_id

alpha

12

The membership program that generated the order. Included only for membership orders generated through the Generating Membership Orders (EGMO) menu option.

membership_seq_nbr

numeric

3

A unique number to identify a customer membership for a single sold-to customer and membership program. This sequence number makes it possible to create multiple customer memberships in the same membership program for a customer. Included only for membership orders generated through the Generating Membership Orders (EGMO) menu option.

batch_nbr

numeric

5

A unique number to identify an order batch. Included only if the order was generated as part of a batch.

order_type

alpha

1

From the Order Type file. See Establishing Order Types (WOTY).

order_type_desc

alpha

30

The description of the order type.

sales_rep_nbr

numeric

7

The salesrep number, if any, specified for the order. See Working with Sales Representatives (WSLS) for more information.

source

alpha

7

The source code from the order header. See Entering Orders Using Header Format for more information on how the source code controls the freight, discounting, currency, and other factors on an order.

entered_by_user

alpha

10

Not implemented in the CWPickOut message.

customer_class

numeric

2

The customer class used to identify and track a group of customers. See Setting Up the Customer Class File (WCCL) for more information.

originator_nbr

numeric

3

The individual originator number, if any, for the order. Specifying an individual originator is always optional, even if the Individuals Required in Order Entry (E01) system control value is set to Yselected. See the Select Individuals for an Order Screen for more information.

placer_nbr

numeric

3

The individual placer number, if any, for the order. Specifying a placer for an order is required if the Individuals Required in Order Entry (E01) system control value is set to Y. See the Select Individuals for an Order Screen for more information.

alternate_order_id

alpha

30

The number used to identify the order in a remote system, such as CWStore. From the E-comm order number in the Order Header Extended file, displayed as the Alt ord # at the Display Order Properties Screen. Included only if this field is populated, such as through the generic order API or the e-commerce interface.

currency_code

alpha

3

The code identifying the currency on the order, as set up through Working with Currency (WCUR). Included only if the Multi Currency by Offer (E03) system control value is set to Y.

currency_desc

alpha

30

The description of the currency, as set up through Working with Currency (WCUR).

currency_rate

alpha

The currency Conversion rate, as set up through Working with Currency (WCUR).

email_address

alpha

50

The order-level email address, if any. See Working with an Order-Level Email Address for more information on how the system selects this email address.

OrderShipTo

While some information on an order, such as payment methods, is stored at the header level, the information in the OrderShipTo can vary for each shipping address on the order. The information in this element is stored in the Order Ship To file (OEORST). See Reviewing the Order Inquiry Header Screen for more information on individual fields.

company

numeric

3

The company that generated the pick slip.

order_nbr

numeric

8

The order number associated with the pick slip.

order_shipto_nbr

numeric

3

A number identifying the shipping address on the order. Set to 1 if there is only one shipping address.

shipto_status

alpha

1

Not implemented in the CWPickOut message.

tax_code

alpha

1

The code indicating the order’s tax status. Valid values are:

T = Standard tax

N = Non taxable

R = Resale

E = Exempt

G = GST only

P = PST only

See Working with Customer Tax Status for more information.

addl_charge_amt

numeric

7.2

The total additional charges for this shipping address. If there are both positive and negative additional charges, this amount is the net.

addl_charge_balance_amt

numeric

7.2

The total amount of the additional charges for this shipping address that have not yet been billed.

arrival_date

numeric

8

The date the customer requested to receive the order. The order date defaults, but you can override it.

cancel_bo

alpha

1

A code that identifies whether items that are unavailable (backordered) should be canceled automatically with the first shipment on the order.

Valid values are:

Y = Cancel backordered items with first shipment.

N = (default): do not cancel backordered items.

cancel_date

numeric

8

The date the customer wants the order canceled if it has not been shipped. The system stops trying to reserve merchandise for this order a predefined number of days before the cancel date. The order is not canceled automatically, but is listed on the Order Cancellation List.

contact_name

alpha

30

The name of the person who should receive the package; your entry at the Attention field in order entry.

est_freight_amt

numeric

7.2

The Estimated freight, if any, entered at the Work with Order Ship to Properties Screen. See that screen for more information.

fedex_nbr

alpha

10

The Federal express #, if any, entered at the Work with Order Ship to Properties Screen. See that screen for more information.

freight_amt

numeric

7.2

The total freight charges for this shipping address.

freight_balance_amt

numeric

7.2

The unpaid freight charges for this shipping address.

gift_order

alpha

1

A code that identifies whether the order is a gift order. If the order is a gift:

• item prices do not print on the pick slip

• the system generates a gift acknowledgment card to notify the sold-to customer who placed the order that the order has been shipped

• a SmartLabel does not print if on the pick slip if you use SmartLabel returns processing. See Using SmartLabel Returns Processing.

Valid values are:

Y = This is a gift order.

N = This is not a gift order.

hand_charge_amt

numeric

7.2

The total special handling charges for the shipping address.

hand_balance_amt

numeric

7.2

The total special handling charges for the shipping address that have not yet been billed.

merch_amt

numeric

9.2

The total dollar value of all items for this shipping address based on the actual selling price.

merch_balance_amt

numeric

9.2

The total merchandise value for the shipping address that has not yet been billed.

resale_exemption_nbr

alpha

15

The number of the certificate that identifies the customer as a reseller or tax exempt. This number is required when the customer's tax code equals R (Reseller) or E (Exempt).

ship_complete

alpha

1

A code that determines whether all the items on an order must ship together. Valid values are:

Y = Ship all items on the order in one shipment; delay printing pick slips until all items are available in the requested quantities.

N = (default): Items on the order ship as soon as they are reserved.

tax_amt

numeric

7.2

The total tax amount for this shipping address.

tax_balance_amt

numeric

7.2

The tax amount for this shipping address that has not yet been billed.

gst_amt

numeric

7.2

The total GST (Canadian goods and services tax) amount for this shipping address.

gst_balance_amt

numeric

7.2

The total GST (Canadian goods and services tax) amount for this shipping address that has not yet been billed.

pst_amt

numeric

7.2

The total PST (Canadian provincial services tax) amount for this shipping address.

pst_balance_amt

numeric

7.2

The total PST (Canadian provincial services tax) amount for this shipping address that has not yet been billed.

po_nbr

alpha

15

The purchase order number under which the order was placed. A purchase order number is required if paying for the order on account (A/R payment type) if the PO Required for A/R Orders (D79) system control value is set to Y.

nbr_lines

numeric

3

The total number of order detail lines for this shipping address.

addl_freight_amt

numeric

7.2

The total additional freight charges for this shipping address.

addl_freight_balance_amt

numeric

7.2

The total additional freight charges for this shipping address that have not yet been billed.

discount_pct

numeric

5.2

The flat discount percentage that applies to the entire order. For example, when you enter a discount percentage at the order header, or it defaults from a membership, this field is updated. Prorated discounts, such as promotions or dollar discounts by source code or offer, do not update this field.

sold_to_customer_nbr

numeric

9

The sold-to customer receiving the order. Included only if it is a different customer than the one who placed the order.

ship_to_customer_nbr

numeric

3

The permanent ship-to customer receiving the order. Included only if the order uses a permanent ship-to address.

hold_reason

alpha

2

Not implemented in the CWPickOut message.

whse

numeric

3

A code that identifies the warehouse from which merchandise on the order will be shipped. A value appears in this field only if it was entered by an operator during order entry or order maintenance.

broker_delivery_type

alpha

1

Set to R if this is a retail pickup order, and set to D if this is a delivery order. Included only for retail pickup or delivery orders fulfilled through the integration with the Order Broker module in Locate 5.1 or higher. See Fulfilling Retail Pickup and Delivery Orders in CWDirect for more information.

Available in XML version: 3.0 in release 18.0 of CWDirect.

ship_via

numeric

2

A code for the shipper. A different ship via may also exist at the item level.

ship_via_desc

alpha

30

The description of the ship via, as set up through Working with Ship Via Codes (WVIA).

line_of_business

alpha

3

The code representing the line of business, if the system has assigned one to the order. See Working with Lines of Business (WLOB).

line_of_business_desc

alpha

40

The description of the line of business.

geographic_zone

alpha

3

The geographic zone where the order is shipping, as set up through Creating and Maintaining Geographic Zones (WGZN). Included only if the Bypass Geographic Zone Searching in Order Entry/Order Maintenance (H55) system control value is set to N.

geographic_zone_desc

alpha

30

The description of the geographic zone.

PickHeaderMsg

Order header messages entered through the Work with Order Messages Screen and flagged with a code of P (print on the pick slip) B (print on both the pick slip and the invoice), or G (gift message) are included in this element. If there is at least one order header message included, the text of the pick slip message is also included. See the msg_code for more information.

seq_nbr

numeric

3

A unique number to identify the pick slip message or order header message. Each message type is numbered separately.

msg_type

alpha

2

Indicates whether this is an order header message or pick slip message. Valid values are:

OH = order header message

PM = pick slip message

msg

alpha

60 (order) or 120 (pick)

The text of the order header or pick slip message.

PickDetail

Which items included? There is a PickDetail element for each order line available to ship with the pick slip, plus items that are backordered, held, have future arrival dates, or drop ship items; however, there is not a PickLocation element for any item that does not also have a printed quantity.

The main set item and each of its component items are all included in the message, with a PickLocation element provided for each.

Canceled and soldout items are not included in the message.

The information in this element is stored in the Pick Control Detail file (FLPCTD). See the Display Pick Control Details Screen for more information.

company

numeric

3

The company that generated the pick slip.

pick_nbr

numeric

7

The pick control number that identifies the pick slip.

pick_line_nbr

numeric

5

A unique number to identify the pick slip line number for the item.

bo_control

alpha

1

Specifies what action should be taken for this line. Set to C (Ship and cancel remainder) only if the Auto-cancel backorder flag was selected in order entry. Otherwise, the system ship any available quantity and puts the remainder on backorder.

original_qty_printed

numeric

5

The quantity available to ship on this pick slip. Included only if the item is available to ship (that is, not backordered, held, a future order, or a drop ship item included on a separate drop ship pick slip or purchase order). Included for both the set component and the set master for set items.

qty_printed

numeric

5

The same as the original quantity printed.

cart_bin_nbr

numeric

3

Included only for items with a printed quantity, and if you are Using Cart/Bin Picking.

line_status

alpha

1

A status of H indicates that the order line is held. Other statuses are not currently implemented.

affect_inventory

alpha

1

Indicates whether shipping this item affects the inventory count. For example, the main set item does not affect inventory, but the set components do. Valid values are:

Y = Affect inventory

N = Does not affect inventory

Not included for items without a printed quantity (held, backordered, drop ship item printed separately, or future arrival date).

selling_price

numeric

7.2

The single-unit selling price of the item after applying any repricing or discounts. Not included for set component items, items flagged as “no charge,” or items without a printed quantity.

selling_price_extended

numeric

11.2

The selling price times the printed quantity. Not included unless both of these values exist.

freight_amt

numeric

7.2

The freight charge for this item on this pick slip. Included only if there is a printed quantity and the source code uses an item-level freight method. See Working with Source Codes (WSRC) for more information.

hand_charge_amt

numeric

7.2

The total special handling charges for the item. Included only if there is a printed quantity.

gift_charge_amt

numeric

7.2

The total giftwrap charge. Included only if there is a printed quantity.

qty_ordered

numeric

5

The original quantity ordered for the order detail line. Always included.

qty_bo

numeric

5

Included for backordered, held, drop ship, and future arrival items.

tax_amt

numeric

10.5

The total tax amount for the item on this pick slip. Included only if there is a selling price included.

gst_amt

numeric

10.5

The total Canadian GST (goods and services tax) amount, if any, for the item on this pick slip. Included only if there is a selling price included.

pst_amt

numeric

10.5

The total Canadian PST (provincial services tax) amount, if any, for the item on this pick slip. Included only if there is a selling price included.

order_nbr

numeric

8

A unique number to identify the order. Always included.

order_shipto_nbr

numeric

3

Identifies the shipping address on the order. Always included.

order_detail_nbr

numeric

5

Identifies the order line number, which may be different from the pick slip line number. Always included.

item

alpha

12

A unique code to identify the item. Always included.

item_desc

alpha

40

The description of the item. Always included.

sku

alpha

14

The item’s unique characteristics, such as its color and size. Always included if the item has SKU’s.

sku_desc

alpha

40

The description of the SKU. Always included if the item has SKU’s.

addl_charge_code

alpha

2

The additional charge code related to special handling, if any. Always included if the item has special handling.

addl_charge_desc

alpha

30

The description of the additional charge code, if any. Always included if the item has special handling.

PickLocation

Note: This element is included only if there is a printed quantity for the item.

The information in this element is stored in the Pick Location file (PCKLOC). See the Display Pick Locations Screen for more information.

company

numeric

3

The company that generated the pick slip.

pick_nbr

numeric

7

The pick control number that identifies the pick slip.

pick_line_nbr

numeric

5

A unique number to identify the pick slip line number for the item.

whse

numeric

3

The warehouse shipping the items.

whse_company

numeric

3

The company associated with the warehouse shipping the item. May be different from the company associated with the order and pick slip if you use inventory sharing. See Inventory Sharing (A69).

whse_zone

alpha

1

The warehouse zone containing the item. See Sorting Pick Slips for more information on how the system uses warehouse zones when sorting pick slips.

whse_location

alpha

7

The location in the warehouse where the item should be picked.

qty_allocated

numeric

5

The same as the printed quantity.

OrderDetail

Note: This element is always included for every pick detail line.

Most of the information in this element is stored in the Order Detail file (OEORDT). See Reviewing Order Inquiry Detail Information for more information.

company

numeric

3

order_nbr

numeric

8

order_shipto_nbr

numeric

3

order_detail_nbr

numeric

5

drop_ship

alpha

1

discount_applied

alpha

1

line_status

alpha

1

no_charge

alpha

1

affect_inventory

alpha

1

arrival_date

numeric

8

cancel_date

numeric

8

coordinate_group

numeric

3

date_printed

numeric

8

date_reserved

numeric

8

discount_amt

numeric

5.2

expected_ship_date

numeric

8

freight_amt

numeric

7.2

future_order

alpha

1

original_price

numeric

7.2

selling_price

numeric

7.2

qty_cancelled

numeric

5

qty_ordered

numeric

5

qty_printed

numeric

5

qty_reserved

numeric

5

qty_shipped

numeric

5

qty_soldout

numeric

5

qty_returned

numeric

5

hand_charge_amt

numeric

7.2

tax_amt

numeric

10.5

gst_amt

numeric

10.5

pst_amt

numeric

10.5

time_reserved

numeric

6

units_confirmed

numeric

5

gift_wrap

alpha

1

cost_override_amt

numeric

11.4

date_entered

numeric

8

time_entered

numeric

6

priority

numeric

1

bo_reason

alpha

1

freight_override

alpha

1

addl_freight_amt

numeric

7.2

offer_price

numeric

7.2

price_method

alpha

1

unit_freight_charge

numeric

7.2

set_main_item

alpha

1

set_seq_nbr

numeric

3

qty_credited

numeric

5

alias

alpha

12

prediscount_amt

numeric

7.2

duty_amt

numeric

7.2

sub_set

alpha

1

sub_set_seq_nbr

numeric

3

warranty_item

alpha

1

needed_by_date

numeric

8

tax_override

alpha

1

sh_exclude_tax

alpha

1

addl_charge_code

alpha

2

addl_charge_desc

alpha

30

item

alpha

12

item_desc

alpha

40

sku

alpha

14

sku_desc

alpha

40

whse

numeric

3

cancel_reason

numeric

2

cancel_reason_desc

alpha

30

offer

alpha

3

ship_via

numeric

2

ship_via_desc

alpha

30

source

alpha

9

price_override_code

alpha

1

price_override_desc

alpha

30

bo_whse

numeric

3

add_on_code

numeric

3

add_on_desc

alpha

40

The del_whse and its associated tags (del_whse_name, del_whse_addr1, del_whse_addr2, del_whse_addr3, del_whse_city, del_whse_state, del_whse_state_name, del_whse_postal_code, del_whse_country, del_whse_country_name, del_whse_phone, and del_whse_manager) represent the HDL assigned to the order line.

An HDL warehouse represents a delivery service provider that provides “white glove” home delivery service. Instead of shipping products directly to the customer, the system sends the products to the HDL, who in turn, delivers the products to the customer. For example, you may wish to use a home delivery service for large items, such as furniture or appliances, that require someone to carry and set up the item in the customer’s home or business.

The system assigns an HDL to an order line if the Include HDL Warehouse Value on Order Detail (J54) system control value is set to Yselected.

See HDL (Home Delivery Service) Processing for more information.

Available in XML version: Version 2.0 (version 10.5 of CWDirect).

del_whse

numeric

3

A code for the HDL assigned to the order line.

From the ODT Future use qty 1 field in the Order Detail file.

Available in XML version: 2.0 (version 10.5 of CWDirect).

del_whse_name

alpha

30

The name of the HDL.

From the Name field in the Warehouse file.

Available in XML version: 2.0 (version 10.5 of CWDirect).

del_whse_addr1

alpha

32

The street address of the HDL.

From the Address field in the Warehouse file.

Available in XML version: 2.0 (version 10.5 of CWDirect).

del_whse_addr2

alpha

32

The second address line of the HDL.

From the Address line 2 field in the Warehouse file.

Available in XML version: 2.0 (version 10.5 of CWDirect).

del_whse_addr3

alpha

32

The third address line of the HDL.

From the Address line 3 field in the Warehouse file.

Available in XML version: 2.0 (version 10.5 of CWDirect).

del_whse_city

alpha

25

The city for the HDL address.

From the City field in the Warehouse file.

Available in XML version: 2.0 (version 10.5 of CWDirect).

del_whse_state

alpha

2

The state for the HDL address.

From the State field in the Warehouse file.

Available in XML version: 2.0 (version 10.5 of CWDirect).

del_whse_state_name

alpha

25

The name of the state.

From the Description field in the State file.

Available in XML version: 2.0 (version 10.5 of CWDirect).

del_whse_postal_code

alpha

25

The postal code for the HDL address.

From the Zip code field in the Warehouse file.

Available in XML version: 2.0 (version 10.5 of CWDirect).

del_whse_country

alpha

3

The country code for the HDL address.

From the RPR Country field in the Warehouse file.

Available in XML version: 2.0 (version 10.5 of CWDirect).

del_whse_country_name

alpha

30

The name of the country.

From the Description field in the Country file.

Available in XML version: 2.0 (version 10.5 of CWDirect).

del_whse_phone

numeric

12

The phone number for the HDL.

From the Phone field in the Warehouse file.

Available in XML version: 2.0 (version 10.5 of CWDirect).

del_whse_manager

alpha

30

The name of the manager at the HDL.

From the Manager field in the Warehouse file.

Available in XML version: 2.0 (version 10.5 of CWDirect).

Item

Note: This element is always included for every pick detail line.

The information in this element is stored in the Item file. See Performing Initial Item Entry (MITM) for more information.

Transaction_type

Company

numeric

3

Item_Number

alpha

12

Allow_SKUs

alpha

1

Item_average_cost

numeric

11.4

ITM_Cubing_value

numeric

7.1

Drop_ship_item

alpha

1

FIFO_cost

numeric

11.4

Item_height

numeric

3

Kit_type

alpha

1

Item_length

numeric

3

Long_SKU_style

alpha

20

Long_SKU_vendor

alpha

7

Lot_Nbr_tracking

alpha

1

Not currently implemented.

Non-inventory

alpha

1

Partial_units

alpha

1

Pieces_per_case

numeric

5

Selling_qty

numeric

5

Selling_weight

numeric

7.3

Serial_Nbr_tracking

alpha

1

Ship_alone

alpha

1

Ship_weight

numeric

7.3

Standard_cost

numeric

11.4

User_field_1

alpha

10

User_field_2

alpha

10

User_field_3

alpha

10

User_field_4

alpha

10

Width

numeric

3

Expiration_limit

numeric

5

FIFO_Tracking

alpha

1

ITM_Allow_Pct_discount

alpha

1

CasePiece

alpha

1

ITM_Oversize_flag

alpha

1

ITM_Description

alpha

40

ITM_Required_truck_item

alpha

1

ITM_Second_Language_

Desc

alpha

40

ITM_Exclude_From_Flex_

Pay

alpha

1

ITM_Royalty

alpha

1

ITM_Membership

alpha

1

ITM_Generic_Ecommerce

alpha

20

ITM_Last_Ecomm_Info_

Chg

numeric

8

ITM_Qty_Threshold

numeric

9

ITM_Create_Date

numeric

8

ITM_Retail_Style_Nbr

alpha

20

Buyer

alpha

3

Buyer_Name

alpha

30

CTN_ID_Nbr

numeric

2

GLA_Account_Nbr

numeric

8

Inventory_Value_GLNbr

numeric

8

HAZ_Code

numeric

2

HAZ_Description

alpha

40

HAZ_Class

alpha

15

HAZ_Label_type

alpha

15

Item_class

alpha

3

ICL_Description

alpha

30

ICL_Commission_Pct

numeric

5.2

ICL_Estimated_Frt

numeric

7.2

ICL_Estimated_Frt_Pct

numeric

5.2

ICL_Desired_GM_Pct

numeric

5.2

ICL_Vat_Exempt

alpha

1

ICL_Hidden_Tax_Amount

numeric

11.2

ICL_Qty_Threshold

numeric

5

ICL_Hidden_Tax_Pct

numeric

5.2

CRV_Code

numeric

3

ICL_GLA_Account_Nbr

numeric

8

Discount_GLA_Account_

Nbr

numeric

8

Return_GLA_Account_

Nbr

numeric

8

Return_Discount_GLA_

Accou

numeric

8

ICL_Cost_Good_Sold_

GL_Nbr

numeric

8

ICL_Cost_Good_Rtn_GL_

Nbr

numeric

8

Cycle

alpha

2

CYC_Days

numeric

5

CYC_Description

alpha

30

SKU_group

numeric

3

SKU_group_description

alpha

30

Item_status

alpha

1

Item_status_description

alpha

30

IST_Message_line_1

alpha

50

IST_Message_line_2

alpha

50

IST_Return_disposition

alpha

2

LCL_Location_class

alpha

2

LCL_Description

alpha

30

Long_SKU_class

numeric

4

LSC_Description

alpha

30

LSD_Department

numeric

4

LSD_Description

alpha

30

LSD_Long_Sku_Division

alpha

3

Long_SKU_Div_

Description

alpha

30

Unit_of_measure

alpha

3

UOM_Description

alpha

30

UOM_Units

numeric

5

Vendor_Nbr

numeric

7

VIA_Ship_via_code

numeric

2

VIA_Shipper_name

alpha

30

Warehouse

numeric

3

Warehouse_name

alpha

30

Manufacturer_Vendor

numeric

7

ITM_ENT_Entity_Number

numeric

3

ENT_Description

alpha

30

ITM_SEA_Season

alpha

3

SEA_description

alpha

30

SEA_Start_date

numeric

8

SEA_End_date

numeric

8

SKU

Note: This element is included for every pick detail line for a SKU’d item.

The information in this element is stored in the SKU file. See Performing Initial Item Entry (MITM) for more information.

SKU_Code

alpha

14

Collating_sequence_Nbr

numeric

5

Compatibility

alpha

3

SKU_Cubing_value_

override

numeric

7.1

SKU_Description

alpha

40

SKU_Subscription

alpha

1

Height_override

numeric

3

Length_override

numeric

3

List_price

numeric

7.2

Long_SKU_color

numeric

5

Long_SKU_size

numeric

5

Long_SKU_width

numeric

5

Lowest_price

numeric

7.2

Max_qty_for_location

numeric

7

Max_qty_for_warehouse

numeric

7

Min_qty_for_location

numeric

7

Min_qty_for_warehouse

numeric

7

SKU_Gift_certificate

alpha

1

Out_of_stock_flag

alpha

1

Qty_order_direct_ship

numeric

7

Receipt_date

numeric

8

Reserve_qty_limit

numeric

7

Restrict_orders

alpha

1

Retail_reference_Nbr

numeric

15

Out_of_stock_date

numeric

8

Selling_weight_override

numeric

7.3

Short_SKU

numeric

7

User_field_1

alpha

10

User_field_2

alpha

10

User_field_3

alpha

10

Weight_override

numeric

7.3

Width_override

numeric

3

Sale_credit_flag

alpha

1

Harmonize_code

alpha

16

SKU_Coordinate_group

numeric

3

SKU_Open_qty

numeric

7

SKU_Future_qty

numeric

7

SKU_Suspense_qty

numeric

7

SKU_On_hold_qty

numeric

7

SKU_Standard_Cost

numeric

11.4

SKU_Second_Language_

Desc

alpha

40

SKU_VAT_Exempt_flag

alpha

1

SKU_Second_compatibility

alpha

3

SKU_Hidden_tax_amount

numeric

7.2

SKU_Hidden_tax_percent

numeric

5.2

SKU_Suppress_BO_Card

alpha

1

SKU_Projected_Returns

numeric

7

SKU_User_field_4

alpha

5

SKU_User_field_5

alpha

5

SKU_Book_Inventory

numeric

7

SKU_Returnable

alpha

1

SKU_Retail_X-Ref_Nbr

numeric

10

SKU_LS_Style

alpha

20

SKU_LS_Vendor

alpha

7

SKU_Receiving_Priority

alpha

2

SKU_Excl_Store_Restock

alpha

1

SKU_Generic_Ecommerce

alpha

10

SKU_Last_Download_Qty

numeric

5

SKU_Last_Extract

numeric

8

SKU_Last_Ecomm_Info_

Chg

numeric

8

SKU_SVC_Card_Reload

alpha

1

SKU_Original_Retail_

Price

numeric

7.2

SKU_Create_Date

numeric

8

SKU_GTIN_Nbr

numeric

14

SKU_Commodity_Code

numeric

8

ABC_Code

alpha

1

ABC_First_order

numeric

5

Percentage_of_Sales

numeric

5.2

New_item_flag

alpha

1

CTN_ID_Nbr

numeric

2

Frequency_code

alpha

1

Percentage_of_picks

numeric

5.2

Warehouse

numeric

3

Warehouse_name

alpha

30

Location

alpha

7

SLC_Code

alpha

2

SLC_Description

alpha

30

SLC_Status

numeric

1

Unit_of_measure

alpha

3

UOM_Description

alpha

30

UOM_Units

numeric

5

SKU_Element_1_Code

alpha

4

SKU_Element_1_Desc

alpha

10

SKU_Element_1_Name

alpha

4

SKU_Element_2_Code

alpha

4

SKU_Element_2_Desc

alpha

10

SKU_Element_2_Name

alpha

4

SKU_Element_3_Code

alpha

4

SKU_Element_3_Desc

alpha

10

SKU_Element_3_Name

alpha

4

SKU_IST_Item_status

alpha

1

Item_status_description

alpha

30

IST_Message_line_1

alpha

50

IST_Message_line_2

alpha

50

IST_Return_disposition

alpha

2

SKU_ITC_Category

alpha

4

Item_category_description

alpha

30

SKU_PRP_Prep_Code

alpha

2

PRP_Description

alpha

30

SKU_Country_of_Origin

alpha

3

Country_description

alpha

30

SKU_LSC_LS_Class

numeric

4

LSC_Description

alpha

30

SKU_ZRC_Zone_

Reservation

alpha

4

UPC

Note: This element is included only if there are any UPC codes defined for the item on the pick detail line.

The information in this element is stored in the Item UPC file. See Work with UPC Codes Screen for more information.

UPC_Type

alpha

3

UPC

numeric

14

UPC_VND_Vendor

numeric

7

PickDetailMsg

Note: This element is included if there are any of the following for the pick detail line:

• SKU comments (see the Work with Item/SKU Comments Window)

• special handling instructions (see the Display Special Handling Screen and the Display Custom Special Handling Screen)

• order line messages (see the Work with Order Line Messages Screen)

pick_line_nbr

numeric

5

Identifies the line number of the PickDetail.

seq_nbr

numeric

3

A unique number to identify the pick detail message line. Numbering restarts for each separate msg_type.

msg_type

alpha

2

Valid values are:

• OL = order line message

• SC = SKU comments

• SH = special handling

msg_label

alpha

Not currently implemented.

msg

alpha

30

The message text.