USP_DATALIST_PDACCOUNTCODEMAPDEVELOPMENTBENEFITS2
Returns a list of account code mappings for Benefits in the Development office.
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @PDACCOUNTSYSTEMID | uniqueidentifier | IN | Input parameter indicating the context ID for the data list. |
Definition
Copy
CREATE procedure dbo.USP_DATALIST_PDACCOUNTCODEMAPDEVELOPMENTBENEFITS2
(
@PDACCOUNTSYSTEMID uniqueidentifier
)
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 = @PDACCOUNTSYSTEMID