Demand links "make to" field

Yahoo Archive
1
I am not sure if this is for a query or BPM -

So if the TargetJobNum = '' and the ordernum = 0 then it is make to stock -
If OrderNum > 0 then it is Make to order
If TargetJobNum <> '' then it is make to job.

You can have all 3 types for a job, so the JobProd can have many records for 1 job.
2

Looking for the table and field that contains info on demand links from jobs. We used developer mode to try and locate the source but it has a "make to" field listed and we can't find it in any of the related tables. Someone has to have used this info before. Any info or help would be appreciated.


Thanks,

3
JobProd

From: "m.hermes@... [vantage]" <vantage@yahoogroups.com>
To: vantage@yahoogroups.com
Sent: Wednesday, May 28, 2014 4:03 PM
Subject: [Vantage] Demand links "make to" field



Looking for the table and field that contains info on demand links from jobs. We used developer mode to try and locate the source but it has a "make to" field listed and we can't find it in any of the related tables. Someone has to have used this info before. Any info or help would be appreciated.

Thanks,




4

Try the JobProd table.

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Wednesday, May 28, 2014 1:03 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Demand links "make to" field

 

 

           Looking for the table and field that contains info on demand links from jobs. We used developer mode to try and locate the source but it has a "make to" field listed and we can't find it in any of the related tables. Someone has to have used this info before. Any info or help would be appreciated.

 

Thanks,

5
Thanks Ted, we were looking there but couldn't find the "maketo" field. We figured out that it seems to be a calculated field where jobprod.ordernum=0 if anyone was wondering.