USP_DATAFORMTEMPLATE_EDITLOAD_APPOSTTOGLPROCESS

The load procedure used by the edit dataform template "AP Post to GL Process Edit 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(100)	INOUT	Name
@DESCRIPTION	nvarchar(255)	INOUT	Description
@INVOICEPOSTINGOPTIONCODE	tinyint	INOUT	Invoices and credit memos
@INVOICEIDSETREGISTERID	uniqueidentifier	INOUT	Selection
@DISBURSEMENTOPTIONCODE	tinyint	INOUT	Disbursements
@DISBURSEMENTREGISTERID	uniqueidentifier	INOUT	Selection
@INCLUDEBYPOSTDATE	bit	INOUT	Include 'not posted' transactions by post date
@POSTTHROUGHDATECODE	tinyint	INOUT	Post dates up to and including
@EXPENSEPOSTMETHODCODE	tinyint	INOUT	Expense
@PAYABLESPOSTMETHODCODE	tinyint	INOUT	Payables summary
@CASHPOSTMETHODCODE	tinyint	INOUT	Treasury cash
@SUMMARIZEBYCODE	tinyint	INOUT	Summarize transactions by
@CREATEOUTPUTIDSET	bit	INOUT	Create selection from results
@OUTPUTIDSETNAME	nvarchar(100)	INOUT	Selection name
@OVERWRITEOUTPUTIDSET	bit	INOUT	Overwrite existing selection
@INVOICERECORDTYPEID	uniqueidentifier	INOUT
@DISBURSEMENTRECORDTYPEID	uniqueidentifier	INOUT

Definition

Copy



create procedure dbo.USP_DATAFORMTEMPLATE_EDITLOAD_APPOSTTOGLPROCESS(
    @ID uniqueidentifier,
    @DATALOADED bit = 0 output,
    @TSLONG bigint = 0 output,
        @NAME nvarchar(100) = null output, 
        @DESCRIPTION nvarchar(255)= null output, 
      @INVOICEPOSTINGOPTIONCODE tinyint = null output,
    @INVOICEIDSETREGISTERID uniqueidentifier = null output,
    @DISBURSEMENTOPTIONCODE tinyint = null output,
    @DISBURSEMENTREGISTERID uniqueidentifier = null output,
    @INCLUDEBYPOSTDATE bit = null output,
    @POSTTHROUGHDATECODE tinyint = null output,
    @EXPENSEPOSTMETHODCODE tinyint = null output,
    @PAYABLESPOSTMETHODCODE tinyint = null output,
    @CASHPOSTMETHODCODE tinyint = null output,
    @SUMMARIZEBYCODE tinyint = null output,
    @CREATEOUTPUTIDSET bit = null output,
    @OUTPUTIDSETNAME nvarchar(100) = null output,
    @OVERWRITEOUTPUTIDSET bit = null output,
        @INVOICERECORDTYPEID uniqueidentifier = null output,
        @DISBURSEMENTRECORDTYPEID uniqueidentifier = 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, @INCLUDEBYPOSTDATE = INCLUDEBYPOSTDATE, @POSTTHROUGHDATECODE = POSTTHROUGHDATECODE,
    @SUMMARIZEBYCODE = SUMMARIZEBYDATECODE, @CREATEOUTPUTIDSET = CREATEOUTPUTIDSET, @OUTPUTIDSETNAME = OUTPUTIDSETNAME, @OVERWRITEOUTPUTIDSET = OVERWRITEOUTPUTIDSET
    from dbo.GLPOSTPROCESS
    where ID = @ID

  select @INVOICEPOSTINGOPTIONCODE = POSTINGOPTIONCODE, @INVOICEIDSETREGISTERID = IDSETREGISTERID
  from dbo.GLPOSTPROCESSTRANSACTIONCRITERIA inner join dbo.FINANCIALSYSTEMTRANSACTIONTYPE on GLPOSTPROCESSTRANSACTIONCRITERIA.FINANCIALSYSTEMTRANSACTIONTYPEID = FINANCIALSYSTEMTRANSACTIONTYPE.ID
  where GLPOSTPROCESSTRANSACTIONCRITERIA.GLPOSTPROCESSID = @ID and FINANCIALSYSTEMTRANSACTIONTYPE.TYPECODE = 101

  select @DISBURSEMENTOPTIONCODE = POSTINGOPTIONCODE, @DISBURSEMENTREGISTERID = IDSETREGISTERID
  from dbo.GLPOSTPROCESSTRANSACTIONCRITERIA inner join dbo.FINANCIALSYSTEMTRANSACTIONTYPE on GLPOSTPROCESSTRANSACTIONCRITERIA.FINANCIALSYSTEMTRANSACTIONTYPEID = FINANCIALSYSTEMTRANSACTIONTYPE.ID
  where GLPOSTPROCESSTRANSACTIONCRITERIA.GLPOSTPROCESSID = @ID and FINANCIALSYSTEMTRANSACTIONTYPE.TYPECODE = 105

  select @EXPENSEPOSTMETHODCODE = POSTMETHODCODE
  from dbo.GLPOSTPROCESSPOSTMETHOD inner join dbo.FINANCIALSYSTEMTRANSACTIONTYPE on GLPOSTPROCESSPOSTMETHOD.FINANCIALSYSTEMTRANSACTIONTYPEID = FINANCIALSYSTEMTRANSACTIONTYPE.ID
  where GLPOSTPROCESSPOSTMETHOD.GLPOSTPROCESSID = @ID and GLPOSTPROCESSPOSTMETHOD.TRANSACTIONTYPECODE = 0 and FINANCIALSYSTEMTRANSACTIONTYPE.TYPECODE = 101

  select @PAYABLESPOSTMETHODCODE = POSTMETHODCODE
  from dbo.GLPOSTPROCESSPOSTMETHOD inner join dbo.FINANCIALSYSTEMTRANSACTIONTYPE on GLPOSTPROCESSPOSTMETHOD.FINANCIALSYSTEMTRANSACTIONTYPEID = FINANCIALSYSTEMTRANSACTIONTYPE.ID
  where GLPOSTPROCESSPOSTMETHOD.GLPOSTPROCESSID = @ID and GLPOSTPROCESSPOSTMETHOD.TRANSACTIONTYPECODE = 1 and FINANCIALSYSTEMTRANSACTIONTYPE.TYPECODE = 101

  select @CASHPOSTMETHODCODE = POSTMETHODCODE
  from dbo.GLPOSTPROCESSPOSTMETHOD inner join dbo.FINANCIALSYSTEMTRANSACTIONTYPE on GLPOSTPROCESSPOSTMETHOD.FINANCIALSYSTEMTRANSACTIONTYPEID = FINANCIALSYSTEMTRANSACTIONTYPE.ID
  where GLPOSTPROCESSPOSTMETHOD.GLPOSTPROCESSID = @ID and GLPOSTPROCESSPOSTMETHOD.TRANSACTIONTYPECODE = 1 and FINANCIALSYSTEMTRANSACTIONTYPE.TYPECODE = 105

    select @INVOICERECORDTYPEID = ID from dbo.RECORDTYPE where upper(NAME) = 'FINANCIAL TRANSACTION'

    select @DISBURSEMENTRECORDTYPEID = ID from dbo.RECORDTYPE where upper(NAME) = 'DISBURSEMENT'

    return 0;