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 Description(s):
Column NameColumn TypeDescription
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.
Index(es):
Index NameIndexed Column NamesIndex Type
SQL050212031207330 CALUSAGE_ID Primary Key

Referenced By:
Constraint NameReferenced Column NameForeign Table NameForeign Column Name(s)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

Feedback