Carryover/Billing Pending Report | Contents | SCVs | Search | Glossary | Reports | XML | Index | Chapter 12: Pick Print Eligibility (WPPE) |
Chapter 11: Generic Pick Out API
Purpose: Use the generic pick out API to generate an outbound pick slip message. This message is available for integration through the scancode site in CWIntegrate, or for your own unique integration.
About the message: The CWPickOut message produced for a new or reprinted pick slip includes the entire contents of each of the files related to the pick slip. For example, for each item included on the order, the CWPickOut message includes the contents of the Item and SKU files. Your integration might not require all of the information in the message, and can omit any unneeded information when mapping the message to another system.
Which items included? Other items on the order are included in the CWPickOut message even if they are not ready to ship because they are backordered, held, or drop shipments; however, the message does not include any pick location details for items that are not included on the pick slip.
The pick slip does not include any information on canceled or soldout items.
In this chapter:
• Sample CWPickOut Message (New or Reprinted Pick Slip)
• Sample CWPickOut message (Void Pick Slip)
• Pick Message from CWDirect (CWPickOut)
The system generates a trigger record of type PCH when you generate pick slips if the Create Generic Pick Download Triggers (I31) system control value is set to Y. The PICK_OUT process in Working with Integration Layer Processes (IJCT) generates the Pick Message from CWDirect (CWPickOut) for each of these trigger records.
When generating the outbound message, the PICK_OUT process uses trigger rules and XML inclusion settings as described below.
Trigger rules: You can set a trigger rule for the pick out API based on the company number specified in the Pick Control Header file. See Defining Outbound Interface Trigger Rules for more information.
XML inclusion: As with other outbound messages generated through Working with Integration Layer Processes (IJCT), you can use the Outbound Interface XML Inclusion Screen to exclude elements and their contents from the Pick Message from CWDirect (CWPickOut). The XML inclusion options for the generic pick download are:
PickHeader
CustomerSoldToAddress
Originator
Placer
CustomerBillToAddress
OrderShipTo
PickHeaderMsgs
OrderHeader
PickDetail
PickLocation
Item
SKU
UPC
OrderDetail
PickDetailMsgs
If you choose to exclude an element, all of the subordinate elements and attributes of that element will also be excluded. For example, if you choose to exclude the CustomerSoldToAddress element, the message will not include the Originator or Placer elements.
If you exclude the PickHeader element, the message will not include any information.
Note: XML inclusion settings are not specific to a company. Any XML inclusion settings you create apply to all companies for which you generate trigger records.
Pick slip information is transmitted as follows:
CWDirect:
• You generate pick slips using Working with Pick Slip Generation (WPSG) or Selecting Vendors for Drop Ship Processing (MDSP).
• The PICK_OUT process in Working with Integration Layer Processes (IJCT) creates a trigger record for each pick slip with a record type of PCH (pick control header). You can review the trigger records at the Work with Outbound Interface Transactions Screen.
Note: Optionally, you can use trigger rules for the PICK_OUT process to restrict trigger creation to one or more specific companies.
• The PICK_OUT process creates a trigger XML message based on trigger record, and then resets the trigger record to processed (X) status.
• The Java helper for the PICK_OUT process creates the Pick Message from CWDirect (CWPickOut).
Void transactions: When you void a pick slip, the PICK_OUT process sends a CWPickOut message indicating to delete the pick slip.
Re-sending transactions: You can re-send a CWPickOut message by resetting the status of its trigger record at the Work with Outbound Interface Transactions Screen.
Sample CWPickOut messages are presented below:
• Sample CWPickOut Message (New or Reprinted Pick Slip)
• Sample CWPickOut message (Void Pick Slip)
Sample CWPickOut Message (New or Reprinted Pick Slip)
<Message source="CWDirect" target="CWIntegrate" type="CWPickOut" date_created="2004-03-29" time_created="17:36:19">
<PickHeader transaction_type="A" company="27" pick_nbr="3457756" pick_status="M" nbr_labels="2" billing_batch_nbr="1486" date_printed="2004-03-29" time_printed="17:36:06" cart_batch_nbr="516" pick_zone1="C" nbr_lines="1" gen_type="R" merch_amt="25.00" freight_amt="2.50" addl_freight_amt="1.23" tax_amt="1.44" total_order_amt="30.17" first_pick="Y" master_carton_nbr="3457756" master_carton_pick="N" master_label_order="N" order_nbr="10049" order_shipto_nbr="1" sold_to_customer_nbr="1057" ship_to_prefix="MS." ship_to_fname="ARIEL" ship_to_lname="PIONUS" ship_to_addr1="257 LOVELL STREET" ship_to_country="USA" ship_to_country_name="UNITED STATES" ship_to_city="WORCESTER" ship_to_state="MA" ship_to_state_name="MASSACHUSETTS" ship_to_postal_code="01602" ship_to_delivery_code="R" ship_via="1" ship_via_desc="Large Thumb Inc." drop_point="1" whse="2" whse_company="27" msg_code="01" pick_weight="2.500" pay_type="5" pay_type_desc="VISA" pay_category="2">
<CustomerSoldToAddress company="27" sold_to_customer_nbr="1057" sold_to_prefix="MS." sold_to_fname="ARIEL" sold_to_lname="PIONUS" sold_to_addr1="257 LOVELL STREET" sold_to_country="USA" sold_to_country_name="UNITED STATES" sold_to_city="WORCESTER" sold_to_state="MA" sold_to_state_name="MASSACHUSETTS" sold_to_postal_code="01602" sold_to_delivery_code="R" sold_to_email_status="O2" />
<OrderHeader company="27" order_nbr="10049" nbr_recipients="1" order_date="2004-03-29" entered_date="2004-03-29" entered_time="17:34:56" sold_to_customer_nbr="1057" order_type="P" order_type_desc="PHONE ORDERS" sales_rep_nbr="1" source="SOURCE" customer_class="18" />
<OrderShipTo company="27" order_nbr="10049" order_shipto_nbr="1" tax_code="T" arrival_date="2004-03-29" cancel_bo="N" freight_amt="2.50" freight_balance_amt="2.50" gift_order="N" merch_amt="25.00" merch_balance_amt="25.00" ship_complete="N" tax_amt="1.44" tax_balance_amt="1.44" nbr_lines="1" addl_freight_amt="1.23" addl_freight_balance_amt="1.23" ship_via="1" ship_via_desc="Large Thumb Inc." line_of_business="TOY" line_of_business_desc="TOYS" geographic_zone="5" geographic_zone_desc="ZONE 5" />
<PickDetails>
<PickDetail company="27" pick_nbr="3457756" pick_line_nbr="1" original_qty_printed="5" qty_printed="5" cart_bin_nbr="1" affect_inventory="Y" selling_price="5.00" selling_price_extended="25.00" qty_ordered="5" tax_amt="1.25000" order_nbr="10049" order_shipto_nbr="1" order_detail_nbr="1" item="PEN23" item_desc="COMFORT-GRIP PEN" sku="BLK" sku_desc="BLACK INK">
<PickLocations>
<PickLocation company="27" pick_nbr="3457756" pick_line_nbr="1" whse="2" whse_company="27" whse_zone="C" whse_location="PRIM1" qty_allocated="5" />
</PickLocations>
<OrderDetail company="27" order_nbr="10049" order_shipto_nbr="1" order_detail_nbr="1" affect_inventory="Y" arrival_date="2004-03-29" date_printed="2004-03-29" date_reserved="2004-03-29" original_price="5.00" selling_price="5.00" qty_ordered="5" qty_printed="5" qty_reserved="5" tax_amt="1.25000" time_reserved="17:35:09" gift_wrap="N" date_entered="2004-03-29" time_entered="17:34:56" freight_override="N" offer_price="5.00" price_method="6" set_main_item="N" prediscount_amt="5.00" warranty_item="N" item="PEN23" item_desc="COMFORT-GRIP PEN" sku="BLK" sku_desc="BLACK INK" offer="OFR" />
<Item Company="27" Item_Number="PEN23" Allow_SKUs="Y" Drop_ship_item="N" Non-inventory="N" Selling_weight="500" Serial_Nbr_tracking="N" Ship_weight="500" Standard_cost="10000" ITM_Allow_Pct_discount="Y" ITM_Oversize_flag="N" ITM_Description="COMFORT-GRIP PEN" ITM_Exclude_From_Flex_Pay="N" ITM_Royalty="N" ITM_Membership="N" ITM_Create_Date="1020529" Buyer="HEB" Buyer_Name="HANNAH ELIZABETH BROWN" Item_class="OFC" ICL_Description="OFFICE SUPPLIES" Item_status="T" Item_status_description="TEST STATUS" Unit_of_measure="EA" UOM_Description="EACHES" UOM_Units="1" Vendor_Nbr="12" VIA_Ship_via_code="0">
<SKU SKU_Code="BLK " SKU_Description="BLACK INK" Max_qty_for_location="999" Max_qty_for_warehouse="99999" Min_qty_for_location="1" Min_qty_for_warehouse="10" Out_of_stock_flag="N" Receipt_date="1020604" Retail_reference_Nbr="888" Short_SKU="1927" SKU_Open_qty="318" SKU_On_hold_qty="77" SKU_Suppress_BO_Card="N" SKU_Returnable="N" SKU_Last_Download_Qty="99999" SKU_Create_Date="1020529" Warehouse="2" Warehouse_name="MAIN WAREHOUSE" Location="PRIM1" SKU_Element_1_Code="BLK" SKU_Element_1_Desc="BLACK" SKU_Element_1_Name="COL" SKU_Element_2_Code="" SKU_Element_2_Name="SIZE" SKU_Element_3_Code="" SKU_Element_3_Name="WDTH">
<UPCs>
<UPC UPC_Type="UA" UPC="12345678" UPC_VND_Vendor="12" />
</UPCs>
</SKU>
</Item>
</PickDetail>
</PickDetails>
</PickHeader>
</Message>
Sample CWPickOut message (Void Pick Slip)
<Message source="CWDirect" target="CWIntegrate" type="CWPickOut" date_created="2004-03-29" time_created="17:02:28">
<PickHeader transaction_type="D" company="27" pick_nbr="3457750" pick_status="V">
<PickDetails>
<PickDetail />
</PickDetails>
</PickHeader>
</Message>
Pick Message from CWDirect (CWPickOut)
The PICK_OUT integration layer process generates this message based on PCH trigger records, as described under Pick Out Processing.
For more information: See XML Messages for a table that provides links to the DTD, schema, and a sample XML layout for each XML message.
Message Attribute |
Alpha/ numeric |
Positions |
Description |
alpha |
25 |
CWDirect |
|
alpha |
25 |
CWintegrate |
|
alpha |
25 |
CWPickOut |
|
numeric |
8 |
|
|
numeric |
6 |
|
|
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). |
numeric |
3 |
The company that generated the pick slip. |
|
numeric |
7 |
The pick control number. |
|
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 |
|||
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. |
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 |
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. |
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 |
|
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. |
|||
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 |
|
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. |
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. |
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. |
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. |
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. |
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. |
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). |
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 |
|
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 |
|
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 |
|
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. |
Carryover/Billing Pending Report | Contents | SCVs | Search | Glossary | Reports | XML | Index | Chapter 12: Pick Print Eligibility (WPPE) |
FU01_11 CWDirect 18.0 August 2015 OTN