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 Description(s):
Column NameColumn TypeDescription
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.
Index(es):
Index NameIndexed Column NamesIndex Type
SQL050212031313140 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
Constraint(s):
Constraint NameColumn Name(s)Foreign Table NameForeign Column Name(s)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

Feedback