Linking Attached Documents Back To Customers
Hello:
Our A/R department attaches notes to new customers using the document attachment feature. We only use long text.
I have a query that shows all the long text documents attached to A/R Customers shown below.
It shows the notes the A/R specialist enters for a customer.
However, I need to know the customer number for the note.
How can I link the note to a specific customer number?
Here's the query that produces the data sample shown below:
select fad.pk1_value -- cust_account_id
,fad.seq_num
,fad.category_id
,fad.document_id
,fd.datatype_id