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