Field in view but not in table

Hi All,

E9.05.702A

I am trying to create a method directive that looks up the Invoicing Method on a Project WBS Phase.
The field help says this field is bound to ProjPhase.InvMethod but this field is not in ProjPhase.
In the past, when I’ve encountered this, I would likely find these type of fields in PatchFld but in this case it’s not there.

This value is stored somewhere because if I set it, it’s saved and it’s retrieved if I pull the Project up and I can set it to a different value than the project but I can’t figure out where else to look?

Anyone know of another place I can look?

JOE ROJAS
Epicor Applications Manager
VENTION MEDICAL + DESIGN & DEVELOPMENT
Advancing Your Innovations For Health

261 Cedar Hill Street | Marlborough, MA 01752
DIRECT: 508.597.1392 x1625 | MOBILE: 774.826.9245
EMAIL: JoRojas@ventionmedical.commailto:JoRojas@ventionmedical.com | WEB: ventionmedical.com http://www.ventionmedical.com/

THINK QUALITY. BE QUALITY. GO BEYOND.

This communication may contain information that is confidential, proprietary or exempt from disclosure, and is intended only for the use of the individual and/or entity it is addressed to. If you are not the intended recipient, please note that any other dissemination, distribution, use or copying of this communication is strictly prohibited. If you have received this message in error, please notify the sender immediately by telephone or by return e-mail, and delete this information from your computer.

It’s a Patch Field according to the help

Thanks Jose.
What version is this from?
Mine looks a little different? Either way, this should lead me to the table PatchFld, right?

[cid:image001.png@01D2A2F0.45564C60]

JOE ROJAS
Epicor Applications Manager
VENTION MEDICAL + DESIGN & DEVELOPMENT
DIRECT: 508.597.1392 x1625 | MOBILE: 774.826.9245

What Theme are you using Jose =) w/ colored icons

I may or may not have taken the 9 colorful theme and loaded it back into E10 :slight_smile:
Should work right out of the box (mostly) @hkeric.wci

This is for version 10 but it was likely in the PatchFieldTable in V9 also.

Separately, I would think that PatchField entries should be flushed at the next schema change, no? There’s an obvious performance hit to get to these field values in the PatchField table. At least move them to a UD table for 10+ (EUD for Epicor User-Defined?) which is a more efficient to look up and contains less data in the buffer. Once you’re making schema changes, why not clean it up?

Just curious…

Mark W.

Generally they do. And this one may be fixed in 10.1 but it still references PatchField in the description cause the docs are the last to get updated LoL

1 Like

I’m afraid documentation updates are not just a problem at Epicor… < hangs head in shame… />

#JobSecurity :wink: