Know the Members of One Kit Item in Items Table in ODBC

In ODBC there are no columns in the ITEMS table exposed showing that a particular item is a member of a kit/package item. Depending on the customer's business use case, we can suggest them to create a simple Suitescript to automatically generate a query to extract all the member items on a kit/package item  

 

In Suitescript the 'Members' line item is exposed in the 'Kit Item' record.

 

//Create a Suitelet and add the following code.

 

var memberStr = "";

var itemMember = nlapiLoadRecord('kititem', '31');

//just change thekit item's  internal ID

var memberCount = itemMember.getLineItemCount('member')

for(var i = 1; i <= memberCount; i++)

{

                if(i != memberCount)

                {

                                var temp = itemMember.getLineItemValue('member', 'item', i) + ",";

                                memberStr += temp;

                }

                else

                {

                var temp = itemMember.getLineItemValue('member', 'item', i);

                                memberStr += temp;

                }

}

var query = "SELECT * FROM ITEMS WHERE ITEM_ID IN(" + memberStr + ")";

//use the query variable to generate the query for the kit items member