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

XML-Schema Name:TsfDesc Version:13.1 Return to Top
Tag Name Type Min Occurs Max Occurs Description rms Mapping For TsfDesc
Table Name Column Name API Type Column Length API Required API Description
tsf_no number10 1 1 The number that uniquely identifies the transfer. tsfhead tsf_no null null Yes The number that uniquely identifies the transfer.
doc_type varchar21 1 1 Defaulted to 'T' for RMS transfers. * * null null Yes Defaulted to 'T' for RMS transfers.
physical_from_loc number10 1 1 Physical location that the from_loc belongs to. store, wh store, physical_wh number 10 Yes Physical location that the from_loc belongs to.
from_loc_type varchar21 1 1 Type of location in the location field. Valid values are: S = Store W = Warehouse item_loc loc_type null null Yes Type of location in the location field. Valid values are: S = Store W = Warehouse
from_loc varchar210 1 1 The location number of the transfer from location. This field will contain 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 field will contain either a store or warehouse number based on the from_loc_type field.
physical_to_loc number10 1 1 Physical location that the to_loc belongs to. store, wh store, physical_wh number 10 Yes Physical location that the to_loc belongs to.
to_loc_type varchar21 1 1 Type of location in the location field. Valid values are: S = Store W = Warehouse item_loc loc_type null null Yes Type of location in the location field. Valid values are: S = Store W = Warehouse
to_loc varchar210 1 1 The location number of the transfer to location. This field will contain 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 field will contain either a store or warehouse number based on the to_loc_type field.
tsf_type varchar26 1 1 A code for the type of the transfer, such as SR - Store Requisition CO - Customer Order RV - RTV CF - Confirmation NS - Non-Salable AD - Administrative MR - Manual Requisitions PL - PO-Linked Transfer. tsfhead tsf_type null null Yes A code for the type of the transfer, such as SR - Store Requisition CO - Customer Order RV - RTV CF - Confirmation NS - Non-Salable AD - Administrative MR - Manual Requisitions PL - PO-Linked Transfer.
pick_not_before_date xs:dateTime 1 1 The date the transfer was approved. tsfhead approval_date null null Yes The date the transfer was approved.
pick_not_after_date xs:dateTime 1 1 This is a calculated date. * * null null Yes This is a calculated date.
default_order_type varchar29 1 1 This is the default order type associated with transfers.. RWMS uses this value to determine how to distribute stock orders. Valid values (e.g. Automatic, Manual, etc.) are on the order_types table. system_options default_order_type null null Yes This is the default order type associated with transfers.. RWMS uses this value to determine how to distribute stock orders. Valid values (e.g. Automatic, Manual, etc.) are on the order_types table.
priority number4 0 1 Reserved for future use; currently defaulted to 1. * * null null No Reserved for future use; currently defaulted to 1.
break_by_distro varchar21 1 1 Set to 'Y' if the deliver_type for the transfer's customer is 'S'. Otherwise, set to N. * * null null Yes Set to 'Y' if the deliver_type for the transfer's customer is 'S'. Otherwise, set to N.
delivery_date xs:dateTime 0 1 The earliest date that the transfer can be delivered to the store. This will be populated if the transfer type is PO-Linked. tsfhead delivery_date RIBDate * No The earliest date that the transfer can be delivered to the store. This will be populated if the transfer type is PO-Linked.
cust_name varchar240 0 1 The name of the customer. customer cust_name null null No The name of the customer.
deliver_add1 varchar2240 0 1 The delivery address for the customer/order relationship. ordcust deliver_add1 null null No The delivery address for the customer/order relationship.
deliver_add2 varchar2240 0 1 Contains an optional second line of the delivery address for the customer/order relationship. ordcust deliver_add2 varchar2 240 No Contains an optional second line of the delivery address for the customer/order relationship.
deliver_city varchar2120 0 1 Contains the city in which the customer order will be delivered. ordcust deliver_city varchar2 120 No Contains the city in which the customer order will be delivered.
deliver_state varchar23 0 1 Contains the state in which the customer order will be delivered. ordcust deliver_state varchar2 3 No Contains the state in which the customer order will be delivered.
deliver_post varchar230 0 1 Contains the postal code in which the customer order will be delivered. ordcust deliver_post varchar2 30 No Contains the postal code in which the customer order will be delivered.
deliver_country_id varchar23 0 1 Contains the country in which the customer order will be delivered. ordcust deliver_country_id varchar2 3 No Contains the country in which the customer order will be delivered.
message varchar22000 0 1 Any comments associated with the transfer. tsfhead comment_desc null null No Any comments associated with the transfer.
TsfDtl * 0 unbounded Child node - see layout below.
tsf_parent_no number10 0 1 Transfer parent number tsfhead tsf_parent_no number 10 No Transfer parent number
exp_dc_date xs:dateTime 0 1 Date the inventory is expected to arrive at the DC. tsfhead exp_dc_date RIBDate * No Date the inventory is expected to arrive at the DC.
approval_id varchar230 0 1 The ID of the user who approved the transfer tsfhead approval_id null null No The ID of the user who approved the transfer
approval_date xs:dateTime 0 1 Date the transfer was approved tsfhead approval_date RIBDate * No Date the transfer was approved
from_loc_tsf_entity number10 0 1 Transfer entity of the from location store, wh tsf_entity_id null null No Transfer entity of the from location
to_loc_tsf_entity number10 0 1 Transfer entity of the to location store, wh tsf_entity_id null null No Transfer entity of the to location
inv_type varchar26 0 1 Type of inventory tsfhead inventory_type null null No Type of inventory
tsf_status varchar21 0 1 Status of the transfer. tsfhead status null null No Status of the transfer.
not_after_date xs:dateTime 0 1 The last day delivery of the transfer will be accepted tsfhead not_after_date null null No The last day delivery of the transfer will be accepted
context_type varchar26 0 1 Can be used to indicate the transfer reason or category, e.g. 'promotion'. tsfhead context_type null null No Can be used to indicate the transfer reason or category, e.g. 'promotion'.
context_value varchar225 0 1 Further info to indicate the reason or category for the transfer. For instance, if context_type was 'promotion', this could be the promotion number. tsfhead context_value null null No Further info to indicate the reason or category for the transfer. For instance, if context_type was 'promotion', this could be the promotion number.
delivery_slot_id varchar215 0 1 Delivery Slot Id. NA NA NA NA NA NA
delivery_slot_desc varchar2240 0 1 Delivery slot description. NA NA NA NA NA NA
ExtOfTsfDesc:ExtOfTsfDesc * 0 1 Provide an extension hook to customize TsfDesc. NA NA NA NA NA NA

