Retail Integration Bus Mappings Report Release:13.1.1

(Retail Merchandising System)

Application	Retail Merchandising 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.
	AppointRef AppointDtlRef ExtOfAppointDtlRef ExtOfAppointRef

XML-Schema Name:AppointRef

Version:13.1.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.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.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.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