USP_DATAFORMTEMPLATE_VIEW_ADVANCESALESORDERSUMMARY

The load procedure used by the view dataform template "Advance Sales Order Summary View Data Form"

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter used to load the fields defined on the form.
@DATALOADED	bit	INOUT	Output parameter indicating whether or not data was actually loaded.
@ITEMS	xml	INOUT	Items
@SUBTOTAL	money	INOUT	Subtotal
@TAXES	money	INOUT	Taxes
@TOTAL	money	INOUT	Total
@BALANCE	money	INOUT	Balance
@CHANGEDUE	money	INOUT	Change due
@TENDERED	money	INOUT	Tendered
@CONSTITUENTID	uniqueidentifier	INOUT	Constituent ID
@ORDERSTATUSCODE	tinyint	INOUT	Order status

Definition

Copy


                CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_ADVANCESALESORDERSUMMARY
                (
                    @ID uniqueidentifier,
                    @DATALOADED bit = 0 output,
                    @ITEMS xml = null output,
                    @SUBTOTAL money = null output,
                    @TAXES money = null output,
                    @TOTAL money = null output,
                    @BALANCE money = null output,
                    @CHANGEDUE money = null output,
                    @TENDERED money = null output,
                    @CONSTITUENTID uniqueidentifier = null output,
                    @ORDERSTATUSCODE tinyint = null output
                )
                as
                    set nocount on;
                    set @DATALOADED = 0;

                    exec dbo.USP_DATAFORMTEMPLATE_VIEW_DAILYSALESORDER @ID, null, null, @ITEMS output, @SUBTOTAL output, @TAXES output, @TOTAL output, @TENDERED output, @CHANGEDUE output, @BALANCE output

                    select 
                        @CONSTITUENTID = [CONSTITUENTID],
                        @ORDERSTATUSCODE = [STATUSCODE]
                    from dbo.[SALESORDER] 
                    where [ID] = @ID

                    set @DATALOADED = 1;

                    return 0;