UFN_PDACCOUNTSYSTEM_SITES

Returns the sites associated with an Accounting system.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@PDACCOUNTSYSTEMID	uniqueidentifier	IN

Definition

Copy



        CREATE function dbo.UFN_PDACCOUNTSYSTEM_SITES(@PDACCOUNTSYSTEMID uniqueidentifier)
            returns table
            as return
            select T1.ID, T1.SITEID
            from PDACCOUNTSYSTEMSITE T1
            where T1.PDACCOUNTSYSTEMID = @PDACCOUNTSYSTEMID