Internal and External Organizations

Internal and External Organizations

Submitted by Nathan Clouse on 09/28/15.

A simple view recreation of the table dirOrganizationBase in the AOT. 

AX Version: 

Module: 

CREATE VIEW [dbo].[vw_sysDirOrganizationBase] 
AS 
  SELECT * 
  FROM   dirpartytable 
  WHERE  instancerelationtype = 6886 

go