Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Shop Order Status View - Operation Info

Status
Not open for further replies.
mlbechard

mlbechard

Programmer
Jun 22, 2009
87
0
0
CA
I am using Macola ES.

I have to create a report and in this report, I have to show the "Actual Hours" values from the "Shop Order Status View - Operation Info" screen (SFOPERNQ). Does anyone know where to find this information in the database?

Thank you
 
Sort by date Sort by votes
Not sure on Macola ES but in Progression it was located in the SFDTLFIL, on Rec_type = 'O' in the field acc_act_lbr_hr.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

sebastian546
  • Locked
  • Question
order status macola status 1 booked
Replies
1
Views
88
crystalreporting
crystalreporting
prog_0927
  • Locked
  • Question
Status of Order 1
Replies
8
Views
133
dgillz
dgillz
prog_0927
  • Locked
  • Question
Status on APOPNHST_SQL Table
Replies
1
Views
64
dgillz
dgillz
LinkMacolaAdmin
  • Locked
  • Question
Shop Floor Order Entry failing due to missing Shop Calendar Detail Record 1
Replies
2
Views
60
LinkMacolaAdmin
LinkMacolaAdmin
prog_0927
  • Locked
  • Question
Move Bulk of Orders to Closed Status
Replies
4
Views
97
crystalreporting
crystalreporting

Part and Inventory Search

Sponsor

Back
Top