Retail Integration Mappings Report Release:16.0.030 (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: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 RMS application.
RMS's Table Name RMS's Column Name Integration API(RIB or/and RSB or/and BDI) 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 number 10,0 Yes Contains the number which uniquely identifies the warehouse. The wh table stores all warehouses in the system. Both virtual and physical warehouses will be stored on this table. The addition of the new column, physical_wh, helps determine which warehouses are physical and which are virtual. All physical warehouses will have a physical_wh column value equal to their wh number. Virtual warehouses will have a valid physical warehouse in this column.
wh_name varchar2150 1 1 Not Yet Available wh wh_name varchar2 150 Yes The name of the warehouse.
wh_add1 varchar2240 0 1 Not Yet Available addr add_1 varchar2 240 Yes This column contains the first line of the address.
wh_add2 varchar2240 0 1 Not Yet Available addr add_2 varchar2 240 No This column contains the second line of the address.
wh_city varchar2120 0 1 Not Yet Available addr city varchar2 120 Yes This column contains the name of the city that is associated with the address.
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 varchar2 100 No Holds the email address for the location
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 varchar2 1 Yes This column will indicate 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.
channel_id number4 0 1 The channel for which the virtual warehouse will be assigned. wh channel_id number 4,0 No This column will contain 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 varchar2 3 Yes This field contains the currency code under which the warehouse operates.
duns_number varchar29 0 1 This type can hold a number of digits count umber. wh duns_number varchar2 9 No This field holds 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 varchar2 4 No This field holds 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 number 10,0 Yes This column will contain the number of the physical warehouse that is assigned to the virtual 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 varchar2 1 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 varchar2 1 Yes Indicates that 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 and approval. This value allows the Redistribution Report to identify orders requiring redistribution. A Warehouse with this indicator will not be limited in any RMS transactions.
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 varchar2 6 Yes Contains 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 before delivering. Valid values come from the DLVY code on code_head/code_detail.
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 number 10,0 No The location from which pricing records will be copied.
pricing_loc_curr varchar23 0 1 This is the currency code of the pricing location. wh_add pricing_loc_curr varchar2 3 Yes 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 number 15,0 No this column will hold the oracle oraganizational unit id value.
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 wh wh_name_secondary varchar2 150 No Secondary name of the warehouse.
vat_region number4 0 1 Not Yet Available wh vat_region number 4,0 No warehouse is located.
org_hier_type number4 0 1 Not Yet Available wh org_hier_type number 4,0 No "Contains the organization type that will be used in reporting purposes for the warehouse. The type comes from the organizational hierarchy.
org_hier_value number10 0 1 Not Yet Available wh org_hier_value number 10,0 No Contains the code associated with the specific organizational hierarchy type. Valid values include the company number, chain number, area number, etc.
primary_vwh number10 0 1 Not Yet Available wh primary_vwh number 10,0 No This field holds the virtual warehouse that will used as the basis for all transactions for which only a physical warehouse and not a virtual warehouse has not been specified.
channel_desc varchar2120 0 1 The channel description for which the virtual warehouse will be assigned. wh * * * Derived
restricted_ind varchar21 0 1 This field's indicator is used to restrict virtual warehouses from receiving stock during an inbound type transaction. wh restricted_ind varchar2 1 Yes Indicator used to restrict virtual warehouses from receiving stock during an inbound type transaction (ex. positive SOH inventory adjustment, PO over-receipt) when stock needs to be prorated across virtual warehouses within a physical warehouse because a virtual warehouse in the physical warehouse has not been identified for the transaction. The indicator will restrict the virtual warehouse from receiving stock unless all the valid virtual warehouses determined by the system are restricted, then the stock will be distributed across those restricted virtual warehouses. This indicator will only be used in a multi-channel environment. It is always set to No in a single channel environment.
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. wh protected_ind varchar2 1 Yes Indicator 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. The indicator will be used in any outbound or inventory removal type transactions (ex. RTVs, negative SOH inventory adjustments, etc.) when the system has to distribute the transaction quantity across virtual warehouses within a physical warehouse either because a virtual warehouse has not been specified or couldnt be derived or if a virtual warehouse doesnt have enough stock to cover the transaction quantity and stock needs to be pulled from other virtual warehouse within the physical warehouse. The indicator will also be used for inbound type transactions where there is some sort of short-shipment ex. a short-shipment for a PO). The indicator will determine which virtual warehouses will have their order quantity fulfilled first with the receipt quantity. Note that this indicator does not guarantee that stock will not be pulled from the virtual warehouse, it is only used to ensure that the virtual warehouse is affected last. This indicator will only be used in a multi-channel environment. It is always set to No in a single channel environment.
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. wh forecast_wh_ind varchar2 1 Yes 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.
tsf_entity_id number10 0 1 This field stores, id of the transfer entity with which this warehouse is associated. wh tsf_entity_id number 10,0 No ID of the transfer entity with which this warehouse is associated. Valid values are found on the TSF_ENTITY table. A transfer entity is a group of locations that share legal requirements around product management.
finisher_ind varchar21 0 1 This field indicates weather a virtual warehouse is an internal finisher or not. wh finisher_ind varchar2 1 Yes Yes/No value which indicates if this virtual warehouse is an internal finisher.
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. wh inbound_handling_days number 2,0 Yes Warehouse inbound handling days are defined as 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.
vwh_type varchar26 0 1 NA wh vmh_type varchar2 6 No This attribute will be included in the location downloads to AIP.
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. wh org_entity_type varchar2 1 Yes This is the new column that will specify if the warehouse is a legal entity (Importer, Exporter) or a regular warehouse.
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. wh customer_order_loc_ind varchar2 1 No This Column determines if the location is customer order location or not, i.e. if the indicator is checked then the location can be used by OMS for sourcing/ fulfillment or both else it cannot be used. It is enabled only for virtual warehouses. For a physical warehouse, this column would be NULL. For virtual warehouses.
default_wh number10 0 1 This field contains the default warehouse linked to the virtual warehouse. wh default_wh number 10,0 No This field contains the default warehouse linked to the virtual warehouse.
gift_wrapping_ind varchar21 0 1 This field indicates weathere a gift wrapping needs to be done or not. store gift_wrapping_ind varchar2 1 Yes This column will indicate if the location will support gift wrappin
customer_order_ship_ind varchar21 0 1 This field indicates wheather the customer order has been been shipped from Warehouse or not. wh customer_order_ship_ind varchar2 1 Yes This column will indicate if the location will support shipping to a customer for customer orders.

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 RMS application.
RMS's Table Name RMS's Column Name Integration API(RIB or/and RSB or/and BDI) 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 Yes Contains the full name of the state.
country_name varchar2120 0 1 Indicates the Country Name. For e.g Brazil,United States country country_desc varchar2 120 Yes Contains the name of the country.
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 addr_key number 11,0 Yes This column contains a unique number used to distinguish between different addresses.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 This column indicates the type for the address.
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 This column indicates whether the address is the primary address for the address type.
add_1 varchar2240 1 1 Contains the first line of the address addr add_1 varchar2 240 Yes This column 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 This column contains the second line of the address.
add_3 varchar2240 0 1 Contains the thirdline of the address. addr add_3 varchar2 240 No This column 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 This column 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 This column contains the state abbreviation for the address.
country_id varchar23 1 1 Contains the country where the address exists. addr country_id varchar2 3 Yes This column contains the country where the address exists.
post varchar230 0 1 Contains the zip code for the address. addr post varchar2 30 No This column 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 This column 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 This column 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 This column contains the telex number of the partner or suppliers representative contact.contact.
contact_fax varchar220 0 1 Contains the fax number of the contact person at this address. addr contact_fax varchar2 20 No This column 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 This column 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,0 No This column will only be used for the Oracle Financial Interfaces. It holds the value of the Oracle vendor site ID for a supplier address. This Oracle vendor site ID is the unique identifier of the address on the Oracle side, it must be stored on the RMS addr table to allow updates from Oracle. This site ID can be found on the Oracle po_vendor_sites table.
county varchar2250 0 1 Contains the county name for the location. addr county varchar2 250 No This column holds 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 Identifies the jurisdiction code for the country-state relationship.
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 RMS application.
RMS's Table Name RMS's Column Name Integration API(RIB or/and RSB or/and BDI) RMS's Column Length Is Column Required in RMS's API? RMS's API Description
name varchar230 1 1 Holds the attribute name. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.
value varchar2250 0 1 Holds the numeric or string value of the attribute. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.
value_date xs:dateTime 0 1 Holds the date value of the attribute. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.

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 RMS application.
RMS's Table Name RMS's Column Name Integration API(RIB or/and RSB or/and BDI) RMS's Column Length Is Column Required in RMS's API? RMS's API Description
name varchar230 1 1 Holds the attribute name. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.
value varchar2250 0 1 Holds the numeric or string value of the attribute. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.
value_date xs:dateTime 0 1 Holds the date value of the attribute. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.