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 |
Index Name | Indexed Column Names | Index Type |
---|---|---|
I0000055 | SUBCLASS, CALUSAGE_ID, STOREENT_ID, NAME | Unique Index |
SQL030416034851470 | CALMETHOD_ID | Primary Key |
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 | 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:
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. |