WebSphere Commerce database table: CALMETHOD

Each row of this table defines a CalculationMethod implementation.

Column Descriptions
Column Name Column Type Description
CALMETHOD_ID INTEGER NOT NULL Generated unique identifier.
STOREENT_ID INTEGER NOT NULL The StoreEntity of which this CalculationMethod definition is a part.
CALUSAGE_ID INTEGER NOT NULL The CalculationUsage (such as discount, shipping, sales tax, shipping tax) of the CalculationMethod.
TASKNAME VARCHAR(254) Complete name of the Java Interface Class for the method. For example, com.ibm.commerce.order.utils.CalculationCodeCombineCmd
DESCRIPTION VARCHAR(508) A description of the CalculationMethod, suitable for display by a user interface that creates and updates CalculationCodes and CalculationScales.
SUBCLASS INTEGER The type of CalculationMethod. Refer to Subclass for more information.
NAME VARCHAR(254) A character string that uniquely identifies this CalculationMethod for a particular combination of StoreEntity, SubClass, and CalculationUsage.
OPTCOUNTER SMALLINT Reserved for IBM internal use.

Indexes
Index Name Indexed Column Names Index Type
I0000055 SUBCLASS+CALUSAGE_ID+STOREENT_ID+NAME Unique Index
SQL060903235135140 CALMETHOD_ID Primary Key
I0000501 STOREENT_ID Non-Unique Index
I0000502 CALUSAGE_ID Non-Unique Index

Constraints
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_163 CALUSAGE_ID CALUSAGE CALUSAGE_ID Cascade
F_164 STOREENT_ID STOREENT STOREENT_ID Cascade

Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
F_154 CALMETHOD_ID_QFY CALCODE CALMETHOD_ID Cascade
F_155 CALMETHOD_ID CALCODE CALMETHOD_ID Cascade
F_156 CALMETHOD_ID_APP CALCODE CALMETHOD_ID Cascade
F_166 CALMETHOD_ID CALRANGE CALMETHOD_ID Cascade
F_171 CALMETHOD_ID_QFY CALRULE CALMETHOD_ID Cascade
F_172 CALMETHOD_ID CALRULE CALMETHOD_ID Cascade
F_179 CALMETHOD_ID CALSCALE CALMETHOD_ID Cascade
F_761 CALMETHOD_ID_SUM STENCALUSG CALMETHOD_ID Cascade
F_762 CALMETHOD_ID_FIN STENCALUSG CALMETHOD_ID Cascade
F_763 CALMETHOD_ID_INI STENCALUSG CALMETHOD_ID Cascade
F_764 CALMETHOD_ID_APP STENCALUSG CALMETHOD_ID Cascade
F_767 ACTCC_CALMETHOD_ID STENCALUSG CALMETHOD_ID Cascade
F_768 ACTRC_CALMETHOD_ID STENCALUSG CALMETHOD_ID Cascade
Related reference