Customers With Party ID

Customers With Party ID

Submitted by Nathan Clouse on 09/01/15.

Simple view for customers that includes the customer's party ID

AX Version: 

Module: 

CREATE VIEW [dbo].[vw_custCustTable] 
AS 
  SELECT Cust.*, 
         dirPar.NAME 
  FROM   custtable AS Cust 
         JOIN dirpartytable AS dirPar 
           ON dirPar.recid = Cust.party 

go