Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

What sql table(s) is/are the Item Extended Attributes link to?

Posted on by 100

Looking for particularly the Unavailable Reason

itemExtAttribs.jpg

Thanks for any help available

*This post is locked for comments

  • Verified answer
    VinhTon Profile Picture
    VinhTon 100 on at
    RE: What sql table(s) is/are the Item Extended Attributes link to?

    Thanks for all the insights.

    It comes from

       Table TM_IV001013

       Field [Unavailable Reason]

  • Tim W Profile Picture
    Tim W 2,925 on at
    RE: What sql table(s) is/are the Item Extended Attributes link to?

    You are very close on this, couple things.

    You can see what's in the Launch file (Dynamics.set) through the UI, it's:

    Administration -> Setup -> Edit Launch File to open this window.

    You can scroll through the list to you find the product, it's there somewhere.  Don't change any location values :).

    Then Change the name in the Product box of the window to that product, then browse the series within the product and you should see tables such that you can use the Physical Name field to see the SQL name for that table.  It wont be Dexterity System for series, likely Inventory or Project or whatever...

    You need Product set to the right product, then should be easy enough to find. 

  • VinhTon Profile Picture
    VinhTon 100 on at
    RE: What sql table(s) is/are the Item Extended Attributes link to?

    unintentional duplicate, please delete this reply.

    get denied when I try to delete it myself

  • VinhTon Profile Picture
    VinhTon 100 on at
    RE: What sql table(s) is/are the Item Extended Attributes link to?

    Thanks for the suggestion. I only have remote access to GP so am not able to look in to the dynamics.set file.

    I did look at the Resource descriptions table of the dexterity system. Didn't find the tables listed though

    4604.dexteritySystem.jpg

  • Tim W Profile Picture
    Tim W 2,925 on at
    RE: What sql table(s) is/are the Item Extended Attributes link to?

    Not in a standard GP table.  Looks like you have a one off custom dexterity product built by your VAR or a third party so I'd look in Dynamics.set for a custom dictionary that likely has your company name in it (just a guess), and then you can query against that through the UI to get table information.... then query in SQL.

    Tools -> Resource Descriptions -> Tables   then search the custom product.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans