Database Table: CALSCALE

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.
Indexes:
Index Name Indexed Column Names Index Type
I0000059 CALUSAGE_ID, CODE, STOREENT_ID Unique Index
SQL030416034853210 CALSCALE_ID Primary Key
Constraints:
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

Referenced By:
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