UFN_BANKACCOUNTTRANSACTION_GETGLDISTRIBUTION_TOITEMLISTXML
Returns an XML with a list of a bank account transaction's GL distribution
Return
| Return Type |
|---|
| xml |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @BANKACCOUNTTRANSACTIONID | uniqueidentifier | IN |
Definition
Copy
create function dbo.UFN_BANKACCOUNTTRANSACTION_GETGLDISTRIBUTION_TOITEMLISTXML
(
@BANKACCOUNTTRANSACTIONID uniqueidentifier
)
returns xml
as begin
return (
select [GLACCOUNTID], [AMOUNT], [DEBITCREDIT], [ID], [PROJECT], [REFERENCE], [TRANSACTIONTYPECODE]
from dbo.UFN_BANKACCOUNTTRANSACTION_GETGLDISTRIBUTION(@BANKACCOUNTTRANSACTIONID)
for xml raw('ITEM'),type,elements,root('GLDISTRIBUTION'),BINARY BASE64
)
end