Each row of this table defines a CalculationMethod
implementation.
Column Descriptions:
| Name | 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 |
- 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.
|
| NAME | VARCHAR (254) | A character string that uniquely identifies this
CalculationMethod for a particular combination of StoreEntity,
SubClass, and CalculationUsage. |
| OPTCOUNTER | SMALLINT NOT NULL DEFAULT 0 | The optimistic concurrency control counter for
the table. Every time there is an update to the table, the counter
is incremented. |
Indexes:
| Name | Column Names | Type |
| <SYSTEM-GENERATED> | CALMETHOD_ID | Primary Key |
| I0000055 | SUBCLASS+CALUSAGE_ID+STOREENT_ID+NAME | Unique Index |
| I0000501 | STOREENT_ID | Non-Unique Index |
| I0000502 | CALUSAGE_ID | Non-Unique Index |
Constrained By Parent Tables:
| Constraint | Columns | Parent Table | Parent Columns | Type |
| F_163 | CALUSAGE_ID | CALUSAGE | CALUSAGE_ID | Cascade |
| F_164 | STOREENT_ID | STOREENT | STOREENT_ID | Cascade |
Referenced By Child Tables:
| Constraint | Columns | Child Table | Child Columns | 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 |