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/LocPOTsfHdrCriVo/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:LocPOTsfHdrCriVo 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 LocPOTsfHdrCriVo 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
order_id number12 0 1 Not Yet Available ordhead,stfhead order_no,tsf_no number 12 No Order_no/Tsf_no fro which information is to be retrieved
item varchar225 0 1 Not Yet Available ordloc,tsfdetail item varchar2 25 No The item for which store order information(orders and transfers) need to be retrieved
loc number10 1 1 Not Yet Available ordloc,tsfhead loc,to_loc number 10 Yes The location for which store order information needs to be retrieved
loc_type varchar21 1 1 Not Yet Available Fill application table name. Fill table column name. varchar2 1 Yes Location Type for the location
source_type varchar21 0 1 Not Yet Available Fill application table name. Fill table column name. varchar2 1 No Fill this description.
source_id number10 0 1 Not Yet Available ordhead,wh supplier,physical_wh number 10 No For an order, this holds the supplier and for a transfer , this holds the physical warehouse id
order_status varchar26 0 1 Not Yet Available ordhead,tsfhead status varchar2 6 No Contains the status of order/transfer
not_before_date xs:dateTime 0 1 Not Yet Available ordhead,tsfhead not_after_date,delivery_date date Fill column length. No For an order,it Contains the first date that delivery of the order will be accepted.For a transfer, it Indicates the earliest date that the transfer can be delivered to the store.
not_after_date xs:dateTime 0 1 Not Yet Available ordhead,tsfhead not_after_date,delivery_date date Fill column length. No For an order,it Contains the first date that delivery of the order will be accepted.For a transfer, it Indicates the earliest date that the transfer can be delivered to the store.