XSD Element Name |
XSD Element Data Type |
XSD Min Occurs |
XSD Max Occurs |
XSD Element Description |
Mapping for FopCriVo 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 |
store_id |
number10 |
1 |
1 |
Include only fulfillment order picks at this store |
FUL_ORD_PICK |
STORE_ID |
NUMBER |
10,0 |
Yes |
The store doing the pick. |
from_date |
xs:dateTime |
0 |
1 |
Include only fulfillment order picks with the create date at or after this date. |
FUL_ORD_PICK |
CREATE_DATE |
Date |
|
Yes |
The date this pick was created. |
to_date |
xs:dateTime |
0 |
1 |
Include only fulfillment order picks with the create date at or before this date. |
FUL_ORD_PICK |
CREATE_DATE |
Date |
|
Yes |
The date this pick was created. |
pick_id |
number12 |
0 |
1 |
Include only fulfillment order picks with this internal identifier. |
FUL_ORD_PICK |
ID |
NUMBER |
12,0 |
Yes |
SIM internal identifier |
customer_order_id |
varchar2128 |
0 |
1 |
Include only fulfillment order picks with customer order identifier. |
FUL_ORD |
CUST_ORDER_ID |
VARCHAR2 |
128 |
Yes |
External identifier of the customer order being fulfilled. |
ext_fulfillment_order_id |
varchar2128 |
0 |
1 |
Include only fulfillment order picks with this external fulfillment order identifier. |
FUL_ORD |
EXTERNAL_ID |
VARCHAR2 |
128 |
No |
External identifier for the fulfillment order. |
int_fulfillment_order_id |
number12 |
0 |
1 |
Include only fulfillment order picks with this internal fulfillment order identifier. |
FUL_ORD_LINE_ITEM |
FUL_ORD_ID |
NUMBER |
12,0 |
Yes |
Identifier of the fulfillment order this line item is associated to. |
bin_id |
varchar2128 |
0 |
1 |
Include only fulfillment order picks with this BIN identifier. |
FUL_ORD_BIN |
BIN_ID |
VARCHAR2 |
128 |
Yes |
Identifier of a bin associated to the fulfillment order. |
status |
FopCriStatus |
1 |
1 |
Include only fulfillment order picks matching this status. Valid values are NEW, IN_PROGRESS, COMPLETED, CANCELED, NO_VALUE. |
FUL_ORD_PICK |
STATUS |
NUMBER |
4,0 |
Yes |
Indicates the status of the fulfillment order. Valid values are
0 - New, 1 - In Progress, 2 - Completed, 3 - Canceled, 4- Active |
pick_type |
FopCriType |
1 |
1 |
Include only fulfillment order picks matching this type. Valid values are ORDER, BIN. |
FUL_ORD_PICK |
TYPE |
NUMBER |
2,0 |
Yes |
The type of pick 0 - SIM Customer Order, 1 - Bin |
user_name |
varchar2128 |
0 |
1 |
Include only fulfillment order picks created or completed by this user. |
FUL_ORD_PICK |
CREATE_USER |
VARCHAR2 |
128 |
Yes |
The user that created this pick. |
item_id |
varchar225 |
0 |
1 |
Include only fulfillment orders containing this item SKU. |
FUL_ORD_LINE_ITEM |
ITEM_ID |
VARCHAR2 |
25 |
Yes |
Item identifier for this line item. |