I would like to see the ISA Control # for every 832 document that I have sent to a certain partner. I can use Trading Networks to search for that document and that vendor, but to get all the data that I want, I have to double click each row, view the “Content” tab and then manually extract the data.
Is there a faster way of doing this?
I have looked at the tables and tried to use SQL queries, but the “Content” in the BizDoc table is encrypted (I think…it just shows up as 0x17183…). What table has the decrypted Content that I see when using TN Console? (I figure I can use SQL to trim the Content to the first X chars and then use Regular expressions to remove everything but the control #)