XSD Element Name |
XSD Element Data Type |
XSD Min Occurs |
XSD Max Occurs |
XSD Element Description |
Mapping for CustOrdSubDesc 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 |
customer_order_no |
varchar248 |
1 |
1 |
Holds the master customer order number from OMS. |
ORDCUST |
CUSTOMER_ORDER_NO |
RSB |
48 |
Yes |
Fill this description. |
fulfill_order_no |
varchar248 |
1 |
1 |
Unique number from OMS related to the fulfillment details. |
ORDCUST |
FULFILL_ORDER_NO |
RSB |
48 |
Yes |
Fill this description. |
loc_type |
loc_type |
1 |
1 |
This would be 'S' for store. Item substitute is only supported for store fulfillment. |
ORDCUST |
FULFILL_LOC_TYPE |
RIB or/and RSB or/and RSL |
1 |
Yes |
Fill this description. |
loc_id |
number10 |
1 |
1 |
Indicates the store number associated with the customer order. |
ORDCUST |
FULFILL_LOC_ID |
RSB |
10 |
Yes |
Fill this description. |
item |
varchar225 |
1 |
1 |
Contains the item number for which substitute item is used. |
ORDCUST_DETAIL |
ITEM |
RSB |
25 |
Yes |
Fill this description. |
item_qty |
number12_4 |
1 |
1 |
Contains the revised order quantity of the original item. |
ORDCUST_DETAIL |
QTY_ORDERED_SUOM |
RSB |
12 |
Yes |
Fill this description. |
qty_uom |
varchar24 |
1 |
1 |
Contains the unit of measure for original item order quantity. This will be the standard uom of the item |
ITEM_MASTER |
STANDARD_UOM |
RSB |
4 |
Yes |
Fill this description. |
SubItemDetails
|
*
|
1
|
unbounded
|
Contains the substitute item details.
|
|
|
|
|
|
|