USP_FENXT_BALANCEACCOUNTS

CREATE procedure dbo.USP_FENXT_BALANCEACCOUNTS
(
@PDACCOUNTSYSTEMID uniqueidentifier
)
    as
    set nocount on;

    select
        ACCOUNTNUMBER,
        CATEGORY
    from dbo.FENXTACCOUNT
    where CATEGORY in ('Revenue','Expense','Transfer','Gift')
    and PDACCOUNTSYSTEMID = @PDACCOUNTSYSTEMID
    order by ACCOUNTNUMBER;