Skip to main content

Notifications

Microsoft Dynamics RMS forum

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

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,867 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,173 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans