XSD Element Name |
XSD Element Data Type |
XSD Min Occurs |
XSD Max Occurs |
XSD Element Description |
Mapping for FulfilOrdRef in SIM application. |
SIM's Table Name |
SIM's Column Name |
Integration API(RIB or/and RSB or/and RSL) |
SIM's Column Length |
Is Column Required in SIM's API? |
SIM's API Description |
customer_order_no |
varchar248 |
1 |
1 |
Holds the master customer order number from OMS. |
FUL_ORD |
CUST_ORDER_ID |
VARCHAR2 |
128 |
Yes |
External identifier of the customer order being fulfilled. |
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. |
FUL_ORD |
ID |
Number |
12,0 |
Yes |
Unique SIM identifier. |
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. |
Fill application table name. |
Fill table column name. |
RIB or/and RSB or/and RSL |
Fill column length. |
Yes |
not used in SIM |
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. |
Fill application table name. |
Fill table column name. |
RIB or/and RSB or/and RSL |
Fill column length. |
Yes |
not used in SIM |
fulfill_loc_type |
fulfill_loc_type |
1 |
1 |
This would be either 'S' (for physical store) or 'V' (for virtual store). |
Fill application table name. |
Fill table column name. |
RIB or/and RSB or/and RSL |
Fill column length. |
Yes |
not used in SIM |
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. |
FUL_ORD |
STORE_ID |
Number |
10,0 |
Yes |
Store identifier at which this order is being fulfilled. |
FulfilOrdDtlRef:FulfilOrdDtlRef
|
*
|
1
|
unbounded
|
Indicates the customer order fulfillment cancellation detail.
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|