Does anyone know where this field is in the Epicor database? There is no Part.SubLevelCode and it doesn’t seem to be Part.LowLevelCode (that is something else)
It’s in the data dictionary. I’m on 10.2.200 though. Do you have APS? We don’t, but it still shows up for me.
Huh, it’s not even in our data dictionary! So maybe in Epicor 10.2.xxx they moved it into the Part table? So where does it live on Epicor 10.1.500 I wonder.
Does not seem to be in Ice.PatchFld
what does your field help say?
Not much help I’m afraid. DB Field is blank.
Yeah, it’s not in 10.2.200. must be something that they were working on.
On the explanation side do they have anything that talks about future implementation or anything?
another thing I notice is the external check box is checked on yours and not in mine. (I don’t know what that means, but it’s different)
Well, as far as I know the field is being stored somewhere - it is set to a value on many of our co-parts - a value that is stored somewhere and survives a refresh on part entry - and has been used since the Epicor 9 days for us. It was explained to us way back then (2012-ish) that we needed to use this to ensure that MRP would process the child co-part parts after it processes the parent parts. Nothing in our description text about it being future plan either.
here’s a shot in the dark. If you do a trace when you change it, can you see the parameter in the trace? Maybe that could give you some clues?
Eureka! Thanks for taking the time to bounce those ideas off me Brandon! You gave me the idea to just go straight to the source and do a SQL Profiler trace, watch what happened in the database when I set the SubLevelCode to an unusual value (it only allows 2 digits, so I did “97”).
I searched for 97 in the SQL trace results and found this query:
exec sp_executesql N'update [Erp].[Local001]
set [Number01] = @0
where ([SysRowID] = @1)
select [SysRevID]
from [Erp].[Local001]
where @@ROWCOUNT > 0 and [SysRowID] = @1',N'@0 decimal(20,9),@1 uniqueidentifier',@0=97.000000000,@1='CAD9675B-8B29-308E-E211-A43247B8AF72'
Aha! Erp.Local001 - which is supposedly a localization table? Odd. I tried looking for more results but everything else that had the string “97” in it seemed to be unrelated.
Hmm… I don’t know if this is the right place to look, but the only one I can find currently. It seems to stay perfectly in sync with changes I make to the field in Part Entry too.