Retail Integration Mappings Report Release:14.1.0 (Retail Merchandising System)
Application Retail Merchandising 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.
XSD Structure

XML-Schema Name:TsfRef Version:14.1.0 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for TsfRef in RMS application.
RMS's Table Name RMS's Column Name Integration API(RIB or/and RSB or/and RSL) RMS's Column Length Is Column Required in RMS's API? RMS's API Description
tsf_no number12 1 1 The number that uniquely identifies the transfer within the system. tsfhead tsf_no number 12 Yes The number to uniquely identify the transfer within the system.
doc_type varchar21 1 1 Defaults to T for RMS transfers. n/a n/a n/a n/a Yes Defaults to T for RMS transfers.
physical_from_loc number10 1 1 Holds the physical_wh value for the from location if it is a warehouse. Otherwise, this will be equal to the value of the from location. store, wh store, physical_wh number 10 Yes Holds the physical_wh value for the from location if it is a warehouse. Otherwise, this will be equal to the value for the from location.
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 varchar2 10 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.
from_loc_type varchar21 0 1 Type of location in the from_loc field. Valid values are: S = Store, W = Warehouse, E = external finisher. tsfhead from_loc_type varchar2 1 Yes Type of location in the from_loc field. Valid values are S = Store, W = Warehouse, E = external finisher.
from_store_type varchar21 0 1 Indicates the store type of the from_loc store. Only populated if from_loc_type is 'S'. Valid values are: 'C' = company store, 'F' = franchise store. store store_type varchar2 6 No Indicates the store type of the from_loc store. Only populated if from_loc_type is 'S'. Valid values are 'C' = company store, 'F' = franchise store.
from_stockholding_ind varchar21 0 1 Indicates if the from_loc store is stockholding or not. Only populated if from_loc_type is 'S'. Valid values are: 'Y' = yes, 'N' = no. store stockholding_ind varchar2 1 No Indicates if the from_loc store is stockholding or not. Only populated if from_loc_type is 'S'. Valid values are 'Y' = yes, 'N' = no.
physical_to_loc number10 1 1 Holds the physical_wh value for to location if it is a warehouse. Otherwise, this will be equal to the value of the to location. store, wh store, physical_wh number 10 Yes Holds the physical_wh value for the value in the TO_LOC field if TO_LOC holds a wh. This will be equal to TO_LOC if TO_LOC is a store.
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 varchar2 10 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.
to_loc_type varchar21 0 1 Type of location in the to_loc field. Valid values are: S = Store, W = Warehouse, E = external finisher. tsfhead to_loc_type varchar2 1 Yes Type of location in the to_loc field. Valid values are S = Store, W = Warehouse, E = external finisher.
to_store_type varchar21 0 1 Indicates the store type of the to_loc store. Only populated if to_loc_type is 'S'. Valid values are: 'C' = company store, 'F' = franchise store. store store_type varchar2 6 No Indicates the store type of the to_loc store. Only populated if to_loc_type is 'S'. Valid values are 'C' = company store, 'F' = franchise store.
to_stockholding_ind varchar21 0 1 Indicates if the to_loc store is stockholding or not. Only populated if to_loc_type is 'S'. Valid values are: 'Y' = yes, 'N' = no. store stockholding_ind varchar2 1 No Indicates if the to_loc store is stockholding or not. Only populated if to_loc_type is 'S'. Valid values are 'Y' = yes, 'N' = no.
TsfDtlRef * 0 unbounded Child Node - see below.
tsf_parent_no number12 0 1 Identifies the transfer at the level above the transfer. n/a n/a n/a n/a No Not used by RMS.

XML-Schema Name:TsfDtlRef Version:14.1.0 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for TsfDtlRef in RMS application.
RMS's Table Name RMS's Column Name Integration API(RIB or/and RSB or/and RSL) RMS's Column Length Is Column Required in RMS's API? RMS's 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.