USP_DATAFORMTEMPLATE_EDIT_POSTTOGLPROCESSTREASURY_3

The save procedure used by the edit dataform template "Post To GL Process Edit Data Form For Basic GL".

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.
@NAME	nvarchar(100)	IN	Name
@DESCRIPTION	nvarchar(255)	IN	Description
@POSTINGOPTIONCODE	tinyint	IN	Revenue
@IDSETREGISTERID	uniqueidentifier	IN	Selection
@CREATEOUTPUTIDSET	bit	IN	Create selection from results
@OUTPUTIDSETNAME	nvarchar(100)	IN	Selection name
@OVERWRITEOUTPUTIDSET	bit	IN	Overwrite existing selection
@MARKASPOSTED	int	IN	Mark revenue records 'Posted' when process completes
@BUSINESSPROCESSVIEWID	uniqueidentifier	IN	Output format
@DEPOSITPOSTINGOPTIONCODE	tinyint	IN	Deposits
@ADJUSTMENTPOSTINGOPTIONCODE	tinyint	IN	Bank account adjustments
@DEPOSITIDSETREGISTERID	uniqueidentifier	IN	Selection
@ADJUSTMENTIDSETREGISTERID	uniqueidentifier	IN	Selection
@REVENUEPOSTMETHODCODE	tinyint	IN	Revenue
@REVENUEREFERENCE	nvarchar(255)	IN	Revenue Reference
@CASHPOSTMETHODCODE	tinyint	IN	Cash
@CASHREFERENCE	nvarchar(255)	IN	Cash Reference
@ARPOSTMETHODCODE	tinyint	IN	Accounts Receivable
@ARREFERENCE	nvarchar(255)	IN	Cash Reference
@SUMMARIZECODE	tinyint	IN	Summarize transactions by
@REVALUATIONGAINLOSSPOSTMETHODCODE	tinyint	IN	Revaluation Gain/Loss
@REVALUATIONGAINLOSSREFERENCE	nvarchar(255)	IN	Revaluation Gain/Loss Reference

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_POSTTOGLPROCESSTREASURY_3
(
    @ID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier = null,                
    @NAME nvarchar(100), 
    @DESCRIPTION nvarchar(255),
    @POSTINGOPTIONCODE tinyint,
    @IDSETREGISTERID uniqueidentifier, 
    @CREATEOUTPUTIDSET bit,
    @OUTPUTIDSETNAME nvarchar(100), 
    @OVERWRITEOUTPUTIDSET bit,    
    @MARKASPOSTED int,
    @BUSINESSPROCESSVIEWID uniqueidentifier,
    @DEPOSITPOSTINGOPTIONCODE tinyint,
    @ADJUSTMENTPOSTINGOPTIONCODE tinyint,
    @DEPOSITIDSETREGISTERID uniqueidentifier,
    @ADJUSTMENTIDSETREGISTERID uniqueidentifier,

    --Post Detail Variables

    @REVENUEPOSTMETHODCODE tinyint,
    @REVENUEREFERENCE nvarchar(255),
    @CASHPOSTMETHODCODE tinyint,
    @CASHREFERENCE nvarchar(255),
    @ARPOSTMETHODCODE tinyint,
    @ARREFERENCE nvarchar(255),
    @SUMMARIZECODE tinyint,
    @REVALUATIONGAINLOSSPOSTMETHODCODE tinyint,
    @REVALUATIONGAINLOSSREFERENCE nvarchar(255)
)
as
    set nocount on;

    declare @POSTDATEUPTOCODE tinyint
    declare @SPECIFICPOSTDATEUPTO date
    declare @BANKACCOUNTS xml
    declare @DEPOSITTEMPLATES xml
    declare @TRANSACTIONTYPES xml

    exec dbo.USP_DATAFORMTEMPLATE_EDITLOAD_POSTTOGLPROCESSTREASURY @ID = @ID
        ,@POSTDATEUPTOCODE = @POSTDATEUPTOCODE output
        ,@SPECIFICPOSTDATEUPTO = @SPECIFICPOSTDATEUPTO output
        ,@BANKACCOUNTS = @BANKACCOUNTS output
        ,@DEPOSITTEMPLATES = @DEPOSITTEMPLATES output
        ,@TRANSACTIONTYPES = @TRANSACTIONTYPES output;

    exec dbo.USP_DATAFORMTEMPLATE_EDIT_POSTTOGLPROCESSTREASURY_4
        @ID,
        @CHANGEAGENTID,                
        @NAME, 
        @DESCRIPTION,
        @POSTINGOPTIONCODE,
        @IDSETREGISTERID, 
        @CREATEOUTPUTIDSET,
        @OUTPUTIDSETNAME, 
        @OVERWRITEOUTPUTIDSET,    
        @MARKASPOSTED,
        @BUSINESSPROCESSVIEWID,
        @DEPOSITPOSTINGOPTIONCODE,
        @ADJUSTMENTPOSTINGOPTIONCODE,
        @DEPOSITIDSETREGISTERID,
        @ADJUSTMENTIDSETREGISTERID,
        @REVENUEPOSTMETHODCODE,
        @REVENUEREFERENCE,
        @CASHPOSTMETHODCODE,
        @CASHREFERENCE,
        @ARPOSTMETHODCODE,
        @ARREFERENCE,
        @SUMMARIZECODE,
        @REVALUATIONGAINLOSSPOSTMETHODCODE,
        @REVALUATIONGAINLOSSREFERENCE,
        @POSTDATEUPTOCODE,
        @SPECIFICPOSTDATEUPTO,
        @BANKACCOUNTS,
        @DEPOSITTEMPLATES,
        @TRANSACTIONTYPES