Oracle Portal
 Retail Integration Bus Mappings Report    

Application Name: Retail Merchandising System
XML-Schema or Node Name:XTsfDesc.xsd
Tag Name Table Name Column Name API Req Description
tsf_no tsfhead tsf_no Yes Number that uniquely identifies the transfer.
from_loc_type tsfhead from_loc_type Yes The location type of the from location.
from_loc tsfhead from_loc Yes The location number of the from location.
to_loc_type tsfhead to_loc_type Yes The location type of the to location.
to_loc tsfhead to_loc Yes The location number of the to location.
delivery_date tsfhead delivery_date No The earliest date the transfer can be delivered.
dept tsfhead dept No The department number associated with the transfer.
routing_code tsfhead routing_code No If the freight status is expedite, this is a code indicating more detailed freight info.
freight_code tsfhead freight_code No A code indicating the freight status of the transfer (e.g. normal, expedite, etc.).
tsf_type tsfhead tsf_type No A code indicating the type of transfer (e.g. store requisition, book transfer, etc.).
XTsfDtl * * * Child node - see layout below.
status tsfhead status No A code indicating the status of the transfer (e.g. approved, closed, etc.).
user_id tsfhead create_id No The userid of the user who created the transfer.
comment_desc tsfhead comment_desc No Comments associated with the transfer.

Application Name: Retail Merchandising System
XML-Schema or Node Name:XTsfDtl
Tag Name Table Name Column Name API Req Description
item tsfdetail item Yes The unique identifier of the item being transferred.
tsf_qty tsfdetail tsf_qty Yes The total quantity of the item reserved for this transfer at the from location.
supp_pack_size tsfdetail supp_pack_size No The supplier pack size for this item/transfer.
inv_status tsfdetail inv_status No A code indicating the inventory status for this transfer detail; valid values are found on the inv_status_types table.
unit_cost * * No Not mapped to a database field. Sometimes used to calculate retail price.