USP_DATAFORMTEMPLATE_ADD_RECONCILIATIONSTARTINGBALANCE_PRELOAD
The load procedure used by the edit dataform template "Reconciliation Starting Balance Add Data Form"
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @CURRENTAPPUSERID | uniqueidentifier | IN | Input parameter indicating the ID of the current user. |
| @STARTINGCASH | money | INOUT | Starting balance |
| @COMMENT | nvarchar(max) | INOUT | Comment |
Definition
Copy
CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_RECONCILIATIONSTARTINGBALANCE_PRELOAD
(
@CURRENTAPPUSERID uniqueidentifier,
@STARTINGCASH money = null output,
@COMMENT nvarchar(max) = null output
)
as
set nocount on;
if exists(select 1 from dbo.CLOSEDRAWERCONFIGURATION C where C.CONFIGURATIONOPTIONCODE = 0)
select
@STARTINGCASH = [STARTINGCASH],
@COMMENT = [COMMENT]
from dbo.[RECONCILIATION]
where [STATUSCODE] = 0
and [APPUSERID] = @CURRENTAPPUSERID;
else
select
@STARTINGCASH = [STARTINGCASH],
@COMMENT = [COMMENT]
from dbo.[RECONCILIATION]
where [STATUSCODE] = 0
return 0;