CALRULEMGP

A row in this table associates a CalculationRule with a MemberGroup. The discount CalculationRuleQualifyMethod can use this relationship to restrict use of the CalculationRule to members of certain MemberGroups. See the STOREMBRGP table.

Column Descriptions:

NameTypeDescription
CALRULE_IDINTEGER NOT NULLThe CalculationRule.
MBRGRP_IDBIGINT NOT NULLThe MemberGroup. The default CalculationRuleQualifyMethod for discount CalculationUsage uses the MemberGroup as well as CALRULE.FLAGS and the STOREMBRGP relationship table to determine which customers can use the CalculationRule.
OPTCOUNTERSMALLINT NOT NULL DEFAULT 0The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>MBRGRP_ID+CALRULE_IDPrimary Key
I0000507CALRULE_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_173MBRGRP_IDMBRGRPMBRGRP_IDCascade
F_174CALRULE_IDCALRULECALRULE_IDCascade