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/StrFordHdrColDesc/v1
Version 1.0
Description
XSD Structure

XML-Schema Name:StrFordHdrColDesc 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 StrFordHdrColDesc 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
StrFordHdrDesc:StrFordHdrDesc * 0 unbounded Collection of fulfillment order headers. NA NA NA NA NA NA
collection_size number4 1 1 Size of the collection. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.

XML-Schema Name:StrFordHdrDesc 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 StrFordHdrDesc 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
int_fulfillment_order_id number12 1 1 Internal fulfillment order identifier FUL_ORD ID number 12,0 Yes Unique SIM identifier.
ext_fulfillment_order_id varchar2128 0 1 External fulfillment order identifier FUL_ORD EXTERNAL_ID varchar2 128 No External identifier for the fulfillment order.
customer_order_id varchar2128 1 1 Customer order identifier FUL_ORD CUST_ORDER_ID varchar2 128 Yes External identifier of the customer order being fulfilled.
order_type str_ford_type 1 1 Type of order Valid values are LAYAWAY, PICKUP_AND_DELIVERY, CUSTOMER_ORDER, PENDING_PURCHASE, SPECIAL_ORDER, WEB_ORDER, UNKNOWN. 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
status str_ford_status 1 1 Current status Valid values are NEW, IN_PROGRESS, COMPLETED, CANCELED, UNKNOWN. FUL_ORD STATUS number 4,0 Yes Indicates the status of the fulfillment order. Valid values are 0 - New, 1 - In Progress, 2 - Completed, 3 - Canceled, 4- Active
create_date xs:dateTime 1 1 Date the fulfillment order was created FUL_ORD CREATE_DATE date Fill column length. Yes The date this fulfillment order was created in SIM.
release_date xs:dateTime 0 1 Date the fulfillment order was released Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.
number_of_skus number9 1 1 Total number of items on the order Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes LineItem count