USP_DATAFORMTEMPLATE_ADD_CREDIT_PRELOAD

The load procedure used by the edit dataform template "Credit Add Data Form"

Parameters

Parameter	Parameter Type	Mode	Description
@ORDERID	uniqueidentifier	IN	Input parameter indicating the context ID for the record being added.
@SALESORDERITEMS	xml	INOUT
@ORDERNUMBER	nvarchar(200)	INOUT	Order number
@ORDERTOTAL	money	INOUT	Order total
@ORDERPAYMENTS	xml	INOUT
@TAXES	xml	INOUT
@SALESORDERTAXITEMS	xml	INOUT

Definition

Copy



                    CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_CREDIT_PRELOAD
                    (
                        @ORDERID uniqueidentifier,
                        @SALESORDERITEMS xml = null output,
                        @ORDERNUMBER nvarchar(200) = null output,
                        @ORDERTOTAL money = null output,
                        @ORDERPAYMENTS xml = null output,
                        @TAXES xml = null output,
                        @SALESORDERTAXITEMS xml = null output
                    )
                    as
                    set nocount on;

                    select 
                        @SALESORDERITEMS = dbo.UFN_CREDIT_GETSALESORDERITEMS_TOITEMLISTXML(@ORDERID),
                        @ORDERNUMBER = SEQUENCEID,
                        @ORDERTOTAL = AMOUNT,
                        @ORDERPAYMENTS = dbo.UFN_CREDIT_GETORDERPAYMENTS_TOITEMLISTXML(@ORDERID),
                        @TAXES = dbo.UFN_CREDIT_GETTAXES_TOITEMLISTXML(@ORDERID),
                        @SALESORDERTAXITEMS = dbo.UFN_CREDIT_GETSALESORDERTAXITEMS_TOITEMLISTXML(@ORDERID)
                    from dbo.SALESORDER
                    where ID = @ORDERID

                    return 0;