Retail Integration Mappings Report Release:15.0.0 (Retail Merchandising System)
Application Retail Merchandising System
Target Name Space http://www.oracle.com/retail/integration/base/bo/LocPOTsfDesc/v1
Version 1.0
Description This is root element of this document which contains name space definitions for the document elements.
XSD Structure

XML-Schema Name:LocPOTsfDesc 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 LocPOTsfDesc in RMS application.
RMS's Table Name RMS's Column Name Integration API(RIB or/and RSB or/and RSL) RMS's Column Length Is Column Required in RMS's API? RMS's API Description
loc number10 0 1 Not Yet Available ordhead,tsfhead location,to_loc number 10 No For a transfer, this will hold the location number of the transfer to location. For an order,This field contains the location all items on the order will be delivered to if populated.
loc_type varchar21 0 1 Not Yet Available ordhead,tsfhead loc_type,to_loc_type varchar2 1 No For a transfer,this field contains the location type of the to location of the transfer. Valid values are
order_id number12 0 1 Not Yet Available ordhead,tsfhead order_no,tsf_no number 12 No Contains the number that uniquely identifies an order/transfer within the system.
source_type varchar21 1 1 Not Yet Available Fill application table name. Fill table column name. varchar2 1 Yes This would be 'S'(supplier) for an order and 'W' (Warehouse)for a transfer
source_id number10 1 1 Not Yet Available ordhead,tsfhead supplier,from_loc number 10 Yes For an order, this field Contains the vendor number who will provide the merchandise specified in the order.For a transfer,this field contains the location number of the transfer from location. This field will contain a store, internal finisher, external finisher or warehouse number based upon the FROM_LOC_TYPE field. An internal finisher is a warehouse and an external finisher is a partner.
user_id varchar230 0 1 Not Yet Available ordhead,tsfhead orig_approval_id,create_id varchar2 30 No For an order,this field Indicates where the order was approved. It will be the user ID of the person approving the order for all orders manually approved on-line and will contain Replen for orders automatically approved in the replenishment process. For a transfer,This field contains the user ID of the user that created the transfer.
comments varchar22000 0 1 Not Yet Available ordhead,tsfhead comments_desc varchar2 2000 No This field contains any miscellaneous comments associated to the Transfer/Order
order_status varchar26 0 1 Not Yet Available ordhead,tsfhead status 6 varchar2 No Contains status of order/transfer
not_before_date xs:dateTime 0 1 Not Yet Available ordhead,tsfhead not_before_date,delivery_date date Fill column length. No For an order,this field contains the first date that delivery of the order will be accepted.For a transfer,this field indicates the earliest date that the transfer can be delivered to the store.
not_after_date xs:dateTime 0 1 Not Yet Available ordhead not_after_date date Fill column length. No For an order,this field contains the last date that delivery of the order will be accepted.
create_date xs:dateTime 0 1 NA ordhead,tsfhead create_date date Fill column length. No This field contains the date the transfer was created.
LocPOTsfDtl * 0 unbounded Description is not available.
orig_ind number1 0 1 Not Yet Available ordhead orig_ind number 1 Yes For an order, this indicates where the order originated.
origin_country_id varchar23 0 1 Not Yet Available ORDSKU ORIGIN_COUNTRY_ID varchar2 3 No For an order, this is the identifier of the country into which the items on the order are being imported.

XML-Schema Name:LocPOTsfDtl 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 LocPOTsfDtl in RMS application.
RMS's Table Name RMS's Column Name Integration API(RIB or/and RSB or/and RSL) RMS's Column Length Is Column Required in RMS's API? RMS's API Description
item varchar225 1 1 Not Yet Available ordsku,tsfdetail item varchar2 25 Yes Unique alphanumeric value that identifies the item.
pack_size number12_4 0 1 Not Yet Available ordsku,tsfdetail supp_pack_size number (12,4) No For an order, this holds the Supplier pack size for this order/item. For a transfer,This field contains the supplier pack size for this transfer/item.
ordered_quantity number12_4 1 1 Not Yet Available ordloc,tsfdetail qty_ordered,tsf_qty number (12,4) Yes For an order, this field Contains the total number of items ordered for the SKU to this location.For a transfer,This field contains the total quantity of the item reserved at the from location for this transfer.
unit_cost number20_4 0 1 NA ordersku unit_cost number (20,4) No This field contains the unit cost for the Item/Location on the order, including discounts (deal/bracket/allowance), but not landed cost components. This field is stored in order currency.
orig_qty number12_4 0 1 NA Fill application table name. Fill table column name. number (12,4) No For an order detail modify message, the difference between the orig_qty and ordered_qty will give the new qty_ordered
loc number10 0 1 NA ordloc,tsfhead location,to_loc number 10 No For an order, this field contains the location that item will be ordered to. This field may contain a store or a warehouse. For a transfer,This field contains the location number of the transfer to location. This field will contain a store, internal finisher, external finisher or warehouse number based upon the TO_LOC_TYPE field. An internal finisher is a warehouse and an external finisher is a partner.
loc_type varchar21 0 1 NA ordloc,tsfhead loc_type,to_loc_type varchar2 1 No For an order,This field contains the type of location in the location field. Valid values are