XSD Element Name |
XSD Element Data Type |
XSD Min Occurs |
XSD Max Occurs |
XSD Element Description |
Mapping for FulfilOrdRef in IGS application. |
IGS's Table Name |
IGS's Column Name |
Integration API(RIB or/and RSB or/and RSL) |
IGS's Column Length |
Is Column Required in IGS's API? |
IGS's API Description |
customer_order_no |
varchar248 |
1 |
1 |
Holds the master customer order number from OMS. |
RMS.ordcust, SIM.ful_ord |
customer_order_no, cust_order_id |
varchar2 |
Holds the master customer order number from OMS. SIM |
Yes, Yes |
RMS |
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. |
RMS.ordcust, SIM.ful_ord |
fulfill_order_no, id |
varchar2 |
Unique number from OMS related to the fulfillment details. One or more fulfillment orders could relate back to a single customer order in OMS. SIM |
Yes, Yes |
RMS |
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. |
RMS.ordcust, SIM.N/A |
source_loc_type, |
varchar2 |
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. SIM |
No, Yes |
RMS |
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. |
RMS.ordcust, SIM.N/A |
source_loc_id, |
number |
Indicates the supplier, store or warehouse number the customer order is sourced from. Only populated for vendor, warehouse or multi-site fulfillment orders. SIM |
No, Yes |
RMS |
fulfill_loc_type |
fulfill_loc_type |
1 |
1 |
This would be either 'S' (for physical store) or 'V' (for virtual store). |
RMS.ordcust, SIM.N/A |
fulfill_loc_type, |
varchar2 |
Contains the fulfillment location type of the customer order. Valid values are 'S' for physical store and 'V' for virtual store. SIM |
Yes, Yes |
RMS |
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. |
RMS.ordcust, SIM.ful_ord |
fulfill_loc_id, store_id |
number |
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. SIM |
Yes, Yes |
RMS |
FulfilOrdDtlRef:FulfilOrdDtlRef
|
*
|
1
|
unbounded
|
Indicates the customer order fulfillment cancellation detail.
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|
|