Reference > Database > WebSphere Commerce database tables > C


WebSphere Commerce database table: CALMETHOD

Each row of this table defines a CalculationMethod implementation.

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
SQL100520030307960 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

Referenced By
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


SUBCLASS column

The type of CalculationMethod...

Value Name Description
1 CalculationCodeCombineMethod Can 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.
2 CalculationCodeQualifyMethod Can be called by the CalculationCodeCombineMethod to determine the applicability of a CalculationCode to a list of OrderItems.
3 CalculationCodeCalculateMethod Can be called by the ApplyCalculationUsageMethod or the CalculationCodeQualifyMethod to calculate values for a list of OrderItems, for a particular CalculationCode.
4 CalculationCodeApplyMethod Can be called by the ApplyCalculationUsageMethod to apply calculated values for a list of OrderItems, to an Order.
5 CalculationRuleCombineMethod Can 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.
6 CalculationRuleQualifyMethod Can be called by the CalculationRuleCombineMethod to determine, for a particular CalculationRule, to which of a list of OrderItems it applies.
7 CalculationRuleCalculateMethod Can be called by the CalculationCodeCalculateMethod or the CalculationRuleCombineMethod to calculate values for a list of OrderItems.
8 QuantityCalculationScaleLookupMethod Can be 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 Can be 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 Can be called by the CalculationRuleCalculateMethod to determine a calculated value from a CalculationRangeLookupResult.
11 IntializeCalculationUsageMethod Can be called by OrderPrepare to initialize an Order, for example, by removing previously calculated values.
12 ApplyCalculationUsageMethod Can 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.
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.


Related reference

_vcc_freeselect_bottom_


+

Search Tips   |   Advanced Search