What table holds the configurator sequence for a part revision?

ERP 10
,
1

Does anyone know what table in the database the configurator sequence is stored?

See the picture below for a part and its sequence. Looking for the table where this is held. We are doing DMTs and we just want to double check that all updated methods generated a configurator sequence after approving the rev. @timshuwy … any ideas?

image
image.jpg892×886 107 KB

2

I think it is PCStruct

3

Sorry, but i am not actually sure… but the thing is, you cannot import the configurator until after the Part Rev/BOM is imported, so the question may not be totally applicable. If you import the configurator first, it will not be connected to the part.

4

We are DMTing methods for parts that contain subconfigurators. When we finish the DMT and approve the methods we notice that sometimes the sequence for the subconfigurators does not get generated… That is why we were looking to see if there was a table that holds the sequence so we could query it and find out if it generated for the methods we approved… Not sure if I am explaining it well enough. But in any case, PCstruct is what we were after. Thanks @timshuwy

1 Like
5

You have to run a bit of code to get to it but here is what I use:

string sConnEpicor = “Data Source=xxxxx;Initial Catalog=xxxxx; User Id=xxxxx;Password=xxxxx; Trusted_Connection=false;”;

string sXML = “”; string sLine = “”; string sPage = “”;

using (System.Data.SqlClient.SqlConnection MyCon = new System.Data.SqlClient.SqlConnection(sConnEpicor))

{

MyCon.Open();

System.Data.SqlClient.SqlCommand oCmd = new System.Data.SqlClient.SqlCommand();

oCmd.Connection = MyCon;

oCmd.CommandText = “select pvs.PageSeq,qd.QuoteNum,qd.QuoteLine,pvs.FieldValues from Epicor10.erp.QuoteDtl qd left join Epicor10.erp.PcValueSet pvs on pvs.GroupSeq = qd.GroupSeq where quotenum = @QuoteNum
and qd.PartNum = ‘Quotable Part’ order by qd.QuoteLine, pvs.PageSeq”;

oCmd.Parameters.AddWithValue(“@QuoteNum”, Inputs.copyQuote.Value);

System.Data.SqlClient.SqlDataReader oReader = oCmd.ExecuteReader();

if (oReader.HasRows)

{

while (oReader.Read())

{

try

{

sXML = oReader[“FieldValues”].ToString();

sLine = oReader[“QuoteLine”].ToString();

sPage = oReader[“PageSeq”].ToString();

System.Xml.XmlDocument xmlDoc = new System.Xml.XmlDocument();

xmlDoc.LoadXml(sXML);

if (sLine == Inputs.copyLine.Value.ToString())

{

if (sPage == “1”)

{

System.Xml.XmlNodeList HPartDesc = xmlDoc.GetElementsByTagName(“HPartDesc”);

Inputs.HPartDesc.Value = HPartDesc[0].InnerText;

System.Xml.XmlNodeList HToolNum = xmlDoc.GetElementsByTagName(“HToolNum”);

Inputs.HToolNum.Value = HToolNum[0].InnerText;

}

catch (Exception e)

{

Inputs.msgForBrenten.Value = e.ToString();

}

} /* oreader */

}

oReader.Close();

MyCon.Close();

}

}

Brenda J. Mohr

Humtown Products

visit us at:
www.humtown.com

image001.jpg