Report query to extract AR Transactions along with Header Attachment information
Requirement is that to extract a report which shows all the AR Transaction details along with Attachment information.
Means if there is an attachment in AR Transaction it should either provide the Attachment name or 'Y' as value. If not it should give 'N'.
For this we are lookin for an SQL Query.
Expected report format
Business Unit | Transaction Source | Bill to Customer Name | Bill to Account Number | Transaction Number | Transaction Date | Transaction Total | Attachments |
|---|---|---|---|---|---|---|---|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Appreciate for your help.
Regards,
Hemanth B.T
0