DynDeveloper.com

DynDeveloper.com

GuestLog Out
You are accessing the Members Only area for DynDeveloper.com using guest access. The member experience is slightly different
AbrahamA 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
 
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

 

 

Add a Comment



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

Comments

body header
No records to display.