USP_DATAFORMTEMPLATE_EDITLOAD_RECONCILIATIONCLOSESHIFT

The load procedure used by the edit dataform template "Reconciliation Close Shift Edit 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.
@TSLONG	bigint	INOUT	Output parameter indicating the TSLONG value of the record being edited. This is used to manage multi-user concurrency issues when multiple users access the same record.
@STARTINGCASH	money	INOUT	Starting balance
@ACTUALCASH	money	INOUT	Cash deposit
@COMMENT	nvarchar(max)	INOUT	Comment
@OTHERRECEIPTS	xml	INOUT	Other receipts

Definition

Copy


                    CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDITLOAD_RECONCILIATIONCLOSESHIFT(
                        @ID uniqueidentifier,
                        @DATALOADED bit = 0 output,
                        @TSLONG bigint = 0 output,
                        @STARTINGCASH money = null output,
                        @ACTUALCASH money = null output,
                        @COMMENT nvarchar(max) = null output,
                        @OTHERRECEIPTS xml = null output
                    )
                    as

                        set nocount on;

                        declare @APPUSERID uniqueidentifier;

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

                        select @APPUSERID = APPUSERID from dbo.RECONCILIATION where ID = @ID;

                        select
                            @DATALOADED = 1,
                            @TSLONG = TSLONG,
                            @STARTINGCASH = STARTINGCASH,
                            @ACTUALCASH = ACTUALCASH,
                            @COMMENT = COMMENT,
                            @OTHERRECEIPTS = (
                                select [ID], [PAYMENTMETHODCODE], [PAYMENTMETHOD], [CREDITTYPECODEID], [OTHERPAYMENTMETHODCODEID], [EXPECTED], [QUANTITY], [ISREFUND], [ISLABEL]
                                from dbo.[UFN_RECONCILIATION_GETOTHERRECEIPTS](@ID, @APPUSERID)
                                order by [ISREFUND] asc, [PAYMENTMETHODCODE]
                                for xml raw('ITEM'),type,elements,root('OTHERRECEIPTS'),BINARY BASE64)
                        from dbo.RECONCILIATION
                        where ID = @ID

                    return 0;