Database Table: STENCALUSG

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.
Indexes:
Index Name Indexed Column Names Index Type
SQL030416035109670 STOREENT_ID, CALUSAGE_ID Primary Key
Constraints:
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

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