USP_DATAFORMTEMPLATE_PRELOAD_ADD_STANDINGORDEREXPORTPROCESS
The load procedure used by the edit dataform template "Standing Orders Export Process Add Form"
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @REVENUERECORDTYPEID | uniqueidentifier | INOUT | Revenue record type |
Definition
Copy
CREATE procedure dbo.USP_DATAFORMTEMPLATE_PRELOAD_ADD_STANDINGORDEREXPORTPROCESS
(
@REVENUERECORDTYPEID uniqueidentifier = null output
)
as
set nocount on;
select @REVENUERECORDTYPEID = ID from dbo.RECORDTYPE where upper(NAME) = 'REVENUE';
return 0;