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.