XSD Element Name |
XSD Element Data Type |
XSD Min Occurs |
XSD Max Occurs |
XSD Element Description |
Mapping for FopItm in SIM application. |
SIM's Table Name |
SIM's Column Name |
Integration API(RIB or/and RSB or/and BDI) |
SIM's Column Length |
Is Column Required in SIM's API? |
SIM's API Description |
line_id |
number12 |
1 |
1 |
Line item identifier |
FUL_ORD_PICK_LINE_ITEM |
ID |
NUMBER |
12,0 |
Yes |
SIM Internal Identifier |
item_id |
varchar225 |
1 |
1 |
SKU number |
FUL_ORD_PICK_LINE_ITEM |
ITEM_ID |
VARCHAR2 |
25 |
Yes |
Item identifier |
bin_id |
varchar2128 |
0 |
1 |
Bin identifier |
FUL_ORD_BIN |
BIN_ID |
VARCHAR2 |
128 |
Yes |
Identifier of a bin associated to the fulfillment order. |
fulfillment_order_id |
number12 |
1 |
1 |
Fulfillment order identifier that pick is for. |
FUL_ORD_PICK_LINE_ITEM |
FUL_ORD_ID |
NUMBER |
12,0 |
Yes |
The SIM identifier of the fulfillment order the pick this line item is on is for. |
fulfillment_order_line_id |
number12 |
0 |
1 |
Fulfillment order line item identifier that pick is for. This may be empty if users adds a substitute item. |
FUL_ORD_PICK_LINE_ITEM |
FUL_ORD_LINE_ITEM_ID |
NUMBER |
12,0 |
No |
The SIM identifier of the fulfillment order line item this line item is being picked for. |
substitute_line_id |
number12 |
0 |
1 |
Line item identifier of the fulfillment order pick line item that this pick line item was substituted for. |
FUL_ORD_PICK_LINE_ITEM |
SUBSTITUTE_LINE_ITEM_ID |
NUMBER |
12,0 |
No |
The SIM identifier of another pick line item for which this line item is being substituted for. |
preferred_uom |
varchar24 |
0 |
1 |
Unit of measure preferred to pick quantities. |
FUL_ORD_PICK_LINE_ITEM |
PREFERRED_UOM |
VARCHAR2 |
4 |
No |
The preferred unit of measure in which to pick. |
standard_uom |
varchar24 |
1 |
1 |
Unit of measure of the quantities. This may or may not be the same as preferred uom. |
ITEM |
UINT_OF_MEASURE |
VARCHAR2 |
4 |
Yes |
unit of measure which the stock for this item is tracked at the coporate level. |
suggested_quantity |
number20_4 |
0 |
1 |
Quantity in units suggested to be picked. |
FUL_ORD_PICK_LINE_ITEM |
QUANTITY_SUGGESTED |
NUMBER |
12,4 |
No |
The system suggested pick quantity for this line item. |
picked_quantity |
number20_4 |
1 |
1 |
Quantity in units being picked. |
FUL_ORD_PICK_LINE_ITEM |
QUANTITY_PICKED |
NUMBER |
12,4 |
No |
The actual quantity of what was picked. |
case_size |
number10_2 |
1 |
1 |
Case size of the item. |
FUL_ORD_PICK_LINE_ITEM |
CASE_SIZE |
NUMBER |
10,2 |
No |
The case size of this item picked. |
pick_area |
varchar2255 |
1 |
1 |
Suggested area from which to pick this item. |
STORE_SEQUENCE_AREA |
DESCRIPTION |
VARCHAR2 |
255 |
No |
Description Of Store Sequence |