I need to pull in the vendor number field for AP invoices and AP checks (manual included) to a the GL_DetailPosting table. We need to know by a posting date range, which vendor number a posting to the GL account is for. I cannot find a linking in the AP_CheckHistoryHeader, AP_CheckHistoryDetail, or AP_TransactionPaymentHistory tables. The only fields I see that are close are the AP_CheckHistoryHeader. It has fields SourceJournal and SourceJournalBatchNo. I need the register number instead of batch number since multiple vendors are in one batch. Does anyone have any luck with linking this information back to the GL?

Thanks!