Each block on an order has a block reason code.
In addition to the order block reason codes with WebSphere Commerce,
you can add additional order block codes to meet your business needs.
These new order blocks can be added manually to orders.
You
must add a new block reason code to the BLKRSNCODE table
and a description of the new block reason in the BLKRSNDESC table. You can add the
description in various languages in the BLKRSNDESC corresponding to
the languages in which people use the WebSphere Commerce tools.
Procedure
- To add a new block reason code, run the following SQL statements:
INSERT INTO BLKRSNCODE (BLKRSNCODE_ID, BLOCKREASONTYPE, MANUALBLOCK, MARKFORDELETE) VALUES (code, "reason", 1, '0')
INSERT INTO BLKRSNDESC (BLKRSNCODE_ID, LANGUAGE_ID, DESCRIPTION) VALUES (code, language_id, "description")
Where:
- code
- A numeric code for the new reason. Four-digit codes starting with
"5" (5xxx) are reserved for IBM use.
- reason
- A broad classification for the reason code. You can use this field
to group reason codes of a similar nature by using the same broad
classification for various reason codes.
- language_id
- The language ID (primary key) of the LANGUAGE table corresponding
to the National Language in which you are adding the description.
The following table lists the language IDs initially available in
WebSphere Commerce.
- English (US)
- -1
- French
- -2
- German
- -3
- Italian
- -4
- Spanish
- -5
- Brazilian Portuguese
- -6
- Simplified Chinese
- -7
- Traditional Chinese
- -8
- Korean
- -9
- Japanese
- -10
- Russian
- -20
- Romanian
- -21
- Polish
- -22
- description
- A description of the reason code. The description displays in
WebSphere Commerce Accelerator.
- Optional: To disable the order block code for
a specific store, issue the following statement:
INSERT INTO STORBLKRSN (STOREENT_ID, BLKRSNCODE_ID, RESPECTED, TKLRGENERATION) VALUES (storeent_id, code, 0, 0)