XSD Element Name |
XSD Element Data Type |
XSD Min Occurs |
XSD Max Occurs |
XSD Element Description |
Mapping for ForpItm 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 |
line_id |
number12 |
1 |
1 |
Line item identifier |
FUL_ORD_RV_PICK_LINE_ITEM |
ID |
NUMBER |
12,0 |
Yes |
SIM Internal Identifier. |
item_id |
varchar225 |
1 |
1 |
SKU number |
FUL_ORD_RV_PICK_LINE_ITEM |
FUL_ORD_LINE_ITEM_ID |
NUMBER |
12,0 |
Yes |
The SIM identifier of the fulfillment order line item this line item is being reverse picked for. |
fulfillment_order_line_id |
number12 |
1 |
1 |
Fulfillment order line item identifier that reverse pick is for. |
FUL_ORD_RV_PICK_LINE_ITEM |
ID |
NUMBER |
12,0 |
Yes |
SIM Internal Identifier. |
standard_uom |
varchar24 |
1 |
1 |
Unit of measure of the quantities. This may or may not be the same as preferred uom. |
ITEM |
UNIT_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 standard unit of measure suggested to be reverse picked. |
FUL_ORD_RV_PICK_LINE_ITEM |
QUANTITY_SUGGESTED |
NUMBER |
12,4 |
Yes |
The system suggested reverse pick quantity for this line item. |
unpicked_quantity |
number20_4 |
1 |
1 |
Quantity in standard unit of measure being reverse picked. |
FUL_ORD_RV_PICK_LINE_ITEM |
QUANTITY_RV_PICKED |
NUMBER |
12,4 |
No |
The actual quantity of that was reverse picked. |
case_size |
number10_2 |
1 |
1 |
Case size of the item. |
FUL_ORD_RV_PICK_LINE_ITEM |
CASE_SIZE |
NUMBER |
10,2 |
No |
The case size of this item reverse picked. |