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
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
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!
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
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 290,867 Super User 2024 Season 2
Martin Dráb 229,173 Most Valuable Professional
nmaenpaa 101,156