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/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.1 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 that uniquely identifies the transfer within the system.
doc_type varchar21 1 1 NA * * null null Yes Defaulted to 'T' for RMS transfers.
physical_from_loc number10 1 1 NA store, wh store, physical_wh number 10 Yes Physical location that the from_loc belongs to.
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 that the to_loc belongs to.
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

XML-Schema Name:TsfDtlRef Version:13.1 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 that identifies the item.
ExtOfTsfRef:ExtOfTsfDtlRef * 0 1 Provide an extension hook to customize TsfDtlRef. NA NA NA NA NA NA

XML-Schema Name:ExtOfTsfDtlRef Version:13.1 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:ExtOfTsfRef Version:13.1 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