UFN_BATCHJOURNALENTRIES_TOITEMLISTXML
Returns the XML representation of batch journal entries.
Return
| Return Type |
|---|
| xml |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @FINANCIALTRANSACTIONLINEITEMID | uniqueidentifier | IN | |
| @RETURNALLELEMENTS | bit | IN |
Definition
Copy
CREATE function [dbo].[UFN_BATCHJOURNALENTRIES_TOITEMLISTXML]
(
@FINANCIALTRANSACTIONLINEITEMID uniqueidentifier,
@RETURNALLELEMENTS bit
)
returns xml as
begin
return
(
select
case TRANSACTIONTYPECODE when 0 then [AMOUNT] else NULL end [DEBITAMOUNT],
case TRANSACTIONTYPECODE when 1 then [AMOUNT] else NULL end [CREDITAMOUNT],
[CLASSCODE],
[COMMENT],
[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],
[ANNOTATIONS].query('/ANNOTATIONS/ITEM') [ANNOTATIONS],
[JOURNALCODEID],
[JOURNALENTRYID],
[PERCENTAGE],
[SEQUENCE],
[POSTDATE]
from
dbo.[UFN_BATCHJOURNALENTRIES](@FINANCIALTRANSACTIONLINEITEMID, @RETURNALLELEMENTS)
order by SEQUENCE
for xml raw('ITEM'),type,elements,root('BATCHJOURNALENTRIES'), binary base64
)
end