The CalculationCodeQualifyMethod can use the rows of this table to restrict use of a CalculationCode to members of certain MemberGroups.
Column Description(s):
Column Name | Column Type | 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. |
OPTCOUNTER |
SMALLINT |
Reserved for IBM internal use. |
Index(es):
Index Name | Indexed Column Names | Index Type |
SQL050212031206060 |
CALCODE_ID+MBRGRP_ID |
Primary Key |
I0000499 |
MBRGRP_ID |
Non-Unique Index |
Constraint(s):
Constraint Name | Column Name(s) | Foreign Table Name | Foreign Column Name(s) | Constraint Type |
F_160 |
CALCODE_ID |
CALCODE |
CALCODE_ID |
Cascade |
F_159 |
MBRGRP_ID |
MBRGRP |
MBRGRP_ID |
Cascade |
Related reference
(C) Copyright IBM Corporation 1996, 2005. All Rights Reserved.