A row in this table represents a CalculationScale. It can be used to perform a scale lookup to calculate a monetary amount for a given set of OrderItems.
Column Descriptions
| 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. The user interface 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.
|