XSD Element Name |
XSD Element Data Type |
XSD Min Occurs |
XSD Max Occurs |
XSD Element Description |
Mapping for FulfilOrdRef in RMS application. |
RMS's Table Name |
RMS's Column Name |
Integration API(RIB or/and RSB or/and BDI) |
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 |
varchar2 |
48 |
Yes |
Holds the master customer order number from OMS. |
fulfill_order_no |
varchar248 |
1 |
1 |
Unique number from OMS related to the fulfillment details. One or more fulfillment orders could relate back to a single customer order in OMS. |
ordcust |
fulfill_order_no |
varchar2 |
48 |
Yes |
Unique number from OMS related to the fulfillment details. One or more fulfillment orders could relate back to a single customer order in OMS. |
source_loc_type |
source_loc_type |
0 |
1 |
This would be either 'SU' for supplier, 'ST' for store, or 'WH' for warehouse. This would only be populated for vendor, warehouse or
multi-site fulfillment orders. |
ordcust |
source_loc_type |
varchar2 |
2 |
No |
Contains the source type for the customer order. Valid values are 'SU' for supplier, 'ST' for store and 'WH' for warehouse. This would only contain a value for vendor, warehouse, or multi-site fulfilment orders. |
source_loc_id |
number10 |
0 |
1 |
Indicates the supplier, store or warehouse number associated with sourcing the customer order. Only populated for vendor, warehouse or multi-site fulfillment orders. |
ordcust |
source_loc_id |
number |
10 |
No |
Indicates the supplier, store or warehouse number the customer order is sourced from. Only populated for vendor, warehouse or multi-site fulfillment orders. |
fulfill_loc_type |
fulfill_loc_type |
1 |
1 |
This would be either 'S' (for physical store) or 'V' (for virtual store). |
ordcust |
fulfill_loc_type |
varchar2 |
1 |
Yes |
Contains the fulfillment location type of the customer order. Valid values are 'S' for physical store and 'V' for virtual store. |
fulfill_loc_id |
number10 |
1 |
1 |
Indicates the store or warehouse number associated with fulfilling the customer order. For this release, this should always be populated with a virtual or physical store number. |
ordcust |
fulfill_loc_id |
number |
10 |
Yes |
Indicates the store or warehouse number associated with fulfilling the customer order. For this release, this should always be populated with a virtual or physical store number. |
FulfilOrdDtlRef:FulfilOrdDtlRef
|
*
|
1
|
unbounded
|
Indicates the customer order fulfillment cancellation detail.
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|