XSD Element Name |
XSD Element Data Type |
XSD Min Occurs |
XSD Max Occurs |
XSD Element Description |
Mapping for XOrderDtlRef in RMS application. |
RMS's Table Name |
RMS's Column Name |
Integration API(RIB or/and RSB or/and RSL) |
RMS's Column Length |
Is Column Required in RMS's API? |
RMS's 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. |