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