USP_DATALIST_PDACCOUNTCODEMAPTREASURYPAYMENT2
Returns a list of account code mappings for Payments in the Business office.
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @CONTEXTID | uniqueidentifier | IN | Input parameter indicating the context ID for the data list. |
Definition
Copy
CREATE procedure dbo.USP_DATALIST_PDACCOUNTCODEMAPTREASURYPAYMENT2(@CONTEXTID uniqueidentifier)
as
set nocount on;
select ID,
dbo.UFN_PDACCOUNTCODEMAPPAYMENTMETHODTYPE_TYPENAMESTRING ('CE11F6CF-AE6F-4263-84C4-D268C938FCEB', PAYMENTMETHOD) PAYMENTMETHOD,
dbo.UFN_PDACCOUNTCODEMAPCREDITCARDSUBTYPE_TYPENAMESTRING (ID) CREDITCARDSUBTYPE,
dbo.UFN_PDACCOUNTCODEMAPOTHERSUBTYPE_TYPENAMESTRING(ID) OTHERSUBTYPE,
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 = 'CE11F6CF-AE6F-4263-84C4-D268C938FCEB'
and PDACCOUNTSYSTEMID = @CONTEXTID