Oracle Portal
 Retail Integration Bus Mappings Report    

Application Name: Retail Merchandising System
XML-Schema or Node Name:WHDesc.xsd
Tag Name Table Name Column Name API Req Description
wh wh wh Yes The number which uniquely identifies the warehouse. The wh table stores all warehouses in the system, both virtual and physical.
wh_name wh wh_name Yes The name of the warehouse.
wh_add1 * * No Field not used.
wh_add2 * * No Field not used.
wh_city * * No Field not used.
county * * No Field not used.
state * * No Field not used.
country_id * * No Field not used.
wh_pcode * * No Field not used.
email wh email No The email address for the warehouse.
stockholding_ind wh stockholding_ind 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 and 'Y' for a virtual warehouse.
channel_id wh channel_id No The channel for which the virtual warehouse will be assigned.
currency_code wh currency_code Yes The code for the currency which the warehouse uses.
duns_number wh duns_number No The Dun and Bradstreet number tp identify the warehouse.
duns_loc wh duns_loc No The Dun and Bradstreet number to identify the location.
physical_wh wh physical_wh Yes The number of the physical warehouse corresponding to this warehouse.
break_pack_ind wh break_pack_ind Yes Indicates whether or not the warehouse is capable of distributing less than the supplier case quantity. Valid values are 'Y' or 'N'
redist_wh_ind wh redist_wh_ind Yes 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.
delivery_policy wh delivery_policy Yes 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.
contact_person * * No Field not used.
dest_fax * * No Field not used.
phone_nbr * * No Field not used.
default_route * * No Field not used.
default_carrier_code * * No Field not used.
default_service_code * * No Field not used.
expedite_route * * No Field not used.
expedite_carrier_code * * No Field not used.
expedite_service_code * * No Field not used.
bol_upload_type * * No Field not used.
bol_print_type * * No Field not used.
lead_time * * No Always set to zero.
distance_to_dest * * No Always set to zero.
drop_trailers_accepted_flag * * No Field not used.
rcv_dock_available_flag * * No Field not used.
container_type * * No Field not used.
mld_default_route * * No Field not used.
unit_pick_container_type * * No Field not used.
dest_seq_nbr * * No Always set to zero.
owning_dc * * No Field not used.
AddrDesc * * * This is a child node; see layout below.
pricing_loc wh_add pricing_location No The location for which pricing info was copied for this warehouse.
pricing_loc_curr wh_add pricing_loc_curr No This is the currency code of the pricing location.

Application Name: Retail Merchandising System
XML-Schema or Node Name:AddrDesc
Tag Name Table Name Column Name API Req Description
addr addr addr_key Yes Address unique identifier
addr_type addr addr_type 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 add_type_module primary_ind Yes Y or N - indicates whether this address type is the primary address type.
primary_addr_ind addr primary_addr_ind Yes Indicates whether this address is the primary address for this address type
add_1 addr add_1 Yes Contains the first line of the address
add_2 addr add_2 No Contains the second line of the address
add_3 addr add_3 No Contains the third line of the address
city addr city Yes Contains the city of this address
state addr state No Contains the postal abbreviation for the state in which the warehouse is located.
country_id addr country_id Yes Contains the country code for this address.
post addr post No Contains the zip code for the address
contact_name addr contact_name No Contains the name of the contact for this address
contact_phone addr contact_phone No Contains the phone number of the contact for this address.
contact_telex addr contact_telex No Contains the telex number of the contact at this address.
contact_fax addr contact_fax No Contains the fax number of the contact at this address.
contact_email addr contact_email No Contains the email address of the contact at this address.
oracle_vendor_site_id addr oracle_vendor_site_id No The unique identifier of this address in the Oracle Financials systems, if used.
county addr county No The county of this address.