It is all in the PartDtl table.
The specific fields you will be after are PartDtl.JobNum and
PartDtl.PONum
Stuart Noble
Thompson Meat Machinery
-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of laidig.systems
Sent: Tuesday, 13 February 2007 6:59 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Part Activity Table for Crystal
Is there a table in vantage db that contains the number of open jobs
and po's that a part is currently allocated on?
[Non-text portions of this message have been removed]
The specific fields you will be after are PartDtl.JobNum and
PartDtl.PONum
Stuart Noble
Thompson Meat Machinery
-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of laidig.systems
Sent: Tuesday, 13 February 2007 6:59 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Part Activity Table for Crystal
Is there a table in vantage db that contains the number of open jobs
and po's that a part is currently allocated on?
[Non-text portions of this message have been removed]