CALCODEMGP

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

Column Descriptions:

NameTypeDescription
CALCODE_IDINTEGER NOT NULLThe CalculationCode. See also the FLAGS column of the CALCODE table.
MBRGRP_IDBIGINT NOT NULLThe 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.
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>CALCODE_ID+MBRGRP_IDPrimary Key
I0000499MBRGRP_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_159MBRGRP_IDMBRGRPMBRGRP_IDCascade
F_160CALCODE_IDCALCODECALCODE_IDCascade