So I've been pulling data from various sources to populate my AML/AVL. I processed 150 MSAccess databases from DLA (https://landandmaritimeapps.dla.mil/programs/QmlQpl/ ) which was so questionable data, inconsistent and difficult to work with. IHS BOM Explorer seems to have better data and considering the Windchill extension for this. Now I want to check my results which all resides in the AXLEntry table. Interesting, this object is not listed in QueryBuilder? Its actually 3 object (OEM, Manufacturer and Vendor Part)
Even though it looks like you can access the complete details of the AXLEntry table, it throws an error message: "PropertyDescriptor not found for 'AXLEntry'" which appears to be a dead end (I think).
I worked around this by adding in the other two sudo objects and joining them by the common ID. Now, what's missing is the sourcing status values? What gives? See error above as this attribute is not part of Manufacturer Part Master AXLEntry or Vendor.
I know I can drop to SQL and get this done but my goal is to provide a report that I can see which parts in my PartsLink library are missing AML/AVL entries . Anyone ahead of me on this? Here is what I have so far:
1 ACCEPTED SOLUTION
Accepted Solutions
