CU*BASE Query: ATM/Debit Card Inquiry

The Member ATM/Debit Card Inquiry tool uses IBM Query to list and count all records in the Plastics file for ATM cards (ATM) and Debit cards (DEBT). This inquiry is helpful for determining the exact number of cards currently held by members. If a member has three ATM cards for the same account, all three records will be listed and counted.

Specifications

File(s) used by this Query: PLASTIC

Access: Tool 171: Batch ATM/Debit Card Inquiry (PLASTIC)

The list will be sorted by Card Type (ATM, then DEBT), then by account number, with a count at the end of each card type.

Sample Conditions

Following are some sample conditions which could be used when running the ATM/Debit Card Inquiry:

Description

Field

Test

Value

Show only ATM records.

PLTYPE

‘ATM'

Show the number of ATM cards held by account 27793

AND

PLTYPE

PLACCT

‘ATM'

27793