WebSphere Commerce database table: CALCODEMGP

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


Column Description(s):
Column NameColumn TypeDescription
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.
OPTCOUNTER SMALLINT Reserved for IBM internal use.
Index(es):
Index NameIndexed Column NamesIndex Type
SQL050212031206060 CALCODE_ID+MBRGRP_ID Primary Key
I0000499 MBRGRP_ID Non-Unique Index
Constraint(s):
Constraint NameColumn Name(s)Foreign Table NameForeign Column Name(s)Constraint Type
F_160 CALCODE_ID CALCODE CALCODE_ID Cascade
F_159 MBRGRP_ID MBRGRP MBRGRP_ID Cascade

Feedback