vendtrans.documentnum is blank for all transactions in the contoso test database. Could I use it to record my own data or is it sometimes used by the system, just not in the contoso database?

The reason I want to use it is so I can pass data through the AIF XML import file which I can subsequently retreive from within vendtrans.


The value in ‘DocumentNum’ field in ‘LedgerJournalTrans’ table gets copied to ‘DocumentNum’ field in ‘VendTrans’ table.

If this field in ‘LedgerJournalTrans’ table is not used in your implementation, you should be able to use this field in VendTrans table for your purpose.

But it is not clear how you are planning to use this field with AIF. Can you please elaborate?

Great! Thanks