Outsort prefix
The database views used by Business Rules to create the endpoint look up table (.TBL) files
must include the outsort prefix. For example, the CREATE VIEW RULES.ValFwdEndpoint view in the
izlview.ddl installed with Distribution contains the outsort prefix. The
resulting table in Business Rules would look similar to the one shown here:
| Routing transit start * | Routing transit end * | Endpoint | MICR prefix | Outsort prefix |
|---|---|---|---|---|
| 110000001 | 119999999 | 1111111111 | 1 | |
| 210000001 | 219999999 | 2222222222 | 1 | 1 |
| 310000001 | 319999999 | 3333333333 | 2 | |
| 410000001 | 419999999 | 4444444444 | 2 |
Note: The key fields for the look up table are indicated by a superscript, *.
Each table that performs endpoint assignment must include the outsort prefix.