Retail Integration Bus Mappings Report Release:13.2.0 (Retail Merchandizing System)
Application Retail Merchandizing System
Target Name Space http://www.oracle.com/retail/integration/base/bo/TsfRef/v1
Version 1.0
Description This is root element of this document which contains name space definitions for the document elements.

XML-Schema Name:TsfRef Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rms Mapping For TsfRef
Table Name Column Name API Type Column Length API Required API Description
tsf_no number10 1 1 The number that uniquely identifies the transfer within the system. tsfhead tsf_no null null Yes The number to uniquely identify the transfer within the system.
doc_type varchar21 1 1 NA * * null null Yes Defaults to T for RMS transfers.
physical_from_loc number10 1 1 NA store, wh store, physical_wh number 10 Yes Physical location of the from_loc.
from_loc varchar210 1 1 The location number of the transfer from location. This will be either a store or warehouse number based on the from_loc_type field. tsfhead from_loc null null 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 number10 1 1 NA store, wh store, physical_wh number 10 Yes Physical location of the to_loc.
to_loc varchar210 1 1 The location number of the transfer to location. This will be either a store or warehouse number based on the to_loc_type field. tsfhead to_loc null null 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 * 0 unbounded Child Node - see below.
tsf_parent_no number10 0 1 Description is not available. NA NA NA NA NA NA
ExtOfTsfRef:ExtOfTsfRef * 0 1 Provide an extension hook to customize TsfRef. NA NA NA NA NA NA
LocOfTsfRef:LocOfTsfRef * 0 1 Provide an extension hook to localize TsfRef. NA NA NA NA NA NA

XML-Schema Name:TsfDtlRef Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rms Mapping For TsfDtlRef
Table Name Column Name API Type Column Length API Required API Description
item varchar225 1 1 Unique alphanumeric value that identifies the item. tsfdetail item varchar2 25 Yes Unique alphanumeric value to identify the item.
ExtOfTsfRef:ExtOfTsfDtlRef * 0 1 Provide an extension hook to customize TsfDtlRef. NA NA NA NA NA NA
LocOfTsfRef:LocOfTsfDtlRef * 0 1 Provide an extension hook to localize TsfDtlRef. NA NA NA NA NA NA

XML-Schema Name:ExtOfTsfDtlRef Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rms Mapping For ExtOfTsfDtlRef
Table Name Column Name API Type Column Length API Required API Description

XML-Schema Name:LocOfTsfDtlRef Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rms Mapping For LocOfTsfDtlRef
Table Name Column Name API Type Column Length API Required API Description
InTsfRef:InTsfDtlRef * 0 unbounded India Localization. NA NA NA NA NA NA
BrTsfRef:BrTsfDtlRef * 0 unbounded Brazil Localization. NA NA NA NA NA NA

XML-Schema Name:ExtOfTsfRef Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rms Mapping For ExtOfTsfRef
Table Name Column Name API Type Column Length API Required API Description

XML-Schema Name:LocOfTsfRef Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rms Mapping For LocOfTsfRef
Table Name Column Name API Type Column Length API Required API Description
InTsfRef:InTsfRef * 0 unbounded India Localization. NA NA NA NA NA NA
BrTsfRef:BrTsfRef * 0 unbounded Brazil Localization. NA NA NA NA NA NA