Retail Integration Bus Mappings Report Release:13.1

(Store Inventory Management)

Application Store Inventory Management Target Name Space http://www.oracle.com/retail/integration/base/bo/WHDesc/v1 Version 1.0 Description This is root element of this document which contains name space definitions for the document elements. WHDesc AddrDesc ExtOfAddrDesc ExtOfWHDesc

XML-Schema Name:WHDesc Version:13.1 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. LO_ADS_NSTD TBD number * No Not Yet Available wh_name varchar2150 1 1 Not Yet Available TBD TBD varchar2 * Not Yet Available Not Yet Available wh_add1 varchar2240 0 1 Not Yet Available TBD TBD varchar2 * Not Yet Available Not Yet Available wh_add2 varchar2240 0 1 Not Yet Available TBD TBD varchar2 * Not Yet Available Not Yet Available wh_city varchar2120 0 1 Not Yet Available TBD TBD varchar2 * Not Yet Available Not Yet Available county varchar2250 0 1 Not Yet Available TBD TBD varchar2 * Not Yet Available Not Yet Available state varchar23 0 1 Not Yet Available TBD TBD varchar2 * Not Yet Available Not Yet Available country_id varchar23 0 1 Not Yet Available TBD TBD varchar2 * Not Yet Available Not Yet Available wh_pcode varchar230 0 1 NA null null null null null email varchar2100 0 1 Not Yet Available TBD TBD varchar2 * Not Yet Available Not Yet Available 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 null null null null channel_id number4 0 1 The channel for which the virtual warehouse will be assigned. null null null null null currency_code varchar23 1 1 The code for the currency which the warehouse uses. null null null null null duns_number varchar29 0 1 This type can hold a number of digits count umber. null null null null null duns_loc varchar24 0 1 The Dun and Bradstreet number to identify the location. null null null null null physical_wh number10 0 1 The number of the physical warehouse corresponding to this warehouse. null null null null null 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 null null null null 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 null null null null 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 null null null contact_person varchar2120 0 1 NA null null null null null dest_fax varchar220 0 1 NA null null null null null phone_nbr varchar220 0 1 NA null null null null null default_route varchar210 0 1 NA null null null null null default_carrier_code varchar24 0 1 NA null null null null null default_service_code varchar26 0 1 NA null null null null null expedite_route varchar210 0 1 NA null null null null null expedite_carrier_code varchar24 0 1 NA null null null null null expedite_service_code varchar26 0 1 NA null null null null null bol_upload_type varchar24 0 1 NA null null null null null bol_print_type varchar24 0 1 NA null null null null null lead_time number4 0 1 NA null null null null null distance_to_dest number4 0 1 NA null null null null null drop_trailers_accepted_flag varchar21 0 1 NA null null null null null rcv_dock_available_flag varchar21 0 1 NA null null null null null container_type varchar26 0 1 NA null null null null null mld_default_route varchar210 0 1 NA null null null null null unit_pick_container_type varchar26 0 1 NA null null null null null dest_seq_nbr number4 0 1 NA null null null null null owning_dc varchar210 0 1 NA null null null null null 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 null null null null pricing_loc_curr varchar23 0 1 This is the currency code of the pricing location. null null null null null ExtOfWHDesc:ExtOfWHDesc * 0 1 Provide an extension hook to customize WHDesc. NA NA NA NA NA NA

XML-Schema Name:AddrDesc Version:13.1 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 addr number6 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 ExtOfAddrDesc:ExtOfAddrDesc * 0 1 Provide an extension hook to customize AddrDesc. NA NA NA NA NA NA

XML-Schema Name:ExtOfAddrDesc Version:13.1 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:ExtOfWHDesc Version:13.1 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