Retail Integration Bus Mappings Report Release:13.1 (Retail Merchandizing System)
Application Retail Merchandizing System
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.

XML-Schema Name:AppointRef Version:13.1 Return to Top
Tag Name Type Min Occurs Max Occurs Description rms Mapping For AppointRef
Table Name Column Name API Type Column Length API Required API Description
appt_nbr number9 1 1 An RWMS-generated unique numerical identifier for an Appointment. Appointment is created in a Warehouse system. 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. appt_head loc varchar2 10 Yes The location to which the merchandise has been sent.
AppointDtlRef * 0 unbounded Description is not available.
ExtOfAppointRef:ExtOfAppointRef * 0 1 Provide an extension hook to customize AppointRef. NA NA NA NA NA NA

XML-Schema Name:AppointDtlRef Version:13.1 Return to Top
Tag Name Type Min Occurs Max Occurs Description rms Mapping For AppointDtlRef
Table Name Column Name API Type Column Length API Required API Description
item_id varchar225 1 1 The item shipped to the location under the Appt ID. appt_detail item varchar2 25 Yes The item shipped to the location under the Appt ID.
po_nbr varchar210 1 1 The Purchase Order/Transfer/Allocation corresponding to the shipped merchandise. appt_detail doc varchar2 10 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. appt_detail asn varchar2 30 No This column will hold the Advance Shipping Notice number associated with the Appointment.
ExtOfAppointRef:ExtOfAppointDtlRef * 0 1 Provide an extension hook to customize AppointDtlRef. NA NA NA NA NA NA

XML-Schema Name:ExtOfAppointDtlRef Version:13.1 Return to Top
Tag Name Type Min Occurs Max Occurs Description rms Mapping For ExtOfAppointDtlRef
Table Name Column Name API Type Column Length API Required API Description

XML-Schema Name:ExtOfAppointRef Version:13.1 Return to Top
Tag Name Type Min Occurs Max Occurs Description rms Mapping For ExtOfAppointRef
Table Name Column Name API Type Column Length API Required API Description