USP_DATAFORMTEMPLATE_EDIT_POSTTOGLPROCESSPREPROCESS

The save procedure used by the edit dataform template "Post to GL Preprocess Edit Form".

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter indicating the ID of the record being edited.
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the procedure.
@MARKASPOSTED	int	IN	Mark revenue records 'Posted' when process completes
@CREATEOUTPUTIDSET	bit	IN	Create selection from results
@OUTPUTIDSETNAME	nvarchar(100)	IN	Selection name
@OVERWRITEOUTPUTIDSET	bit	IN	Overwrite existing selection

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_POSTTOGLPROCESSPREPROCESS
(
    @ID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier = null,                
    @MARKASPOSTED int,
    @CREATEOUTPUTIDSET bit,
    @OUTPUTIDSETNAME nvarchar(100), 
    @OVERWRITEOUTPUTIDSET bit
)
as                
begin
    set nocount on

    declare @POSTDATEUPTOCODE tinyint;
    declare @SPECIFICPOSTDATEUPTO date;

    exec dbo.USP_DATAFORMTEMPLATE_EDITLOAD_POSTTOGLPROCESSPREPROCESS @ID = @ID
        ,@POSTDATEUPTOCODE = @POSTDATEUPTOCODE output
        ,@SPECIFICPOSTDATEUPTO = @SPECIFICPOSTDATEUPTO output

    exec dbo.USP_DATAFORMTEMPLATE_EDIT_POSTTOGLPROCESSPREPROCESS_2
        @ID
        ,@CHANGEAGENTID
        ,@MARKASPOSTED
        ,@CREATEOUTPUTIDSET
        ,@OUTPUTIDSETNAME
        ,@OVERWRITEOUTPUTIDSET
        ,@POSTDATEUPTOCODE
        ,@SPECIFICPOSTDATEUPTO;
end