UFN_SALESDEPOSITPROCESS_TEMPLATE_FROMITEMLISTXML

CREATE function dbo.UFN_SALESDEPOSITPROCESS_TEMPLATE_FROMITEMLISTXML
(
  @ITEMLISTXML xml
)
RETURNS TABLE AS
RETURN (
    select
        T.c.value('(ID)[1]', 'uniqueidentifier') as 'ID',
        T.c.value('(INCLUDEINPROCESS)[1]', 'bit') as 'INCLUDEINPROCESS',
        T.c.value('(NAME)[1]', 'nvarchar(100)') as 'NAME',
        T.c.value('(BANKACCOUNTID)[1]', 'uniqueidentifier') as 'BANKACCOUNTID',
    T.c.value('(SALESCHANNELOPTIONCODE)[1]', 'tinyint') as 'SALESCHANNELOPTIONCODE',
    T.c.value('(PAYMENTMETHODOPTIONCODE)[1]', 'tinyint') as 'PAYMENTMETHODOPTIONCODE',
    T.c.value('(CURRENCYOPTIONCODE)[1]', 'tinyint') as 'CURRENCYOPTIONCODE'
    from @ITEMLISTXML.nodes('/TEMPLATES/ITEM') T(c)
)