Demantra- Key Tables

DEMANTRA: Key Tables

 Base Tables : 

S.No	Table Name	Important Columns	Description
1	SALES_DATA	ITEM_ID, LOCATION_ID, SALES_DATE	This is the main table which contains all the sales data history and forecast. It also contains any new series you created
2	MDP_MATRIX	ITEM_ID, LOCATION_ID, SALES_DATE, T_EP_ITEM_EP_ID, T_EP_SITE_EP_ID	This is table contains the combinations of item and locations
3	T_EP_ITEMS	T_EP_ITEM_EP_ID, ITEM, DM_ITEM_DESC	Stores the item information
4	T_EP_SITES	T_EP_SITE_EP_ID, SITE, DM_SITE_DESC	States the location/sites information
5	INPUTS	DATET	Contains the time buckets
6	COMPUTED_FIELDS	COMPUTED_NAME, COMPUTED_TITLE,DBNAME	Series definition and its name
7	WF_PROCESS_LOG	SCHEMA_ID, PROCESS_ID	Workflow instances or processes
8	TRANSFER_QUERY	VIEW_NAME, TABLE_NAME, QUERY_NAME, FROM_DATE, UNTIL_DATE	integration interface definitions
9	VERSION_DETAILS	VERSION	Demantra application version details
10	DB_EXCEPTION_LOG	ERR_DATE, PROC_NAME, ERR_MSG	Stores erros if there are any errors in the system
11	NOTES	NOTE_DESC, USER_ID	Notes information
12	WF_SCHEMAS	SCHEMA_NAME	Workflow definition
13	T_EP_EBS_CUST_CLASS	T_EP_CUST_CLASS_EP_ID, EBS_CUST_CLASS, EBS_CUST_CLASS_DESC	Customer Class
14	T_EP_EBS_CUSTOMER	T_EP_EBS_CUSTOMER_EP_ID,EBS_CUSTOMER, EBS_CUSTOMER_DESC	Customer information
15	T_EP_EBS_ACCOUNT	T_EP_EBS_ACCOUNT_EP_ID, EBS_ACCOUNT, EBS_ACCOUNT_DESC	Customer Account information
16	T_EP_ORGANIZATION	T_EP_ORGANIZATION-EP_ID, ORGANIZATION, DM_ORG_DESC	Inventory Organizations
17	T_EP_I_ATT_1	I_ATT_1	Level/Attribute information
18	T_EP_I_ATT_2	I_ATT_2	Level/Attribute information
19	T_EP_I_ATT_3	I_ATT_3	Level/Attribute information
20	T_EP_I_ATT_4	I_ATT_4	Level/Attribute information
21	T_EP_I_ATT_5	I_ATT_5	Level/Attribute information
22	SERIES_GROUPS	GROUP_NAME	Series GroupHeader
23	SERIES_GROUPS_M	SERIES_ID, GROUP_ID	Series group and series

 Interface Tables : 

S.No	Table Name	Important Columns	Description
1	T_SRC_ITEM_TMPL	DM_ITEM_CODE, DM_ITEM_DESC	Interface Table for Items
2	T_SRC_LOC_TMPL	DM_SITE_CODE, DM_SITE_DESC,DM_ORG_CODE, DM_ORG_DESC	Interface Table for Locations
3	T_SRC_SALES_TMPL	DM_ITEM_CODE,DM_SITE_CODE, SALES_DATE,  DM_ORG_CODE,,ACTUAL_QTY, ITEM_PRICE	Interface Tables for sales history data

 Important Procedures :

S.No	Procedure Name	Description
1	EP_LOAD_MAIN	Main procedure which loads all item , locations and sales date into Demantra
2	EP_LOAD_ITEMS	Loads only items
3	EP_LOAD_LOCATIONS	Loads only locations
4	EP_LOAD_SALES	loads only sales data
5	PRE_LOGON	Alter the session to set the language, date format etc