USP_DATAFORMTEMPLATE_VIEW_CLOSINGREQUIREMENTSUMMARY
The load procedure used by the view dataform template "Closing Requirement Summary View 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. |
| @HASCLOSINGREQUIREMENTS | bit | INOUT | HASCLOSINGREQUIREMENTS |
Definition
Copy
CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_CLOSINGREQUIREMENTSUMMARY
(
@ID uniqueidentifier,
@DATALOADED bit = 0 output,
@HASCLOSINGREQUIREMENTS bit = null output
)
as
set nocount on;
set @DATALOADED = 0;
select @DATALOADED = 1,
@HASCLOSINGREQUIREMENTS = count(ID)
from dbo.CLOSINGREQUIREMENT
where LEDGERACCOUNTID is null
and PDACCOUNTSYSTEMID = @ID
return 0;