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

XML-Schema Name:StrFordDesc 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 StrFordDesc 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 1 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 is to be released 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.
delivery_date xs:dateTime 0 1 Date the fulfillment order is to be delivered FUL_ORD DELIVERY_DATE DATE Fill column length. No The date in which the fulfillment order is to be delivered.
delivery_type str_ford_delivery_type 1 1 Delivery type Valid values are PICKUP, SHIPMENT, UNKNOWN. FUL_ORD DELIVERY_TYPE NUMBER 4,0 Yes Identifier that represents the type of delivery for this order. Valid values are 1- Customer Pickup 2- Ship to Customer
delivery_carrier_code varchar2128 0 1 Delivery carrier code SHIPMENT_CARRIER CODE VARCHAR2 4 Yes Unique code identifier for a carrier
delivery_service_code varchar2128 0 1 Delivery carrier service code SHIPMENT_CARRIER_SERVICE CODE VARCHAR2 6 Yes Unique identifier that represents the delivery service
allow_partial_delivery xs:boolean 1 1 True if the order allows for partial delivery, false otherwise, FUL_ORD ALLOW_PARTIAL_DELIVERY VARCHAR2 1 Yes Indicator whether all items on the order must be there to be delivered.
comments varchar22000 0 1 Comments about the fulfillment order. FUL_ORD COMMENTS VARCHAR2 2000 No Comments defined by the external system for this order.
StrFordCust * 0 1 Customer details
StrFordItm * 0 unbounded Collection of fulfillment order line items

XML-Schema Name:StrFordCust 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 StrFordCust 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
customer_id varchar214 1 1 Customer identifier FUL_ORD CUSTOMER_ID VARCHAR2 14 No Customer identifier for this fulfillment order.
delivery_first_name varchar2120 0 1 First name of delivery contact ADDRESS FIRST_NAME VARCHAR2 120 No Holds the contact's first name
delivery_phonetic_first_name varchar2120 0 1 Phonetic first name of delivery contact ADDRESS PHONETIC_FIRST_NAME VARCHAR2 120 No Holds the contact's phonetic first name
delivery_last_name varchar2120 0 1 Last name of delivery contact ADDRESS LAST_NAME VARCHAR2 120 No Holds the contact's last name
delivery_phonetic_last_name varchar2120 0 1 Phonetic last name of delivery contact ADDRESS PHONETIC_LAST_NAME VARCHAR2 120 No Holds the contact's phonetic last name
delivery_preferred_name varchar2120 0 1 Preferred name of delivery contact ADDRESS CONTACT_NAME VARCHAR2 120 No supplier name for address type
delivery_company_name varchar2120 0 1 Company name of delivery contact ADDRESS COMPANY_NAME VARCHAR2 120 No Holds the contact's company name
delivery_address1 varchar2240 0 1 First address line of delivery contact ADDRESS ADDRESS_LINE_1 VARCHAR2 240 No FIRST ADDRESS
delivery_address2 varchar2240 0 1 Second address line of delivery contact ADDRESS ADDRESS_LINE_2 VARCHAR2 240 No SECOND ADDRESS
delivery_address3 varchar2240 0 1 Third address line of delivery contact ADDRESS ADDRESS_LINE_3 VARCHAR2 240 No THIRD ADDRESS
delivery_county varchar2120 0 1 County of delivery contact ADDRESS COUNTY VARCHAR2 250 No Holds the county of the contact
delivery_city varchar2120 0 1 City of delivery contact ADDRESS CITY VARCHAR2 120 No supplier city id for address type
delivery_state varchar23 0 1 State of delivery contact ADDRESS STATE VARCHAR2 3 No supplier state for address type
delivery_postal_code varchar230 0 1 Postal code of delivery contact ADDRESS POSTAL_CODE VARCHAR2 30 No supplier post info depending on address type
delivery_country varchar23 0 1 Country of delivery contact ADDRESS COUNTRY_ID VARCHAR2 3 No supplier country id depending on address type
delivery_phone varchar220 0 1 Phone number of delivery contact ADDRESS CONTACT_PHONE VARCHAR2 20 No supplier phone for address type
billing_first_name varchar2120 0 1 First name of billing contact ADDRESS FIRST_NAME VARCHAR2 120 No Holds the contact's first name
billing_phonetic_first_name varchar2120 0 1 Phonetic first name of billing contact ADDRESS PHONETIC_FIRST_NAME VARCHAR2 120 No Holds the contact's phonetic first name
billing_last_name varchar2120 0 1 Last name of billing contact ADDRESS LAST_NAME VARCHAR2 120 No Holds the contact's last name
billing_phonetic_last_name varchar2120 0 1 Phonetic last name of billing contact ADDRESS PHONETIC_LAST_NAME VARCHAR2 120 No Holds the contact's phonetic last name
billing_preferred_name varchar2120 0 1 Preferred name of billing contact ADDRESS CONTACT_NAME VARCHAR2 120 No supplier name for address type
billing_company_name varchar2120 0 1 Company name of billing contact ADDRESS COMPANY_NAME VARCHAR2 120 No Holds the contact's company name
billing_address1 varchar2240 0 1 First address line of billing contact ADDRESS ADDRESS_LINE_1 varchar2 240 No first address
billing_address2 varchar2240 0 1 Second address line of billing contact ADDRESS ADDRESS_LINE_2 varchar2 240 No second address
billing_address3 varchar2240 0 1 Third address line of billing contact ADDRESS ADDRESS_LINE_3 VARCHAR2 240 No third address
billing_county varchar2120 0 1 County of billing contact ADDRESS COUNTY VARCHAR2 250 No Holds the county of the contact
billing_city varchar2120 0 1 City of billing contact ADDRESS CITY VARCHAR2 120 No supplier city id for address type
billing_state varchar23 0 1 State of billing contact ADDRESS STATE VARCHAR2 3 No supplier state for address type
billing_postal_code varchar230 0 1 Postal code of billing contact ADDRESS POSTAL_CODE VARCHAR2 30 No supplier post info depending on address type
billing_country varchar23 0 1 Country of billing contact ADDRESS COUNTRY_ID VARCHAR2 3 No supplier country id depending on address type
billing_phone varchar220 0 1 Phone number of billing contact ADDRESS CONTACT_PHONE VARCHAR2 20 No supplier phone for address type

