Oracle Portal
 Retail Integration Bus Mappings Report     Release: 13.0.1

Application Name: Retail Merchandising System
Version 13.0.1
XML-Schema or Node Name:TsfDesc.xsd
Tag Name Table Name Column Name API Req Description
tsf_no tsfhead tsf_no Yes The number that uniquely identifies the transfer.
doc_type * * Yes Defaulted to 'T' for RMS transfers.
physical_from_loc store, wh store, physical_wh Yes Physical location that the from_loc belongs to.
from_loc_type item_loc loc_type Yes Type of location in the location field. Valid values are: S = Store W = Warehouse
from_loc tsfhead from_loc 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 store, wh store, physical_wh Yes Physical location that the to_loc belongs to.
to_loc_type item_loc loc_type Yes Type of location in the location field. Valid values are: S = Store W = Warehouse
to_loc tsfhead to_loc 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 tsfhead tsf_type 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 tsfhead approval_date Yes The date the transfer was approved.
pick_not_after_date * * Yes This is a calculated date.
default_order_type system_options default_order_type 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 * * No Reserved for future use; currently defaulted to 1.
break_by_distro * * Yes Set to 'Y' if the deliver_type for the transfer's customer is 'S'. Otherwise, set to N.
delivery_date tsfhead delivery_date 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 customer cust_name No The name of the customer.
deliver_add1 ordcust deliver_add1 No The delivery address for the customer/order relationship.
deliver_add2 ordcust deliver_add2 No Contains an optional second line of the delivery address for the customer/order relationship.
deliver_city ordcust deliver_city No Contains the city in which the customer order will be delivered.
deliver_state ordcust deliver_state No Contains the state in which the customer order will be delivered.
deliver_post ordcust deliver_post No Contains the postal code in which the customer order will be delivered.
deliver_country_id ordcust deliver_country_id No Contains the country in which the customer order will be delivered.
message tsfhead comment_desc No Any comments associated with the transfer.
TsfDtl * * * Child node - see layout below.
tsf_parent_no tsfhead tsf_parent_no No Transfer parent number
exp_dc_date tsfhead exp_dc_date No Date the inventory is expected to arrive at the DC.
approval_id tsfhead approval_id No The ID of the user who approved the transfer
approval_date tsfhead approval_date No Date the transfer was approved
from_loc_tsf_entity store, wh tsf_entity_id No Transfer entity of the from location
to_loc_tsf_entity store, wh tsf_entity_id No Transfer entity of the to location
inv_type tsfhead inventory_type No Type of inventory
tsf_status tsfhead status No Status of the transfer.
not_after_date tsfhead not_after_date No The last day delivery of the transfer will be accepted
context_type tsfhead context_type No Can be used to indicate the transfer reason or category, e.g. 'promotion'.
context_value tsfhead context_value 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.

Application Name: Retail Merchandising System
Version 13.0.1
XML-Schema or Node Name:TsfDtl
Tag Name Table Name Column Name API Req Description
item tsfdetail item Yes Unique alphanumeric value that identifies the item.
tsf_qty tsfdetail tsf_qty 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 * * No This field is generated from a call to PRICING_ATTRIB_SQL.GET_RETAIL with item as the input.
selling_uom * * No This field is generated from a call to PRICING_ATTRIB_SQL.GET_RETAIL with item as the input.
priority * * No This field is currently defaulted to 1. It is reserved for future use.
expedite_flag * * No If TSFHEAD.FREIGHT_CODE is 'E', expedite_flag is 'Y'. Otherwise, expedite_flag is 'N'.
store_ord_mult item_loc store_ord_mult No The multiple in which the item needs to be shipped from a warehouse to the location.
tsf_po_link_no tsfdetail tsf_po_link_no 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 item_ticket ticket_type_id No The ticket type associated with the item.
TsfDtlTckt * * * Child Node - see layout below.
inv_status tsfdetail inv_status No *

Application Name: Retail Merchandising System
Version 13.0.1
XML-Schema or Node Name:TsfDtlTckt
Tag Name Table Name Column Name API Req Description
comp_item packitem_breakout item Yes Alphanumeric value that identifies the item within the pack.
comp_price * * No This field is generated from a call to PRICING_ATTRIB_SQL.GET_RETAIL with comp_item as the input.
comp_selling_uom * * No This field is generated from a call to PRICING_ATTRIB_SQL.GET_RETAIL with comp_item as the input.