STORBLKRSN

Store level block reason code configuration. Used to configure whether a block reason code is turned on for a store and also configure whether this block reason code will generate ticklers.

Column Descriptions:

NameTypeDescription
STOREENT_IDINTEGER NOT NULLThe store entity id, foreign key of STOREENT table.
BLKRSNCODE_IDINTEGER NOT NULLThe block reason code id. Foreign key to the BLKRSNCODE table.
RESPECTEDSMALLINT NOT NULL DEFAULT 1Indicates whether the block reason code is active for the store. 0 = off - the code is not active for the store. 1 = on (default) - the code is active for the store.
TKLRGENERATIONSMALLINT NOT NULL DEFAULT 1Indicates whether the block reason code generates ticklers for the store. 0 = off - the block reason code does not generate ticklers for the store. 1 = on (default) - the block reason code generates ticklers for the store.
FIELD1INTEGERCustomizable field1.
FIELD2VARCHAR (254)Customizable field2.
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+BLKRSNCODE_IDPrimary Key

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
R_3448STOREENT_IDSTOREENTSTOREENT_IDCascade
R_3449BLKRSNCODE_IDBLKRSNCODEBLKRSNCODE_IDCascade