Updated: May 19, 2021 9:02am

Matching Processor Card Name with RIL Card Name

(Note: This topic only applies to Prism 1.14.7 and earlier; Prism 2.0 is standalone and does not communicate with RIL/RP9)

In Preferences & Settings > Transactions > EFT, you can select the credit cards that your business accepts at POS. If the checkbox for a card is selected, then the card type will be available for selection at POS. There are a set of default card names defined in Prism, as well as several user-defined fields where you can define new card names or cards that are less-well-known but still used by your business. The card name is written to the Card Type field on the Prism transaction.
 Short Labels and Long Labels
Each card name has a short label and a long label. The short cannot be edited and it corresponds to the card names used in RIL (or RP9) preferences. The long label is displayed in a text field and can be edited.

Preferences & Settings > Transactions > Tenders > EFT
Matching Processor Card Name with RIL Card Name
When replicating transactions between Prism and RIL, if you want transactions to include the correct credit card name, RIL must be able to match the card name returned by the processor with the card name defined in RIL Prism Management preferences. The names are usually different, primarily because card names in RIL are limited to six characters. The card name returned by the processor is written to the EFTDATA1 field and is often a longer (or different) value than what is entered in RIL Prism Management card name preferences.
If the card name returned in EFTData1 is different than the value in the Card column in RIL Prism Management preferences, enter the Processor Card Name in RIL Prism Management preferences. If the card name returned by the processor matches the value in the Card column (e.g. VISA), you do not have to enter a Processor Card Name in RIL Prism Management preferences.
 
To find the card name returned by the processor:

  1. Launch and log in to TechToolkit.exe  
  2. Select Managing Schema Objects > SQL Shell    
  3. Enter the following query: Select * from invc_tender where eftdata1 is not null    
  4. Click the button to execute the query.    
  5. Navigate to the EFTDATA1 column to view the card name returned by the processor. Make note of the name for each card type used by your business.    
  6. Enter the appropriate Processor Card Name in RIL Prism Management preferences (Point of Sale > Tenders > Credit Card).    


DRS Replication Notes:

  • If EFTDATA1 field has a value and this is a credit card tender, DRS will assume that the card was swiped and will look for a credit card record that has the same processor card name as listed in EFTDATA1. If it is not found, the card type will be blank.
  • If EFTDATA1 field is blank, DRS will assume that the CED was not configured and the card type was selected from a drop-down list - in this case it will use the tender name from Prism to find the credit card record that has the same card type (V9's normal card type) as the tender name.

The reason why these two cases are handled differently is because when the drop-down list is used, the Prism web client is putting the hard-coded labels to the tender name, but when the CED is used, the web client puts the card name it received from Cayan into the tender name.