XML-Schema Name:StrFordItm 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 StrFordItm 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
line_id number12 1 1 Line identifier FUL_ORD_LINE_ITEM ID number 12,0 Yes Unique SIM identifier.
item_id varchar225 1 1 SKU number FUL_ORD_LINE_ITEM ITEM_ID varchar2 25 Yes Item identifier for this line item.
description varchar2250 0 1 Description of this item ITEM SHORT_DESCRIPTION, LONG_DESCRIPTION VARCHAR2 400 No long/ short description of the item
substitute_item_id varchar225 0 1 SKU for substituted item FUL_ORD_LINE_ITEM SUBSTITUTE_LINE_ITEM_ID number 12,0 No Identifier of the line item this line item was substituted for.
preferred_uom varchar240 1 1 Preferred unit of measure FUL_ORD_LINE_ITEM PREFERRED_UOM VARCHAR2 4 No Preferred unit of measure of this line item.
standard_uom varchar240 1 1 Standard unit of measure ITEM UNIT_OF_MEASURE VARCHAR2 4 Yes unit of measure which the stock for this item is tracked at the coporate level.
order_qty number9_2 1 1 Quantity ordered in standard unit of measure. FUL_ORD_LINE_ITEM QUANTITY_ORDERED number 12,4 Yes The quantity ordered of this line item.
picked_qty number9_2 1 1 Quantity picked in standard unit of measure. FUL_ORD_LINE_ITEM QUANTITY_PICKED number 12,4 Yes The quantity picked of this line item.
delivered_qty number9_2 1 1 Quantity delivered in standard unit of measure. FUL_ORD_LINE_ITEM QUANTITY_DELIVERED NUMBER 12,4 Yes The quantity delivered of this line item.
canceled_qty number9_2 1 1 Quantity canceled in standard unit of measure. FUL_ORD_LINE_ITEM QUANTITY_CANCELED NUMBER 12,4 Yes The quantity canceled of this line item.
remaining_qty number9_2 1 1 Quantity remaining/unfulfilled in standard unit of measure FUL_ORD_LINE_ITEM QUANTITY_PICKED, QUANTITY_DELIVERED NUMBER 12,4 Yes picked quantity subtract delivered quantity
reserved_qty number9_2 1 1 Quantity reserved in standard unit of measure. FUL_ORD_LINE_ITEM QUANTITY_RESERVED NUMBER 12,4 Yes QUANTITY RESERVED
allow_substitution xs:boolean 1 1 True if this item allows substitutions, false if it does not. FUL_ORD_LINE_ITEM ALLOW_SUBSTITUTION VARCHAR2 1 Yes True if this item allows substitutions, false if it does not.
create_date xs:dateTime 1 1 Date this line item was created FUL_ORD_LINE_ITEM CREATE_DATE DATE Fill column length. Yes The date this line item was created.
last_update_date xs:dateTime 1 1 Date this line item was last updated FUL_ORD_LINE_ITEM UPDATE_DATE date Fill column length. Yes The date this line item was last modified.
comments varchar2512 0 1 Comments about this line item FUL_ORD_LINE_ITEM COMMENTS VARCHAR2 2000 No Comments on this line item defined by an external system.