Method and apparatus for processing financial transactions over a paging network

A method of processing financial transaction requests received from a paging network with a transaction processor comprising a network interface server, a transaction server, a database server, and a message server, the method comprising the steps of:

• receiving a financial transaction request in the form of an encrypted paging message at the network interface server, said paging message comprising a set of transaction data including a routing number, an account number, a transaction amount, a security code and a paging unit ID number;
• decrypting the paging message at the message server;
• comparing each data field within the set of transaction data with a corresponding data field standard from the database server to determine if the format of the data fields are acceptable for processing;
• if any of the data fields do not have an acceptable format, then performing the following steps a) through d);
• a) generating a transaction denied paging message corresponding to the reason why the transaction was denied;
• b) identifying a paging unit address that corresponds to a paging unit ID number within the set of transaction data;
• c) encrypting the transaction denied paging message;
• d) sending the encrypted transaction denied paging message to the paging unit address
• if all of the data fields have an acceptable format, then performing the following steps e) through j):
• e) assigning the transaction request a transaction reference number;
• f) storing the set of transaction data, the transaction reference number, and an approval flag in a temporary transaction table in the database server;
• g) retrieving a set of account data and a set of customer data from the database server, both of which correspond to the account number in the set of transaction data;
• h) comparing a security code from the set of transaction data with a security code from the corresponding set of customer data to determine if an acceptable security code has been provided;
• i) if an acceptable security code has not been provided, then performing the transaction denied routine designated above as steps a) through d);
• j) if an acceptable security code has been provided then performing the following steps l) through n):
• l) comparing a transaction amount from the set of transaction data with a balance amount from the corresponding set of account data to determine if sufficient funds are available for the requested financial transaction;
• m) if sufficient funds are not available for the requested financial transaction, then performing the transaction denied routine designated above as steps a) through d);
• n) if sufficient funds are available for the requested financial transaction, then performing the following steps o) through s):
• o) activating the approval flag in the set of transaction data;
• p) generating a transaction approved paging message comprising a plurality of data fields including an account balance data field;
• q) identifying a paging unit address that corresponds to a paging unit ID number within the set of transaction data;
• r) encrypting the transaction approved paging message;
• s) sending the encrypted transaction approved paging message to the paging unit address;
• transferring all sets of transaction data in which the approval flag has been activated from the temporary transaction table to a transaction table in the database server;
• transferring all sets of transaction data in which the approval flag has not been activated from the temporary transaction table to a history table in the database server;
• and
• exporting the transaction table into an ACH file for transmission to an ACH network.

A computer program product suitable for execution on a general purpose computer, the computer program product encoded with instructions for performing the following steps:

• receiving a financial transaction request at the transaction processor in the form of a paging message comprising a set of transaction data;
• storing the set of transaction data with an approval flag in a temporary transaction table in a database in the transaction processor;
• retrieving a set of account data corresponding to an account number within the set of transaction data from the database within the transaction processor;
• comparing a transaction amount from the set of transaction data with a balance amount from the corresponding set of account data to determine if sufficient funds are available for the requested financial transaction;
• if sufficient funds are not available for the requested financial transaction, then performing the following steps a) through c):
• a) generating a transaction denied paging message;
• b) identifying a paging unit address that corresponds to a paging unit ID number within the set of transaction data;
• c) sending the transaction denied paging message to the paging unit address;
• if sufficient funds are available for the requested financial transaction, then performing the following steps d) through g):
• d) activating the approval flag in the set of transaction data;
• e) generating a transaction approved paging message comprising a plurality of data fields including an account balance data field;
• f) identifying a paging unit address that corresponds to a paging unit ID number within the set of transaction data;
• g) sending the transaction approved paging message to the paging unit address;
• transferring all sets of transaction data in which the approval flag has been activated from the temporary transaction table to a transaction table in the database;
• transferring all sets of transaction data in which the approval flag has not been activated from the temporary transaction table to a history table in the database;
• and
• exporting the transaction table into an ACH file in the database for transmission on an ACH network.

A computer program product suitable for execution on a general purpose computer, the computer program product encoded with instructions for performing the following steps:

• receiving a financial transaction request in the form of an encrypted paging, said paging message comprising a set of transaction data including a routing number, an account number, a transaction amount, a security code and a paging unit ID number;
• decrypting the paging message at the message server;
• comparing each data field within the set of transaction data with a corresponding data field standard from a database in the transaction processor to determine if the format of the data fields are acceptable for processing;
• if any of the data fields do not have an acceptable format, then performing the following steps a) through d);
• a) generating a transaction denied paging message corresponding to the reason why the transaction was denied;
• b) identifying a paging unit address that corresponds to a paging unit ID number within the set of transaction data;
• c) encrypting the transaction denied paging message;
• d) sending the encrypted transaction denied paging message to the paging unit address
• if all of the data fields have an acceptable format, then performing the following steps e) through j):
• e) assigning the transaction request a transaction reference number;
• f) storing the set of transaction data, the transaction reference number, and an approval flag in a temporary transaction table in the database;
• g) retrieving a set of account data and a set of customer data from the database, both of which correspond to the account number in the set of transaction data;
• h) comparing a security code from the set of transaction data with a security code from the corresponding set of customer data to determine if an acceptable security code has been provided;
• i) if an acceptable security code has not been provided, then performing the transaction denied routine designated above as steps a) through d);
• j) if an acceptable security code has been provided then performing the following steps l) through n):
• l) comparing a transaction amount from the set of transaction data with a balance amount from the corresponding set of account data to determine if sufficient funds are available for the requested financial transaction;
• m) if sufficient funds are not available for the requested financial transaction, then performing the transaction denied routine designated above as steps a) through d);
• n) if sufficient funds are available for the requested financial transaction, then performing the following steps o) through s):
• o) activating the approval flag in the set of transaction data;
• p) generating a transaction approved paging message comprising a plurality of data fields including an account balance data field;
• q) identifying a paging unit address that corresponds to a paging unit ID number within the set of transaction data;
• r) encrypting the transaction approved paging message;
• s) sending the encrypted transaction approved paging message to the paging unit address;
• transferring all sets of transaction data in which the approval flag has been activated from the temporary transaction table to a transaction table in the database;
• transferring all sets of transaction data in which the approval flag has not been activated from the temporary transaction table to a history table in the database;
• and
• exporting the transaction table into an ACH file for transmission to an ACH network.

