Overview
This article provides the AQB (Advanced Query Builder) query that can be used to pull up SalesRep information in the Customer Contact Address' Custom Fields.
Information
The following query can be used to create a custom report in the Advanced Query Builder showing all SalesRep information in the Customer Contact Address' Custom Fields:
SELECT
ADDRESS.Active,
ADDRESS.ADDR_CODE,
ADDRESS.CUST_CODE,
ADDRESS.ACCT_NAME,
ADDRESS.CUSTCHAR1
FROM
[DB Schema Name].[ADDRESS] (NOLOCK)
WHERE
TYPE = 6
Refer to Building a Custom Report using Advanced Query Builder SQL Statements for more information on how to use the AQB to execute the above query.
Comments
0 comments
Please sign in to leave a comment.