---
title: Tips & Tricks - Finding Table Specs Without a Dev Client!
description: Discover how to find table specs in JDE EnterpriseOne 9.1 and 9.2 using the Table Definition Inquiry screen without a dev client.
image: https://www.denovo-us.com/hubfs/Blog%20Images/Ask%20Denovo.jpg
---

[![DenovoOracleLogo_White-1](https://www.denovo-us.com/hs-fs/hubfs/DenovoOracleLogo_White-1.png?width=264&height=100&name=DenovoOracleLogo_White-1.png "DenovoOracleLogo_White-1")](https://www.denovo-us.com/)

# Tips & Tricks - Finding Table Specs Without a Dev Client!

Posted: August 7, 2025

Did you know there's an easy way to look up a table's prefix (and all the table specs) right inside JD Edwards? It's available in EnterpriseOne 9.1 and 9.2, and it's in P90U100, the Table Definition Inquiry screen. This is accessible from the web, too! There is no need for a dev machine to get to Table Design ever again! It looks like this:

![](https://www.denovo-us.com/hs-fs/hubfs/image-png-Aug-05-2025-01-36-15-5955-PM.png?width=724&height=328&name=image-png-Aug-05-2025-01-36-15-5955-PM.png)

If you get this error...

![](https://www.denovo-us.com/hs-fs/hubfs/image-png-Aug-05-2025-01-36-32-8985-PM.png?width=451&height=130&name=image-png-Aug-05-2025-01-36-32-8985-PM.png)

...it means your Data Dictionary and Central Objects data source are not in same database. In this case, this application won't work. If this won't work and you don't have access to a dev machine, there's always JDE Tables!

Do you know of any cool tricks like this one that you want Ask Denovo to share with the JDE community? Let us know below!

 

[Ask Denovo](https://www.denovo-us.com/blog/tag/ask-denovo)

### Recent Posts

### Posts by Topic

- [Ask Denovo (212)](https://www.denovo-us.com/blog/tag/ask-denovo)
- [Infrastructure Managed Services (39)](https://www.denovo-us.com/blog/tag/infrastructure-managed-services)
- [Application Managed Services (35)](https://www.denovo-us.com/blog/tag/application-managed-services)
- [Denovo Insights (31)](https://www.denovo-us.com/blog/tag/denovo-insights)
- [Denovo Consulting (4)](https://www.denovo-us.com/blog/tag/denovo-consulting)

### Annual Archives

- [September 2017 (9)](https://www.denovo-us.com/blog/archive/2017/09)
- [October 2017 (7)](https://www.denovo-us.com/blog/archive/2017/10)
- [November 2017 (7)](https://www.denovo-us.com/blog/archive/2017/11)
- [January 2024 (7)](https://www.denovo-us.com/blog/archive/2024/01)
- [May 2024 (7)](https://www.denovo-us.com/blog/archive/2024/05)
- [July 2024 (7)](https://www.denovo-us.com/blog/archive/2024/07)
- [October 2024 (7)](https://www.denovo-us.com/blog/archive/2024/10)
- [April 2025 (7)](https://www.denovo-us.com/blog/archive/2025/04)
- [October 2025 (7)](https://www.denovo-us.com/blog/archive/2025/10)
- [November 2022 (6)](https://www.denovo-us.com/blog/archive/2022/11)
- [November 2023 (6)](https://www.denovo-us.com/blog/archive/2023/11)
- [February 2024 (6)](https://www.denovo-us.com/blog/archive/2024/02)
- [January 2025 (6)](https://www.denovo-us.com/blog/archive/2025/01)
- [July 2017 (5)](https://www.denovo-us.com/blog/archive/2017/07)
- [April 2018 (5)](https://www.denovo-us.com/blog/archive/2018/04)
- [January 2023 (5)](https://www.denovo-us.com/blog/archive/2023/01)
- [June 2023 (5)](https://www.denovo-us.com/blog/archive/2023/06)
- [August 2023 (5)](https://www.denovo-us.com/blog/archive/2023/08)
- [April 2024 (5)](https://www.denovo-us.com/blog/archive/2024/04)
- [June 2024 (5)](https://www.denovo-us.com/blog/archive/2024/06)
- [August 2024 (5)](https://www.denovo-us.com/blog/archive/2024/08)
- [March 2025 (5)](https://www.denovo-us.com/blog/archive/2025/03)
- [May 2025 (5)](https://www.denovo-us.com/blog/archive/2025/05)
- [June 2025 (5)](https://www.denovo-us.com/blog/archive/2025/06)
- [August 2025 (5)](https://www.denovo-us.com/blog/archive/2025/08)
- [January 2026 (5)](https://www.denovo-us.com/blog/archive/2026/01)
- [April 2026 (5)](https://www.denovo-us.com/blog/archive/2026/04)
- [May 2026 (5)](https://www.denovo-us.com/blog/archive/2026/05)
- [June 2026 (5)](https://www.denovo-us.com/blog/archive/2026/06)
- [May 2018 (4)](https://www.denovo-us.com/blog/archive/2018/05)
- [June 2018 (4)](https://www.denovo-us.com/blog/archive/2018/06)
- [July 2018 (4)](https://www.denovo-us.com/blog/archive/2018/07)
- [October 2022 (4)](https://www.denovo-us.com/blog/archive/2022/10)
- [February 2023 (4)](https://www.denovo-us.com/blog/archive/2023/02)
- [March 2023 (4)](https://www.denovo-us.com/blog/archive/2023/03)
- [April 2023 (4)](https://www.denovo-us.com/blog/archive/2023/04)
- [September 2023 (4)](https://www.denovo-us.com/blog/archive/2023/09)
- [October 2023 (4)](https://www.denovo-us.com/blog/archive/2023/10)
- [December 2023 (4)](https://www.denovo-us.com/blog/archive/2023/12)
- [March 2024 (4)](https://www.denovo-us.com/blog/archive/2024/03)
- [September 2024 (4)](https://www.denovo-us.com/blog/archive/2024/09)
- [November 2024 (4)](https://www.denovo-us.com/blog/archive/2024/11)
- [December 2024 (4)](https://www.denovo-us.com/blog/archive/2024/12)
- [February 2025 (4)](https://www.denovo-us.com/blog/archive/2025/02)
- [July 2025 (4)](https://www.denovo-us.com/blog/archive/2025/07)
- [November 2025 (4)](https://www.denovo-us.com/blog/archive/2025/11)
- [December 2025 (4)](https://www.denovo-us.com/blog/archive/2025/12)
- [February 2026 (4)](https://www.denovo-us.com/blog/archive/2026/02)
- [March 2026 (4)](https://www.denovo-us.com/blog/archive/2026/03)
- [December 2017 (3)](https://www.denovo-us.com/blog/archive/2017/12)
- [January 2018 (3)](https://www.denovo-us.com/blog/archive/2018/01)
- [March 2018 (3)](https://www.denovo-us.com/blog/archive/2018/03)
- [August 2019 (3)](https://www.denovo-us.com/blog/archive/2019/08)
- [October 2019 (3)](https://www.denovo-us.com/blog/archive/2019/10)
- [December 2022 (3)](https://www.denovo-us.com/blog/archive/2022/12)
- [May 2023 (3)](https://www.denovo-us.com/blog/archive/2023/05)
- [July 2023 (3)](https://www.denovo-us.com/blog/archive/2023/07)
- [September 2025 (3)](https://www.denovo-us.com/blog/archive/2025/09)
- [February 2018 (2)](https://www.denovo-us.com/blog/archive/2018/02)
- [August 2018 (2)](https://www.denovo-us.com/blog/archive/2018/08)
- [September 2018 (2)](https://www.denovo-us.com/blog/archive/2018/09)
- [November 2019 (2)](https://www.denovo-us.com/blog/archive/2019/11)
- [May 2021 (2)](https://www.denovo-us.com/blog/archive/2021/05)
- [July 2026 (2)](https://www.denovo-us.com/blog/archive/2026/07)
- [December 2018 (1)](https://www.denovo-us.com/blog/archive/2018/12)
- [January 2019 (1)](https://www.denovo-us.com/blog/archive/2019/01)
- [March 2019 (1)](https://www.denovo-us.com/blog/archive/2019/03)
- [September 2019 (1)](https://www.denovo-us.com/blog/archive/2019/09)
- [January 2020 (1)](https://www.denovo-us.com/blog/archive/2020/01)
- [March 2020 (1)](https://www.denovo-us.com/blog/archive/2020/03)
- [March 2021 (1)](https://www.denovo-us.com/blog/archive/2021/03)
- [April 2021 (1)](https://www.denovo-us.com/blog/archive/2021/04)
- [June 2021 (1)](https://www.denovo-us.com/blog/archive/2021/06)
- [August 2021 (1)](https://www.denovo-us.com/blog/archive/2021/08)
- [September 2021 (1)](https://www.denovo-us.com/blog/archive/2021/09)
- [October 2021 (1)](https://www.denovo-us.com/blog/archive/2021/10)
- [November 2021 (1)](https://www.denovo-us.com/blog/archive/2021/11)
- [December 2021 (1)](https://www.denovo-us.com/blog/archive/2021/12)
- [April 2022 (1)](https://www.denovo-us.com/blog/archive/2022/04)
- [September 2022 (1)](https://www.denovo-us.com/blog/archive/2022/09)

[See all](https://www.denovo-us.com/blog/tips-tricks-finding-table-specs-without-a-dev-client#)