WebSphere Commerce database table: CALMETHOD

Each row of this table defines a CalculationMethod implementation.


Column Description(s):
Column NameColumn TypeDescription
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.
Index(es):
Index NameIndexed Column NamesIndex Type
I0000055 SUBCLASS+CALUSAGE_ID+STOREENT_ID+NAME Unique Index
SQL050212031206360 CALMETHOD_ID Primary Key
I0000501 STOREENT_ID Non-Unique Index
I0000502 CALUSAGE_ID Non-Unique Index
Constraint(s):
Constraint NameColumn Name(s)Foreign Table NameForeign Column Name(s)Constraint Type
F_163 CALUSAGE_ID CALUSAGE CALUSAGE_ID Cascade
F_164 STOREENT_ID STOREENT STOREENT_ID Cascade

Referenced By:
Constraint NameReferenced Column NameForeign Table NameForeign Column Name(s)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

SUBCLASS column

The type of CalculationMethod as follows:

ValueNameDescription
1CalculationCodeCombineMethodCan be called by the ApplyCalculationUsageMethod to identify relationships between OrderItems and CalculationCodes. The default implementations use the CATENCALCD, CATGPCALCD, ORDICALCD, and ORDCALCD tables, and call the CalculationCodeQualifyMethod.
2CalculationCodeQualifyMethodCan be called by the CalculationCodeCombineMethod to determine the applicability of a CalculationCode to a list of OrderItems.
3CalculationCodeCalculateMethodCan be called by the ApplyCalculationUsageMethod or the CalculationCodeQualifyMethod to calculate values for a list of OrderItems, for a particular CalculationCode.
4CalculationCodeApplyMethodCan be called by the ApplyCalculationUsageMethod to apply calculated values for a list of OrderItems, to an Order.
5CalculationRuleCombineMethodCan be called by the CalculationCodeCalculateMethod to determine a list of CalculationRules and associated OrderItems that should be applied for the CalculationCode. The default implementations call the CalculationRuleQualifyMethod and the CalculationRuleCalculateMethod to find the lowest values for each allowable Combination of CalculationRules.
6CalculationRuleQualifyMethodCan be called by the CalculationRuleCombineMethod to determine, for a particular CalculationRule, to which of a list of OrderItems it applies.
7CalculationRuleCalculateMethodCan be called by the CalculationCodeCalculateMethod or the CalculationRuleCombineMethod to calculate values for a list of OrderItems.
8QuantityCalculationScaleLookupMethodCan be called by the CalculationRuleCalculateMethod to determine how a quantity based CalculationScale can be used to lookup a CalculationRange for a list of OrderItems.
9MonetaryCalculationScaleLookupMethodCan be called by the CalculationRuleCalculateMethod to determine how a monetary based CalculationScale can be used to lookup a CalculationRange for a list of OrderItems.
10CalculationRangeMethodCan be called by the CalculationRuleCalculateMethod to determine a calculated value from a CalculationRangeLookupResult.
11IntializeCalculationUsageMethodCan be called by OrderPrepare to initialize an Order, for example, by removing previously calculated values.
12ApplyCalculationUsageMethodCan be called by OrderPrepare to calculate values and apply them to an Order, for example, as OrderAdjustments, shipping charges, or tax amounts. The default implementations call the CalculationCodeCombineMethod, the CalculationCodeCalculateMethod, and the CalculationCodeApplyMethod.
13SummarizeCalculationUsageMethodSummarizes calculated values and applies them to an Order, including, for example, populating SubOrderAdjustments or SubOrder shipping charges or tax amounts.
14FinalizeCalculationUsageMethodCalled when an Order is placed to mark consumed resources, such as coupons, as no longer available.

Feedback