USP_DATALIST_PDACCOUNTCODEMAPTREASURYADJUSTMENT
Returns a list of account code mappings for Adjustments in the Business office.
Definition
Copy
CREATE procedure dbo.USP_DATALIST_PDACCOUNTCODEMAPTREASURYADJUSTMENT
as
set nocount on;
select ID,
dbo.UFN_PDACCOUNTCODEMAPPAYMENTMETHODTYPE_TYPENAMESTRING ('0074260A-6756-44C2-8570-D44778956B1D', PAYMENTMETHOD) PAYMENTMETHOD,
dbo.UFN_GLACCOUNT_GETACCOUNTNUMBER(CREDITGLACCOUNTID) CREDITACCOUNT,
(select SHORTDESCRIPTION from PDACCOUNTSEGMENTVALUE where ID = CREDITPDACCOUNTSEGMENTVALUEID) CREDITCODE
from dbo.PDACCOUNTCODEMAPPING
where PDACCOUNTCODEMAPOFFICEID = '0074260A-6756-44C2-8570-D44778956B1D' and PDACCOUNTSYSTEMID = '4B121C2C-CCE6-440D-894C-EA0DEF80D50B'