UFN_BENEFIT_GETGLDISTRIBUTION_TOITEMLISTXML

Gets the distributions for Benefit.

Return

Return Type
xml

Parameters

Parameter	Parameter Type	Mode	Description
@REVENUEID	uniqueidentifier	IN

Definition

Copy



CREATE function dbo.UFN_BENEFIT_GETGLDISTRIBUTION_TOITEMLISTXML
(
    @REVENUEID uniqueidentifier
)
returns xml
as
begin

return (
    select 
        [ACCOUNT], 
        [AMOUNT], 
        [DEBITCREDIT], 
        [GLPAYMENTMETHODREVENUETYPEMAPPINGID], 
        [ID], 
        [PROJECT], 
        [REFERENCE], 
        [TRANSACTIONTYPECODE],
        [ORGANIZATIONAMOUNT], 
        [BASECURRENCYID], 
        [TRANSACTIONAMOUNT], 
        [TRANSACTIONCURRENCYID], 
        [BASEEXCHANGERATEID], 
        [ORGANIZATIONEXCHANGERATEID],
        [REVENUEBENEFITID]
    from 
        dbo.[UFN_BENEFIT_GETGLDISTRIBUTION](@REVENUEID)
    for xml raw('ITEM'),type,elements,root('GLDISTRIBUTION'),BINARY BASE64

)

end