USP_DATALIST_PDACCOUNTCODEMAPDEVELOPMENTPAYMENT2
Returns a list of account code mappings for Payments in the Development office.
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @ID | uniqueidentifier | IN | Input parameter indicating the context ID for the data list. |
| @APPLICATIONTYPEID | uniqueidentifier | IN | Application type |
| @PAYMENTMETHODID | uniqueidentifier | IN | Payment method |
Definition
Copy
CREATE procedure dbo.USP_DATALIST_PDACCOUNTCODEMAPDEVELOPMENTPAYMENT2
(
@ID uniqueidentifier,
@APPLICATIONTYPEID uniqueidentifier = null,
@PAYMENTMETHODID uniqueidentifier = null
)
as
set nocount on;
select PDACCOUNTCODEMAPPING.ID,
dbo.UFN_PDACCOUNTCODEMAPREVENUETYPE_TYPENAMESTRING ('1A692E94-3214-44B8-A658-F2927230BC25', REVENUETYPE) REVENUETYPE,
dbo.UFN_PDACCOUNTCODEMAPAPPLICATIONTYPE_TYPENAMESTRING ('1A692E94-3214-44B8-A658-F2927230BC25', APPLICATIONTYPE) APPLICATIONTYPE,
dbo.UFN_PDACCOUNTCODEMAPPAYMENTMETHODTYPE_TYPENAMESTRING ('1A692E94-3214-44B8-A658-F2927230BC25', PAYMENTMETHOD) PAYMENTMETHOD,
dbo.UFN_GLACCOUNT_GETACCOUNTNUMBER(DEBITGLACCOUNTID) DEBITACCOUNT,
DEBITVALUE.SHORTDESCRIPTION as DEBITCODE,
dbo.UFN_GLACCOUNT_GETACCOUNTNUMBER(CREDITGLACCOUNTID) CREDITACCOUNT,
CREDITVALUE.SHORTDESCRIPTION as CREDITCODE
from dbo.PDACCOUNTCODEMAPPING
left join dbo.PDACCOUNTSEGMENTVALUE DEBITVALUE on DEBITPDACCOUNTSEGMENTVALUEID = DEBITVALUE.ID
left join dbo.PDACCOUNTSEGMENTVALUE CREDITVALUE on CREDITPDACCOUNTSEGMENTVALUEID = CREDITVALUE.ID
where PDACCOUNTCODEMAPOFFICEID = '1A692E94-3214-44B8-A658-F2927230BC25'
and PDACCOUNTCODEMAPPING.PDACCOUNTSYSTEMID = @ID
and (@APPLICATIONTYPEID is null or (@APPLICATIONTYPEID in (select ID from dbo.PDACCOUNTCODEMAPAPPLICATIONTYPE a where (a.NAMEID & APPLICATIONTYPE) > 0)))
and (@PAYMENTMETHODID is null or (@PAYMENTMETHODID in (select ID from dbo.PDACCOUNTCODEMAPPAYMENTMETHODTYPE p where (p.nameid & PAYMENTMETHOD) > 0)))