https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=29985
--- Comment #1 from Katrin Fischer <[email protected]> --- Possibly easier to read if you copy from here to an editor: MariaDB [koha_kohadev]> select * from accountlines; +-----------------+----------+----------------+------------+---------------------+------------+-------------+------------------+-----------------+---------------+----------+--------------+-------------------+---------------------+------+------------+-------------+-----------+------------+ | accountlines_id | issue_id | borrowernumber | itemnumber | date | amount | description | credit_type_code | debit_type_code | credit_number | status | payment_type | amountoutstanding | timestamp | note | manager_id | register_id | interface | branchcode | +-----------------+----------+----------------+------------+---------------------+------------+-------------+------------------+-----------------+---------------+----------+--------------+-------------------+---------------------+------+------------+-------------+-----------+------------+ | 1 | NULL | 19 | NULL | 2022-01-31 21:18:18 | -20.000000 | | CREDIT | NULL | NULL | NULL | NULL | 0.000000 | 2022-01-31 21:19:21 | | 51 | NULL | intranet | CPL | | 2 | NULL | 19 | NULL | 2022-01-31 21:18:32 | 7.000000 | New card | NULL | NEW_CARD | NULL | REFUNDED | NULL | 0.000000 | 2022-01-31 21:19:58 | | 51 | NULL | intranet | CPL | | 3 | NULL | 19 | NULL | 2022-01-31 21:18:48 | 10.000000 | Umbrella | NULL | UMBR | NULL | NULL | NULL | 0.000000 | 2022-01-31 21:19:21 | | 51 | NULL | intranet | CPL | | 4 | NULL | 19 | NULL | 2022-01-31 21:18:54 | 4.500000 | USB Stick | NULL | USB | NULL | NULL | NULL | 0.000000 | 2022-01-31 21:19:48 | | 51 | NULL | intranet | CPL | | 5 | NULL | 19 | NULL | 2022-01-31 21:19:03 | 5.550000 | Manual fee | NULL | MANUAL | NULL | NULL | NULL | 0.000000 | 2022-01-31 21:20:14 | | 51 | NULL | intranet | CPL | | 6 | NULL | 19 | NULL | 2022-01-31 21:19:36 | -4.550000 | | PAYMENT | NULL | NULL | NULL | CASH | 0.000000 | 2022-01-31 21:19:36 | | 51 | 1 | intranet | CPL | | 7 | NULL | 19 | NULL | 2022-01-31 21:19:48 | -1.500000 | | PAYMENT | NULL | NULL | NULL | CASH | 0.000000 | 2022-01-31 21:19:48 | | 51 | 1 | intranet | CPL | | 8 | NULL | 19 | NULL | 2022-01-31 21:19:58 | -7.000000 | NULL | REFUND | NULL | NULL | ADDED | NULL | 0.000000 | 2022-01-31 21:20:56 | NULL | 51 | NULL | intranet | CPL | | 9 | NULL | 19 | NULL | 2022-01-31 21:20:56 | 6.000000 | | NULL | PAYOUT | NULL | PAID | CASH | 0.000000 | 2022-01-31 21:20:56 | | NULL | 1 | intranet | NULL | +-----------------+----------+----------------+------------+---------------------+------------+-------------+------------------+-----------------+---------------+----------+--------------+-------------------+---------------------+------+------------+-------------+-----------+------------+ 9 rows in set (0.002 sec) MariaDB [koha_kohadev]> select * from account_offsets; +----+-----------+----------+--------+------------+---------------------+ | id | credit_id | debit_id | type | amount | created_on | +----+-----------+----------+--------+------------+---------------------+ | 1 | 1 | NULL | CREATE | 20.000000 | 2022-01-31 21:18:18 | | 2 | NULL | 2 | CREATE | 7.000000 | 2022-01-31 21:18:32 | | 3 | NULL | 3 | CREATE | 10.000000 | 2022-01-31 21:18:48 | | 4 | NULL | 4 | CREATE | 4.500000 | 2022-01-31 21:18:54 | | 5 | NULL | 5 | CREATE | 5.550000 | 2022-01-31 21:19:03 | | 6 | 1 | 2 | APPLY | -7.000000 | 2022-01-31 21:19:21 | | 7 | 1 | 3 | APPLY | -10.000000 | 2022-01-31 21:19:21 | | 8 | 1 | 4 | APPLY | -3.000000 | 2022-01-31 21:19:21 | | 9 | 6 | NULL | CREATE | 4.550000 | 2022-01-31 21:19:36 | | 10 | 6 | 5 | APPLY | -4.550000 | 2022-01-31 21:19:36 | | 11 | 7 | NULL | CREATE | 1.500000 | 2022-01-31 21:19:48 | | 12 | 7 | 4 | APPLY | -1.500000 | 2022-01-31 21:19:48 | | 13 | 8 | NULL | CREATE | -7.000000 | 2022-01-31 21:19:58 | | 14 | 8 | 2 | APPLY | 0.000000 | 2022-01-31 21:19:58 | | 15 | 8 | 5 | APPLY | -1.000000 | 2022-01-31 21:20:14 | | 16 | NULL | 9 | CREATE | 6.000000 | 2022-01-31 21:20:56 | | 17 | 8 | 9 | APPLY | -6.000000 | 2022-01-31 21:20:56 | +----+-----------+----------+--------+------------+---------------------+ -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes. _______________________________________________ Koha-bugs mailing list [email protected] https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
