Retail Integration Mappings Report Release:16.0.030 (Store Inventory Management)
Application Store Inventory Management
Target Name Space http://www.oracle.com/retail/integration/base/bo/WHDesc/v1
Version 1.1
Description This is root element of this document which contains name space definitions for the document elements.
XSD Structure

XML-Schema Name:WHDesc Version:16.0.030 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for WHDesc in SIM application.
SIM's Table Name SIM's Column Name Integration API(RIB or/and RSB or/and BDI) SIM's Column Length Is Column Required in SIM's API? SIM's API Description
wh number10 1 1 The number which uniquely identifies the warehouse. The wh table stores all warehouses in the system, both virtual and physical. WAREHOUSE ID NUMBER 10,0 Yes Warehouse id
wh_name varchar2150 1 1 Not Yet Available WAREHOUSE NAME VARCHAR2 150 Yes WAREHOUSE NAME
wh_add1 varchar2240 0 1 Not Yet Available ADDRESS ADDRESS_LINE_1 VARCHAR2 240 No FIRST ADDRESS
wh_add2 varchar2240 0 1 Not Yet Available ADDRESS ADDRESS_LINE_2 VARCHAR2 240 No second address
wh_city varchar2120 0 1 Not Yet Available ADDRESS CITY VARCHAR2 120 No warehouse city id for address type
county varchar2250 0 1 Not Yet Available ADDRESS COUNTY VARCHAR2 250 No County where warehouse is located
state varchar23 0 1 Not Yet Available ADDRESS STATE VARCHAR2 3 No warehouse state for address type
country_id varchar23 0 1 Not Yet Available ADDRESS, WAREHOUSE COUNTRY_ID, LOCALE_COUNTRY VARCHAR2 3 No locale country of the warehouse
wh_pcode varchar230 0 1 NA ADDRESS POSTAL_CODE VARCHAR2 30 No warehouse post info depending on address type
email varchar2100 0 1 Not Yet Available ADDRESS CONTACT_EMAIL VARCHAR2 100 No supplier email for address type
stockholding_ind varchar21 0 1 Indicates if the warehouse is a stock holding location. In a non-multichannel environment, this will always be 'Y'. In a multichannel environment it will be 'N' for a physical warehouse and 'Y' for a virtual warehouse. No Not used in SIM.
channel_id number4 0 1 The channel for which the virtual warehouse will be assigned. No NOT USED IN SIM
currency_code varchar23 1 1 The code for the currency which the warehouse uses. WAREHOUSE CURRENCY_CODE VARCHAR2 40 Yes Currency Code
duns_number varchar29 0 1 This type can hold a number of digits count umber. No NOT USED IN SIM
duns_loc varchar24 0 1 The Dun and Bradstreet number to identify the location. No NOT USED IN SIM
physical_wh number10 0 1 The number of the physical warehouse corresponding to this warehouse. No NOT USED IN SIM
break_pack_ind varchar21 0 1 Indicates whether or not the warehouse is capable of distributing less than the supplier case quantity. Valid values are 'Y' or 'N' No NOT USED IN SIM
redist_wh_ind varchar21 0 1 Indicates whether the warehouse is a 'Re-Distribution' warehouse. Used as a location on Purchase Orders in place of actual locations that are unknown at the time of purchase order creation. Used by Redistribution report. No NOT USED IN SIM
delivery_policy varchar26 0 1 The delivery policy of the warehouse. Next day indicates that the if a location is closed, the warehouse will deliver on the next day. Next Valid Delivery Day indicates that the warehouse will wait until the next scheduled delivery day. No NOT USED IN SIM
contact_person varchar2120 0 1 NA No NOT USED IN SIM
dest_fax varchar220 0 1 NA No Not used in SIM.
phone_nbr varchar220 0 1 NA ADDRESS CONTACT_PHONE VARCHAR2 20 No warehouse phone for address type
default_route varchar210 0 1 NA No NOT USED IN SIM
default_carrier_code varchar24 0 1 NA No NOT USED IN SIM
default_service_code varchar26 0 1 NA No NOT USED IN SIM
expedite_route varchar210 0 1 NA No NOT USED IN SIM
expedite_carrier_code varchar24 0 1 NA No NOT USED IN SIM
expedite_service_code varchar26 0 1 NA No NOT USED IN SIM
bol_upload_type varchar24 0 1 NA No NOT USED IN SIM
bol_print_type varchar24 0 1 NA No NOT USED IN SIM
lead_time number4 0 1 NA No NOT USED IN SIM
distance_to_dest number4 0 1 NA No NOT USED IN SIM
drop_trailers_accepted_flag varchar21 0 1 NA No NOT USED IN SIM
rcv_dock_available_flag varchar21 0 1 NA No NOT USED IN SIM
container_type varchar26 0 1 NA No NOT USED IN SIM
mld_default_route varchar210 0 1 NA No NOT USED IN SIM
unit_pick_container_type varchar26 0 1 NA No NOT USED IN SIM
dest_seq_nbr number4 0 1 NA No Not used in SIM.
owning_dc varchar210 0 1 NA No NOT USED IN SIM
AddrDesc:AddrDesc * 0 unbounded It's a referenced element. For detailed description, please refer referenced element doc. NA NA NA NA NA NA
pricing_loc number10 0 1 The location for which pricing info was copied for this warehouse. No NOT USED IN SIM
pricing_loc_curr varchar23 0 1 This is the currency code of the pricing location. No NOT USED IN SIM
org_unit_id number15 0 1 This field holds the Org Unit id of the Warehouse. WAREHOUSE ORGANIZATION_UNIT_ID VARCHAR2 15 No Fill this description.
CustFlexAttriVo:CustFlexAttriVo * 0 unbounded References a collection of customer flexible attributes. NA NA NA NA NA NA
wh_name_secondary varchar2150 0 1 Not Yet Available No Not used by SIM.
vat_region number4 0 1 Not Yet Available No Not used in SIM.
org_hier_type number4 0 1 Not Yet Available No Not used in SIM.
org_hier_value number10 0 1 Not Yet Available No Not used in SIM.
primary_vwh number10 0 1 Not Yet Available No Not used in SIM.
channel_desc varchar2120 0 1 The channel description for which the virtual warehouse will be assigned.
restricted_ind varchar21 0 1 This field's indicator is used to restrict virtual warehouses from receiving stock during an inbound type transaction. No Not used in SIM.
protected_ind varchar21 0 1 This field's indicator is used to determine if the virtual warehouse is affected last in transactions where inventory is removed or affected first in short-shipment type transactions where inventory is being added. No Not used in SIM.
forecast_wh_ind varchar21 0 1 This indicator determines if a warehouse is forecastable. The intent of this indicator is to restrict the information being sent to RDF against which to generate forecasts. No Not used in SIM.
tsf_entity_id number10 0 1 This field stores, id of the transfer entity with which this warehouse is associated. No Not used in SIM.
finisher_ind varchar21 0 1 This field indicates weather a virtual warehouse is an internal finisher or not. No Not used in SIM.
inbound_handling_days number2 0 1 This field indicated the number of days that the warehouse requires to receive any item and get it to the shelf so that it is ready to pick. No Not used in SIM.
vwh_type varchar26 0 1 NA No Not used in SIM.
org_entity_type varchar21 0 1 This field will specify if the warehouse is a legal entity (Importer, Exporter) or a regular warehouse. Valid values are: R - regular warehouse (including finisher); M - importer; X - exporter. Default value is R. No Not used in SIM.
customer_order_loc_ind varchar21 0 1 This field indicates if the location is customer order location or not.It is enabled only for virtual WH. No Not used in SIM.
default_wh number10 0 1 This field contains the default warehouse linked to the virtual warehouse. No Not used in SIM.
gift_wrapping_ind varchar21 0 1 This field indicates weathere a gift wrapping needs to be done or not. No Not used in SIM.
customer_order_ship_ind varchar21 0 1 This field indicates wheather the customer order has been been shipped from Warehouse or not. No Not used in SIM.

