UFN_SALESDEPOSITTEMPLATE_PAYMENTMETHODS_FROMITEMLISTXML

create function dbo.UFN_SALESDEPOSITTEMPLATE_PAYMENTMETHODS_FROMITEMLISTXML(
    @ITEMLISTXML xml
)
RETURNS TABLE AS
RETURN (
    select
        T.c.value('(ID)[1]', 'uniqueidentifier') as 'ID',
        T.c.value('(PAYMENTMETHODCODE)[1]', 'tinyint') as 'PAYMENTMETHODCODE',
        T.c.value('(CREDITTYPECODEID)[1]', 'uniqueidentifier') as 'CREDITTYPECODEID',
        T.c.value('(OTHERPAYMENTMETHODCODEID)[1]', 'uniqueidentifier') as 'OTHERPAYMENTMETHODCODEID',
        T.c.value('(INCLUDE)[1]', 'bit') as 'INCLUDE'
    from @ITEMLISTXML.nodes('/PAYMENTTYPE/ITEM') T(c)
)