WebSphere Commerce 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 Descriptions
Column Name Column Type Description
STOREENT_ID INTEGER NOT NULL The StoreEntity.
CALUSAGE_ID INTEGER NOT NULL The CalculationUsage.
ACTCC_CALMETHOD_ID INTEGER The CalculationCodeCombineMethod for the StoreEntity and CalculationUsage.
ACTRC_CALMETHOD_ID INTEGER The CalculationRuleCombineMethod for the StoreEntity and CalculationUsage.
CALCODE_ID INTEGER The default CalculationCode, of the specified CalculationUsage, for the StoreEntity.
CALMETHOD_ID_APP INTEGER The ApplyCalculationUsageMethod for the StoreEntity and CalculationUsage.
CALMETHOD_ID_SUM INTEGER The SummarizeCalculationUsageMethod for the StoreEntity and CalculationUsage.
CALMETHOD_ID_FIN INTEGER The FinalizeCalculationUsageMethod for the StoreEntity and CalculationUsage.
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.
CALMETHOD_ID_INI INTEGER The InitializeCalculationUsageMethod for the StoreEntity and CalculationUsage.
SEQUENCE DOUBLE NOT NULL DEFAULT 0 The OrderPrepare and OrderPrepare commands use CalculationUsages in ascending order of this Sequence attribute.
OPTCOUNTER SMALLINT Reserved for IBM internal use.

Indexes
Index Name Indexed Column Names Index Type
SQL060903235252390 STOREENT_ID+CALUSAGE_ID Primary Key
I0000770 ACTCC_CALMETHOD_ID Non-Unique Index
I0000771 CALUSAGE_ID Non-Unique Index
I0000772 CALMETHOD_ID_APP Non-Unique Index
I0000773 CALMETHOD_ID_INI Non-Unique Index
I0000774 CALMETHOD_ID_FIN Non-Unique Index
I0000775 CALMETHOD_ID_SUM Non-Unique Index
I0000776 CALCODE_ID Non-Unique Index
I0000777 ACTRC_CALMETHOD_ID Non-Unique Index

Constraints
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_769 CALCODE_ID CALCODE CALCODE_ID Cascade
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_767 ACTCC_CALMETHOD_ID CALMETHOD CALMETHOD_ID Cascade
F_768 ACTRC_CALMETHOD_ID CALMETHOD CALMETHOD_ID Cascade
F_766 CALUSAGE_ID CALUSAGE CALUSAGE_ID Cascade
F_765 STOREENT_ID STOREENT STOREENT_ID Cascade