|
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.2.0
|
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
|
|
LocOfAppointRef:LocOfAppointRef
|
*
|
0
|
1
|
Provide an extension hook to localize AppointRef.
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|
|
|
|
XML-Schema Name:AppointDtlRef
|
Version:13.2.0
|
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 contains 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
|
|
LocOfAppointRef:LocOfAppointDtlRef
|
*
|
0
|
1
|
Provide an extension hook to localize AppointDtlRef.
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|
|
|
|
XML-Schema Name:ExtOfAppointDtlRef
|
Version:13.2.0
|
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:LocOfAppointDtlRef
|
Version:13.2.0
|
Return to Top
|
| Tag Name |
Type |
Min Occurs |
Max Occurs |
Description |
rms Mapping For LocOfAppointDtlRef |
| Table Name |
Column Name |
API Type |
Column Length |
API Required |
API Description |
|
InAppointRef:InAppointDtlRef
|
*
|
0
|
unbounded
|
India Localization.
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|
|
BrAppointRef:BrAppointDtlRef
|
*
|
0
|
unbounded
|
Brazil Localization.
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|
|
|
|
XML-Schema Name:ExtOfAppointRef
|
Version:13.2.0
|
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 |
|
|
|
XML-Schema Name:LocOfAppointRef
|
Version:13.2.0
|
Return to Top
|
| Tag Name |
Type |
Min Occurs |
Max Occurs |
Description |
rms Mapping For LocOfAppointRef |
| Table Name |
Column Name |
API Type |
Column Length |
API Required |
API Description |
|
InAppointRef:InAppointRef
|
*
|
0
|
unbounded
|
India Localization.
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|
|
BrAppointRef:BrAppointRef
|
*
|
0
|
unbounded
|
Brazil Localization.
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|
|
|
