USP_DATAFORMTEMPLATE_ADDLOAD_INVOICE_GL

The load procedure used by the edit dataform template "Invoice Add Form With Inline Distribution"

Parameters

Parameter	Parameter Type	Mode	Description
@VENDORID	uniqueidentifier	INOUT	Vendor
@NUMBER	nvarchar(60)	INOUT	Invoice number
@DATEDUE	datetime	INOUT	Due date
@PURCHASEORDERID	nvarchar(20)	INOUT	PO number
@AMOUNT	money	INOUT	Invoice amount
@DATE	datetime	INOUT	Invoice date
@REMITADDRESSID	uniqueidentifier	INOUT	Remit to address
@DISCOUNTPERCENT	numeric(20, 4)	INOUT	Discount percent
@DISCOUNTAMOUNT	money	INOUT	Discount amount
@DISCOUNTEXPIRATIONDATE	datetime	INOUT	Discount expiration date
@SEPARATEPAYMENT	bit	INOUT	Create a separate disbursement for this invoice
@PAYMENTMETHODCODE	tinyint	INOUT	Payment method
@POSTDATE	datetime	INOUT	Post date
@POSTSTATUSCODE	tinyint	INOUT	Post status
@BANKACCOUNTID	uniqueidentifier	INOUT	Bank account
@FINANCIALTRANSACTION1099DISTRIBUTIONS	xml	INOUT	1099 distribution
@DESCRIPTION	nvarchar(100)	INOUT	Invoice description
@DISCOUNTTOTAL	money	INOUT	Amount after discount
@LINEITEMS	xml	INOUT	Line items
@ELEMENTMETADATA	xml	INOUT	Account element meta data

Definition

Copy



create procedure dbo.USP_DATAFORMTEMPLATE_ADDLOAD_INVOICE_GL
(
  @VENDORID uniqueidentifier = null output
  ,@NUMBER nvarchar(60) = null output
  ,@DATEDUE datetime = null output
  ,@PURCHASEORDERID nvarchar(20) = null output
  ,@AMOUNT money = null output
    ,@DATE datetime = null output
  ,@REMITADDRESSID uniqueidentifier = null output
  ,@DISCOUNTPERCENT numeric(20,4) = null output
  ,@DISCOUNTAMOUNT money = null output
  ,@DISCOUNTEXPIRATIONDATE datetime = null output
  ,@SEPARATEPAYMENT bit = null output
  ,@PAYMENTMETHODCODE tinyint = null output
  ,@POSTDATE datetime = null output
  ,@POSTSTATUSCODE tinyint = null output
  ,@BANKACCOUNTID uniqueidentifier = null output
  ,@FINANCIALTRANSACTION1099DISTRIBUTIONS xml = null output
    ,@DESCRIPTION  nvarchar(100) = null output
  ,@DISCOUNTTOTAL money = null output
    ,@LINEITEMS xml = null output
  ,@ELEMENTMETADATA xml = null output
)
as

set nocount on;

select 
  @ELEMENTMETADATA = (
            select
              E.ID as ID
                ,E.NAME as COLUMNHEADER
                ,case when E.ELEMENTTYPECODE = 1 then 1 else 0 end as ISACCOUNTSEGMENT
                ,E.SEGMENTSEQUENCE
        ,E.SEQUENCE
        ,E.LENGTH as FIELDLENGTH
            from
                dbo.ACCOUNTSTRUCTURE E
            order by
                E.SEQUENCE
            for xml raw('ITEM'),type,elements,root('ELEMENTMETADATA'),binary base64
  )