XML-Schema Name:AddrDesc Version:16.0.030 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for AddrDesc in SIM application.
SIM's Table Name SIM's Column Name Integration API(RIB or/and RSB or/and BDI) SIM's Column Length Is Column Required in SIM's API? SIM's API Description
city_id varchar210 0 1 Indicates the City Id or Code. No Not used by SIM.
state_name varchar2120 0 1 Indicates the State name. No Not used by SIM.
country_name varchar2120 0 1 Indicates the Country Name. For e.g Brazil,United States No Not used by SIM.
addr varchar232 1 1 This field holds the unique address ID from the source system. For addresses that are interfaced into RMS, it will hold the external system's address ID. For addresses published out of RMS, it will hold RMS's address ID. ADDRESS EXTERNAL_ID VARCHAR2 25 No this will hold the external reference id
addr_type varchar22 1 1 Indicates the type for the address. Valid values (e.g. 01-business, 02-postal) are in the add_type table. ADDRESS TYPE VARCHAR2 2 Yes denotes the address type. Possible values: 01(for Business Address), 02 (for Postal Address), 03 (for Return Address), 04 (for Order Address), 05 (for Invoice Address), 06 (for Remittance Address), 07 (for Billing Address), 08 (for Delivery Address) 09 (for External Address)
primary_addr_type_ind varchar21 0 1 Description is not available. No Not used by SIM.
primary_addr_ind varchar21 1 1 Indicates whether this address is the primary address for this address type ADDRESS IS_PRIMARY VARCHAR2 1 Yes indicator to denote which address is primary
add_1 varchar2240 1 1 Contains the first line of the address ADDRESS ADDRESS_LINE_1 VARCHAR2 240 No first address
add_2 varchar2240 0 1 Contains the second line of the address. ADDRESS ADDRESS_LINE_2 VARCHAR2 240 No second address
add_3 varchar2240 0 1 Contains the thirdline of the address. ADDRESS ADDRESS_LINE_3 VARCHAR2 240 Yes third address
city varchar2120 1 1 Contains the name of the city that is associated with the address. ADDRESS CITY VARCHAR2 120 No city for address type
state varchar23 0 1 Contains the postal abbreviation for the state in which the warehouse is located. ADDRESS STATE VARCHAR2 3 No State for the address type.
country_id varchar23 1 1 Contains the country where the address exists. ADDRESS COUNTRY_ID VARCHAR2 3 No country id for the address location
post varchar230 0 1 Contains the zip code for the address. ADDRESS POSTAL_CODE VARCHAR2 30 No postal code for the address
contact_name varchar2120 0 1 Contains the name of the contact for the supplier at this address. ADDRESS CONTACT_NAME VARCHAR2 120 No name of contact person for address type
contact_phone varchar220 0 1 Contains the phone number of the contact person at this address. ADDRESS CONTACT_PHONE VARCHAR2 20 No phone number for the contact person at the address.
contact_telex varchar220 0 1 Contains the telex number of the partner or suppliers representative contact. No Not used by SIM.
contact_fax varchar220 0 1 Contains the fax number of the contact person at this address. ADDRESS CONTACT_FAX VARCHAR2 20 No fax for address type
contact_email varchar2100 0 1 Contains the email address of the partner or suppliers representative contact. ADDRESS CONTACT_EMAIL VARCHAR2 100 No email for address type
oracle_vendor_site_id number15 0 1 The unique identifier of this address in the Oracle Financials systems, if used. No Not used by SIM.
county varchar2250 0 1 Contains the county name for the location. No Not used by SIM.
jurisdiction_code varchar210 0 1 ID associated to the tax jurisdiction of the country-state relationship. No Not used by SIM.
CustFlexAttriVo:CustFlexAttriVo * 0 unbounded References a collection of customer flexible attributes. NA NA NA NA NA NA

