I think the most import takeaway is battk's point that

lineuniquekey

is essentially a PK for the TRANSACTIONS table.