This project default manages the trigger on the standardizations table.
This functionality does not work in the case when one user insert records in batch and other in online at same time and logged in same product group or project.
This trigger is applicable for following tables in the respective pages.
Page Name |
Table |
---|---|
Attributes (A.50.01) |
M_ATTRS |
Tables (A.50.02) |
M_DICT_TABS |
Commodity Group (S.10.02) |
M_COMMODITY_GROUPS |
Commodity Part (S.10.030 |
M_PARTS |
Commodity Code (S.30.01) |
M_COMMODITY_CODES |
Standard Geometrics (S.40.10) |
M-GEOM_NAMES |
Specification Rules (S.50.01) |
M_SPEC_RULES |
Specification Types (S.50.02) |
M_SPEC_TYPES |
Specification Management (S.50.06) |
M_SPEC_HEADERS |
-
Module(s) affected by this setting: Tables and Properties > Tables, and Property Set Layout, Commodity Groups, S1003, S5001, S5002, Specification Items, Geometrics Details..
-
List of Values: Y (default) and N.
-
If set to Y, a trigger on the standardization tables prevents you from inserting a code on a project that already exists in the inherent product group; also, it is not possible to insert a code into a product group that already exists in one (or more) inherent projects.
-
If set to N or not set, the trigger does not work.
-