Retail Integration Bus Mappings Report
Application Name: Retail Merchandising System
XML-Schema or Node Name:TsfRef.xsd
Tag Name
Table Name
Column Name
API Req
Description
tsf_no
tsfhead
tsf_no
Yes
The number that uniquely identifies the transfer within the system.
doc_type
*
*
Yes
Defaulted to 'T' for RMS transfers.
physical_from_loc
store, wh
store, physical_wh
Yes
Physical location that the from_loc belongs to.
from_loc
tsfhead
from_loc
Yes
The location number of the transfer from location. This will be either a store or warehouse number based on the from_loc_type field.
physical_to_loc
store, wh
store, physical_wh
Yes
Physical location that the to_loc belongs to.
to_loc
tsfhead
to_loc
Yes
The location number of the transfer to location. This will be either a store or warehouse number based on the to_loc_type field.
TsfDtlRef
*
*
*
Child Node - see below.
Application Name: Retail Merchandising System
XML-Schema or Node Name:TsfDtlRef
Tag Name
Table Name
Column Name
API Req
Description
item
tsfdetail
item
Yes
Unique alphanumeric value that identifies the item.