Retail Integration Bus Mappings Report
Application Name: Retail Warehouse Management System
XML-Schema or Node Name:LocationDesc.xsd
Tag Name
Table Name
Column Name
API Req
Description
dest_id
ship_dest
dest_id
*
*
dest_type
ship_dest
dest_type
*
*
description
ship_dest
description
*
*
address1
ship_dest
address1
*
*
address2
ship_dest
address2
*
*
city
shiip_dest
city
*
*
state
ship_dest
state
*
*
country_code
ship_dest
country_code
*
*
zip
ship_dest
zip
*
*
contact_person
ship_dest
contact_person
*
*
dest_fax
ship_dest
dest_fax
*
*
phone_nbr
ship_dest
phone_nbr
*
*
currency_code
ship_dest
currency_code
*
*
default_route
ship_dest
default_route
*
*
default_carrier_code
ship_dest
default_carrier_code
*
*
default_service_code
ship_dest
default_service_code
*
*
expedite_route
ship_dest
expedite_route
*
*
expedite_carrier_code
ship_dest
expedite_carrier_code
*
*
expedite_service_code
ship_dest
expedite_service_code
*
*
bol_upload_type
ship_dest
bol_upload_type
*
*
bol_print_type
ship_dest
bol_print_type
*
*
lead_time
ship_dest
lead_time
*
*
distance_to_dest
ship_dest
distance_to_dest
*
*
drop_trailers_accepted_flag
ship_dest
drop_trailers_accepted_flag
*
*
rcv_dock_available_flag
ship_dest
rcv_dock_available_flag
*
*
container_type
ship_dest
container_type
*
*
mld_default_route
ship_dest
mld_default_route
*
*
unit_pick_container_type
ship_dest
unit_pick_container_type
*
*
dest_seq_nbr
ship_dest
dest_seq_nbr
*
*
owning_dc
ship_dest
owning_dc
*
*
email_to
ship_dest
email_to
*
*
email_cc
ship_dest
email_cc
*
*
email_bcc
ship_dest
email_bcc
*
*