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:

NameTypeDescription
STOREENT_IDINTEGER NOT NULLThe StoreEntity.
CALUSAGE_IDINTEGER NOT NULLThe CalculationUsage.
ACTCC_CALMETHOD_IDINTEGERThe CalculationCodeCombineMethod for the StoreEntity and CalculationUsage.
ACTRC_CALMETHOD_IDINTEGERThe CalculationRuleCombineMethod for the StoreEntity and CalculationUsage.
CALCODE_IDINTEGERThe default CalculationCode, of the specified CalculationUsage, for the StoreEntity.
CALMETHOD_ID_APPINTEGERThe ApplyCalculationUsageMethod for the StoreEntity and CalculationUsage.
CALMETHOD_ID_SUMINTEGERThe SummarizeCalculationUsageMethod for the StoreEntity and CalculationUsage.
CALMETHOD_ID_FININTEGERThe FinalizeCalculationUsageMethod for the StoreEntity and CalculationUsage.
USAGEFLAGSINTEGER NOT NULL DEFAULT 0Bit 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_INIINTEGERThe InitializeCalculationUsageMethod for the StoreEntity and CalculationUsage.
SEQUENCEDOUBLE NOT NULL DEFAULT 0The OrderPrepare command uses CalculationUsage in ascending order of this Sequence attribute.
OPTCOUNTERSMALLINT NOT NULL DEFAULT 0The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>STOREENT_ID+CALUSAGE_IDPrimary Key
I0000770ACTCC_CALMETHOD_IDNon-Unique Index
I0000771CALUSAGE_IDNon-Unique Index
I0000772CALMETHOD_ID_APPNon-Unique Index
I0000773CALMETHOD_ID_ININon-Unique Index
I0000774CALMETHOD_ID_FINNon-Unique Index
I0000775CALMETHOD_ID_SUMNon-Unique Index
I0000776CALCODE_IDNon-Unique Index
I0000777ACTRC_CALMETHOD_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_761CALMETHOD_ID_SUMCALMETHODCALMETHOD_IDCascade
F_762CALMETHOD_ID_FINCALMETHODCALMETHOD_IDCascade
F_763CALMETHOD_ID_INICALMETHODCALMETHOD_IDCascade
F_764CALMETHOD_ID_APPCALMETHODCALMETHOD_IDCascade
F_765STOREENT_IDSTOREENTSTOREENT_IDCascade
F_766CALUSAGE_IDCALUSAGECALUSAGE_IDCascade
F_767ACTCC_CALMETHOD_IDCALMETHODCALMETHOD_IDCascade
F_768ACTRC_CALMETHOD_IDCALMETHODCALMETHOD_IDCascade
F_769CALCODE_IDCALCODECALCODE_IDCascade