USP_DATAFORMTEMPLATE_EDIT_CREDITCARDPROCESSINGPREPROCESS_2

The save procedure used by the edit dataform template "Credit Card Processing 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.
@NAME nvarchar(100) IN Name
@DESCRIPTION nvarchar(255) IN Description
@BATCHID uniqueidentifier IN Batch
@IDSETREGISTERID uniqueidentifier IN Selection
@CUTOFFDATE datetime IN Include transactions on or before
@BATCHTEMPLATEID uniqueidentifier IN Payment batch template
@TRANSACTIONTYPECODE tinyint IN Transaction types
@OWNERID uniqueidentifier IN Payment batch owner
@DUEDATETYPECODE tinyint IN Payments due on or before
@DAYSAFTER int IN Days after this process runs
@CONSOLIDATEPAYMENTS bit IN Consolidate multiple commitments to a single payment by constituent

Definition

Copy


CREATE procedure USP_DATAFORMTEMPLATE_EDIT_CREDITCARDPROCESSINGPREPROCESS_2
(
    @ID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier,
    @NAME nvarchar(100),
    @DESCRIPTION nvarchar(255),
    @BATCHID uniqueidentifier,
    @IDSETREGISTERID uniqueidentifier,
    @CUTOFFDATE datetime,
    @BATCHTEMPLATEID uniqueidentifier,
    @TRANSACTIONTYPECODE tinyint,
    @OWNERID uniqueidentifier,
    @DUEDATETYPECODE tinyint,
    @DAYSAFTER integer,
    @CONSOLIDATEPAYMENTS bit
)

as
    set nocount on;

    declare @VALIDATEPROJECTEDBATCHTOTALS bit;

    exec dbo.USP_DATAFORMTEMPLATE_EDITLOAD_CREDITCARDPROCESSINGPREPROCESS
        @ID = @ID,
        @VALIDATEPROJECTEDBATCHTOTALS = @VALIDATEPROJECTEDBATCHTOTALS output

    exec dbo.USP_DATAFORMTEMPLATE_EDIT_CREDITCARDPROCESSINGPREPROCESS_3
        @ID,
        @CHANGEAGENTID,
        @NAME,
        @DESCRIPTION,
        @BATCHID,
        @IDSETREGISTERID,
        @CUTOFFDATE,
        @BATCHTEMPLATEID,
        @TRANSACTIONTYPECODE,
        @OWNERID,
        @DUEDATETYPECODE,
        @DAYSAFTER,
        @CONSOLIDATEPAYMENTS,
        @VALIDATEPROJECTEDBATCHTOTALS

    return 0;