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 Name | Column Type | Column Description |
---|---|---|
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. |
CALSCALE_ID | INTEGER NOT NULL |
Generated unique identifier. |
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. |
CODE | CHARACTER (30) NULL |
A character string that uniquely identifies this CalculationScale, given a particular CalculationUsage and StoreEntity. |
DESCRIPTION | VARCHAR (254) NULL |
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. |
FIELD1 | VARCHAR (254) NULL |
Customizable. |
QTYUNIT_ID | CHARACTER (16) NULL |
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. |
SETCCURR | CHARACTER (3) NULL |
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. |
STOREENT_ID | INTEGER NOT NULL |
The CalculationScale is part of this StoreEntity. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
I0000059 | CALUSAGE_ID, CODE, STOREENT_ID | Unique Index |
SQL030416034853210 | CALSCALE_ID | Primary Key |
Constraint Name | Column Names | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|
F_175 | SETCCURR | SETCURR | SETCCURR | Cascade |
F_176 | CALUSAGE_ID | CALUSAGE | CALUSAGE_ID | Cascade |
F_177 | STOREENT_ID | STOREENT | STOREENT_ID | Cascade |
F_178 | QTYUNIT_ID | QTYUNIT | QTYUNIT_ID | Cascade |
F_179 | CALMETHOD_ID | CALMETHOD | CALMETHOD_ID | Cascade |
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Names | 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 |