USP_DATAFORMTEMPLATE_EDITLOAD_RESERVATIONDUEDATES

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@DATALOADED	bit	INOUT
@TSLONG	bigint	INOUT
@DEPOSITREQUIRED	bit	INOUT
@DEPOSITAMOUNT	money	INOUT
@DEPOSITDUEDATE	date	INOUT
@SECURITYDEPOSITREQUIRED	bit	INOUT
@SECURITYDEPOSITAMOUNT	money	INOUT
@SECURITYDEPOSITDUEDATE	date	INOUT
@CONTRACTREQUIRED	bit	INOUT
@CONTRACTDUEDATE	date	INOUT
@FINALCOUNTREQUIRED	bit	INOUT
@FINALCOUNTDUEDATE	date	INOUT
@FINALDUEDATE	date	INOUT
@ORDERTOTAL	money	INOUT
@DEFAULTDEPOSITTYPECODE	tinyint	INOUT
@DEFAULTDEPOSITAMOUNT	money	INOUT
@DEFAULTDEPOSITPERCENT	decimal(5, 2)	INOUT
@DEFAULTSECURITYDEPOSITTYPECODE	tinyint	INOUT
@DEFAULTSECURITYDEPOSITAMOUNT	money	INOUT
@DEFAULTSECURITYDEPOSITPERCENT	decimal(5, 2)	INOUT

Definition

Copy


CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDITLOAD_RESERVATIONDUEDATES (
    @ID uniqueidentifier,
    @DATALOADED bit = 0 output,
    @TSLONG bigint = 0 output,
    @DEPOSITREQUIRED bit = null output,
    @DEPOSITAMOUNT money = null output,
    @DEPOSITDUEDATE date = null output,
    @SECURITYDEPOSITREQUIRED bit = null output,
    @SECURITYDEPOSITAMOUNT money = null output,
    @SECURITYDEPOSITDUEDATE date = null output,
    @CONTRACTREQUIRED bit = null output,
    @CONTRACTDUEDATE date = null output,
    @FINALCOUNTREQUIRED bit = null output,
    @FINALCOUNTDUEDATE date = null output,
    @FINALDUEDATE date = null output,
    @ORDERTOTAL money = null output,
    @DEFAULTDEPOSITTYPECODE tinyint = null output,
    @DEFAULTDEPOSITAMOUNT money = null output,
    @DEFAULTDEPOSITPERCENT decimal(5,2) = null output,
    @DEFAULTSECURITYDEPOSITTYPECODE tinyint = null output,
    @DEFAULTSECURITYDEPOSITAMOUNT money = null output,
    @DEFAULTSECURITYDEPOSITPERCENT decimal(5,2) = null output
)
as
    set nocount on;

    set @DATALOADED = 0;
    set @TSLONG = 0;

    select
        @DATALOADED = 1,
        @TSLONG = RESERVATION.TSLONG,
        @DEPOSITREQUIRED = RESERVATION.DEPOSITREQUIRED,
        @DEPOSITAMOUNT = RESERVATION.DEPOSITAMOUNT,
        @DEPOSITDUEDATE = RESERVATION.DEPOSITDUEDATE,
        @SECURITYDEPOSITREQUIRED = RESERVATION.SECURITYDEPOSITREQUIRED,
        @SECURITYDEPOSITAMOUNT = RESERVATION.SECURITYDEPOSITAMOUNT,
        @SECURITYDEPOSITDUEDATE = RESERVATION.SECURITYDEPOSITDUEDATE,
        @CONTRACTREQUIRED = RESERVATION.CONTRACTREQUIRED,
        @CONTRACTDUEDATE = RESERVATION.CONTRACTDUEDATE,
        @FINALCOUNTREQUIRED = RESERVATION.FINALCOUNTREQUIRED,
        @FINALCOUNTDUEDATE = RESERVATION.FINALCOUNTDUEDATE,
        @FINALDUEDATE = RESERVATION.FINALDUEDATE,
        @ORDERTOTAL = TOTALS.TOTAL
    from
        dbo.RESERVATION
    outer apply
        dbo.UFN_SALESORDER_TOTALS(RESERVATION.ID) as TOTALS
    where
        RESERVATION.ID = @ID;

    select top 1
        @DEFAULTDEPOSITTYPECODE = DEPOSITTYPECODE,
        @DEFAULTDEPOSITAMOUNT = DEPOSITAMOUNT,
        @DEFAULTDEPOSITPERCENT = DEPOSITPERCENT,
        @DEFAULTSECURITYDEPOSITTYPECODE = SECURITYDEPOSITTYPECODE,
        @DEFAULTSECURITYDEPOSITAMOUNT = SECURITYDEPOSITAMOUNT,
        @DEFAULTSECURITYDEPOSITPERCENT = SECURITYDEPOSITPERCENT
    from
        dbo.GROUPSALESDEFAULT;

    return 0;