3 ms·
What you have done is record credit and debit entries in the same column, distinguishing credits and debits by sign. This is a design choice in the data structu
by inopinatus 2y ago
What you have done is record credit and debit entries in the same column, distinguishing credits and debits by sign. This is a design choice in the data structure for DE systems. It's a tossup whether that's better than either of the alternatives.
In the case of moving money between regular bank accounts in the same institution, you regard that as a movement between two asset accounts, whilst the bank regards that as a movement between two liability accounts.
So their entries would have the same magnitude as yours, but inverted signs.
- Izkata 2y ago> It's a tossup whether that's better than either of the alternatives. Which means you aren't even thinking of the "bad" single-entry version, which is what a lot of people here are stumbling over because apparently it's more natural: A "transfers" table with the columns FromAccount, ToAccount, Amount, were a single row represents both the "Entry" rows from mine above.
- deleted 2y ago[deleted]