Most changes in Retail3000 can be requested by using a 'ModifiedDateTime' filter. Every table in Retail3000 has a 'LastModifiedDateTime' timestamp field which is updated when any data is changed. But there is an exception on this rule, which has to do with 'static' or also called 'calculated' fields. To get a better performance and to report certain data on reports (without having to do complex and heavy calcuations) Retail3000 uses static fields. In more recent tables these fields can be recognized because the field name starts with 'Static'. The downside of these static fields is that the timestamp of the belonging table will not be updated.

Most of the stock relevant data is stored in the table 'StoreProducts'. This table has a lot of calculated fields. Each time a stock change occurs, the field 'LastStockChangeDateTIme' will be explicitly updated. The stock change can be the regular stock, but also free stock, future stock etcetera. To synchronize this table with other systems, there is a filter property 'ModifiedStockSinceDateTime' in the StoreProductsFilter object. By using that property, external systems will always have a correct representation of the stock within Retail3000.