A transaction processor adapted for processing financial transactions received from a paging network, the transaction processor comprising:

• a network interface electrically connected to a paging network;
• a transaction server electrically connected to the network interface and to a processor network, wherein the transaction server is adapted to process financial transaction requests;
• a message server electrically connected the network interface and the transaction server, wherein the message server is adapted to receive inbound paging messages from the network interface, and generate outbound paging messages for transmission through the network interface to the paging network;
• a database electrically connected to the transaction server and the message server, the database comprising a computer memory encoded with a relational database including an account table, a transaction table, a temporary transaction table, and a history table;
• a computer memory product encoded with instructions for performing the following steps:
• receiving a financial transaction request in the form of a paging message comprising a set of transaction data;
• storing the set of transaction data with an approval flag in the temporary transaction table;
• retrieving a set of account data corresponding to an account number within the set of transaction data from the account table;
• comparing a transaction amount from the set of transaction data with a balance amount from the corresponding set of account data to determine if sufficient funds are available for the requested financial transaction;
• if sufficient funds are not available for the requested financial transaction, then performing the following steps a) through c):
• a) generating a transaction denied paging message;
• b) identifying a paging unit address that corresponds to a paging unit ID number within the set of transaction data;
• c) sending the transaction denied paging message to the paging unit address;
• if sufficient funds are available for the requested financial transaction, then performing the following steps d) through g):
• d) activating the approval flag in the set of transaction data;
• e) generating a transaction approved paging message comprising a plurality of data fields including an account balance data field;
• f) identifying a paging unit address that corresponds to a paging unit ID number within the set of transaction data;
• g) sending the transaction approved paging message to the paging unit address;
• transferring all sets of transaction data in which the approval flag has been activated from the temporary transaction table to a transaction table in the database;
• transferring all sets of transaction data in which the approval flag has not been activated from the temporary transaction table to a history table in the database;
• and
• exporting the transaction table into an ACH file in the database for transmission on an ACH network.

A transaction processor adapted for processing financial transactions received from a paging network, the transaction processor comprising:

• a network interface electrically connected to a paging network;
• a transaction server electrically connected to the network interface and to a processor network, wherein the transaction server is adapted to process financial transaction requests;
• a message server electrically connected the network interface and the transaction server, wherein the message server is adapted to receive inbound paging messages from the network interface, and generate outbound paging messages for transmission through the network interface to the paging network;
• a database electrically connected to the transaction server and the message server, the database comprising a computer memory encoded with a relational database including an account table, a transaction table, a temporary transaction table, and a history table;
• a computer memory product encoded with instructions for performing the following steps:
• receiving a financial transaction request in the form of an encrypted paging message at the network interface, said paging message comprising a set of transaction data including a routing number, an account number, a transaction amount, a security code and a paging unit ID number;
• decrypting the paging message at the message server;
• comparing each data field within the set of transaction data with a corresponding data field standard from the database to determine if the format of the data fields are acceptable for processing;
• if any of the data fields do not have an acceptable format, then performing the following steps a) through d);
• a) generating a transaction denied paging message corresponding to the reason why the transaction was denied;
• b) retrieving a paging unit address corresponding to a paging unit ID number within the set of transaction data from the database;
• c) encrypting the transaction denied paging message;
• d) sending the encrypted transaction denied paging message to the paging unit address;
• if all of the data fields have an acceptable format, then performing the following steps e) through j):
• e) assigning the transaction request a transaction reference number;
• f) storing the set of transaction data, the transaction reference number, and an approval flag in a temporary transaction table in the database server;
• g) retrieving a set of account data and a set of customer data from the database, both of which correspond to the set of transaction data;
• h) comparing a security code from the set of transaction data with a security code from the corresponding set of customer data to determine if an acceptable security code has been provided;
• i) if an acceptable security code has not been provided, then performing the transaction denied routine designated above as steps a) through d);
• j) if an acceptable security code has been provided then performing the following steps l) through n):
• l) comparing a transaction amount from the set of transaction data with a balance amount from the corresponding set of account data to determine if sufficient funds are available for the requested financial transaction;
• m) if sufficient funds are not available for the requested financial transaction, then performing the transaction denied routine designated above as steps a) through d);
• n) if sufficient funds are available for the requested financial transaction, then performing the following steps o) through s):
• o) activating the approval flag in the set of transaction data;
• p) generating a transaction approved paging message comprising a plurality of data fields including an account balance data field;
• q) identifying a paging unit address that corresponds to a paging unit ID number within the set of transaction data;
• r) encrypting the transaction approved paging message;
• s) sending the encrypted transaction approved paging message to the paging unit address;
• transferring all sets of transaction data in which the approval flag has been activated from the temporary transaction table to a transaction table in the database server;
• transferring all sets of transaction data in which the approval flag has not been activated from the temporary transaction table to a history table in the database server;
• and
• exporting the transaction table into an ACH file for transmission to an ACH network.