declare @AgingDate as date
set @agingdate = '6/24/2016'
declare @out TABLE (
[VENDORID] [char](15) NOT NULL,
[VENDNAME] [char](65) NOT NULL,
[VNDCLSID] [char](11) NOT NULL,
[USERDEF1] [char](21) NOT NULL,
[PYMNTPRI] [char](3) NOT NULL,
[VEN_KEYSOURC] [char](41) NOT NULL,
[APTVCHNM] [char](21) NOT NULL,
[APTODCTY] [smallint] NOT NULL,
[VCHRNMBR] [char](21) NOT NULL,
[APP_DOCTYPE] [smallint] NOT NULL,
[APAMAGPR_1] [numeric](19, 5) NOT NULL,
[APAMAGPR_2] [numeric](19, 5) NOT NULL,
[APAMAGPR_3] [numeric](19, 5) NOT NULL,
[APAMAGPR_4] [numeric](19, 5) NOT NULL,
[APAMAGPR_5] [numeric](19, 5) NOT NULL,
[APAMAGPR_6] [numeric](19, 5) NOT NULL,
[APAMAGPR_7] [numeric](19, 5) NOT NULL,
[APPLDAMT] [numeric](19, 5) NOT NULL,
[POSTED] [tinyint] NOT NULL,
[ORAPPAMT] [numeric](19, 5) NOT NULL,
[APP_OAGPRAMT_1] [numeric](19, 5) NOT NULL,
[APP_OAGPRAMT_2] [numeric](19, 5) NOT NULL,
[APP_OAGPRAMT_3] [numeric](19, 5) NOT NULL,
[APP_OAGPRAMT_4] [numeric](19, 5) NOT NULL,
[APP_OAGPRAMT_5] [numeric](19, 5) NOT NULL,
[APP_OAGPRAMT_6] [numeric](19, 5) NOT NULL,
[APP_OAGPRAMT_7] [numeric](19, 5) NOT NULL,
[CNTRLNUM] [char](21) NOT NULL,
[CNTRLTYP] [smallint] NOT NULL,
[DOCNUMBR] [char](21) NOT NULL,
[DOC_DOCTYPE] [smallint] NOT NULL,
[DOCAMNT] [numeric](19, 5) NOT NULL,
[DISTKNAM] [numeric](19, 5) NOT NULL,
[DOCDATE] [datetime] NOT NULL,
[DUEDATE] [datetime] NOT NULL,
[DISCDATE] [datetime] NOT NULL,
[TRXSORCE] [char](13) NOT NULL,
[CURTRXAM] [numeric](19, 5) NOT NULL,
[EAMAGPER_1] [numeric](19, 5) NOT NULL,
[EAMAGPER_2] [numeric](19, 5) NOT NULL,
[EAMAGPER_3] [numeric](19, 5) NOT NULL,
[EAMAGPER_4] [numeric](19, 5) NOT NULL,
[EAMAGPER_5] [numeric](19, 5) NOT NULL,
[EAMAGPER_6] [numeric](19, 5) NOT NULL,
[EAMAGPER_7] [numeric](19, 5) NOT NULL,
[DISAMTAV] [numeric](19, 5) NOT NULL,
[PERIODID] [smallint] NOT NULL,
[WROFAMNT] [numeric](19, 5) NOT NULL,
[DOC_KEYSOURC] [char](41) NOT NULL,
[DINVPDOF] [datetime] NOT NULL,
[PSTGDATE] [datetime] NOT NULL,
[ORDOCAMT] [numeric](19, 5) NOT NULL,
[ORDISTKN] [numeric](19, 5) NOT NULL,
[ORCTRXAM] [numeric](19, 5) NOT NULL,
[DOC_OAGPRAMT_1] [numeric](19, 5) NOT NULL,
[DOC_OAGPRAMT_2] [numeric](19, 5) NOT NULL,
[DOC_OAGPRAMT_3] [numeric](19, 5) NOT NULL,
[DOC_OAGPRAMT_4] [numeric](19, 5) NOT NULL,
[DOC_OAGPRAMT_5] [numeric](19, 5) NOT NULL,
[DOC_OAGPRAMT_6] [numeric](19, 5) NOT NULL,
[DOC_OAGPRAMT_7] [numeric](19, 5) NOT NULL,
[ODISAMTAV] [numeric](19, 5) NOT NULL,
[ORWROFAM] [numeric](19, 5) NOT NULL,
[DEX_ROW_ID] [int] NOT NULL
)
insert into @Out
exec seepmHATBWrapper
@I_dAgingDate = @agingdate,
@I_cStartVendorID= '',
@I_cEndVendorID = 'þþþþþþþþþþþþþþþ',
@I_cStartVendorName = '',
@I_cEndVendorName = 'þþþþþþþþþþþþþþþ',
@I_cStartClassID = '',
@I_cEndClassID = 'þþþþþþþþþþþþþþþ',
@I_cStartUserDefined = '',
@I_cEndUserDefined = 'þþþþþþþþþþþþþþþ',
@I_cStartPaymentPriority = '',
@I_cEndPaymentPriority = 'þþþþþþþþþþþþþþþ',
@I_cStartDocumentNumber = '',
@I_cEndDocumentNumber = 'þþþþþþþþþþþþþþþ',
@I_tUsingDocumentDate = 0,
@I_dStartDate = '1/1/1900',
@I_dEndDate = @agingdate,
@I_tExcludeNoActivity = '1',
@I_tExcludeMultiCurrency = '1',
@I_tExcludeZeroBalanceVendors = '1',
@I_tExcludeFullyPaidTrxs = '1',
@I_tExcludeCreditBalance = '0',
@I_tExcludeUnpostedAppldCrDocs = '1'
select * from @out