USP_DATAFORMTEMPLATE_PRELOAD_ADD_DOCUMENTPRINTINGRULE
The load procedure used by the edit dataform template "Document Printing Rule Add Data Form"
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @CURRENTAPPUSERID | uniqueidentifier | IN | Input parameter indicating the ID of the current user. |
| @DOCUMENTID | uniqueidentifier | IN | Input parameter indicating the context ID for the record being added. |
| @DOCUMENTPRINTINGRULESALESMETHODS | xml | INOUT | Sales method |
Definition
Copy
CREATE procedure dbo.USP_DATAFORMTEMPLATE_PRELOAD_ADD_DOCUMENTPRINTINGRULE
(
@CURRENTAPPUSERID uniqueidentifier,
@DOCUMENTID uniqueidentifier,
@DOCUMENTPRINTINGRULESALESMETHODS xml = null output
)
as
begin
set nocount on;
set @DOCUMENTPRINTINGRULESALESMETHODS =
(
select
SALESMETHOD.ID as SALESMETHODID,
SALESMETHOD.TYPE as SALESMETHODTYPE,
1 as ISAVAILABLE
from dbo.SALESMETHOD
where ISACTIVE = 1 and
--Advanced, daily, online
SALESMETHOD.TYPECODE in (0,1,2)
order by SALESMETHOD.TYPECODE
for xml raw ('ITEM'), type, elements, root('DOCUMENTPRINTINGRULESALESMETHODS'), BINARY BASE64
)
return 0;
end