Hi Jared,
The MatUseTransID is the Unique Column ID for the MatUseTrans table and you should see an Index named MATUSETRANSU_NDX on that column alone. Technically, the MatUseTransID could have been defined as the sole Primary Key Column, but most Site-Level objects include the SiteID in the Primary Key and most Org-level objects include the OrgID in the Primary Key.
In the case of MatUseTrans, there really is no other set of columns other than MatUseTrans that form a Unique key since you can have multiple Issues or Returns for the same Item, Storeroom, Bin, WO, Location, and/or Asset with the same Transaction Date.
For out-of-the-box objects, the Index on the Unique Column normally ends in "_Ndx" and should have the "Internal?" and "Enforce Uniqueness?" checkboxes checked. The Index on the Primary Key Columns normally ends in "_Ndx1" and should have the "Enforce Uniqueness?" checkbox checked.
------------------------------
Julio Hernandez
Ergonare, Inc.
------------------------------
Original Message:
Sent: 03-19-2024 13:12
From: Jared Schrag
Subject: Primary Key of MATUSETRANS Tabe
I've got a strange question. Why is the primary key columns of the MATUSETRANS object include SITEID and MATUSETRANSID? These two attributes form the only unique key on that table. I would have guessed that it would just be the MATUSETRNASID attribute alone. Does anybody have a good explanation as to why it would also include SITEID. This means that for you could have two records with the same MATUSETRANSID value for two different SITEID values (although, the application will likely never generate data in this way).
#Administration
#Architecture
#Inventory
------------------------------
Kind Regards,
Jared Schrag
Koch Ag & Energy Solutions
------------------------------