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/XTsfDesc/v1
Version 1.1
Description This is root element of this document which contains name space definitions for the document elements.

XML-Schema Name:XTsfDesc Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rms Mapping For XTsfDesc
Table Name Column Name API Type Column Length API Required API Description
tsf_no number10 1 1 Number that uniquely identifies the transfer. tsfhead tsf_no null null Yes Number that uniquely identifies the transfer.
from_loc_type varchar21 1 1 The location type of the from location. tsfhead from_loc_type null null Yes The location type of the From location.
from_loc varchar210 1 1 The location number of the from location. tsfhead from_loc null null Yes The location number of the From location.
to_loc_type varchar21 1 1 The location type of the to location. tsfhead to_loc_type null null Yes The location type of the To location.
to_loc varchar210 1 1 The location number of the to location. tsfhead to_loc null null Yes The location number of the To location.
delivery_date xs:dateTime 0 1 The earliest date the transfer can be delivered. tsfhead delivery_date null null No The earliest date the transfer can be delivered.
dept number4 0 1 The department number associated with the transfer. tsfhead dept null null No The department number associated with the transfer.
routing_code varchar21 0 1 If the freight status is expedite, this is a code indicating more detailed freight info. tsfhead routing_code null null No If the freight status is expedite, this code indicates more detailed freight information.
freight_code varchar21 0 1 A code indicating the freight status of the transfer (e.g. normal, expedite, etc.). tsfhead freight_code null null No A code indicating the freight status of the transfer (such as normal and expedite).
tsf_type varchar26 0 1 A code indicating the type of transfer (e.g. store requisition, book transfer, etc.). tsfhead tsf_type null null No A code indicating the type of transfer (such as store requisition and book transfer).
XTsfDtl * 0 unbounded Child node - see layout below.
status varchar21 0 1 A code indicating the status of the transfer (e.g. approved, closed, etc.). tsfhead status null null No A code indicating the status of the transfer, such as Approved and Closed.
user_id varchar230 0 1 The userid of the user who created the transfer. tsfhead create_id null null No The userid of the user who created the transfer.
comment_desc varchar22000 0 1 Comments associated with the transfer. tsfhead comment_desc null null No Comments associated with the transfer.
context_type varchar26 0 1 This field holds the functional area code to which the transfer relates to. Valid values are PROM and REPAIR. tsfhead context_type null varchar2(6) No This field holds the functional area code to which the transfer relates to. Valid values are PROM and REPAIR.
context_value varchar225 0 1 This field holds the value relating to the context type like Promotion number. tsfhead tsf_type null null No This field holds the value relating to the context type like Promotion number.
ExtOfXTsfDesc:ExtOfXTsfDesc * 0 1 Provide an extension hook to customize XTsfDesc. NA NA NA NA NA NA
LocOfXTsfDesc:LocOfXTsfDesc * 0 1 Provide an extension hook to localize XTsfDesc. NA NA NA NA NA NA

XML-Schema Name:XTsfDtl Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rms Mapping For XTsfDtl
Table Name Column Name API Type Column Length API Required API Description
item varchar225 1 1 The unique identifier of the item being transferred. tsfdetail item null null Yes The unique identifier of the item being transferred.
tsf_qty number12_4 1 1 The total quantity of the item reserved for this transfer at the from location. tsfdetail tsf_qty null null Yes The total quantity of the item reserved for this transfer at the From location.
supp_pack_size number12_4 0 1 The supplier pack size for this item/transfer. tsfdetail supp_pack_size null null No The supplier pack size for this item/transfer.
inv_status number2 0 1 A code indicating the inventory status for this transfer detail; valid values are found on the inv_status_types table. tsfdetail inv_status null null No A code indicating the inventory status for this transfer detail; valid values are found in the inv_status_types table.
unit_cost number20_4 0 1 Not mapped to a database field. Sometimes used to calculate retail price. * * null null No Not mapped to a database field. Sometimes used to calculate retail price.
ExtOfXTsfDesc:ExtOfXTsfDtl * 0 1 Provide an extension hook to customize XTsfDtl. NA NA NA NA NA NA
LocOfXTsfDesc:LocOfXTsfDtl * 0 1 Provide an extension hook to localize XTsfDtl. NA NA NA NA NA NA

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

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

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

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