USP_DATAFORMTEMPLATE_ADD_DISCOUNTBYSIZE_PRELOAD

The load procedure used by the edit dataform template "Discount By Group Size Add Data Form"

Parameters

Parameter	Parameter Type	Mode	Description
@WALKUPID	uniqueidentifier	INOUT	Walk Up Sales ID
@WALKUPACTIVE	bit	INOUT	Walk Up Sales Active
@WALKUPDESCRIPTION	nvarchar(50)	INOUT	Walk Up Description
@ADVANCEDID	uniqueidentifier	INOUT	Advanced Sales ID
@ADVANCEDACTIVE	bit	INOUT	Advanced Sales Active
@ADVANCEDDESCRIPTION	nvarchar(50)	INOUT	Advanced Description
@ONLINEID	uniqueidentifier	INOUT	Online Sales ID
@ONLINEACTIVE	bit	INOUT	Online Sales Active
@ONLINEDESCRIPTION	nvarchar(50)	INOUT	Online Description
@GROUPSALESID	uniqueidentifier	INOUT
@GROUPSALESACTIVE	bit	INOUT
@GROUPSALESDESCRIPTION	nvarchar(50)	INOUT

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_DISCOUNTBYSIZE_PRELOAD
(
    @WALKUPID uniqueidentifier = null output,
    @WALKUPACTIVE bit = null output,
    @WALKUPDESCRIPTION nvarchar(50) = null output,
    @ADVANCEDID uniqueidentifier = null output,
    @ADVANCEDACTIVE bit = null output,
    @ADVANCEDDESCRIPTION nvarchar(50) = null output,
    @ONLINEID uniqueidentifier = null output,
    @ONLINEACTIVE bit = null output,
    @ONLINEDESCRIPTION nvarchar(50) = null output,
    @GROUPSALESID uniqueidentifier = null output,
    @GROUPSALESACTIVE bit = null output,
    @GROUPSALESDESCRIPTION nvarchar(50) = null output
)
as
    select @WALKUPID = ID, @WALKUPACTIVE = ISACTIVE, @WALKUPDESCRIPTION = [TYPE] from dbo.SALESMETHOD where TYPECODE = 0;
    select @ADVANCEDID = ID, @ADVANCEDACTIVE = ISACTIVE, @ADVANCEDDESCRIPTION = [TYPE] from dbo.SALESMETHOD where TYPECODE = 1;
    select @ONLINEID = ID, @ONLINEACTIVE = ISACTIVE, @ONLINEDESCRIPTION = [TYPE] from dbo.SALESMETHOD where TYPECODE = 2;
    select @GROUPSALESID = ID, @GROUPSALESACTIVE = ISACTIVE, @GROUPSALESDESCRIPTION = [TYPE] from dbo.SALESMETHOD where TYPECODE = 3;