USP_DATAFORMTEMPLATE_VIEW_RESERVATIONPRICINGSUMMARY

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@DATALOADED	bit	INOUT
@ORDERTOTAL	money	INOUT
@AMOUNTPAID	money	INOUT
@ORDERBALANCE	money	INOUT
@PRICINGCODE	tinyint	INOUT
@PRICING	nvarchar(max)	INOUT
@RATESCALENAME	nvarchar(100)	INOUT
@AMOUNTREFUNDED	money	INOUT
@ORDERSTATUSCODE	tinyint	INOUT
@ISRATESCALEAPPLIED	bit	INOUT
@OVERAGEKEPT	money	INOUT
@SUBTOTAL	money	INOUT
@TAXES	money	INOUT
@ISTAXEXEMPT	bit	INOUT

Definition

Copy


CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_RESERVATIONPRICINGSUMMARY
(
    @ID uniqueidentifier,
    @DATALOADED bit = 0 output,
    @ORDERTOTAL money = null output,
    @AMOUNTPAID money = null output,
    @ORDERBALANCE money = null output,
    @PRICINGCODE tinyint = null output,
    @PRICING nvarchar(max) = null output,
    @RATESCALENAME nvarchar(100) = null output,
    @AMOUNTREFUNDED money = null output,
    @ORDERSTATUSCODE tinyint = null output,
    @ISRATESCALEAPPLIED bit = null output,
    @OVERAGEKEPT money = null output,
    @SUBTOTAL money = null output,
    @TAXES money = null output,
    @ISTAXEXEMPT bit = null output
)
as
    set nocount on;

    set @DATALOADED = 0;

    select
        @DATALOADED = 1,
        @ORDERTOTAL = ORDERTOTALS.TOTAL,
        @AMOUNTPAID = ORDERTOTALS.AMOUNTTENDERED,
        @ORDERBALANCE = ORDERTOTALS.BALANCE,
        @PRICINGCODE = RESERVATION.PRICINGCODE,
        @PRICING = RESERVATION.PRICING,
        @RATESCALENAME = RATESCALE.NAME,
        @AMOUNTREFUNDED = ORDERTOTALS.REFUNDS,
        @ORDERSTATUSCODE = SALESORDER.STATUSCODE,
        @ISRATESCALEAPPLIED = dbo.UFN_RESERVATIONRATESCALE_ISAPPLIED(RESERVATION.ID),
        @OVERAGEKEPT = ORDERTOTALS.OVERAGEKEPT,
        @SUBTOTAL = ORDERTOTALS.SUBTOTAL,
        @TAXES = ORDERTOTALS.TAXES
    from
        dbo.RESERVATION
    inner join
        dbo.SALESORDER on SALESORDER.ID = RESERVATION.ID
    left outer join
        dbo.RESERVATIONRATESCALE on RESERVATIONRATESCALE.ID = RESERVATION.ID
    left outer join
        dbo.RATESCALE on RATESCALE.ID = RESERVATIONRATESCALE.RATESCALEID
    outer apply
        dbo.UFN_SALESORDER_TOTALS(RESERVATION.ID) as ORDERTOTALS
    where
        RESERVATION.ID = @ID;

    set @ISTAXEXEMPT = dbo.UFN_SALESORDER_ISTAXEXEMPT(@ID);

    return 0;