CALMETHOD

Each row of this table defines a CalculationMethod implementation.

Column Descriptions:

NameTypeDescription
CALMETHOD_IDINTEGER NOT NULLGenerated unique identifier.
STOREENT_IDINTEGER NOT NULLThe StoreEntity of which this CalculationMethod definition is a part.
CALUSAGE_IDINTEGER NOT NULLThe CalculationUsage (such as discount, shipping, sales tax, shipping tax) of the CalculationMethod.
TASKNAMEVARCHAR (254)Complete name of the Java Interface Class for the method. For example, com.ibm.commerce.order.utils.CalculationCodeCombineCmd
DESCRIPTIONVARCHAR (508)A description of the CalculationMethod, suitable for display by a user interface that creates and updates CalculationCodes and CalculationScales.
SUBCLASSINTEGER
1-CalculationCodeCombineMethod
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.
2-CalculationCodeQualifyMethod
Called by the CalculationCodeCombineMethod to determine the applicability of a CalculationCode to a list of OrderItems.
3-CalculationCodeCalculateMethod
Called by the ApplyCalculationUsageMethod or the CalculationCodeQualifyMethod to calculate values for a list of OrderItems, for a particular CalculationCode.
4-CalculationCodeApplyMethod
Called by the ApplyCalculationUsageMethod to apply calculated values for a list of OrderItems, to an Order.
5-CalculationRuleCombineMethod
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.
6-CalculationRuleQualifyMethod
Called by the CalculationRuleCombineMethod to determine, for a particular CalculationRule, to which of a list of OrderItems it applies.
7-CalculationRuleCalculateMethod
Called by the CalculationCodeCalculateMethod or the CalculationRuleCombineMethod to calculate values for a list of OrderItems.
8-QuantityCalculationScaleLookupMethod
Called by the CalculationRuleCalculateMethod to determine how a quantity based CalculationScale can be used to lookup a CalculationRange for a list of OrderItems.
9-MonetaryCalculationScaleLookupMethod
Called by the CalculationRuleCalculateMethod to determine how a monetary based CalculationScale can be used to lookup a CalculationRange for a list of OrderItems.
10-CalculationRangeMethod
Called by the CalculationRuleCalculateMethod to determine a calculated value from a CalculationRangeLookupResult.
11-IntializeCalculationUsageMethod
Called by OrderPrepare to initialize an Order, for example, by removing previously calculated values.
12-ApplyCalculationUsageMethod
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 alculationCodeCalculateMethod, and the CalculationCodeApplyMethod.
13-SummarizeCalculationUsageMethod
Summarizes calculated values and applies them to an Order, including, for example, populating SubOrderAdjustments or SubOrder shipping charges or tax amounts.
14-FinalizeCalculationUsageMethod
Called when an Order is placed to mark consumed resources, such as coupons, as no longer available.
NAMEVARCHAR (254)A character string that uniquely identifies this CalculationMethod for a particular combination of StoreEntity, SubClass, and CalculationUsage.
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>CALMETHOD_IDPrimary Key
I0000055SUBCLASS+CALUSAGE_ID+STOREENT_ID+NAMEUnique Index
I0000501STOREENT_IDNon-Unique Index
I0000502CALUSAGE_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_163CALUSAGE_IDCALUSAGECALUSAGE_IDCascade
F_164STOREENT_IDSTOREENTSTOREENT_IDCascade

Referenced By Child Tables:

ConstraintColumnsChild TableChild ColumnsType
F_154CALMETHOD_IDCALCODECALMETHOD_ID_QFYCascade
F_155CALMETHOD_IDCALCODECALMETHOD_IDCascade
F_156CALMETHOD_IDCALCODECALMETHOD_ID_APPCascade
F_166CALMETHOD_IDCALRANGECALMETHOD_IDCascade
F_171CALMETHOD_IDCALRULECALMETHOD_ID_QFYCascade
F_172CALMETHOD_IDCALRULECALMETHOD_IDCascade
F_179CALMETHOD_IDCALSCALECALMETHOD_IDCascade
F_761CALMETHOD_IDSTENCALUSGCALMETHOD_ID_SUMCascade
F_762CALMETHOD_IDSTENCALUSGCALMETHOD_ID_FINCascade
F_763CALMETHOD_IDSTENCALUSGCALMETHOD_ID_INICascade
F_764CALMETHOD_IDSTENCALUSGCALMETHOD_ID_APPCascade
F_767CALMETHOD_IDSTENCALUSGACTCC_CALMETHOD_IDCascade
F_768CALMETHOD_IDSTENCALUSGACTRC_CALMETHOD_IDCascade