As a follow up for future reference, it looks like the ForeignKey is in the format of:
DemandContractHdr.DemandContractNum~DemandHead.DemandHeadSeq
________________________________
From: NigelK <nigel.kerley@...>
To: vantage@yahoogroups.com
Sent: Wed, March 3, 2010 6:11:53 PM
Subject: [Vantage] Re: Shipto on Demand Header
Â
Success!
It's stored in PatchFld! This table is "Patch Fields. A generic table used to provoide a temporary storage location for new fields that need to be implemented within a patch before a schema change can be made."
You'll need to search on:
Company
TableName = "DemandHead"
FieldName = "ShipToNum"
ForeignKey = seems to equal "1~" + DemandHeadSeq
Then DataCharacter holds the ShipToNum.
Maybe you should phone Epicor and remind them where it is?
Nigel.
DemandContractHdr.DemandContractNum~DemandHead.DemandHeadSeq
________________________________
From: NigelK <nigel.kerley@...>
To: vantage@yahoogroups.com
Sent: Wed, March 3, 2010 6:11:53 PM
Subject: [Vantage] Re: Shipto on Demand Header
Â
Success!
It's stored in PatchFld! This table is "Patch Fields. A generic table used to provoide a temporary storage location for new fields that need to be implemented within a patch before a schema change can be made."
You'll need to search on:
Company
TableName = "DemandHead"
FieldName = "ShipToNum"
ForeignKey = seems to equal "1~" + DemandHeadSeq
Then DataCharacter holds the ShipToNum.
Maybe you should phone Epicor and remind them where it is?
Nigel.
--- In vantage@yahoogroups .com, Steven Gotschall <sgotschall@ ...> wrote:
>
> The shipto table has the list of available shipto addresses for any one customer, but it doesn't tell me which one was selected as the default for any demandhead table. So I can have 500 shipto addresses for a customer, and 20 demand entries against that customer, each of which has a different default shipto set in the Demand header table, but how can I tell which of the 500 has been selected for each demand header? This took me 20 minutes to explain to Epicor Support. The Demand Entry form knows so it must be stored somewhere.
>
>
>
>
> ____________ _________ _________ __
> From: Karen Schoenung <kschoenung@ ...>
> To: vantage@yahoogroups .com
> Sent: Wed, March 3, 2010 2:47:30 PM
> Subject: RE: [Vantage] Re: Shipto on Demand Header
>
> ÂÂ
> Look into the ShipTo table…It is also shown in Service Connect workflow in the DemandHead â€" get list for ShipToService…
>
>
>
> From: vantage@yahoogroups .com [mailto:vantage@ yahoogroups .com] On Behalf Of Steven Gotschall
> Sent: Wednesday, March 03, 2010 1:35 PM
> To: vantage@yahoogroups .com
> Subject: Re: [Vantage] Re: Shipto on Demand Header
>
>
>
>
>
> I came to the same conclusion, but it must be stored somewhere.
>
> ____________ _________ _________ __
> From: NigelK <nigel.kerley@ johnhinde. com <mailto:nigel. kerley%40johnhin de.com> >
> To: vantage@yahoogroups .com <mailto:vantage% 40yahoogroups. com>
> Sent: Wed, March 3, 2010 1:14:28 PM
> Subject: [Vantage] Re: Shipto on Demand Header
>
>
> I've just looked at the database directly and that field definitely isn't in DemandHead.
>
> The form must be using a dataset and that's one of the temporary fields included in it.
>
> Nigel.
>
> --- In vantage@yahoogroups .com, Steven Gotschall <sgotschall@ ...> wrote:
> >
> > Correction. I meant to say:
> >
> > The really strange thing is that if you look at the field on the form in developer mode, it says DemandHead.ShipToNu m. This field also exists in the temp table of the BPM, but if you look at what is stored in it, its not the ShipTo number but the ShipTo ID (character string).
> >
> >
> >
> >
> > ____________ _________ _________ __
> > From: Steven Gotschall <sgotschall@ ...>
> > To: vantage@yahoogroups .com
> > Sent: Wed, March 3, 2010 10:55:03 AM
> > Subject: Re: [Vantage] Re: Shipto on Demand Header
> >
> > Â
> > DemandSchedule. ShipToNum is the specific ship to for a particular schedule. The ShipTo I am referring to is the one you enter in the demand header that then becomes the default for all future schedules against that demand.
> >
> > I just spent an hour on the phone with Epicor support being bounced around until I found someone who understood what I was talking about, but he couldn't give me an answer and had to create an incident for it.
> >
> > The really strange thing is that if you look at the field on the form in developer mode, it says DemandSchedule. ShipToNum. This field also exists in the temp table of the BPM, but if you look at what is stored in it, its not the ShipTo number but the ShipTo ID (character string).
> >
> > ____________ _________ _________ __
> > From: NigelK <nigel.kerley@ johnhinde. com>
> > To: vantage@yahoogroups .com
> > Sent: Wed, March 3, 2010 10:08:05 AM
> > Subject: [Vantage] Re: Shipto on Demand Header
> >
> > Â
> > It's in DemandSchedule. ShipToNum
> >
> > --- In vantage@yahoogroups .com, "Steven" <sgotschall@ ...> wrote:
> > >
> > > Vantage 8.03.408A Progress
> > >
> > > Can anyone tell me which table contains the shipto information for a demand header? You would think it was in the DemandHead table, but I couldn't find it there.
> > >
> >
> > [Non-text portions of this message have been removed]
> >
> >
> >
> >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
> [Non-text portions of this message have been removed]
>
>
>
>
> [Non-text portions of this message have been removed]
>
>
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
[Non-text portions of this message have been removed]