USP_DATAFORMTEMPLATE_EDITLOAD_DISBURSEMENTFORMAT

The load procedure used by the edit dataform template "Disbursement Format Edit Data Form"

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter used to load the fields defined on the form.
@DATALOADED	bit	INOUT	Output parameter indicating whether or not data was actually loaded.
@TSLONG	bigint	INOUT	Output parameter indicating the TSLONG value of the record being edited. This is used to manage multi-user concurrency issues when multiple users access the same record.
@NAME	nvarchar(20)	INOUT	Name
@DESCRIPTION	nvarchar(100)	INOUT	Description
@PAYMENTMETHODCODE	tinyint	INOUT	Payment method
@REPORTCATALOGID	uniqueidentifier	INOUT	Layout template
@TYPECODE	tinyint	INOUT	Stock type
@PRENUMBERED	bit	INOUT	Pre-numbered stock
@PRINTTRANSACTIONSORDERCODE	tinyint	INOUT	Print order
@PRINTORDERCODE	tinyint	INOUT	Print order
@SORTTRANSACTIONSCODE	tinyint	INOUT	Sort transactions on the check stub by
@SORTORDERCODE	tinyint	INOUT	Sort order
@PRINTCUSTOMERNUMBER	bit	INOUT	Print customer number on the check stub
@PRINTSITEADDRESS	bit	INOUT	Print a site address on the check stub
@SITEADDRESSID	uniqueidentifier	INOUT	Address
@PRINTSTUBLOGO	bit	INOUT	Print a logo on the check stub
@STUBLOGO	varbinary	INOUT	Check stub logo
@PRINTTRANSITABANUMBER	bit	INOUT	Print Transit ABA number on the check
@PRINTORGANIZATIONNAME	bit	INOUT	Print organization name on the check
@ORGANIZATIONNAME	nvarchar(100)	INOUT	Organization name
@PRINTMESSAGE	bit	INOUT	Print messages on the check
@MESSAGE1	nvarchar(60)	INOUT	Message 1
@MESSAGE2	nvarchar(60)	INOUT	Message 2
@PRINTCHECKLOGO	bit	INOUT	Print a logo on the check
@CHECKLOGO	varbinary	INOUT	Check logo
@PRINTNUMBER	bit	INOUT	Print disbursement number

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDITLOAD_DISBURSEMENTFORMAT(
  @ID uniqueidentifier,
  @DATALOADED bit = 0 output,
  @TSLONG bigint = 0 output,
  @NAME nvarchar(20) = null output,
  @DESCRIPTION nvarchar(100) = null output,
  @PAYMENTMETHODCODE tinyint = null output,
  @REPORTCATALOGID uniqueidentifier = null output,
  @TYPECODE tinyint = null output,
  @PRENUMBERED bit = null output, 
  @PRINTTRANSACTIONSORDERCODE tinyint = null output,
  @PRINTORDERCODE tinyint = null output,
  @SORTTRANSACTIONSCODE tinyint = null output,
  @SORTORDERCODE tinyint = null output,
  @PRINTCUSTOMERNUMBER bit = null output,
  @PRINTSITEADDRESS bit = null output,
  @SITEADDRESSID uniqueidentifier = null output,
  @PRINTSTUBLOGO bit = null output,
  @STUBLOGO varbinary(max) = null output,
  @PRINTTRANSITABANUMBER bit = null output,
  @PRINTORGANIZATIONNAME bit = null output,
  @ORGANIZATIONNAME nvarchar(100) = null output,
  @PRINTMESSAGE bit = null output,
  @MESSAGE1 nvarchar(60) = null output,
  @MESSAGE2 nvarchar(60) = null output,
  @PRINTCHECKLOGO bit = null output,
  @CHECKLOGO varbinary(max) = null output
    ,@PRINTNUMBER bit = null output
)
as

    set nocount on;

    -- be sure to set these, in case the select returns no rows

    set @DATALOADED = 0;
    set @TSLONG = 0;

    select
        @DATALOADED = 1,
        @TSLONG = TSLONG,
      @NAME = NAME,
    @DESCRIPTION = DESCRIPTION,
    @PAYMENTMETHODCODE = PAYMENTMETHODCODE,
    @REPORTCATALOGID = REPORTCATALOGID,
    @TYPECODE = TYPECODE,
      @PRENUMBERED = PRENUMBERED,
    @PRINTTRANSACTIONSORDERCODE = PRINTTRANSACTIONSORDERCODE,
    @PRINTORDERCODE = PRINTORDERCODE,
    @SORTTRANSACTIONSCODE = SORTTRANSACTIONSCODE,
    @SORTORDERCODE = SORTORDERCODE,
    @PRINTCUSTOMERNUMBER = PRINTCUSTOMERNUMBER,
    @PRINTSITEADDRESS = PRINTSITEADDRESS,
    --@SITEADDRESSID = SITEADDRESSID,

    @PRINTSTUBLOGO = PRINTSTUBLOGO,
    @STUBLOGO = STUBLOGO,
    @PRINTTRANSITABANUMBER = PRINTTRANSITABANUMBER,
    @PRINTORGANIZATIONNAME =PRINTORGANIZATIONNAME,
    @ORGANIZATIONNAME = ORGANIZATIONNAME,
    @PRINTMESSAGE = PRINTMESSAGE,
    @MESSAGE1 = MESSAGE1,
    @MESSAGE2 = MESSAGE2,
    @PRINTCHECKLOGO = PRINTCHECKLOGO,
    @CHECKLOGO = CHECKLOGO
        ,@PRINTNUMBER = PRINTNUMBER
    from dbo.DISBURSEMENTFORMAT
    where ID = @ID;

    return 0;