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

XML-Schema Name:XTsfDesc Version:13.1 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 is a code indicating more detailed freight info.
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 (e.g. normal, expedite, etc.).
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 (e.g. store requisition, book transfer, etc.).
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 (e.g. approved, closed, etc.).
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.
ExtOfXTsfDesc:ExtOfXTsfDesc * 0 1 Provide an extension hook to customize XTsfDesc. NA NA NA NA NA NA

XML-Schema Name:XTsfDtl Version:13.1 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 on 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

XML-Schema Name:ExtOfXTsfDtl Version:13.1 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:ExtOfXTsfDesc Version:13.1 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