Application
|
Retail Merchandizing System
|
Target Name Space
|
http://www.oracle.com/retail/integration/base/bo/XOrderRef/v1
|
Version
|
1.0
|
Description
|
This is root element of this document which contains name space definitions for the document elements.
|
|
|
|
XML-Schema Name:XOrderRef
|
Version:13.2.0
|
Return to Top
|
Tag Name |
Type |
Min Occurs |
Max Occurs |
Description |
rms Mapping For XOrderRef |
Table Name |
Column Name |
API Type |
Column Length |
API Required |
API Description |
order_no |
varchar210 |
1 |
1 |
The unique identifier for the order. |
ordhead |
order_no |
varchar2 |
10 |
Yes |
The unique identifier for the order. |
XOrderDtlRef
|
*
|
0
|
unbounded
|
Description is not available.
|
|
|
|
|
|
|
ExtOfXOrderRef:ExtOfXOrderRef
|
*
|
0
|
1
|
Provide an extension hook to customize XOrderRef.
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|
LocOfXOrderRef:LocOfXOrderRef
|
*
|
0
|
1
|
Provide an extension hook to localize XOrderRef.
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|
|
|
XML-Schema Name:XOrderDtlRef
|
Version:13.2.0
|
Return to Top
|
Tag Name |
Type |
Min Occurs |
Max Occurs |
Description |
rms Mapping For XOrderDtlRef |
Table Name |
Column Name |
API Type |
Column Length |
API Required |
API Description |
item |
varchar225 |
0 |
1 |
An approved, transaction level item. If a pack, it must be an orderable pack (with an order_as_type of 'P'). |
ordsku |
item |
varchar2 |
25 |
No |
An approved, transaction-level item. If a pack, it must be an orderable pack (where order_as_type = P). |
location |
number10 |
1 |
1 |
An active store or warehouse. If multichannel is on, and a warehouse is being order to, a virtual warehouse is expected. |
ordloc |
location |
number |
10 |
Yes |
An active store or warehouse. If multichannel is on, and a warehouse is being order to, a virtual warehouse is expected. |
ref_item |
varchar225 |
0 |
1 |
The id of a reference item which can be used instead of using the item field. If the item field is not populated this field is required. |
ordsku |
ref_item |
varchar2 |
25 |
No |
The ID of a reference item that can be used instead of using the item field. If the item field is not populated, this field is required. |
ExtOfXOrderRef:ExtOfXOrderDtlRef
|
*
|
0
|
1
|
Provide an extension hook to customize XOrderDtlRef.
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|
LocOfXOrderRef:LocOfXOrderDtlRef
|
*
|
0
|
1
|
Provide an extension hook to localize XOrderDtlRef.
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|
|
|
XML-Schema Name:ExtOfXOrderDtlRef
|
Version:13.2.0
|
Return to Top
|
Tag Name |
Type |
Min Occurs |
Max Occurs |
Description |
rms Mapping For ExtOfXOrderDtlRef |
Table Name |
Column Name |
API Type |
Column Length |
API Required |
API Description |
|
|
XML-Schema Name:LocOfXOrderDtlRef
|
Version:13.2.0
|
Return to Top
|
Tag Name |
Type |
Min Occurs |
Max Occurs |
Description |
rms Mapping For LocOfXOrderDtlRef |
Table Name |
Column Name |
API Type |
Column Length |
API Required |
API Description |
InXOrderRef:InXOrderDtlRef
|
*
|
0
|
unbounded
|
India Localization.
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|
BrXOrderRef:BrXOrderDtlRef
|
*
|
0
|
unbounded
|
Brazil Localization.
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|
|
|
XML-Schema Name:ExtOfXOrderRef
|
Version:13.2.0
|
Return to Top
|
Tag Name |
Type |
Min Occurs |
Max Occurs |
Description |
rms Mapping For ExtOfXOrderRef |
Table Name |
Column Name |
API Type |
Column Length |
API Required |
API Description |
|
|
XML-Schema Name:LocOfXOrderRef
|
Version:13.2.0
|
Return to Top
|
Tag Name |
Type |
Min Occurs |
Max Occurs |
Description |
rms Mapping For LocOfXOrderRef |
Table Name |
Column Name |
API Type |
Column Length |
API Required |
API Description |
InXOrderRef:InXOrderRef
|
*
|
0
|
unbounded
|
India Localization.
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|
BrXOrderRef:BrXOrderRef
|
*
|
0
|
unbounded
|
Brazil Localization.
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|
|
|