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/LocPOTsfHdrColDesc/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:LocPOTsfHdrColDesc 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 LocPOTsfHdrColDesc 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
collection_size number4 1 1 Number of items in the collection. Fill application table name. Fill table column name. number 4 Yes Fill this description.
LocPOTsfHdrDesc:LocPOTsfHdrDesc * 0 unbounded Description is not available. NA NA NA NA NA NA

XML-Schema Name:LocPOTsfHdrDesc 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 LocPOTsfHdrDesc 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 1 1 Description is not available. ordhead,tsfhead orser_no,tsf_no number 12 Yes Contains the number that uniquely identifies an order/transfer within the system.
source_type varchar21 1 1 Description is not available. Fill application table name. Fill table column name. varchar2 1 Yes For on order, this would be 'S'(supplier) and for a transfer, this would be 'W'(warehouse)
source_id number10 1 1 Description is not available. ordhead,wh supplier,physical_wh number 10 Yes For an order, this holds the supplier and for a transfer , this holds the physical warehouse id
create_date xs:dateTime 0 1 Description is not available. ordhead,tsfhead written_date,create_date date Fill column length. No This field contains the date the transfer was created or Contains the date the order was created within the system.
order_status varchar26 1 1 Description is not available. ordhead,tsfhead status varchar2 6 Yes Contains the status of order/transfer
not_before_date xs:dateTime 1 1 Description is not available. ordhead,tsfhead not_before_date,delivery_date date Fill column length. Yes 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 1 1 Description is not available. ordhead,tsfhead not_after_date,delivery_date date Fill column length. Yes For an order,it Contains the last 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.
user_id varchar230 0 1 Description is not 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.
quantity number12_4 0 1 Description is not available. ordloc,tsfdetail qty_ordered,tsf_qty number (12,4) No For an order, it contains the total ordered quantity for that order.For a transfer, it contains the total quantity on that transfer