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 Descriptions
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
SQL060903235136320 CALUSAGE_ID Primary Key

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