What's the SQL table for "acc_trans"?

system · February 26, 2014, 8:54pm

simpleone81 wrote on Wednesday, February 26, 2014:

I was looking at the code at /interface/billing/sl_receipts_report.php:

$query = "SELECT acc_trans.amount, acc_trans.transdate, " .
"acc_trans.memo, acc_trans.project_id, acc_trans.trans_id, " .
"ar.invnumber, ar.employee_id, invoice.sellprice, invoice.qty " .
"FROM acc_trans, ar, invoice WHERE " .

I couldn’t figure out what the SQL table for acc_trans is. Could anyone provide some clue?

thanks!

system · February 26, 2014, 9:11pm

simpleone81 wrote on Wednesday, February 26, 2014:

Never mind - I think this is an obsolete table that doesn’t exist in new versions of openEMR anymore.

system · February 26, 2014, 9:25pm

sunsetsystems wrote on Wednesday, February 26, 2014:

Right, obsolete. It’s left over from the days of SQL-Ledger support. It’s a table in the SQL-Ledger database, not the OpenEMR database.

Rod
http://www.sunsetsystems.com/