GET DOTACTIV’S STAGING TABLES DOCUMENTATION
DOWNLOAD YOUR COPY OF THE STAGING TABLES DOCUMENTrequired fields *
DOWNLOAD THE STAGING TABLES DOCUMENTATION AND KICKSTART THE DATA INTEGRATION PROCESS
Since you must pull data from your systems and push it into the staging tables we provide, you are responsible for inputting the correct information.
But what data fields do you need to populate? And what are the minimum requirements?
WHAT CAN YOU EXPECT IN THE STATING TABLES DOCUMENTATION?
Formatted in Microsoft Excel, the staging tables documentation details all the necessary data fields you need to populate. The following data fields are included:
1MarketsThis includes fields such as Store ID, Store Name, Retailer Retail Format, Region, Cluster, Market Attributes and more. It is a daily feed.
2ProductsThis includes fields such as Product ID, Product Code, Barcode, Brand, Description, Size Uom and more. It is a daily feed.
3SalesThis includes From Date and To Date, Store ID, Product ID, Sales, Units, Sales at Cost, Ranging Indicator, and Facts. It is a monthly feed.
4Store StockThis includes fields such as a From Date and To Date, Store ID, Product ID, Stock on Hand Cost, Stock Units, and Facts. It is a daily feed.
5DC StockThis includes fields such as a From Date and To Date, Store ID, Product ID, Stock on Hand Cost, Stock Units, and Facts. It is a daily feed.
6Export DataThis includes fields such as Store ID, Product ID, Category, Format, NODs, and Actual Facings. It can be a daily feed or when needed.
BONUSGetting Data Into and Out of DotActiv
Together with the Staging Tables documentation, you'll receive a PDF detailing how to transfer data into and out of DotActiv.