You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Primary and Incremental keys for ItemEFFBIFlattenedVO

edited Jun 9, 2025 7:18AM in Inventory Management 1 comment

Summary:

Looking for the appropriate columns to use as primary keys and incremental keys for BICC extraction of FscmTopModelAM.EgpItemsPublicModelAM.ItemEFFBIFlattenedVO


Content (please ensure you mask any confidential information):

We are attempting to extract data from BICC pvo(FscmTopModelAM.EgpItemsPublicModelAM.ItemEFFBIFlattenedVO) after selecting below mentioned columns as keys. However, we are encountering duplicate records for this combination.

Could you please advise on the appropriate combination of columns within this PVO that can serve as a primary key?

Additionally, we would appreciate your guidance on selecting a suitable column to use as an incremental key

Current keys:

InventoryItemId
InventoryItemId4
OrganizationId
OrganizationId12

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!