Stores the various reason codes for which an Order
may be blocked.
Column Descriptions:
| Name | Type | Description |
| BLKRSNCODE_ID | INTEGER NOT NULL | Unique reason code Id for the block reason |
| BLOCKREASONTYPE | CHAR (25) NOT NULL | A broad classification for the reason code.
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 | Indicates if 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 | The optimistic concurrency control counter for
the table. Every time there is an update to the table, the counter
is incremented. |
Indexes:
| Name | Column Names | Type |
| <SYSTEM-GENERATED> | BLKRSNCODE_ID | Primary Key |
Referenced By Child Tables:
| Constraint | Columns | Child Table | Child Columns | Type |
| F_1220 | BLKRSNCODE_ID | ORDERBLK | BLKRSNCODE_ID | Cascade |
| F_1221 | BLKRSNCODE_ID | BLKRSNDESC | BLKRSNCODE_ID | Cascade |
| R_3449 | BLKRSNCODE_ID | STORBLKRSN | BLKRSNCODE_ID | Cascade |