Retail Integration Bus Mappings Report Release:13.1

(Retail Warehouse Management System)

Application Retail Warehouse Management System Target Name Space http://www.oracle.com/retail/integration/base/bo/LocationDesc/v1 Version 1.0 Description This is root element of this document which contains name space definitions for the document elements. LocationDesc ExtOfLocationDesc

XML-Schema Name:LocationDesc Version:13.1 Return to Top Tag Name Type Min Occurs Max Occurs Description rwms Mapping For LocationDesc Table Name Column Name API Type Column Length API Required API Description dest_id varchar210 1 1 Description is not available. ship_dest dest_id varchar2 10 * * dest_type varchar220 0 1 Description is not available. ship_dest dest_type varchar2 20 * * description varchar21000 0 1 Description is not available. ship_dest description varchar2 1000 * * address1 varchar2240 0 1 Description is not available. ship_dest address1 varchar2 240 * * address2 varchar2240 0 1 Description is not available. ship_dest address2 varchar2 240 * * city varchar2120 0 1 Description is not available. shiip_dest city varchar2 120 * * state varchar23 0 1 Description is not available. ship_dest state varchar2 3 * * country_code varchar23 0 1 Description is not available. ship_dest country_code varchar2 3 * * zip varchar230 0 1 Description is not available. ship_dest zip varchar2 30 * * contact_person varchar2120 0 1 Description is not available. ship_dest contact_person varchar2 120 * * dest_fax varchar220 0 1 Description is not available. ship_dest dest_fax varchar2 20 * * phone_nbr varchar220 0 1 Description is not available. ship_dest phone_nbr varchar2 20 * * currency_code varchar23 0 1 Description is not available. ship_dest currency_code varchar2 3 * * default_route varchar210 0 1 Description is not available. ship_dest default_route varchar2 10 * * default_carrier_code varchar24 0 1 Description is not available. ship_dest default_carrier_code varchar2 4 * * default_service_code varchar26 0 1 Description is not available. ship_dest default_service_code varchar2 6 * * expedite_route varchar210 0 1 Description is not available. ship_dest expedite_route varchar2 10 * * expedite_carrier_code varchar24 0 1 Description is not available. ship_dest expedite_carrier_code varchar2 4 * * expedite_service_code varchar26 0 1 Description is not available. ship_dest expedite_service_code varchar2 6 * * bol_upload_type varchar24 0 1 Description is not available. ship_dest bol_upload_type varchar2 4 * * bol_print_type varchar24 0 1 Description is not available. ship_dest bol_print_type varchar2 4 * * lead_time number3 0 1 Description is not available. ship_dest lead_time number 4 * * distance_to_dest number4 0 1 Description is not available. ship_dest distance_to_dest number 4 * * drop_trailers_accepted_flag varchar21 0 1 Description is not available. ship_dest drop_trailers_accepted_flag varchar2 1 * * rcv_dock_available_flag varchar21 0 1 Description is not available. ship_dest rcv_dock_available_flag varchar2 1 * * container_type varchar26 0 1 Description is not available. ship_dest container_type varchar2 6 * * mld_default_route varchar210 0 1 Description is not available. ship_dest mld_default_route varchar2 10 * * unit_pick_container_type varchar26 0 1 Description is not available. ship_dest unit_pick_container_type varchar2 6 * * dest_seq_nbr number4 0 1 Description is not available. ship_dest dest_seq_nbr number 4 * * owning_dc varchar210 0 1 Description is not available. ship_dest owning_dc varchar2 10 * * email_to varchar2500 0 1 Description is not available. ship_dest email_to varchar2 500 * * email_cc varchar2500 0 1 Description is not available. ship_dest email_cc varchar2 500 * * email_bcc varchar2500 0 1 Description is not available. ship_dest email_bcc varchar2 500 * * ExtOfLocationDesc:ExtOfLocationDesc * 0 1 Provide an extension hook to customize LocationDesc. NA NA NA NA NA NA

XML-Schema Name:ExtOfLocationDesc Version:13.1 Return to Top Tag Name Type Min Occurs Max Occurs Description rwms Mapping For ExtOfLocationDesc Table Name Column Name API Type Column Length API Required API Description