Easy Automation - Vendor Export - SQL View

Issue No: AP-6183
Created 9/10/2018 1:58:54 PM
Type Integration
Priority Minor
Status Closed
Resolution Fixed
Fixed Version 19.1
Description Integration Map: [http://inet.irelyserver.com/pages/viewpage.action?pageId=91468625]   High level flow for integrations: [http://inet.irelyserver.com/display/IM/Handling+3rd+Party+File+Types+and+Formats]   This ticket calls for the creation of the SQL stored procedure(s) that will export all vendors (new and recently modified) to a staging table that can be used by the Vendor export EXE to create JSON (flat) files that will be imported by Easy Automation. The stored proc should have a date parameter. Any vendor that were added or modified on or after the given date would be exported by this stored proc.   !pastedImage_d104565_0.png|height=432,width=1005!