Database Table: CALCODEMGP

The CalculationCodeQualifyMethod can use the rows of this table to restrict use of a CalculationCode to members of certain MemberGroups.

Column Name Column Type Column Description
CALCODE_ID INTEGER
NOT NULL
The CalculationCode. See also the FLAGS column of the CALCODE table.
MBRGRP_ID BIGINT
NOT NULL
The MemberGroup. The default implementation of the CalculationCodeQualifyMethod will only allow use of the CalculationCode by users who are members of the MemberGroup, and only if the MemberGroup appears in the STOREMBGRP table for the Store.
Indexes:
Index Name Indexed Column Names Index Type
SQL030416034850830 CALCODE_ID, MBRGRP_ID Primary Key
Constraints:
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_159 MBRGRP_ID MBRGRP MBRGRP_ID Cascade
F_160 CALCODE_ID CALCODE CALCODE_ID Cascade

Referenced By:
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
Not Applicable