web

You’re offline. This is a read only version of the page.

Dynamics 365 CommunityForums Microsoft Dynamics RMS (Archived) Item Type

Microsoft Dynamics RMS (Archived)

Item Type

(0) Share

Report

Report

Posted on by Chris Keller

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

I have the same question (0)

All responses Img

All responses (3)

Answers Img

Answers (0)

milesb 300 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Chris Keller 45 on at

Like (0)

Report

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!

Was this reply helpful? Yes No
milesb 300 on at

Like (0)

Report

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

Was this reply helpful? Yes No

Helpful resources

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Leaderboard > 🔒一 Microsoft Dynamics RMS (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans