Retail Integration Mappings Report Release:15.0.0 (Store Inventory Management)
Application Store Inventory Management
Target Name Space http://www.oracle.com/retail/integration/base/bo/StrFordHdrCriVo/v1
Version 1.0
Description
XSD Structure

XML-Schema Name:StrFordHdrCriVo Version:15.0.0 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for StrFordHdrCriVo in SIM application.
SIM's Table Name SIM's Column Name Integration API(RIB or/and RSB or/and RSL) SIM's Column Length Is Column Required in SIM's API? SIM's API Description
release_from_date xs:dateTime 0 1 Include only fulfillment orders with the release date at or after this date. FUL_ORD RELEASE_DATE date Fill column length. No The date in which the fulfillment order must be shipped or picked up in the store.
release_to_date xs:dateTime 0 1 Include only fulfillment orders with the release date at or before this date. FUL_ORD RELEASE_DATE Date Fill column length. No The date in which the fulfillment order must be shipped or picked up in the store.
status StrFordCriStatus 1 1 Include only fulfillment orders matching this status. Valid values are NEW, IN_PROGRESS, COMPLETED, CANCELED, ACTIVE, NO_VALUE. FUL_ORD STATUS number 0 - New, 1 - In Progress, 2 - Completed, 3 - Canceled, 4- Active Yes Indicates the status of the fulfillment order. Valid values are
int_fulfillment_order_id number12 0 1 Include only fulfillment orders with this internal fulfillment order identifier. FUL_ORD ID NUMBER 12,0 Yes Unique SIM identifier.
ext_fulfillment_order_id varchar2128 0 1 Include only fulfillment orders with this external fulfillment order identifier. FUL_ORD EXTERNAL_ID VARCHAR2 128 No External identifier for the fulfillment order.
customer_order_id varchar2128 0 1 Include only fulfillment orders with this customer order identifier. FUL_ORD CUST_ORDER_ID varchar2 128 Yes External identifier of the customer order being fulfilled.
bin_id varchar2128 0 1 Include only fulfillment orders with this BIN identifier. FUL_ORD_BIN BIN_ID varchar2 128 Yes Identifier of a bin associated to the fulfillment order.
order_type StrFordCriType 1 1 Include only fulfillment orders of this type Valid values are LAYAWAY, PICKUP_AND_DELIVERY, CUSTOMER_ORDER, PENDING_PURCHASE, SPECIAL_ORDER, WEB_ORDER, NO_VALUE. FUL_ORD ORDER_TYPE NUMBER 4,0 Yes The type of fulfillment order. Valid values are 1- Layaway, 2- Pickup and Delivery Orders, 3- Customer Order, 4- Pending Purchase, 5- Special Order, 6- Web Order
customer_name varchar2128 0 1 Include only deliveries with this customer name. ADDRESS CONTACT_NAME, FIRST_NAME, LAST_NAME varchar2 120 No Holds the contact's last name/first name/ supplier name for address type
item_id varchar225 0 1 Include only fulfillment orders containing this item SKU. FUL_ORD_LINE_ITEM ITEM_ID VARCHAR2 25 Yes Item identifier for this line item.
store_id number10 1 1 Include only fulfillment orders at this store FUL_ORD STORE_ID number 10,0 Yes Store identifier at which this order is being fulfilled.