Calc_OpText Field on Job Traveler

Kinetic ERP
, ,
1

I am running into a weird wild goose chase. Does anyone happen to know off the top of your head which table is being used to display the [Calc_OPText] field on the standard Job Traveler SSRS report in Epicor Kinetic? On the RDD I see it as a calculated field under JobOper table and I think it is pulling from the “Operation Text Maintenance” screen but just wondering how it is getting linked up to show on the SSRS. The dataset in SSRS describes it as “T3.Calc_OPText”. I can’t find it under the JobOper table in the data dictionary viewer unless I am overlooking it. I am trying to figure this out on my own but just wondered if anyone knew off the top of your head to steer me in the right direction? I am hoping to be able to add that field to our Job Tracker with a customization if possible.

Thanks,
Chris

2

OpText is in the Operation Maintenance, and it does have to be setup in Operation Text Maintenance. From the help file:

The OpText is intended to be used for things such as creating inspection check off lines on the router.

You can find the OpText linked in the OpMaster table. It is linked by the OpTextID to the OpText table. Technically, the actual OpText is stored in OpText.Description. But this is not the same as the Op Description, so be careful.

3

Thanks for the info Nate. That gave me some more to go off of than I had discovered yet.