web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Blogs / Dynamics GP Essentials / Vendor EFT Bank Details - S...

Vendor EFT Bank Details - SQL Script

Views (4838)
Mahmoud Saadi Profile Picture Mahmoud Saadi 32,738
A client of us requested a consolidated report for all the vendor EFT Bank details, I was quite sure that I have come across an SQL Script on that matter, It was Ian's script | SQL view on Vendor EFT from Azurecurve. While it is just perfect, I still wanted further definitive details including most of the fields in the screen.  


The Vendor EFT Bank details can be found on:
  • Cards > Purchasing > Vendor > Address Button > EFT Bank ButtonOr
  • Cards > Purchasing > Address > EFT BanK

Vendor EFT Bank Maintenance Window 

The script can be downloaded from >> Download Link

/*--------------------------------------------------------------------------------
Creation Date: 23, November, 2015
Created by: Mahmoud M. AlSaadi
The main purpose of the script is to retrieve vendor EFT Bank details. 

Revision History:
Revision No.            Revision Date    Description
1                       23/11/2015      Original Version
-------------------------------------------------------------------------------- */

-- Tables Included:
-- SY06000 EFT Bank Setup Information
  
SELECT  SERIES Series ,
        ADRSCODEAS 'Address Code',
        VENDORIDAS 'Vendor ID' ,
        CASE FRGNBANK
          WHEN1 THEN 'Yes'
          WHEN0 THEN 'No'
          ELSE ''
        END AS 'Additional Information',
        CASE INACTIVE
          WHEN1 THEN 'Yes'
          WHEN0 THEN 'No'
          ELSE ''
        END AS Inactive ,
        BANKNAMEAS 'Bank Name' ,
        EFTBankAcctAS 'EFT Bank Account',
        EFTBankBranchAS 'EFT Bank Branch',
        IntlBankAcctNumAS IBAN ,
        CASE EFTAccountType
          WHEN1 THEN 'Checking'
          WHEN2 THEN 'Savings'
          WHEN3 THEN 'General Ledger'
          WHEN4 THEN 'Loan'
          ELSE ''
        END AS 'EFT Account Type' ,
        CASE EFTTransferMethod
          WHEN1 THEN 'Not specified'
          WHEN2 THEN 'Business Account'
          WHEN3 THEN 'Corporate Account'
          WHEN4 THEN 'Personal Account'
          WHEN5 THEN 'Foreign Account'
          ELSE ''
        END AS 'EFT Transfer Method',
        CASE GIROPostType
          WHEN1 THEN 'Pure'
          WHEN2 THEN 'Impure'
          ELSE ''
        END AS 'GIRO Post Type' ,
        SWIFTADDRAS 'Swift Address',
        CustVendCountryCodeAS 'Vendor Country Code' ,
        DeliveryCountryCodeAS 'Delivery Country Code' ,
        BNKCTRCDAS 'Bank Country Code',
        CBANKCDAS 'Central Bank Code',
        ADDRESS1AS AddressLine_1,
        ADDRESS2AS AddressLine_2,
        ADDRESS3AS AddressLine_3,
        ADDRESS4AS AddressLine_4,
        RegCode1AS RegulatoryCode_1,
        RegCode2AS RegulatoryCode_2,
        EFTTransitRoutingNo,
        CURNCYIDAS CurrencyID ,
        EFTPrenoteDateAS 'EFT Pre Note Date',
        EFTTerminationDateAS 'EFT Termination Date'
FROM    SY06000
WHERE   SERIES = 4  --- Purchasing Series

Best Regards,
Mahmoud M. AlSaadi

This was originally posted here.

Comments

*This post is locked for comments