UFN_BATCHJOURNALENTRIES_FROMITEMLISTXML

CREATE FUNCTION [dbo].[UFN_BATCHJOURNALENTRIES_FROMITEMLISTXML](@ITEMLISTXML xml) RETURNS TABLE AS
RETURN (
SELECT

T.c.value('(DEBITAMOUNT)[1]','money') AS 'DEBITAMOUNT',
T.c.value('(CREDITAMOUNT)[1]','money') AS 'CREDITAMOUNT',
T.c.value('(CLASSCODE)[1]','tinyint') AS 'CLASSCODE',
T.c.value('(COMMENT)[1]','nvarchar(60)') AS 'COMMENT',
T.c.value('(DATAELEMENT1ID)[1]','uniqueidentifier') AS 'DATAELEMENT1ID',
T.c.value('(DATAELEMENT2ID)[1]','uniqueidentifier') AS 'DATAELEMENT2ID',
T.c.value('(DATAELEMENT3ID)[1]','uniqueidentifier') AS 'DATAELEMENT3ID',
T.c.value('(DATAELEMENT4ID)[1]','uniqueidentifier') AS 'DATAELEMENT4ID',
T.c.value('(DATAELEMENT5ID)[1]','uniqueidentifier') AS 'DATAELEMENT5ID',
T.c.value('(DATAELEMENT6ID)[1]','uniqueidentifier') AS 'DATAELEMENT6ID',
T.c.value('(DATAELEMENT7ID)[1]','uniqueidentifier') AS 'DATAELEMENT7ID',
T.c.value('(DATAELEMENT8ID)[1]','uniqueidentifier') AS 'DATAELEMENT8ID',
T.c.value('(DATAELEMENT9ID)[1]','uniqueidentifier') AS 'DATAELEMENT9ID',
T.c.value('(DATAELEMENT10ID)[1]','uniqueidentifier') AS 'DATAELEMENT10ID',
T.c.value('(DATAELEMENT11ID)[1]','uniqueidentifier') AS 'DATAELEMENT11ID',
T.c.value('(DATAELEMENT12ID)[1]','uniqueidentifier') AS 'DATAELEMENT12ID',
T.c.value('(DATAELEMENT13ID)[1]','uniqueidentifier') AS 'DATAELEMENT13ID',
T.c.value('(DATAELEMENT14ID)[1]','uniqueidentifier') AS 'DATAELEMENT14ID',
T.c.value('(DATAELEMENT15ID)[1]','uniqueidentifier') AS 'DATAELEMENT15ID',
T.c.value('(DATAELEMENT16ID)[1]','uniqueidentifier') AS 'DATAELEMENT16ID',
T.c.value('(DATAELEMENT17ID)[1]','uniqueidentifier') AS 'DATAELEMENT17ID',
T.c.value('(DATAELEMENT18ID)[1]','uniqueidentifier') AS 'DATAELEMENT18ID',
T.c.value('(DATAELEMENT19ID)[1]','uniqueidentifier') AS 'DATAELEMENT19ID',
T.c.value('(DATAELEMENT20ID)[1]','uniqueidentifier') AS 'DATAELEMENT20ID',
T.c.value('(DATAELEMENT21ID)[1]','uniqueidentifier') AS 'DATAELEMENT21ID',
T.c.value('(DATAELEMENT22ID)[1]','uniqueidentifier') AS 'DATAELEMENT22ID',
T.c.value('(DATAELEMENT23ID)[1]','uniqueidentifier') AS 'DATAELEMENT23ID',
T.c.value('(DATAELEMENT24ID)[1]','uniqueidentifier') AS 'DATAELEMENT24ID',
T.c.value('(DATAELEMENT25ID)[1]','uniqueidentifier') AS 'DATAELEMENT25ID',
T.c.value('(DATAELEMENT26ID)[1]','uniqueidentifier') AS 'DATAELEMENT26ID',
T.c.value('(DATAELEMENT27ID)[1]','uniqueidentifier') AS 'DATAELEMENT27ID',
T.c.value('(DATAELEMENT28ID)[1]','uniqueidentifier') AS 'DATAELEMENT28ID',
T.c.value('(DATAELEMENT29ID)[1]','uniqueidentifier') AS 'DATAELEMENT29ID',
T.c.value('(DATAELEMENT30ID)[1]','uniqueidentifier') AS 'DATAELEMENT30ID',                        
case when T.c.exist('./ANNOTATIONS/ITEM') = 1 then T.c.query('(ANNOTATIONS)[1]') else null end AS 'ANNOTATIONS',
T.c.value('(JOURNALCODEID)[1]','uniqueidentifier') AS 'JOURNALCODEID',
T.c.value('(JOURNALENTRYID)[1]','uniqueidentifier') AS 'JOURNALENTRYID',
T.c.value('(PERCENTAGE)[1]','numeric(20, 4)') AS 'PERCENTAGE',
T.c.value('(SEQUENCE)[1]','int') AS 'SEQUENCE',
T.c.value('(POSTDATE)[1]','date') AS 'POSTDATE'
FROM @ITEMLISTXML.nodes('/BATCHJOURNALENTRIES/ITEM') T(c)
)