I've done more research and I understand now that there are tables that use id directly from the sequence 'id'. It appears that trans_id is a foreign key for those id.
Still trying to grok the transactions table. Eric Eric Lucas wrote: > 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
