Reference > Database > WebSphere Commerce database tables > C
WebSphere Commerce database table: CALUSAGE
A row in this table represents a CalculationUsage, indicating what kind of calculation a CalculationCode or CalculationScale is used for. Examples of CalculationUsages include discounts, shipping charges, sales tax, and shipping tax.
Column Name Column Type Description CALUSAGE_ID INTEGER NOT NULL Unique identifier. DESCRIPTION VARCHAR(254) A brief description of the Calculation Usage, suitable for display by an administration user interface that works with Calculation Usages. OPTCOUNTER SMALLINT Reserved for IBM internal use. STRELTYPNAMECFG VARCHAR(60) The store relationship type of configuration data for this calculation usage. STRELTYPNAMERT VARCHAR(60) The store relationship type of calculation runtime for this calculation usage.
Indexes Index Name Indexed Column Names Index Type SQL100520030309210 CALUSAGE_ID Primary Key
Referenced By Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type F_1225 CALUSAGE_ID CALADJUST CALUSAGE_ID Cascade F_151 CALUSAGE_ID CALCODE CALUSAGE_ID Cascade F_163 CALUSAGE_ID CALMETHOD CALUSAGE_ID Cascade F_176 CALUSAGE_ID CALSCALE CALUSAGE_ID Cascade F_492 CALUSAGE_ID ORDADJUST CALUSAGE_ID Cascade F_766 CALUSAGE_ID STENCALUSG CALUSAGE_ID Cascade F_823 TAXTYPE_ID TAXTYPE CALUSAGE_ID Cascade
Related reference
- Calculation usage data model
- Calculation scale data model
- Tax type and category data model
- Order adjustment data model
- Calculation method data model
- Calculation code data model
_vcc_freeselect_bottom_