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!
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.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.