thanks Sebastian. gotcha!
You all are THE best!!! i finally got what i was looking for for so long (ever since our upgrade started) - pls check this out for the tool that can dump JDE file structures into Excel (i tried Xe 7333 and 8.12 as well) - and works great!!!
http://www.geocities.com/tpw_nz/
we have some 40 odd JDE files they use to report off using a third party software. And since the layouts from 7333 has drastically changed in 8.12 - it was really important for me to find this out to simplify our work.
thankyou one and all for helping me out.
FYI... Here is what Oracle got back with (just so you know another workaround) :
ISSUE:
Is it possible to export the specifications of a table to Excel. I would like a spreadsheet that includes the data item, alias, type, size and description information.
SOLUTION:
Within the EnterpriseOne toolset, the functionality is not available to Export table design information to Excel. The only option available for output of the table information is to print the table information from within Table Design Aid. There are several enhancement SARs in the system requesting this ability, but currently the functionality is not available.
As a workaround, create a custom report over the tables that contain the desired table information and then export the report to CSV. For example, the F98711 Central Objects table column contains all the Data Dictionary alias names for the columns in each table. This can be filtered by the TDOBNM column which contains the table name. Once the data dictionary alias is determined, the information regarding the data item type and size can be retrieved from the F9210 Data Field Specifications table. The description of the data item can be retrieved from the F9203 Data Item Alpha Descriptions table. Both of these data items store the data dictionary alias name in the FRDTAI column. Finally, index information for the table can be retrieved from the F98713 Primary Index Detail table. This table contains a record for each index and each column within the index.
This type of report would take advanced knowledge of the EnterpriseOne report writer including the ability to use event rules to perform such functions as Table I/O and business functions. However, once a report was created, it could then be exported to CSV and subsequently opened in Excel.
thanks very much again.
sheeba