[SQL-Ledger-users] Examination of database tables

[Thomas S. <ps...@on...>]

Well I'm doing indepth analysis here trying to understand everything
and its starting to unfold for me.

I see now how the 'ar' and 'ap' tables serve as header records for customer
invoices and vendor invoices, respectively. And that for both the detail
line item records go into the 'invoice' table.

I am unclear what the 'ordnumber' field is for in the 'ap' table, but
I assume that it is for the idetification of the Vendor's Invoice, i.e
the number the vendor put on it. After making this conclusion, it would
seem appropriate that there be a 'ordnumber' field in the 'ar' table
too, to be used for customer purchase order numbers if they have one.

Am I on the right track here? I hope so b/c I took the inititive and
created near-exact copies of the 'ar', 'ap' and 'invoice' tables to use
for customer orders and purchase orders. I figure they will work nearly
the same. So now I have an 'so' table for sales orders and a 'po' table
for purchase orders and an 'order' table for their line items.

Now I'm going to copy the ir.cgi and is.cgi scripts and change them to
match, making sure to remove any code that creates actual transactions.

So in proceeding is there anything I need to watch for?




__________________________________________________
FREE voicemail, email, and fax...all in one place.
Sign Up Now! http://www.onebox.com