Stores the various reason codes for which an Order may be blocked.
Column Descriptions
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
| 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.
|