Database Table: CALCODEDSC

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

Column Name Column Type Column Description
CALCODE_ID INTEGER
NOT NULL
The CalculationCode to which this information applies.
DESCRIPTION VARCHAR (254)
NULL
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.
LANGUAGE_ID INTEGER
NOT NULL
The language for which this information applies. For a list of language components, see the LANGUAGE table.
LONGDESCRIPTION VARCHAR (4000)
NULL
A detailed description of the CalculationCode.
Indexes:
Index Name Indexed Column Names Index Type
SQL030416034850500 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

Referenced By:
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
Not Applicable