Menu Option

Description

Working with Order Line Activity Codes (WOLA)

Use this menu option to create any user-defined order line activity codes you wish to send to CWDirect in the Order Line History In Message (CWORDLNHSTIN).

The system automatically creates the System-Delivered Order Line Activity Codes in the Order Line Activity Codes file and displays them on the Work with Order Line Activity Codes Screen the first time you:

• advance to the Work with Order Line Activity Codes Screen, or

• send an Order Line History In Message (CWORDLNHSTIN) to CWDirect

Working with Integration Layer Processes (IJCT)

The Order Line History (ORDLNHSTIN) job:

• Validates the data in the Order Line History In Message (CWORDLNHSTIN). If an error exists, the order line history error displays in the Working with Order Line History Errors (WOHE) menu option.

• Creates an order line history record based on the information in the Order Line History In Message (CWORDLNHSTIN) received from an external system.

• If the activity_code is I (In Transit), the system displays TBD next to order lines on the Order Inquiry Detail Screen that are in an In Transit status.

• If the activity_code is V (Delivered), the system posts the delivery confirmation to the general ledger; see Posting Delivery Confirmation.

You must set up an inbound MQ queue to receive the Order Line History In Message (CWORDLNHSTIN) from an external system.

Working with Order Line History Errors (WOHE)

Use this menu option to review and correct order line history errors.

Attribute Name

Type

Length

Comments

Message

source

alpha

25

Identifies the source of the XML message. CWIntegrate indicates the XML message is from an outside source.

target

alpha

25

Identifies the target of the XML message. CWDirect indicates the XML message is sent to CWDirect.

type

alpha

25

Identifies the type of information in the XML message. CWORDLNHSTIN indicates the message contain an order line history update.

Header

company_code

numeric

3

Indicates the company where the order associated with the order line history update exists.

Required.

Updates the Company field in the Order Line History file.

order_number

numeric

8

The order number that contains the order line whose order line history you wish to update.

Required.

Updates the Order # field in the Order Line History file.

ShipTo

ship_to_number

numeric

3

The order ship to that contains the order line whose order line history you wish to update.

Required.

Updates the Ship to # field in the Order Line History file.

OrderLineHistory

olh_odt_seq

numeric

5

Identifies the order line whose order line history you wish to update; this is the order_detail_nbr tag in the Pick Message from CWDirect (CWPickOut).

Required.

Updates the Seq # field in the Order Line History file.

activity_code

alpha

2

Indicates the type of activity performed against the order line.

Order line activity codes are defined in and validated against the Order Line Activity Codes file; see Working with Order Line Activity Codes (WOLA).

You can pass any user-defined activity code in the CWORDLNHSTIN message. The only system-delivered activity codes CWDirect can receive in the message are:

V = Delivered; the item on the order line has been delivered to the customer. When the system receives an Order Line History In message with an activity code of V, the system posts the delivery confirmation to the general ledger; see Posting Delivery Confirmation.

I = In Transit; the item on the order line is in the process of being delivered to the customer. TBD displays next to order lines on the Order Inquiry Detail Screen that are in an In Transit status.

If the activity code does not exist in the Order Line Activity file, or a system-reserved activity code other than V or I is passed in the message, the system places the message in error; see Working with Order Line History Errors (WOHE).

Required.

Updates the OLH Activity field in the Order Line History file.

item_id

alpha

12

A code for the item on the order line.

If you pass an item number, the system validates that the item number matches the item number on the order line.

Optional.

sku

alpha

14

Identifies the SKU of the item on the order line.

If you pass a SKU, the system validates that the SKU code matches the SKU code defined for the item on the order line.

Optional.

quantity

numeric

5

The quantity of the item on the order line associated with the order line activity update.

Required.

Updates the OLH Qty field in the Order Line History file.

contact_date

numeric

7

The date associated with the order line activity, in MMDDYYYY format. Must be a valid date.

For example, if the activity_code is I (In Transit), the contact_date represents the date the item on the order line is scheduled to be delivered; if the activity_code is V (Delivered), the contact_date represents the date the item on the order line was delivered to the customer.

Optional.

Updates the OLH Contact date field in the Order Line History file.

contact_time

numeric

6

The time the activity occurred, in HHMMSS format.

For example, if the activity_code is I (In Transit), the contact_time represents the time the item on the order line is scheduled to be delivered; if the activity_code is V (Delivered), the contact_time represents the time the item on the order line was delivered to the customer.

Optional.

Updates the OLH Contact time field in the Order Line History file.

delivery_provider

alpha

15

Identifies the name of the delivery provider. For example, this represents the HDL (Home Delivery Service) provider.

The system truncates this number to 15 positions.

Optional.

Updates the OLH Delivery provider field in the Order Line History file.

ext_sys_date

numeric

7

The date the message was processed in the external system, in MMDDYYYY format. Must be a valid date.

Optional.

Updates the OLH External system date field in the Order Line History file.

ext_ref_num

alpha

20

Represents an external reference number provided by the external system.

The system truncates this number to 20 positions.

Optional.

Updates the OLH External reference # field in the Order Line History file.

user

alpha

10

Identifies the user who performed the activity against the item on the order line.

User IDs are defined in and validated against the User file.

Optional.

Updates the User field in the Order Line History file.