I'm trying to load some QuickBooks data into Ledger SMB and I'm having
trouble understanding one aspect about the structure of Ledger SMB:
I notice the transactions table appears to keep it's id values in a
sequence and that they match the id or trans_id column values in various
other tables (*). Can someone briefly describe the approximate
relationship? For example, are they here to establish some relationship
for all transactions that impact the acc_trans, gl, and chart tables?
Since I'm entering chart records (and then gl and acc_trans records)
manually do I need to add a record to the transactions table for each
one I enter? Are the rules actually more complex than that?
Does that id come from a sequence and if so is it the 'id' sequence as I
suspect?
Thanks!
Eric
(*) I believe the affected tables are:
acc_trans,
audit_trail,
dpt_trans,
inventory,
invoice,
jcitems,
orderitems,
shipto,
status,
translation,
yearend
What about employee? I have a transactions table entry for employee but
it contains "id" and not trans_id
--
# Eric Lucas | Email: [EMAIL PROTECTED]
# Lucii.com | Website: www.lucii.com
# PO Box 5301 | Phone: 610-541-0774 or 484-889-3240
# Springfield Pa. 19064 | Mobile: 610-715-6881
-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
Ledger-smb-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
