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