Pages

Friday, October 19, 2012

OTM Data Dictionary


OTM Data Dictionary has the list of all OTM database tables and their columns, foreign key references etc,

Data Dictionary can be opened with <OTM_Installation_Directory>/apache/htdocs/html/data_dict/index.html

Below diagram show the various sections of Data Dictionary.


I opened OB_REFNUM table & can see that there is a composite primary key for this table. Also 2 columns are referring to OB_ORDER_BASE & OB_REFNUM_QUAL tables. 

No comments:

Post a Comment