Data Dictionary, Defintion and table for mBOM

[PPuneeth]

Hello Guys, 

I am new to this forum and windchill as well. I am looking for data dictonary, defintion for field attributes and table level information. For instance:- Defintion of Product Code wrt to windchill and which table in windchill contains all mBOM related infromation etc.. I would appreciate if you could help me with this! 

Thanks 

Puneeth

[Rocket_Max · Accepted solution]

Hello @PPuneeth 

Currently, PTC does not have a similar document as it is.

You can refer to the following content to try to obtain the information you need

====================================================================================

Introduction

User can access UML diagrams for desired Windchill types using the following steps:

• Access following URL on your server:https://<HOST_NAME>/Windchill/app/#ptc1/comp/carambola.tools.index_table_for_modeledObjectIndexPage
• Search for Desired Object Type using “Search in table” search box. Example ‘WTPart’
• Click on Information Page of WTPart type
• Select Java Information table > UML Diagram (or desired information about properties and links)

Disclaimer

This requirement is out of the scope of PTC Technical Support

• PTC can't provide any document regarding the Windchill PLM database and data model. It's a PTC proprietary
• There is no such full documentation of all UML diagrams
• PTC does not authorize any reverse engineering against Windchill Database and Java classes

The following articles help with writing customization and business reporting.


Table of content

• General
• Object Reference
• Object relationships
• Preference
• EPM
• WVS
• Principal
• Change objects
• Workflow
• Options and variants
• MPM
• SIM
• Troubleshooting

General

• CS357942  - Windchill Versioning Data Model
• CS253668  - Overview of the meta model and related APIs in Windchill
• CS351959 - Object Relationships for Report Building
• Database Documentation: 
  • Oracle: CS352575 - How to generate Windchill PLM Database Doc for Oracle Database
  • CS51689  - Understanding Database tables relationships to generate Queries or build Reports in Windchill PDMLink

Object Reference

• CS112668  - Object Reference APIs in Windchill
• CS346238  - What's ObjectReference and difference from WTObject in Windchill PDMLink

Link Objects

• CS131357  - Overview of Link objects in Windchill PDMLink

Preferences

• CS64896  - About Preference Database Table in Windchill PDMLink

EPM

• CS119448  - Where to find information about the EPM data model in Windchill PDMLink

WVS

• CS361466  - Windchill PLM Visualization Data Model

Principal

• CS188216  - How to get the UML relation among WTUser/WTPrincipal/WTPrincipalReference objects in Windchill PDMLink?
• CS94037  - What is the relationship between WTUser, remoteobjectinfo and remoteobjectid tables in Windchill PDMLink database

Change Management Objects

• CS63595  - Understanding Change Management objects and their relations in Windchill PDMLink
• CS334442  - Is it possible to determine whether a change object uses the Legacy or Flexible data model through windchill UI in Windchill PDMLink

Workflow

• CS153902  - Windchill Data Model for Workflow related objects in Windchill PDMLink

Options and Variants

• CS357952  - Basic Data Model for O&V basic expression in Windchill PDMLink

MPMLink Enterprise Data

• CS262214  - General documentation on Enterprise Data type used in Windchill MPMLink

SIM

• CS219370  - Need more information about Data Models in Windchill Service Information Manager (SIM)

Troubleshooting

• CS247782  - Data model documentation is not available under codebasewbmhelp in Windchill Bulk Migrator 11.0
• CS52984 - Location of HTML version of UML diagrams in Windchill PDMLink 10.0 (ptc.com)
• CS252190  - Windchill Data Model (Information Model Diagram) documentation is not available.
• CS17170  - Accessing the description of the data model via the UI fails with error in Windchill PDMLink 10.0 C000