V_FENXTINTEGRATION_MAPPEDDESIGNATION

Fields

Field	Field Type	Null	Description
PDACCOUNTSYSTEMID	uniqueidentifier
DESIGNATIONID	nvarchar(36)
SHORTDESCRIPTION	nvarchar(100)

Indexes

Index Name	Fields	Unique	Primary	Clustered
UIX_V_FENXTINTEGRATION_MAPPEDDESIGNATION_PDACCOUNTSYSTEMID_SHORTDESCRIPTION	PDACCOUNTSYSTEMID, SHORTDESCRIPTION	yes		yes

Definition

Copy


            create view V_FENXTINTEGRATION_MAPPEDDESIGNATION WITH SCHEMABINDING
                as
                select
                    PDACCOUNTSTRUCTURE.PDACCOUNTSYSTEMID,
                    PDACCOUNTSEGMENTMAPPING.LONGDESCRIPTIONID as DESIGNATIONID,
                    PDACCOUNTSEGMENTVALUE.SHORTDESCRIPTION
                from dbo.PDACCOUNTSTRUCTURE
                inner join dbo.PDACCOUNTSEGMENTVALUE
                    on PDACCOUNTSTRUCTURE.ID = PDACCOUNTSEGMENTVALUE.PDACCOUNTSTRUCTUREID
                inner join dbo.PDACCOUNTSEGMENTMAPPING
                    on PDACCOUNTSEGMENTVALUE.ID = PDACCOUNTSEGMENTMAPPING.PDACCOUNTSEGMENTVALUEID
                inner join dbo.DESIGNATIONALTLOOKUPID
                    on PDACCOUNTSEGMENTMAPPING.LONGDESCRIPTIONID = DESIGNATIONALTLOOKUPID.DESIGNATIONID
                inner join dbo.FENXTINTEGRATION
                    on PDACCOUNTSTRUCTURE.PDACCOUNTSYSTEMID = FENXTINTEGRATION.PDACCOUNTSYSTEMID
                where PDACCOUNTSTRUCTURE.ISPROJECTSEGMENT = 1
                    and PDACCOUNTSTRUCTURE.PDACCOUNTTABLESAVAILABLEFORSEGMENTID = '2B1E041E-8FA3-4301-A5DB-E6531E9C3CED'
                    and FENXTINTEGRATION.ENVIRONMENTID is not null;