Skip to main content

Hello!

Does anyone know what table I could find the unique line id in (report picking of parts)? I’m looking to create a barcode on our pick list.

 

Thanks,

Mike

 

 

hello Mike

is this for a shop order pick?  If so, I guess it’s the OBJID column in SHOP_MATERIAL_PICK_LINE.

If it’s a customer order pick then it’s a different view.


Hi Paul,

It’s a shipping pick list.


ok, in that case try PICK_SHIPMENT_RES_STOCK_ALT

 


correction - i think it is CUSTOMER_ORDER_RESERVATION, objid column.


Yes, UNIQUE_LINE_ID is objid. Since the pick list objects didn’t had any clear line keys we needed a data item that could identify the whole record so we choose to use objid for this purpose even thou its not something that is visible for a normal user, so that why this item most often is hidden and auto-picked in a guided processes.

But please don’t move this item down in the configuration like some customers have done, it is needed early in the configuration to quickly identify a pick list record since using this will speed up the performance.


Reply