CRULESCALE

Each row in this table shows that a CalculationRule is associated with a CalculationScale. Both are used by the Calculation Framework for discounts, shipping charges, taxes, and so on.

Column Descriptions:

NameTypeDescription
CALSCALE_IDINTEGER NOT NULLThe CalculationScale for the calculation. CalculationScales are represented by rows in the CALSCALE table.
CALRULE_IDINTEGER NOT NULLThe CalculationRule for the calculation. CalclationRules are represented by rows in the CALRULE table.
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>CALRULE_ID+CALSCALE_IDPrimary Key
I0000550CALSCALE_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_280CALRULE_IDCALRULECALRULE_IDCascade
F_281CALSCALE_IDCALSCALECALSCALE_IDCascade