UFN_FINANCIALTRANSACTION_LINEITEM_GL_TOITEMLISTXML
Returns the distribution for a line item in a financialtransaction
Return
| Return Type |
|---|
| xml |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @FINANCIALTRANSACTIONLINEITEMID | uniqueidentifier | IN |
Definition
Copy
CREATE function dbo.UFN_FINANCIALTRANSACTION_LINEITEM_GL_TOITEMLISTXML(@FINANCIALTRANSACTIONLINEITEMID uniqueidentifier)
returns xml
with execute as caller
as begin
return (
select
CASE WHEN SUBLEDGERTYPECODE=TRANSACTIONTYPECODE THEN TRANSACTIONAMOUNT ELSE -TRANSACTIONAMOUNT END
,CASE WHEN SUBLEDGERTYPECODE=TRANSACTIONTYPECODE THEN BASEAMOUNT ELSE -BASEAMOUNT END
,CASE WHEN SUBLEDGERTYPECODE=TRANSACTIONTYPECODE THEN ORGAMOUNT ELSE -ORGAMOUNT END
,CLASSCODE
,COMMENT
,JOURNALCODEID
,ID as JOURNALENTRYID -- To maintain compat with the grid team's code.
,PERCENTAGE
,SEQUENCE
,POSTDATE
,SUBLEDGERTYPECODE as TRANSACTIONTYPECODE
,DATAELEMENT1ID
,DATAELEMENT2ID
,DATAELEMENT3ID
,DATAELEMENT4ID
,DATAELEMENT5ID
,DATAELEMENT6ID
,DATAELEMENT7ID
,DATAELEMENT8ID
,DATAELEMENT9ID
,DATAELEMENT10ID
,DATAELEMENT11ID
,DATAELEMENT12ID
,DATAELEMENT13ID
,DATAELEMENT14ID
,DATAELEMENT15ID
,DATAELEMENT16ID
,DATAELEMENT17ID
,DATAELEMENT18ID
,DATAELEMENT19ID
,DATAELEMENT20ID
,DATAELEMENT21ID
,DATAELEMENT22ID
,DATAELEMENT23ID
,DATAELEMENT24ID
,DATAELEMENT25ID
,DATAELEMENT26ID
,DATAELEMENT27ID
,DATAELEMENT28ID
,DATAELEMENT29ID
,DATAELEMENT30ID
,dbo.UFN_JOURNALENTRYANNOTATIONS_TOITEMLISTXML(ID, NULL, NULL)
from dbo.JOURNALENTRY
where FINANCIALTRANSACTIONLINEITEMID = @FINANCIALTRANSACTIONLINEITEMID
order by SEQUENCE
for xml raw('ITEM'),type,elements,root('GLENTRIES'),BINARY BASE64);
end