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
| Column Name
| Column Type
| Description
|
| STOREENT_ID
| INTEGER NOT NULL
| The store entity id, foreign key of STOREENT table.
|
| BLKRSNCODE_ID
| INTEGER NOT NULL
| The block reason code id. Foreign key to the BLKRSNCODE table.
|
| RESPECTED
| SMALLINT NOT NULL DEFAULT 1
| Indicates 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.
|
| TKLRGENERATION
| SMALLINT NOT NULL DEFAULT 1
| Indicates 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.
|
| FIELD1
| INTEGER
| Customizable field1.
|
| FIELD2
| VARCHAR(254)
| Customizable field2.
|
| OPTCOUNTER
| SMALLINT
| Reserved for IBM Internal Use
|