USP_DATALIST_PDACCOUNTCODEMAPFIXEDASSETS

Returns a list of account code mappings for the Fixed Assets office.

Definition

Copy 


CREATE procedure dbo.USP_DATALIST_PDACCOUNTCODEMAPFIXEDASSETS
as
    set nocount on;

    select  ID,
    dbo.UFN_PDACCOUNTCODEMAPPAYMENTMETHODTYPE_TYPENAMESTRING ('7FDFF48B-4A32-439F-805A-8981AF064A6E', PAYMENTMETHOD) PAYMENTMETHOD,
    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 = '7FDFF48B-4A32-439F-805A-8981AF064A6E' and PDACCOUNTSYSTEMID = '4B121C2C-CCE6-440D-894C-EA0DEF80D50B'