Transactions and Payments
I have two tables Customers and Transactions. Transactions is very simplified, charges and payments. If I am posting a payment, and put in the customer number, I want the unpaid transactions to populate a portal.
I have a TO for the posting of the charges. I am not sure how to define the second TO. Suggestions?
The SeqNum in the Customer table is the customer number which is the secondary key (sKey) in the transaction file. I am thinking populating the TranCode (PAY) and the Customer Number would populate a portal with transactions for the customer with a balance due greater than 0.00.