CALCODEDSC

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

Column Descriptions:

NameTypeDescription
CALCODE_IDINTEGER NOT NULLThe CalculationCode to which this information applies.
LANGUAGE_IDINTEGER NOT NULLThe language for which this information applies. For a list of language components, see the LANGUAGE table.
DESCRIPTIONVARCHAR (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.
LONGDESCRIPTIONVARCHAR (4000)A detailed description of the CalculationCode.
OPTCOUNTERSMALLINT NOT NULL DEFAULT 0The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>CALCODE_ID+LANGUAGE_IDPrimary Key

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_157CALCODE_IDCALCODECALCODE_IDCascade
F_158LANGUAGE_IDLANGUAGELANGUAGE_IDCascade