Section 11
TRANCODES_HOST_TO_QUAD Conversion Table
This table is used when importing transaction data from external
systems. RASWIN requires a pre-defined
TRANCODE (contained in
the
TRANCODES
table.)
In many cases the
TRANCODE provided by the
host system does not match the
TRANCODE
used in RASWIN. For example, the host may send
UTIL
as the
TRANCODE, but the corresponding
TRANCODE used in the RASWIN is
1000.
During the import process, RASWIN will convert the
HOST_CODE to the
QUAD_CODE
using this table.
-
HOST_CODE
This is the
TRANCODE that is expected to be
found in the host system
file..
-
QUAD_CODE
This is the
TRANCODE to be used when the record
is generated into a
transaction
in the RASWIN database.
In the example below there are several codes setup for conversion
from the
HOST_CODE to the
QUAD_CODE. For example, during the
interface process
the
RASWIN
will look up the
HOST_CODE
UTIL and use the
corresponding RASWIN trancode
1000.
Note that two
HOST_CODE values in this example
(
util, and
utilpay)
both point to the single
QUAD_CODE
1000. This permits
multiple host
interfaces that may use different trancodes to be linked
to a single RASWIN
TRANCODE.
In the event that the interface system uses the SAME
TRANCODE as RASWIN, they must still be
defined
in this table on a one-to-one basis.
The
HOST_CODE column values
must be UNIQUE, but the
QUAD_CODE values can contain
duplicate entries, as shown in the example above.
