Sage 200 Database ID: Looking for the datapoint that drives the indication that a supplier transaction has an attachment uploaded.

Question

Hi, City Crew. 
 Hoping someone might be able to shed some light on the Sage 200 database. Specifically, I am trying to find the table/Column (should be binary) that drives the Supplier Transaction indicator (paperclip icon) on whether or not a transaction has an attachment against it. Any and all help is greatly appreciated. 
 Wm

Geoff Turner · Accepted Answer

To expand on Toby's reply, there isn't a Yes/No column, but for each purchase transaction there may be record(s) in SYSDocCapture (link PLPostedSupplierTranID to DocPrimaryID) 
 Is this for SQL or Report Designer?

Sage 200 UKI

Sage 200 Database ID: Looking for the datapoint that drives the indication that a supplier transaction has an attachment uploaded.

Top Replies

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING