Each row of this table contains information about how a CalculationUsage is used by a StoreEntity. If a column value is NULL for a Store, the Store uses the value specified for its StoreGroup.
Column Name | Column Type | Column Description |
---|---|---|
ACTCC_CALMETHOD_ID | INTEGER NULL |
The CalculationCodeCombineMethod for the StoreEntity and CalculationUsage. |
ACTRC_CALMETHOD_ID | INTEGER NULL |
The CalculationRuleCombineMethod for the StoreEntity and CalculationUsage. |
CALCODE_ID | INTEGER NULL |
The default CalculationCode, of the specified CalculationUsage, for the StoreEntity. |
CALMETHOD_ID_APP | INTEGER NULL |
The ApplyCalculationUsageMethod for the StoreEntity and CalculationUsage. |
CALMETHOD_ID_FIN | INTEGER NULL |
The FinalizeCalculationUsageMethod for the StoreEntity and CalculationUsage. |
CALMETHOD_ID_INI | INTEGER NULL |
The InitializeCalculationUsageMethod for the StoreEntity and CalculationUsage. |
CALMETHOD_ID_SUM | INTEGER NULL |
The SummarizeCalculationUsageMethod for the StoreEntity and CalculationUsage. |
CALUSAGE_ID | INTEGER NOT NULL |
The CalculationUsage. |
SEQUENCE | DOUBLE NOT NULL, DEFAULT 0 |
The OrderPrepare and OrderPrepare commands use CalculationUsages in ascending order of this Sequence attribute. |
STOREENT_ID | INTEGER NOT NULL |
The StoreEntity. |
USAGEFLAGS | INTEGER NOT NULL, DEFAULT 0 |
Bit flags to control how the OrderPrepare command uses this
CalculationUsage: 1 = use - use this CalculationUsage. 2 = check - throw an ECApplicationException if this CalculationUsage does not calculate a value for an OrderItem. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
SQL030416035109670 | STOREENT_ID, CALUSAGE_ID | Primary Key |
Constraint Name | Column Names | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|
F_761 | CALMETHOD_ID_SUM | CALMETHOD | CALMETHOD_ID | Cascade |
F_762 | CALMETHOD_ID_FIN | CALMETHOD | CALMETHOD_ID | Cascade |
F_763 | CALMETHOD_ID_INI | CALMETHOD | CALMETHOD_ID | Cascade |
F_764 | CALMETHOD_ID_APP | CALMETHOD | CALMETHOD_ID | Cascade |
F_765 | STOREENT_ID | STOREENT | STOREENT_ID | Cascade |
F_766 | CALUSAGE_ID | CALUSAGE | CALUSAGE_ID | Cascade |
F_767 | ACTCC_CALMETHOD_ID | CALMETHOD | CALMETHOD_ID | Cascade |
F_768 | ACTRC_CALMETHOD_ID | CALMETHOD | CALMETHOD_ID | Cascade |
F_769 | CALCODE_ID | CALCODE | CALCODE_ID | Cascade |
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|