Retail Integration Mappings Report Release:15.0.0 (Retail Merchandising System)
Application Retail Merchandising System
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:15.0.0 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for WHDesc in RMS application.
RMS's Table Name RMS's Column Name Integration API(RIB or/and RSB or/and RSL) RMS's Column Length Is Column Required in RMS's API? RMS'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. wh wh null null Yes The number to uniquely identify the warehouse. The warehouse table stores all warehouses in the system, both virtual and physical.
wh_name varchar2150 1 1 Not Yet Available wh wh_name null null Yes The name of the warehouse.
wh_add1 varchar2240 0 1 Not Yet Available * * null null No Not used by RMS.
wh_add2 varchar2240 0 1 Not Yet Available * * null null No Not used by RMS.
wh_city varchar2120 0 1 Not Yet Available * * null null No Not used by RMS.
county varchar2250 0 1 Not Yet Available * * null null No Not used by RMS.
state varchar23 0 1 Not Yet Available * * null null No Not used by RMS.
country_id varchar23 0 1 Not Yet Available * * null null No Not used by RMS.
wh_pcode varchar230 0 1 NA * * null null No Not used by RMS.
email varchar2100 0 1 Not Yet Available wh email null null No The email address for the warehouse.
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. wh stockholding_ind null null Yes 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) or Y (for a virtual warehouse).
channel_id number4 0 1 The channel for which the virtual warehouse will be assigned. wh channel_id null null No The channel for which the virtual warehouse will be assigned.
currency_code varchar23 1 1 The code for the currency which the warehouse uses. wh currency_code null null Yes The code for the currency used by the warehouse.
duns_number varchar29 0 1 This type can hold a number of digits count umber. wh duns_number null null No The Dun and Bradstreet number to identify the warehouse.
duns_loc varchar24 0 1 The Dun and Bradstreet number to identify the location. wh duns_loc null null No The Dun and Bradstreet number to identify the location.
physical_wh number10 0 1 The number of the physical warehouse corresponding to this warehouse. wh physical_wh null null Yes The number of the physical warehouse corresponding to this warehouse.
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' wh break_pack_ind null null Yes Indicates whether the warehouse is capable of distributing less than the supplier case quantity. Valid values are Yand N.
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. wh redist_wh_ind null null Yes Indicates whether the warehouse is a Redistribution 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 the Redistribution report.
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. wh delivery_policy null null Yes The warehouse's delivery policy. 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.
contact_person varchar2120 0 1 NA * * null null No Not used by RMS.
dest_fax varchar220 0 1 NA * * null null No Not used by RMS.
phone_nbr varchar220 0 1 NA * * null null No Not used by RMS.
default_route varchar210 0 1 NA * * null null No Not used by RMS.
default_carrier_code varchar24 0 1 NA * * null null No Not used by RMS.
default_service_code varchar26 0 1 NA * * null null No Not used by RMS.
expedite_route varchar210 0 1 NA * * null null No Not used by RMS.
expedite_carrier_code varchar24 0 1 NA * * null null No Not used by RMS.
expedite_service_code varchar26 0 1 NA * * null null No Not used by RMS.
bol_upload_type varchar24 0 1 NA * * null null No Field not used.
bol_print_type varchar24 0 1 NA * * null null No Not used by RMS.
lead_time number4 0 1 NA * * null null No Not used by RMS.
distance_to_dest number4 0 1 NA * * null null No Always set to zero.
drop_trailers_accepted_flag varchar21 0 1 NA * * null null No Not used by RMS.
rcv_dock_available_flag varchar21 0 1 NA * * null null No Not used by RMS.
container_type varchar26 0 1 NA * * null null No Not used by RMS.
mld_default_route varchar210 0 1 NA * * null null No Not used by RMS.
unit_pick_container_type varchar26 0 1 NA * * null null No Not used by RMS.
dest_seq_nbr number4 0 1 NA * * null null No Always set to zero.
owning_dc varchar210 0 1 NA * * null null No Not used by RMS.
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. wh_add pricing_location null null No The location for which pricing information was copied for this warehouse.
pricing_loc_curr varchar23 0 1 This is the currency code of the pricing location. wh_add pricing_loc_curr null null No This is the currency code of the pricing location.
org_unit_id number15 0 1 This field holds the Org Unit id of the Warehouse. wh org_unit_id null varchar2(1) No This field holds the Org Unit id of the Warehouse. .

