Retail Integration Mappings Report Release:15.0.0 (Integration Gateway Services)
Application Integration Gateway Services
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.
XSD Structure

XML-Schema Name:XTsfDesc Version:15.0.0 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for XTsfDesc in IGS application.
IGS's Table Name IGS's Column Name Integration API(RIB or/and RSB or/and RSL) IGS's Column Length Is Column Required in IGS's API? IGS's API Description
tsf_no number12 1 1 Number that uniquely identifies the transfer. RMS.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. RMS.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. RMS.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. RMS.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. RMS.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. RMS.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. RMS.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. RMS.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.). RMS.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.). RMS.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.). RMS.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. RMS.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. RMS.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. RMS.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. RMS.tsfhead tsf_type null null No This field holds the value relating to the context type like Promotion number.

XML-Schema Name:XTsfDtl Version:15.0.0 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for XTsfDtl in IGS application.
IGS's Table Name IGS's Column Name Integration API(RIB or/and RSB or/and RSL) IGS's Column Length Is Column Required in IGS's API? IGS's API Description
item varchar225 1 1 The unique identifier of the item being transferred. RMS.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. RMS.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. RMS.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. RMS.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. RMS.* * null null No Not mapped to a database field. Sometimes used to calculate retail price.
adjustment_type varchar26 0 1 Not mapped to a database field. Sometimes used to calculate retail price. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.
adjustment_value number20_4 0 1 Not mapped to a database field. Sometimes used to calculate retail price. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.