Section 11
PMTTYPE_HOST_TO_QUAD Conversion Table

This table is used when importing transaction data from external systems. RASWIN requires a pre-defined payment method (contained in the PMTTYPES table.) In many cases the method provided by the host system does not match the method used in RASWIN. For example, the host may send CHECK as the payment method, but the corresponding method used in the RASWIN is CK.

During the import process, RASWIN will convert the HOST_CODE method to the QUAD_CODE method using this table.

1. HOST_CODE
   
   This is the payment that is expected to be found in the host system file..
2. QUAD_CODE
   
   This is the payment method to be used when the payment record is generated for insertion in to 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 CHECK and use the corresponding RASWIN payment type CK. Note that two HOST_CODE values in this example (DD, and DIRECT) both point to the single QUAD_CODE DD. This permits multiple host interfaces that may use different payment types to be linked to a single RASWIN payment type.

The HOST_CODE column values must be UNIQUE, but the QUAD_CODE column can contain duplicate entries, as shown in the example above.