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/AppointRef/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:AppointRef 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 AppointRef 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
appt_nbr number9 1 1 An RWMS-generated unique numerical identifier for an Appointment. Appointment is created in a Warehouse system. RMS.appt_head appt number 9 Yes An RWMS-generated unique numerical identifier for an appointment. Appointment is created in a Warehouse system.
from_location varchar210 1 1 The location to which the merchandise has been sent. RMS.appt_head loc varchar2 10 Yes The location to which the merchandise has been sent.
AppointDtlRef * 0 unbounded Description is not available.

XML-Schema Name:AppointDtlRef 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 AppointDtlRef 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_id varchar225 1 1 The item shipped to the location under the Appt ID. RMS.appt_detail item varchar2 25 Yes The item shipped to the location under the Appt ID.
po_nbr varchar212 1 1 The Purchase Order/Transfer/Allocation corresponding to the shipped merchandise. RMS.appt_detail doc varchar2 12 Yes The Purchase Order/Transfer/Allocation corresponding to the shipped merchandise.
asn_nbr varchar230 0 1 This column will hold the Advance Shipping Notice number associated with the Appointment. RMS.appt_detail asn varchar2 30 No This column contains the Advance Shipping Notice number associated with the appointment.