XSD Element Name |
XSD Element Data Type |
XSD Min Occurs |
XSD Max Occurs |
XSD Element Description |
Mapping for FopHdrDesc 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 |
pick_id |
number12 |
1 |
1 |
Fulfillment order pick identifier. |
FUL_ORD_PICK |
ID |
NUMBER |
12,0 |
Yes |
SIM internal identifier |
create_date |
xs:dateTime |
1 |
1 |
Date the fulfillment order pick was created. |
FUL_ORD_PICK |
CREATE_DATE |
Date |
|
Yes |
The date this pick was created. |
create_user_name |
varchar2128 |
1 |
1 |
User that created this fulfillment order pick. |
FUL_ORD_PICK |
CREATE_USER |
VARCHAR2 |
128 |
Yes |
The user that created this pick. |
complete_date |
xs:dateTime |
0 |
1 |
Date the fulfillment order pick was completed. |
FUL_ORD_PICK |
COMPLETE_DATE |
Date |
|
No |
The date this pick was completed. |
complete_user_name |
varchar2128 |
0 |
1 |
User that confirmed this fulfillment order pick. |
FUL_ORD_PICK |
COMPLETE_USER |
VARCHAR2 |
128 |
No |
The user that completed this pick. |
pick_type |
FopType |
1 |
1 |
Type of the fulfillment order pick. Valid values are ORDER, BIN, UNKNOWN. |
FUL_ORD_PICK |
TYPE |
NUMBER |
2,0 |
Yes |
The type of pick 0 - SIM Customer Order, 1 - Bin |
status |
FopStatus |
1 |
1 |
Status of the fulfillment order pick. Valid values are NEW, IN_PROGRESS, COMPLETED, CANCELED, UNKNOWN. |
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 |
total_quantity |
number20_4 |
1 |
1 |
Total suggested quantity to be picked. |
FUL_ORD_PICK_LINE_ITEM |
QUANTITY_PICKED |
NUMBER |
12,4 |
No |
The actual quantity of what was picked. |
actual_quantity |
number20_4 |
1 |
1 |
Actual quantity being picked. |
FUL_ORD_PICK_LINE_ITEM |
QUANTITY_PICKED |
NUMBER |
12,4 |
No |
The actual quantity of what was picked. |