Reference > Database > WebSphere Commerce database tables > C


WebSphere Commerce database table: CALCODEDSC

Each row of this table contains Language-dependent information for a CalculationCode.

Column Name Column Type Description
CALCODE_ID INTEGER NOT NULL The CalculationCode to which this information applies.
LANGUAGE_ID INTEGER NOT NULL The language for which this information applies. For a list of language components, see the LANGUAGE table.
DESCRIPTION VARCHAR(254) A short description of the CalculationCode. For discount CalculationCodes, this information is copied to the OrderItemAdjustments created when the CalculationCode is applied to OrderItems in an Order.
LONGDESCRIPTION VARCHAR(4000) A detailed description of the CalculationCode.
OPTCOUNTER SMALLINT Reserved for IBM internal use.

Indexes
Index Name Indexed Column Names Index Type
SQL100520030307480 CALCODE_ID+LANGUAGE_ID Primary Key

Constraints
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_157 CALCODE_ID CALCODE CALCODE_ID Cascade
F_158 LANGUAGE_ID LANGUAGE LANGUAGE_ID Cascade


Related reference

_vcc_freeselect_bottom_


+

Search Tips   |   Advanced Search