Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics RMS (Archived)

Item Type

Posted on by 45

In the item table, there is a field called itemtype, which is used to tell if the item is serailized,matrix, etc...

The item type is an integer like 0 or 1 or 5. I cannot seem to find the table that holds the information telling wha the number is.

Can anyone help me out with this?

Thanks

*This post is locked for comments

  • milesb Profile Picture
    milesb 300 on at
    Re: Re: Re: Item Type

    Chris:

    You're welcome.

    I am pretty sure this is hard coded into the program.  The table I posted is from the data import guide.

    HTH

    Aloha,

    Miles

  • Chris Keller Profile Picture
    Chris Keller 45 on at
    Re: Re: Item Type

    Thank you very much Miles. Is this hard coded data...or is this a table in the dynamics database? I can't seem to find it in there....

    Thanks again!

  • milesb Profile Picture
    milesb 300 on at
    Re: Item Type

    Here you go Chris.

    Value assigned to Item Type

    Item Type
    0 Standard Item
    1 Serialized
    2 Matrix Item
    3 Kit
    4 Lot Matrix Item
    5 Gasoline
    6 Weighed
    7 Non-Inventory
    8 Assembly Item
    9 Voucher

    Aloha,

    Miles

    Pacific Computer Systems

    Miles Baidack

    miles@pacificcomp.biz 

    Supporting Business Since 1985

    Phone: (808)395-8156 or (808)277-8156

     

     

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,253 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans