Stores the various reason codes for which an Order may be blocked.
Column Description(s):
Column Name | Column Type | Description |
BLKRSNCODE_ID |
INTEGER NOT NULL |
Unique reason code Id for the block reason |
BLOCKREASONTYPE |
CHAR(25) NOT NULL |
Reason codes of similar nature are grouped together by block reason type. |
MANUALBLOCK |
SMALLINT NOT NULL |
1- Manual Block; 0- Not manual block. Blocks that are marked manual can be applied using the Telesales rich client. |
MARKFORDELETE |
CHAR(1) NOT NULL |
This reason code is scheduled to be deleted, and hence will not be used. |
FIELD1 |
INTEGER |
Field for customization |
FIELD2 |
VARCHAR(254) |
Field for customization |
OPTCOUNTER |
SMALLINT |
Reserved for IBM internal use. |
Index(es):
Index Name | Indexed Column Names | Index Type |
SQL050212031202050 |
BLKRSNCODE_ID |
Primary Key |
Referenced By:
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Name(s) | Constraint Type |
F_1221 |
BLKRSNCODE_ID |
BLKRSNDESC |
BLKRSNCODE_ID |
Cascade |
F_1220 |
BLKRSNCODE_ID |
ORDERBLK |
BLKRSNCODE_ID |
Cascade |
(C) Copyright IBM Corporation 1996, 2005. All Rights Reserved.