What should be the query for pulling the Master Data like Customer and Vendor after the first extraction was done. Let's say I run the query today 07/19/2018 and again on 07/31/2018 I want to extract only the Master Data from 07/20/2018.
Whether below mentioned query will help.
Select * from RM00101 where CREATDDT >= '2018-07-19 00:00:00.000'
If you goal is to identify those customers which have been created after a certain point in time, then yes using the script above which references the CREATDDT will work. However, if you are also needing to identify changes "edits", then you will need to used the last modified date as well.