Reference > Database > WebSphere Commerce database tables > S
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 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 SQL100520030431070 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
Related reference
_vcc_freeselect_bottom_