cancel
Showing results for 
Search instead for 
Did you mean: 

Field Names Not Found in Item Table Properties

Former Member
0 Kudos

Please note that the following field names cannot be found in the Table Object properties but can be found in the database table for the Item table.

ItemType within Item Heading

ReorderQty within Inventory Data -

this is called Required Stock Level on Inventory scrn.

MinOrdrQty - Minimum Ordered Qty on Planning scrn.

Please advise. Thanks!

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

What kind of advice you need?

Former Member
0 Kudos

Sorry, can you please give me the property name for the Item Type as I can't find it.

Also, re MinOrdrQty, please let me know the name of the Minimum Ordered Quantity property if it is available.

Thanks.

Eneveux
Product and Topic Expert
Product and Topic Expert
0 Kudos

Satish,

The Item Type property in the "Items" Object is "ItemType". This is in the 2005A version of the Business One SDK. The Item Type does not seem to be available in the 2004A version of the Business One SDK. The MinOrdrQty is also a property available with the 2005A SDK. Apologies for any confusion.

HTH,

Eddy

Former Member
0 Kudos

Re Item ReorderQty, please advise if this will be available in Version 2005A of B1 SDK as well.

Many thanks,

Eric

Answers (1)

Answers (1)

Eneveux
Product and Topic Expert
Product and Topic Expert
0 Kudos

Satish,

The ItemType property is available for the Items Object. As far as the ReOrderQty ... this does not seem to be available as a property. If you must use these properties in your add-on, you could go to the Db directly as they are in the appropriate tables HOWEVER, this is not a recommended approach as data corruption could occur as well as SAP will not certify a solution that used direct table access to the Db. You could put in a request via SAP Support for these properties to be added in coming versions of the DI API.

HTH,

Eddy