Reference > Database > WebSphere Commerce database tables > C
WebSphere Commerce database table: CALSCALE
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 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.
Indexes Index Name Indexed Column Names Index Type I0000059 CALUSAGE_ID+CODE+STOREENT_ID Unique Index SQL100520030308880 CALSCALE_ID Primary Key I0000508 CALMETHOD_ID Non-Unique Index I0000509 STOREENT_ID Non-Unique Index
Constraints Constraint Name Column Names Foreign Table Name Foreign Column Names 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 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
Related reference
- Calculation usage data model
- Calculation scale data model
- Quantity unit - references data model
- Calculation method data model
- Calculation rule data model
_vcc_freeselect_bottom_