Database Table: CALMETHOD

Each row of this table defines a CalculationMethod implementation.

Column Name Column Type Column Description
CALMETHOD_ID INTEGER
NOT NULL
Generated unique identifier.
CALUSAGE_ID INTEGER
NOT NULL
The CalculationUsage (such as discount, shipping, sales tax, shipping tax) of the CalculationMethod.
DESCRIPTION VARCHAR (508)
NULL
A description of the CalculationMethod, suitable for display by a user interface that creates and updates CalculationCodes and CalculationScales.
NAME VARCHAR (254)
NULL
A character string that uniquely identifies this CalculationMethod for a particular combination of StoreEntity, SubClass, and CalculationUsage.
STOREENT_ID INTEGER
NOT NULL
The StoreEntity of which this CalculationMethod definition is a part.
SUBCLASS INTEGER
NULL
The type of CalculationMethod. Refer to Details for more information.
TASKNAME VARCHAR (254)
NULL
Complete name of the Java Interface Class for the method. For example, com.ibm.commerce.order.utils.CalculationCodeCombineCmd
Indexes:
Index Name Indexed Column Names Index Type
I0000055 SUBCLASS, CALUSAGE_ID, STOREENT_ID, NAME Unique Index
SQL030416034851470 CALMETHOD_ID Primary Key
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

Referenced By:
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
F_154 CALMETHOD_ID CALCODE CALMETHOD_ID_QFY Cascade
F_155 CALMETHOD_ID CALCODE CALMETHOD_ID Cascade
F_156 CALMETHOD_ID CALCODE CALMETHOD_ID_APP Cascade
F_166 CALMETHOD_ID CALRANGE CALMETHOD_ID Cascade
F_171 CALMETHOD_ID CALRULE CALMETHOD_ID_QFY Cascade
F_172 CALMETHOD_ID CALRULE CALMETHOD_ID Cascade
F_179 CALMETHOD_ID CALSCALE CALMETHOD_ID Cascade
F_761 CALMETHOD_ID STENCALUSG CALMETHOD_ID_SUM Cascade
F_762 CALMETHOD_ID STENCALUSG CALMETHOD_ID_FIN Cascade
F_763 CALMETHOD_ID STENCALUSG CALMETHOD_ID_INI Cascade
F_764 CALMETHOD_ID STENCALUSG CALMETHOD_ID_APP Cascade
F_767 CALMETHOD_ID STENCALUSG ACTCC_CALMETHOD_ID Cascade
F_768 CALMETHOD_ID STENCALUSG ACTRC_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.