USP_DATALIST_PDACCOUNTCODEMAPDEVELOPMENTBENEFITS

Returns a list of account code mappings for Benefits in the Development office.

Definition

Copy 


CREATE procedure dbo.USP_DATALIST_PDACCOUNTCODEMAPDEVELOPMENTBENEFITS
as
    set nocount on;

    select  ID,
  dbo.UFN_PDACCOUNTCODEMAPREVENUETYPE_TYPENAMESTRING ('31E50EE1-4029-40E4-999D-499375B2AB99', REVENUETYPE) REVENUETYPE,
  dbo.UFN_PDACCOUNTCODEMAPBENEFITSUBTYPE_TYPENAMESTRING (ID) SUBTYPE,
  dbo.UFN_GLACCOUNT_GETACCOUNTNUMBER(DEBITGLACCOUNTID) DEBITACCOUNT,
    (select SHORTDESCRIPTION from PDACCOUNTSEGMENTVALUE where ID = DEBITPDACCOUNTSEGMENTVALUEID) DEBITCODE,
  dbo.UFN_GLACCOUNT_GETACCOUNTNUMBER(CREDITGLACCOUNTID) CREDITACCOUNT,
    (select SHORTDESCRIPTION from PDACCOUNTSEGMENTVALUE where ID = CREDITPDACCOUNTSEGMENTVALUEID) CREDITCODE

    from dbo.PDACCOUNTCODEMAPPING
    where PDACCOUNTCODEMAPOFFICEID = '31E50EE1-4029-40E4-999D-499375B2AB99' and PDACCOUNTSYSTEMID = '4B121C2C-CCE6-440D-894C-EA0DEF80D50B'