[SQL-Ledger-users] More Examination of database tables

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

Some difficulties:

What is the 'allocated' field used for in the invoice table? Where is
it used --in what scripts?

Also how can I tell by looking at an invoice record which header record
goes to it --the trans_id matches the id of the 'ar' or 'ap' record,
but how can you determine which of the two table it relates too?

-- 
Thomas Sawyer
ps...@on... - email
(303) 285-3487 x1594 - voicemail/fax



---- "Thomas Sawyer" <ps...@on...> wrote:
> 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
> 
> 
> 

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