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
Best answer by paul harland
View originalHello!
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
Best answer by paul harland
View originalhello 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.
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 username or e-mail address. We'll send you an e-mail with instructions to reset your password.