Susan:

If the AP Transaction table doesn't contain what you are looking for then try the AP Invoice Posting Journal (assumes you are following best practises and not purging your posting journals). Unfortunately at best the Invoice POsting Journal will only contain the current fiscal years data.