USP_DATALIST_PDACCOUNTCODEMAPTREASURYDEPOSITCORRECTIONS

Returns a list of account code mappings for Deposit Corrections in the Business office.

Definition

Copy 


CREATE procedure dbo.USP_DATALIST_PDACCOUNTCODEMAPTREASURYDEPOSITCORRECTIONS
as
    set nocount on;

    select  ID,
    dbo.UFN_PDACCOUNTCODEMAPPAYMENTMETHODTYPE_TYPENAMESTRING ('A6C4E35B-43F9-49ae-AD5C-A0907D010973', PAYMENTMETHOD) PAYMENTMETHOD,
    dbo.UFN_PDACCOUNTCODEMAPREVENUETYPE_TYPENAMESTRING ('A6C4E35B-43F9-49ae-AD5C-A0907D010973', REVENUETYPE) REVENUETYPE,
    dbo.UFN_GLACCOUNT_GETACCOUNTNUMBER(CREDITGLACCOUNTID) CREDITACCOUNT,
(select SHORTDESCRIPTION from PDACCOUNTSEGMENTVALUE where ID = CREDITPDACCOUNTSEGMENTVALUEID)  CREDITCODE

    from dbo.PDACCOUNTCODEMAPPING
    where PDACCOUNTCODEMAPOFFICEID = 'A6C4E35B-43F9-49ae-AD5C-A0907D010973' and PDACCOUNTSYSTEMID = '4B121C2C-CCE6-440D-894C-EA0DEF80D50B'