USP_UPDATEUNMAPPEDTRANSACTIONS_GETTRANSACTIONSTOPROCESS
Retrieve all the records for a specific update unmapped transactions process.
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @ID | uniqueidentifier | IN |
Definition
Copy
CREATE procedure dbo.USP_UPDATEUNMAPPEDTRANSACTIONS_GETTRANSACTIONSTOPROCESS
(
@ID uniqueidentifier = null
)
as begin
select ME.TRANSACTIONID
,ME.TRANSACTIONTYPECODE
from dbo.GLACCOUNTMAPPINGERROR ME
where ME.GLACCOUNTMAPPINGERRORUPDATEPROCESSID = @ID and ME.DELETED = 0
group by ME.TRANSACTIONID, ME.TRANSACTIONTYPECODE
order by ME.TRANSACTIONTYPECODE asc
end