Session ticst0402m000:

Has anybody modified this session's report to breakout man and machine hours in the Operating Cost section of the report?

We don't have source code and I have a request to break out the hours and costs by man and machine. I can't see where the session script is pulling its information.


There is another session- Print Actual Costs by Production Order that I could easily alter the report to read from the ticst002 table to get the info but that table lists info by Production order (like the report). The report I need to modify looks at things within a specific tme period.

Any help would be greatly appreciated.

You could run bic_info on the session to get a idea of what tables are used. Maybe ttstpsessinfo also. About the best I can come up with since we are in the same boat as you - no source code. Below is a snippet of what I got using bic_info:


"select ticpr300.*, ticpr300.cpcp:cp.comp, ticpr010.*
from ticpr300

where ticpr300._index1 = {:item.code, "", :copr.indt}
and ticpr300.cpcp refers to ticpr010
and (ticpr010.cref = tccref.chg.material or
ticpr010.cref = tccref.chg.operation)
order by ticpr300._index1
"
"cp.comp"
"select tfgld410.*, tfgld410.cpcp:cp.comp
from tfgld410
where tfgld410._index2 = {:curr.compnr,"", tctror.prd,
:tisfc001.pdno, 0, tcfitr.surcharge}
and tfgld410.line = 0
order by tfgld410._index2
"


Other tables included ticst001 and ticst002. Good Luck!

Mark