USP_REPORT_DEFAULTITEMIZEDRECEIPT_GETORDERINFORMATION

create procedure [dbo].[USP_REPORT_DEFAULTITEMIZEDRECEIPT_GETORDERINFORMATION]
(
    @ORDERID uniqueidentifier
)
as
    set nocount on;
    set transaction isolation level read uncommitted;

    select
        TOTALS.TOTAL as ORDERTOTAL,
        TOTALS.AMOUNTTENDERED as AMOUNTPAID,
        TOTALS.CHANGEDUE,
        cast(dbo.UFN_TIMEZONEENTRY_GETSYSTEMDEFAULTDATEFROMUTC(getutcdate()) as nvarchar) as TIMEOFPURCHASE,
        SALESORDER.SEQUENCEID as ORDERNUMBER
    from
        dbo.SALESORDER
    outer apply
        dbo.UFN_SALESORDER_TOTALS(SALESORDER.ID) as TOTALS
    where
        SALESORDER.ID = @ORDERID;

    return 0;