Retail Integration Bus Mappings Report Release:13.2.0 (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.

XML-Schema Name:WHDesc Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description sim Mapping For WHDesc
Table Name Column Name API Type Column Length API Required 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. PA_ORGN ID_PRTY_ORGN varchar2 128 Yes Warehouse id
wh_name varchar2150 1 1 Not Yet Available PA_ORGN NM_ORGN varchar2 150 No WAREHOUSE NAME
wh_add1 varchar2240 0 1 Not Yet Available ADDRESS_DETAIL ADD_1 varchar2 240 Yes FIRST ADDRESS
wh_add2 varchar2240 0 1 Not Yet Available ADDRESS_DETAIL ADD_2 varchar2 240 No second address
wh_city varchar2120 0 1 Not Yet Available ADDRESS_DETAIL CITY varchar2 120 Yes CITY OF ENTITY
county varchar2250 0 1 Not Yet Available Not Yet Available NOT USED IN SIM
state varchar23 0 1 Not Yet Available ADDRESS_DETAIL STATE varchar2 3 No STATE OF ENTITY
country_id varchar23 0 1 Not Yet Available ADDRESS_DETAIL COUNTRY_ID varchar2 3 No County_id of entity depending on address type
wh_pcode varchar230 0 1 NA ADDRESS_DETAIL post varchar2 30 No Post or zip code of entity depending on address type
email varchar2100 0 1 Not Yet Available ADDRESS_DETAIL contact_email varchar2 100 No Contact email for entity
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. null not used in sim
channel_id number4 0 1 The channel for which the virtual warehouse will be assigned. null NOT USED IN SIM
currency_code varchar23 1 1 The code for the currency which the warehouse uses. pa_str_rtl ty_cny varchar2 40 No Currency Code
duns_number varchar29 0 1 This type can hold a number of digits count umber. null NOT USED IN SIM
duns_loc varchar24 0 1 The Dun and Bradstreet number to identify the location. null NOT USED IN SIM
physical_wh number10 0 1 The number of the physical warehouse corresponding to this warehouse. 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' 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. 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. null null NOT USED IN SIM
contact_person varchar2120 0 1 NA null NOT USED IN SIM
dest_fax varchar220 0 1 NA null NOT USED IN SIM
phone_nbr varchar220 0 1 NA ADDRESS_DETAIL CONTACT_PHONE varchar2 20 No PHONE NUMBER
default_route varchar210 0 1 NA null NOT USED IN SIM
default_carrier_code varchar24 0 1 NA null NOT USED IN SIM
default_service_code varchar26 0 1 NA null NOT USED IN SIM
expedite_route varchar210 0 1 NA null NOT USED IN SIM
expedite_carrier_code varchar24 0 1 NA null NOT USED IN SIM
expedite_service_code varchar26 0 1 NA null NOT USED IN SIM
bol_upload_type varchar24 0 1 NA null NOT USED IN SIM
bol_print_type varchar24 0 1 NA null NOT USED IN SIM
lead_time number4 0 1 NA null NOT USED IN SIM
distance_to_dest number4 0 1 NA null NOT USED IN SIM
drop_trailers_accepted_flag varchar21 0 1 NA null NOT USED IN SIM
rcv_dock_available_flag varchar21 0 1 NA null NOT USED IN SIM
container_type varchar26 0 1 NA null NOT USED IN SIM
mld_default_route varchar210 0 1 NA null NOT USED IN SIM
unit_pick_container_type varchar26 0 1 NA null NOT USED IN SIM
dest_seq_nbr number4 0 1 NA null NOT USED IN SIM
owning_dc varchar210 0 1 NA 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. null NOT USED IN SIM
pricing_loc_curr varchar23 0 1 This is the currency code of the pricing location. null NOT USED IN SIM
org_unit_id number15 0 1 This field holds the Org Unit id of the Warehouse. NA NA NA NA NA NA
ExtOfWHDesc:ExtOfWHDesc * 0 1 Provide an extension hook to customize WHDesc. NA NA NA NA NA NA
LocOfWHDesc:LocOfWHDesc * 0 1 Provide an extension hook to localize WHDesc. NA NA NA NA NA NA

XML-Schema Name:AddrDesc Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description sim Mapping For AddrDesc
Table Name Column Name API Type Column Length API Required API Description
city_id varchar210 0 1 Indicates the City Id or Code. NA NA NA NA NA NA
state_name varchar2120 0 1 Indicates the State name. NA NA NA NA NA NA
country_name varchar2120 0 1 Indicates the Country Name. For e.g Brazil,United States NA NA NA NA NA NA
addr number11 1 1 Description is not available. 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 1 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 Description is not available. null varchar2 240 null null
add_2 varchar2240 0 1 Description is not available. null varchar2 240 null null
add_3 varchar2240 0 1 Description is not available. null varchar2 240 null null
city varchar2120 1 1 Description is not available. 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 Description is not available. null null null null null
post varchar230 0 1 Description is not available. null null null null null
contact_name varchar2120 0 1 Description is not available. null null null null null
contact_phone varchar220 0 1 Description is not available. 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 Description is not available. 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 varchar220 0 1 Description is not available. null null null null null
jurisdiction_code varchar210 0 1 ID associated to the tax jurisdiction of the country-state relationship. NA NA NA NA NA NA
ExtOfAddrDesc:ExtOfAddrDesc * 0 1 Provide an extension hook to customize AddrDesc. NA NA NA NA NA NA
LocOfAddrDesc:LocOfAddrDesc * 0 1 Provide an extension hook to localize AddrDesc. NA NA NA NA NA NA

XML-Schema Name:ExtOfAddrDesc Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description sim Mapping For ExtOfAddrDesc
Table Name Column Name API Type Column Length API Required API Description

XML-Schema Name:LocOfAddrDesc Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description sim Mapping For LocOfAddrDesc
Table Name Column Name API Type Column Length API Required API Description
InAddrDesc:InAddrDesc * 0 unbounded India Localization. NA NA NA NA NA NA
BrAddrDesc:BrAddrDesc * 0 unbounded Brazil Localization. NA NA NA NA NA NA

XML-Schema Name:ExtOfWHDesc Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description sim Mapping For ExtOfWHDesc
Table Name Column Name API Type Column Length API Required API Description

XML-Schema Name:LocOfWHDesc Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description sim Mapping For LocOfWHDesc
Table Name Column Name API Type Column Length API Required API Description
InWHDesc:InWHDesc * 0 unbounded India Localization. NA NA NA NA NA NA
BrWHDesc:BrWHDesc * 0 unbounded Brazil Localization. NA NA NA NA NA NA