SQL Script for Vendor EFT Information

| 07/16/2011 | 2 Comments

Hi all

Today, I am posting a SQL Script for getting the EFT information of various vendors.

/******************************************************************
Created July 16, 2011 by Sivakumar Venkataraman - Interdyn AKA
This view returns a returns the details of the EFT Information
for the various vendors setup in the company.
 
Tables used: 
 - PM00100 - Vendor Class Master
 - PM00200 - Vendor Master
 - PM00300 - Vendor Address Master
 - SY06000 - Address EFT Master
 ******************************************************************/
SELECT A.VENDORID ,
        A.VENDNAME ,
        A.VNDCHKNM ,
        A.VENDSHNM ,
        A.VNDCLSID ,
        C.VNDCLDSC ,
        B.ADRSCODE ,
        B.VNDCNTCT ,
        B.ADDRESS1 ,
        B.ADDRESS2 ,
        B.ADDRESS3 ,
        B.CITY ,
        B.STATE ,
        B.ZIPCODE ,
        B.COUNTRY ,
        B.PHNUMBR1 ,
        B.FAXNUMBR ,
        D.EFTBankType ,
        D.BANKNAME ,
        D.EFTBankAcct ,
        D.EFTBankBranch ,
        D.EFTBankCode ,
        D.EFTBankBranchCode ,
        D.EFTBankCheckDigit ,
        D.EFTTransitRoutingNo ,
        D.EFTTransferMethod ,
        D.CURNCYID ,
        D.EFTAccountType ,
        D.EFTPrenoteDate ,
        D.EFTTerminationDate ,
        D.BNKCTRCD ,
        D.SWIFTADDR ,
        D.IntlBankAcctNum
    FROM TWO.dbo.PM00200 A
        INNER JOIN TWO.dbo.PM00300 B
        ON A.VENDORID = B.VENDORID
        LEFT OUTER JOIN TWO.dbo.PM00100 C
        ON A.VNDCLSID = C.VNDCLSID 
        LEFT OUTER JOIN TWO.dbo.SY06000 D
        ON B.ADRSCODE = D.ADRSCODE
           AND B.VENDORID = D.CustomerVendor_ID
           AND D.SERIES = 4

Hope this helps the community…

Until next post!

VN:F [1.9.22_1171]
Rating: 7.0/10 (3 votes cast)
VN:F [1.9.22_1171]
Rating: +2 (from 2 votes)
SQL Script for Vendor EFT Information, 7.0 out of 10 based on 3 ratings

Tags: , ,

Category: Accounts Payables, Dynamics, EFT For Payables, Great Plains, SQL Server, SQL Server 2000, SQL Server 2005

About the Author ()