When a Patch field isn't in PatchFld

Hello,

E9.05.702A

I am trying to create a BAQ that shows the order number and order line associated with a Project WBS Phase.
In project entry, I can see these values on the WBS Phases → Invoicing and Recognition tab but cannot find these fields in the ProjPhase table.
Field help is telling me that the field is an “External” field and the description says, for example “Order Number (Patch field)”.
When I look in the PatchFld table, there is no records for the ProjPhase and no other table seems to make sense for storing these fields.

So my question is, where the heck is Epicor storing the data for these fields?

JOE ROJAS
Epicor Applications Manager
VENTION MEDICAL
A NORDSON COMPANY

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/

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.

Would this link not be to PBGInvcHead? I have been spending more time in E10, which has changed how this was stored, so could be wrong. In E10 this was changed to be saved in ProjPhase.

PBGInvcHead would only exist after generating an Invoice.
I looking to connect WBS Project Phase to the associated sales order.

JOE ROJAS
Epicor Applications Manager
VENTION MEDICAL
A NORDSON COMPANY
DIRECT: 508.597.1392 x1625 | MOBILE: 774.826.9245

With E9 it looks like you have to use Local001. Seems odd but only linkage that I can see pre-invoice.

Hi Dan,

I checked out this table and I can see the ProjPhase records but there is no indication of the order number.

JOE ROJAS
Epicor Applications Manager
VENTION MEDICAL
A NORDSON COMPANY
DIRECT: 508.597.1392 x1625 | MOBILE: 774.826.9245

Number01 is the order number and Number02 is the line number.

Wow! This is awesome Dan.
Thanks so much for your help. We’ve been trying to figure this out for some time now and support has been unable to answer.

JOE ROJAS
Epicor Applications Manager
VENTION MEDICAL
A NORDSON COMPANY
DIRECT: 508.597.1392 x1625 | MOBILE: 774.826.9245

Awesome, glad I could help.