XML-Schema Name:AddrDesc 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 AddrDesc in RMS application.
RMS's Table Name RMS's Column Name Integration API(RIB or/and RSB or/and RSL) RMS's Column Length Is Column Required in RMS's API? RMS's API Description
city_id varchar210 0 1 Indicates the City Id or Code. N/A N/A varchar2 10 No Indicates the City Id or Code.
state_name varchar2120 0 1 Indicates the State name. state description varchar2 120 No Indicates the State name.
country_name varchar2120 0 1 Indicates the Country Name. For e.g Brazil,United States country country_desc varchar2 120 No Indicates the Country Name. For e.g Brazil,United States
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. addr external_ref_id varchar2 32 Yes 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.
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. addr addr_type varchar2 2 Yes Indicates the type for the address. Valid values (e.g. 01-business, 02-postal) are in the add_type table.
primary_addr_type_ind varchar21 0 1 Description is not available. * * varchar2 1 No Fill this description.
primary_addr_ind varchar21 1 1 Indicates whether this address is the primary address for this address type addr primary_addr_ind varchar2 1 Yes Indicated whether this address is the primary address for this address type.
add_1 varchar2240 1 1 Contains the first line of the address addr add_1 varchar2 240 Yes Contains the first line of the address.
add_2 varchar2240 0 1 Contains the second line of the address. addr add_2 varchar2 240 No Contains the second line of the address.
add_3 varchar2240 0 1 Contains the thirdline of the address. addr add_3 varchar2 240 No Contains the third line of the address.
city varchar2120 1 1 Contains the name of the city that is associated with the address. addr city varchar2 120 Yes Contains the name of the city that is associated with the address.
state varchar23 0 1 Contains the postal abbreviation for the state in which the warehouse is located. addr state varchar2 3 No Contains the postal abbreviation for the state in which the warehouse is located.
country_id varchar23 1 1 Contains the country where the address exists. addr country_id varchar2 3 Yes Contains the country where the address exists.
post varchar230 0 1 Contains the zip code for the address. addr post varchar2 30 No Contains the zip code for the address.
contact_name varchar2120 0 1 Contains the name of the contact for the supplier at this address. addr contact_name varchar2 120 No Contains the name of the contact for the supplier at this address.
contact_phone varchar220 0 1 Contains the phone number of the contact person at this address. addr contact_phone varchar2 20 No Contains the phone number of the contact person at this address.
contact_telex varchar220 0 1 Contains the telex number of the partner or suppliers representative contact. addr contact_telex varchar2 20 No Contains the telex number of the partner or suppliers representative contact.
contact_fax varchar220 0 1 Contains the fax number of the contact person at this address. addr contact_fax varchar2 20 No Contains the fax number of the contact person at this address.
contact_email varchar2100 0 1 Contains the email address of the partner or suppliers representative contact. addr contact_email varchar2 100 No Contains the email address of the partner or suppliers representative contact.
oracle_vendor_site_id number15 0 1 The unique identifier of this address in the Oracle Financials systems, if used. addr oracle_vendor_site_id number 15 No The unique identifier of this address in the Oracle Financials systems, if used.
county varchar2250 0 1 Contains the county name for the location. addr county varchar2 250 No Contains the county name for the location.
jurisdiction_code varchar210 0 1 ID associated to the tax jurisdiction of the country-state relationship. addr jurisdiction_code varchar2 10 No ID associated to the tax jurisdiction of the country-state relationship.