You are accessing the Members Only area for DynDeveloper.com using guest access. The member experience is slightly different
AbrahamA
4Penny.net
Points: 7175

4/23/2016 8:08:02 AM

seepmHATBWrapper

* This article, and all our great .NET Development documentation, Is available on the .NET Development menu
SQL Code to execute the seepmHATBWrapper native stored procedure, this proc powers the PM Historical Aged Trial Balance report
 
4Penny.net
Version: GP 2013,GP 2015
Section: SQL Scripts

 

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

 

 

Please leave a comment

Add a Comment



Not Subscribed. You will not receive emails on article changes or comment additions

Comments

body header
No records to display.
Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables
3