How to set the primary key for an IAL object?

Question

Hi,

I created a partially replicable IAL object.

For some time later a problem occurred. There were duplicate rows. Then we understand there is a problem with the IAL. While setting partially replicable IAL. The app threw information about duplicate rows. I didn’t care about it before. Now I need to set the primary key for this IAL.

The IAL includes only the INVENTORY_PART_IN_STOCK view. And for this table (INVENTORY_PART_IN_STOCK_TAB) primary key is “PART_NO, CONTRACT, CONFIGURATION_ID, LOCATION_NO, LOT_BATCH_NO, SERIAL_NO, ENG_CHG_LEVEL, WAIV_DEV_REJ_NO, ACTIVITY_SEQ, HANDLING_UNIT_ID”. How can I set the primary key for the IAL object?

Page 1 / 1

Hi @hhy38

When you are creating the IAL, you can mention which columns from the SQL to be used as PK Index.

Hope it helps!

Damith

Thank you Damith @dsj :) I didn’t read this section.

@hhy38 You are not alone . Here’s a quote I live by: When all else fails, read the instructions.

Reply

dsj · Accepted Answer

Hi @hhy38When you are creating the IAL, you can mention which columns from the SQL to be used as PK Index.Hope it helps!Damith

dsj · Answer

Thank you Damith@dsj:) I didn’t read this section.🙈@hhy38 You are not alone 😆. Here’s a quote I live by:When all else fails, read the instructions.

Reply

Did you find what you're looking for? If not:

Sign up

Login to the community

Scanning file for viruses.

This file cannot be downloaded