Vendors

Vendors

Submitted by Nathan Clouse on 09/19/15.

Simple view with common vendor related info plus the vendor Party Id.

AX Version: 

Module: 

CREATE VIEW [dbo].[vw_vendVendTable] 
AS 
  SELECT vend.*, 
         dirPar.NAME 
  FROM   vendtable AS vend 
         JOIN dirpartytable AS dirPar 
           ON dirPar.recid = vend.party 

go