Create_WCS_ExpectedInventoryRecord message

The Create_WCS_ExpectedInventoryRecord message is an inbound message that contains information for creating an expected inventory record in the HCL Commerce database. A fulfillment center application generates this request and sends it to the HCL Commerce inbound message queue, where the HCL Commerce system receives it. After HCL Commerce processes the message, the ExpectedInventoryRecordCreate command is invoked. The command creates a record in the RA table and one RADETAIL record for each RADETAIL component in the message.

Note: If the inbound message does not contain a valid StoreID or a valid ExpectedDate, the GenericApplicationError viewname is used for error message composition and the ExpectedInventoryRecordCreate command is not invoked. The response message is generated by GenericApplicationErrorXML.jsp.

The Create_WCS_ExpectedInventoryRecord message uses the XML message format and follows Create_WCS_ExpectedInventoryRecord_10.dtd.

The following table describes the format of the Create_WCS_ExpectedInventoryRecord message. For a description of the database column, follow the link to its associated table. All fields are optional unless otherwise noted. The tag value length in the XML message for database fields of type INT, BIGINT and DOUBLE should be CHAR (10), CHAR(19), and CHAR(16) respectively.

Field Name Comment Table Name Column Name Note
1 BackendRaID N/A N/A This can be used in the response message to associate with the original request
2 StoreID Mandatory RA STORE_ID N/A
3 VendorID Mandatory RA VENDOR_ID N/A
4 OrderDate Mandatory RA ORDERDATE N/A
5 ExternalID RA EXTERNALID N/A
6 FulfillmentCenterID Mandatory RADETAIL FFMCENTER_ID N/A
7 ItemOwnerID Mandatory ITEMSPC MEMBER_ID N/A
8 ProductSKU Mandatory ITEMSPC PARTNUMBER ProductSKU along with ItemOwnerID is used to identify the item specification
9 ExpectedDate Mandatory RADETAIL EXPECTEDDATE ISO 8601 date format
10 QuantityOrdered Mandatory RADETAIL QTYORDERED N/A
11 Comment RADETAIL RADETAILCOMMENT N/A
12 BackendRaDetailID N/A N/A This can be used in the response message to associate with the original request.