Solved

WaDaCo - Unique Line ID - Database Location

  • 25 August 2020
  • 5 replies
  • 220 views

Userlevel 4
Badge +9

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

 

 

icon

Best answer by paul harland 25 August 2020, 19:20

View original

5 replies

Userlevel 7
Badge +24

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.

Userlevel 4
Badge +9

Hi Paul,

It’s a shipping pick list.

Userlevel 7
Badge +24

ok, in that case try PICK_SHIPMENT_RES_STOCK_ALT

 

Userlevel 7
Badge +24

correction - i think it is CUSTOMER_ORDER_RESERVATION, objid column.

Userlevel 6
Badge +16

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