The CalculationCodeQualifyMethod can use the rows
of this table to restrict use of a CalculationCode to members of
certain MemberGroups.
Column Descriptions:
Name | 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 NOT NULL DEFAULT 0 | The optimistic concurrency control counter for
the table. Every time there is an update to the table, the counter
is incremented. |
Indexes:
Name | Column Names | Type |
<SYSTEM-GENERATED> | CALCODE_ID+MBRGRP_ID | Primary Key |
I0000499 | MBRGRP_ID | Non-Unique Index |
Constrained By Parent Tables:
Constraint | Columns | Parent Table | Parent Columns | Type |
F_159 | MBRGRP_ID | MBRGRP | MBRGRP_ID | Cascade |
F_160 | CALCODE_ID | CALCODE | CALCODE_ID | Cascade |