A row in this table represents a CalculationScale, which can be used to perform a scale lookup to calculate a monetary amount, for a given set of OrderItems.
Column Description(s):
Column Name | Column Type | Description |
CALSCALE_ID |
INTEGER NOT NULL |
Generated unique identifier. |
QTYUNIT_ID |
CHAR(16) |
If specified, the unit of measure for the rangeStart values of the CalculationRange objects for this CalculationScale. The CalculationScaleLookupMethod should return a "lookup number" in these units. |
CODE |
CHAR(30) |
A character string that uniquely identifies this CalculationScale, given a particular CalculationUsage and StoreEntity. |
DESCRIPTION |
VARCHAR(254) |
A brief description of this CalculationScale, suitable for display by a user interface that allows creators of CalculationRules to choose from a list of available CalculationScales. |
STOREENT_ID |
INTEGER NOT NULL |
The CalculationScale is part of this StoreEntity. |
CALUSAGE_ID |
INTEGER NOT NULL |
Indicates the kind of calculation this CalculationScale is used for. For example, the CalculationScale may be used to calculate one of the following monetary amounts: discounts, shipping charges, sales tax, or shipping tax. |
SETCCURR |
CHAR(3) |
If specified, the currency for the rangeStart values of the CalculationRange objects for this CalculationScale. The CalculationScaleLookupMethod should return a "lookup number" in this currency. This is a currency code as per ISO 4217 standards. |
CALMETHOD_ID |
INTEGER NOT NULL |
The CalculationScaleLookupMethod that given a set of OrderItems determines a "lookup number", a "base monetary value", a "result multiplier", and a set of mathematical weights that can be used by the CalculationScale to calculate a monetary amount. |
FIELD1 |
VARCHAR(254) |
Customizable. |
OPTCOUNTER |
SMALLINT |
Reserved for IBM internal use. |
Index(es):
Index Name | Indexed Column Names | Index Type |
I0000059 |
CALUSAGE_ID+CODE+STOREENT_ID |
Unique Index |
SQL050212031207050 |
CALSCALE_ID |
Primary Key |
I0000508 |
CALMETHOD_ID |
Non-Unique Index |
I0000509 |
STOREENT_ID |
Non-Unique Index |
Constraint(s):
Constraint Name | Column Name(s) | Foreign Table Name | Foreign Column Name(s) | Constraint Type |
F_179 |
CALMETHOD_ID |
CALMETHOD |
CALMETHOD_ID |
Cascade |
F_176 |
CALUSAGE_ID |
CALUSAGE |
CALUSAGE_ID |
Cascade |
F_178 |
QTYUNIT_ID |
QTYUNIT |
QTYUNIT_ID |
Cascade |
F_175 |
SETCCURR |
SETCURR |
SETCCURR |
Cascade |
F_177 |
STOREENT_ID |
STOREENT |
STOREENT_ID |
Cascade |
Referenced By:
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Name(s) | Constraint Type |
F_165 |
CALSCALE_ID |
CALRANGE |
CALSCALE_ID |
Cascade |
F_181 |
CALSCALE_ID |
CALSCALEDS |
CALSCALE_ID |
Cascade |
F_281 |
CALSCALE_ID |
CRULESCALE |
CALSCALE_ID |
Cascade |
Related reference
(C) Copyright IBM Corporation 1996, 2005. All Rights Reserved.