Retail Integration Bus Mappings Report Release:13.1

(Retail Merchandizing System)

Application Retail Merchandizing System 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 rms 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. wh wh null null Yes The number which uniquely identifies the warehouse. The wh 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 Field not used. wh_add2 varchar2240 0 1 Not Yet Available * * null null No Field not used. wh_city varchar2120 0 1 Not Yet Available * * null null No Field not used. county varchar2250 0 1 Not Yet Available * * null null No Field not used. state varchar23 0 1 Not Yet Available * * null null No Field not used. country_id varchar23 0 1 Not Yet Available * * null null No Field not used. wh_pcode varchar230 0 1 NA * * null null No Field not used. 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 and '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 which the warehouse uses. 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 tp 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 or not the warehouse is capable of distributing less than the supplier case quantity. Valid values are 'Y' or '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 '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 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 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 varchar2120 0 1 NA * * null null No Field not used. dest_fax varchar220 0 1 NA * * null null No Field not used. phone_nbr varchar220 0 1 NA * * null null No Field not used. default_route varchar210 0 1 NA * * null null No Field not used. default_carrier_code varchar24 0 1 NA * * null null No Field not used. default_service_code varchar26 0 1 NA * * null null No Field not used. expedite_route varchar210 0 1 NA * * null null No Field not used. expedite_carrier_code varchar24 0 1 NA * * null null No Field not used. expedite_service_code varchar26 0 1 NA * * null null No Field not used. bol_upload_type varchar24 0 1 NA * * null null No Field not used. bol_print_type varchar24 0 1 NA * * null null No Field not used. lead_time number4 0 1 NA * * null null No Always set to zero. 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 Field not used. rcv_dock_available_flag varchar21 0 1 NA * * null null No Field not used. container_type varchar26 0 1 NA * * null null No Field not used. mld_default_route varchar210 0 1 NA * * null null No Field not used. unit_pick_container_type varchar26 0 1 NA * * null null No Field not used. dest_seq_nbr number4 0 1 NA * * null null No Always set to zero. owning_dc varchar210 0 1 NA * * null null No Field not used. 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 info 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. 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 rms Mapping For AddrDesc Table Name Column Name API Type Column Length API Required API Description addr number6 1 1 Description is not available. addr addr_key null null Yes Address unique identifier 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 null null 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 1 1 Description is not available. add_type_module primary_ind null null Yes Y or N - indicates whether this address type is the primary address type. primary_addr_ind varchar21 1 1 Indicates whether this address is the primary address for this address type addr primary_addr_ind null null Yes Indicates whether this address is the primary address for this address type add_1 varchar2240 1 1 Description is not available. addr add_1 varchar2 240 Yes Contains the first line of the address add_2 varchar2240 0 1 Description is not available. addr add_2 varchar2 240 No Contains the second line of the address add_3 varchar2240 0 1 Description is not available. addr add_3 varchar2 240 No Contains the third line of the address city varchar2120 1 1 Description is not available. addr city null null Yes Contains the city of this address state varchar23 0 1 Contains the postal abbreviation for the state in which the warehouse is located. addr state null null No Contains the postal abbreviation for the state in which the warehouse is located. country_id varchar23 1 1 Description is not available. addr country_id null null Yes Contains the country code for this address. post varchar230 0 1 Description is not available. addr post null null No Contains the zip code for the address contact_name varchar2120 0 1 Description is not available. addr contact_name null null No Contains the name of the contact for this address contact_phone varchar220 0 1 Description is not available. addr contact_phone null null No Contains the phone number of the contact for this address. contact_telex varchar220 0 1 Contains the telex number of the partner or suppliers representative contact. addr contact_telex null null No Contains the telex number of the contact at this address. contact_fax varchar220 0 1 Description is not available. addr contact_fax null null No Contains the fax number of the contact at this address. contact_email varchar2100 0 1 Contains the email address of the partner or suppliers representative contact. addr contact_email null null No Contains the email address of the contact at this address. 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 null null No The unique identifier of this address in the Oracle Financials systems, if used. county varchar220 0 1 Description is not available. addr county null null No The county of this address. 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 rms 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 rms Mapping For ExtOfWHDesc Table Name Column Name API Type Column Length API Required API Description