Link between jobs and orders

Yahoo Archive
1
To add to the confusion, the jobprod also goes down to the release level.
However, if a job is created that covers multiple releases for an order then
the release # is not in the JobProd table. This creates a bit of confusion
as when you join an order to the JobProd table, you may need to join the
JobProd in twice - once by company/Order/Line and also by
Company/Order/Line/Release - and then determine later, if there isn't any
info at the release level to then go to the line level.



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Mark Wonsil
Sent: Tuesday, March 16, 2010 8:12 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Link between jobs and orders







>
> I believe it is the jobprod table that is the go between you are looking
for.
>

Like Dennis said, JobProd is the table that links Orders and Jobs.
It is worth noting that this does not have to be a one-to-one
relationship. You can make a Job for ten and have eight go to an order
and to go to stock. You can have a job that fulfills the demand of two
or more orders, etc.





[Non-text portions of this message have been removed]
2
Can someone please explain to me how there is no link between the jobhead table and the orderhead, orderdtl, and orderrel tables? Jobs are created from orders aren't they? So how can they not be linked?
3
I believe it is the jobprod table that is the go between you are looking
for.

Sean Toler wrote:
>
> Can someone please explain to me how there is no link between the
> jobhead table and the orderhead, orderdtl, and orderrel tables? Jobs
> are created from orders aren't they? So how can they not be linked?
>
>
4
>
> I believe it is the jobprod table that is the go between you are looking for.
>


Like Dennis said, JobProd is the table that links Orders and Jobs.
It is worth noting that this does not have to be a one-to-one
relationship. You can make a Job for ten and have eight go to an order
and to go to stock. You can have a job that fulfills the demand of two
or more orders, etc.