UFN_SALESORDER_GETPAYMENTS_FROMXML

        CREATE function dbo.UFN_SALESORDER_GETPAYMENTS_FROMXML(@PAYMENTS 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('(AMOUNT)[1]','money') AS 'AMOUNT',
            T.c.value('(CHECKDATE)[1]','nvarchar(8)') AS 'CHECKDATE',
            T.c.value('(CHECKNUMBER)[1]','nvarchar(20)') AS 'CHECKNUMBER',
            T.c.value('(CARDHOLDERNAME)[1]','nvarchar(255)') AS 'CARDHOLDERNAME',
            T.c.value('(CREDITCARDNUMBER)[1]','nvarchar(8)') AS 'CREDITCARDNUMBER',
            T.c.value('(CREDITTYPECODEID)[1]','uniqueidentifier') AS 'CREDITTYPECODEID',
            T.c.value('(AUTHORIZATIONCODE)[1]','nvarchar(20)') AS 'AUTHORIZATIONCODE',
            T.c.value('(EXPIRESON)[1]','nvarchar(8)') AS 'EXPIRESON',
            T.c.value('(OTHERPAYMENTMETHODCODEID)[1]','uniqueidentifier') AS 'OTHERPAYMENTMETHODCODEID'            
            from @PAYMENTS.nodes('/PAYMENTS/ITEM') T(c)
            )