XML-Schema Name:TsfDtl Version:13.1 Return to Top
Tag Name Type Min Occurs Max Occurs Description rms Mapping For TsfDtl
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.
tsf_qty number12_4 1 1 The total quantity of the item reserved at the from location for this transfer. This field is set back to zero each time the stock is either merged into a 'Combined Transfer' or shipped. tsfdetail tsf_qty null null Yes The total quantity of the item reserved at the from location for this transfer. This field is set back to zero each time the stock is either merged into a 'Combined Transfer' or shipped.
price number20_4 0 1 This field is generated from a call to PRICING_ATTRIB_SQL.GET_RETAIL with item as the input. * * null null No This field is generated from a call to PRICING_ATTRIB_SQL.GET_RETAIL with item as the input.
selling_uom varchar24 0 1 This field is generated from a call to PRICING_ATTRIB_SQL.GET_RETAIL with item as the input. * * null null No This field is generated from a call to PRICING_ATTRIB_SQL.GET_RETAIL with item as the input.
priority number4 0 1 This field is currently defaulted to 1. It is reserved for future use. * * null null No This field is currently defaulted to 1. It is reserved for future use.
expedite_flag varchar21 0 1 If TSFHEAD.FREIGHT_CODE is 'E', expedite_flag is 'Y'. Otherwise, expedite_flag is 'N'. * * null null No If TSFHEAD.FREIGHT_CODE is 'E', expedite_flag is 'Y'. Otherwise, expedite_flag is 'N'.
store_ord_mult varchar21 0 1 The multiple in which the item needs to be shipped from a warehouse to the location. item_loc store_ord_mult null null No The multiple in which the item needs to be shipped from a warehouse to the location.
tsf_po_link_no number10 0 1 A reference number to link the item on the transfer to any purchase orders that have been created to allow the from location (i.e. warehouse) on the transfer to fulfill the transfer quantity to the to location (i.e store) on the transfer. tsfdetail tsf_po_link_no number 10 No A reference number to link the item on the transfer to any purchase orders that have been created to allow the from location (i.e. warehouse) on the transfer to fulfill the transfer quantity to the to location (i.e store) on the transfer.
ticket_type_id varchar24 0 1 The ticket type associated with the item. item_ticket ticket_type_id null null No The ticket type associated with the item.
TsfDtlTckt * 0 unbounded Child Node - see layout below.
inv_status number2 0 1 Description is not available. tsfdetail inv_status null null No *
ExtOfTsfDesc:ExtOfTsfDtl * 0 1 Provide an extension hook to customize TsfDtl. NA NA NA NA NA NA

XML-Schema Name:TsfDtlTckt Version:13.1 Return to Top
Tag Name Type Min Occurs Max Occurs Description rms Mapping For TsfDtlTckt
Table Name Column Name API Type Column Length API Required API Description
comp_item varchar225 1 1 Alphanumeric value that identifies the item within the pack. packitem_breakout item varchar2 25 Yes Alphanumeric value that identifies the item within the pack.
comp_price number20_4 0 1 This field is generated from a call to PRICING_ATTRIB_SQL.GET_RETAIL with comp_item as the input. * * null null No This field is generated from a call to PRICING_ATTRIB_SQL.GET_RETAIL with comp_item as the input.
comp_selling_uom varchar24 0 1 This field is generated from a call to PRICING_ATTRIB_SQL.GET_RETAIL with comp_item as the input. * * null null No This field is generated from a call to PRICING_ATTRIB_SQL.GET_RETAIL with comp_item as the input.
ExtOfTsfDesc:ExtOfTsfDtlTckt * 0 1 Provide an extension hook to customize TsfDtlTckt. NA NA NA NA NA NA

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

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

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