XSD Element Name |
XSD Element Data Type |
XSD Min Occurs |
XSD Max Occurs |
XSD Element Description |
Mapping for FulfilOrdCfmDesc 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 |
Yes |
Unique SIM identifier. |
confirm_type |
confirm_type |
1 |
1 |
Contains the confirmation type. 'P' - Order Partially Created; 'X' - Order Could not be Created. |
n/a |
n/a |
RIB or/and RSB |
n/a |
No |
SIM sets the value as X |
confirm_no |
number12 |
0 |
1 |
Contains the PO or Transfer number in RMS related to the fulfillment order line. Required if fulfillment status is 'P'. |
Fill application table name. |
Fill table column name. |
RIB or/and RSB |
Fill column length. |
Yes |
not used in SIM |
FulfilOrdCfmDtl:FulfilOrdCfmDtl
|
*
|
0
|
unbounded
|
References a collection of customer order confirmation item details.
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|