XML-Schema Name:CustFlexAttriVo Version:16.0.030 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for CustFlexAttriVo in SIM application.
SIM's Table Name SIM's Column Name Integration API(RIB or/and RSB or/and BDI) SIM's Column Length Is Column Required in SIM's API? SIM's API Description
name varchar230 1 1 Holds the attribute name. ITEM_CFA, SUPPLIER_CFA, SUPPLIER_ITEM_CFA, STORE_ITEM_CFA NAME VARCHAR2 30 Yes the name of the custom flex attribute.
value varchar2250 0 1 Holds the numeric or string value of the attribute. ITEM_CFA, SUPPLIER_CFA, SUPPLIER_ITEM_CFA, STORE_ITEM_CFA VALUE VARCHAR2 250 No the value of the custom flex attribute.
value_date xs:dateTime 0 1 Holds the date value of the attribute. ITEM_CFA, SUPPLIER_CFA, SUPPLIER_ITEM_CFA, STORE_ITEM_CFA VALUE_DATE DATE No the date value of the custom flex attribute.

XML-Schema Name:CustFlexAttriVo Version:16.0.030 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for CustFlexAttriVo in SIM application.
SIM's Table Name SIM's Column Name Integration API(RIB or/and RSB or/and BDI) SIM's Column Length Is Column Required in SIM's API? SIM's API Description
name varchar230 1 1 Holds the attribute name. ITEM_CFA, SUPPLIER_CFA, SUPPLIER_ITEM_CFA, STORE_ITEM_CFA NAME VARCHAR2 30 Yes the name of the custom flex attribute.
value varchar2250 0 1 Holds the numeric or string value of the attribute. ITEM_CFA, SUPPLIER_CFA, SUPPLIER_ITEM_CFA, STORE_ITEM_CFA VALUE VARCHAR2 250 No the value of the custom flex attribute.
value_date xs:dateTime 0 1 Holds the date value of the attribute. ITEM_CFA, SUPPLIER_CFA, SUPPLIER_ITEM_CFA, STORE_ITEM_CFA VALUE_DATE DATE No the date value of the custom flex attribute.