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 gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Where is work order # field located?

Status
Not open for further replies.
smtoomey3

smtoomey3

Technical User
Nov 8, 2005
69
US
Does anyone know where the Work order # field is located in the tables, the field I'm referring to is used in the PO Enter Orders Line Item screen.
 
Sort by date Sort by votes
Try shop_ord_no in POORDLIN_SQL.
What version are you using?
Do you know if your screens were customized? Our screen uses the term Shop Order, but internally we use work order and shop order verbally to mean the same thing.
 
Upvote 0 Downvote
Thanks,,,it was actually USER_DEF_FLD_1 but it was in the POORDLIN_SQL table
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

sebastian546
  • Locked
  • Question
order status macola status 1 booked
Replies
1
Views
280
crystalreporting
crystalreporting
prog_0927
  • Locked
  • Question
Status of Order 1
Replies
8
Views
404
dgillz
dgillz
mjbasecamp
  • Locked
  • Question
What is the highest version of SQL Server 2017 CU that Macola Progression 7.9.300 is compatible with
Replies
3
Views
267
dgillz
dgillz
O
  • Locked
  • Question
Flex Issue
Replies
0
Views
252
OrganicByNature
O
Candice71
  • Locked
  • Question
Stocked Flag is Greyed out in Macola
Replies
3
Views
241
dgillz
dgillz

Part and Inventory Search

Sponsor

Back
Top