Demantra tables

a) Staging Tables

select * from t_src_item_tmpl;

select * from t_src_sales_tmpl;

select  * from t_src_loc_tmpl;


b) Patch

select * from version_details_history;


c) Base tables

select * from sales_data;--sales order historical data

select * from mdp_matrix;--combination data

select * from inputs;--time buckets

select * from queries;--worksheets

select * from items;--items

select * from location;--locations


d) Workflow

select * from wf_schemas;

select * from wf_process_log;


e) Integration interface

select * from transfer_query;