Retail Integration Mappings Report Release:16.0.21 (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.21 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 RSL) 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 Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Not Yet Available NOT USED IN SIM
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 COUNTRY_ID VARCHAR2 3 No supplier country id depending on address type
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. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. null not used in sim
channel_id number4 0 1 The channel for which the virtual warehouse will be assigned. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. null 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. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. null NOT USED IN SIM
duns_loc varchar24 0 1 The Dun and Bradstreet number to identify the location. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. null NOT USED IN SIM
physical_wh number10 0 1 The number of the physical warehouse corresponding to this warehouse. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. null 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' Fill application table name. Fill table column name. RIB or/and RSB Fill column length. null 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. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. null 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. Fill application table name. null RIB or/and RSB Fill column length. null NOT USED IN SIM
contact_person varchar2120 0 1 NA Fill application table name. Fill table column name. RIB or/and RSB Fill column length. null NOT USED IN SIM
dest_fax varchar220 0 1 NA Fill application table name. Fill table column name. RIB or/and RSB Fill column length. null 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 Fill application table name. Fill table column name. RIB or/and RSB Fill column length. null NOT USED IN SIM
default_carrier_code varchar24 0 1 NA Fill application table name. Fill table column name. RIB or/and RSB Fill column length. null NOT USED IN SIM
default_service_code varchar26 0 1 NA Fill application table name. Fill table column name. RIB or/and RSB Fill column length. null NOT USED IN SIM
expedite_route varchar210 0 1 NA Fill application table name. Fill table column name. RIB or/and RSB Fill column length. null NOT USED IN SIM
expedite_carrier_code varchar24 0 1 NA Fill application table name. Fill table column name. RIB or/and RSB Fill column length. null NOT USED IN SIM
expedite_service_code varchar26 0 1 NA Fill application table name. Fill table column name. RIB or/and RSB Fill column length. null NOT USED IN SIM
bol_upload_type varchar24 0 1 NA Fill application table name. Fill table column name. RIB or/and RSB Fill column length. null NOT USED IN SIM
bol_print_type varchar24 0 1 NA Fill application table name. Fill table column name. RIB or/and RSB Fill column length. null NOT USED IN SIM
lead_time number4 0 1 NA Fill application table name. Fill table column name. RIB or/and RSB Fill column length. null NOT USED IN SIM
distance_to_dest number4 0 1 NA Fill application table name. Fill table column name. RIB or/and RSB Fill column length. null NOT USED IN SIM
drop_trailers_accepted_flag varchar21 0 1 NA Fill application table name. Fill table column name. RIB or/and RSB Fill column length. null NOT USED IN SIM
rcv_dock_available_flag varchar21 0 1 NA Fill application table name. Fill table column name. RIB or/and RSB Fill column length. null NOT USED IN SIM
container_type varchar26 0 1 NA Fill application table name. Fill table column name. RIB or/and RSB Fill column length. null NOT USED IN SIM
mld_default_route varchar210 0 1 NA Fill application table name. Fill table column name. RIB or/and RSB Fill column length. null NOT USED IN SIM
unit_pick_container_type varchar26 0 1 NA Fill application table name. Fill table column name. RIB or/and RSB Fill column length. null NOT USED IN SIM
dest_seq_nbr number4 0 1 NA Fill application table name. Fill table column name. RIB or/and RSB Fill column length. null NOT USED IN SIM
owning_dc varchar210 0 1 NA Fill application table name. Fill table column name. RIB or/and RSB Fill column length. null 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. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. null NOT USED IN SIM
pricing_loc_curr varchar23 0 1 This is the currency code of the pricing location. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. null 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.

XML-Schema Name:AddrDesc Version:16.0.21 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 RSL) 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. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.
state_name varchar2120 0 1 Indicates the State name. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.
country_name varchar2120 0 1 Indicates the Country Name. For e.g Brazil,United States Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.
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. null null null null null
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. null null null null null
primary_addr_type_ind varchar21 0 1 Description is not available. null null null null null
primary_addr_ind varchar21 1 1 Indicates whether this address is the primary address for this address type null null null null null
add_1 varchar2240 1 1 Contains the first line of the address null varchar2 240 null null
add_2 varchar2240 0 1 Contains the second line of the address. null varchar2 240 null null
add_3 varchar2240 0 1 Contains the thirdline of the address. null varchar2 240 null null
city varchar2120 1 1 Contains the name of the city that is associated with the address. null null null null null
state varchar23 0 1 Contains the postal abbreviation for the state in which the warehouse is located. null null null null null
country_id varchar23 1 1 Contains the country where the address exists. null null null null null
post varchar230 0 1 Contains the zip code for the address. null null null null null
contact_name varchar2120 0 1 Contains the name of the contact for the supplier at this address. null null null null null
contact_phone varchar220 0 1 Contains the phone number of the contact person at this address. null null null null null
contact_telex varchar220 0 1 Contains the telex number of the partner or suppliers representative contact. null null null null null
contact_fax varchar220 0 1 Contains the fax number of the contact person at this address. null null null null null
contact_email varchar2100 0 1 Contains the email address of the partner or suppliers representative contact. null null null null null
oracle_vendor_site_id number15 0 1 The unique identifier of this address in the Oracle Financials systems, if used. null null null null null
county varchar2250 0 1 Contains the county name for the location. null null null null null
jurisdiction_code varchar210 0 1 ID associated to the tax jurisdiction of the country-state relationship. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.