MPF Primary Bin Field In 8.03.305K - SQL

Yahoo Archive
1
Many thanks Charles, I had not spotted that... ;o)

Nick

-- In vantage@yahoogroups.com, Charles Carden <ccarden@...> wrote:
>
> The primary bin is stored in the PlantWhse table.
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
Behalf Of nmtaylor1969
> Sent: Monday, August 04, 2008 3:25 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] MPF Primary Bin Field In 8.03.305K - SQL
>
>
> Can anyone tell me in which table the Primary Bin field on the
> Plants : Warehouses : Detail tab within the MPF actually resides
> please...?
>
> Looking at the MPF form it would appear to come from the PartWhse
> datasource, and the PrimBinNum field. I can see that this is in turn
> relating to the WhseBin.BinNum field. But, the PartWhse table does
> not appear to contain any field which holds the primary bin
reference.
>
> Just to make matters more confusing, the service-connect partservice
> returns a part dataset which in turn contains the PartWhse table.
> This does have the PrimBinNum field and works perfectly when I
update
> the field value through code.
>
> I am trying to show this field in a BAQ and of course I can't see
> it...
>
> I am confused...!?
>
> Thanks in advance
>
> Nick
>
>
> ________________________________
> DISCLAIMER:
> This e-mail, including attachments, may include confidential and/or
proprietary information, and may be used only by the person or entity
to which it is addressed. If the reader of this e-mail is not the
intended recipient or his or her authorized agent, the reader is
hereby notified that any dissemination, distribution or copying of
this e-mail is prohibited. If you have received this e-mail in error,
please notify the sender by replying to this message and delete this
e-mail immediately.
>
>
> [Non-text portions of this message have been removed]
>
2
Can anyone tell me in which table the Primary Bin field on the
Plants : Warehouses : Detail tab within the MPF actually resides
please...?

Looking at the MPF form it would appear to come from the PartWhse
datasource, and the PrimBinNum field. I can see that this is in turn
relating to the WhseBin.BinNum field. But, the PartWhse table does
not appear to contain any field which holds the primary bin reference.

Just to make matters more confusing, the service-connect partservice
returns a part dataset which in turn contains the PartWhse table.
This does have the PrimBinNum field and works perfectly when I update
the field value through code.

I am trying to show this field in a BAQ and of course I can't see
it...

I am confused...!?

Thanks in advance

Nick
3
The primary bin is stored in the PlantWhse table.

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of nmtaylor1969
Sent: Monday, August 04, 2008 3:25 PM
To: vantage@yahoogroups.com
Subject: [Vantage] MPF Primary Bin Field In 8.03.305K - SQL


Can anyone tell me in which table the Primary Bin field on the
Plants : Warehouses : Detail tab within the MPF actually resides
please...?

Looking at the MPF form it would appear to come from the PartWhse
datasource, and the PrimBinNum field. I can see that this is in turn
relating to the WhseBin.BinNum field. But, the PartWhse table does
not appear to contain any field which holds the primary bin reference.

Just to make matters more confusing, the service-connect partservice
returns a part dataset which in turn contains the PartWhse table.
This does have the PrimBinNum field and works perfectly when I update
the field value through code.

I am trying to show this field in a BAQ and of course I can't see
it...

I am confused...!?

Thanks in advance

Nick


________________________________
DISCLAIMER:
This e-mail, including attachments, may include confidential and/or proprietary information, and may be used only by the person or entity to which it is addressed. If the reader of this e-mail is not the intended recipient or his or her authorized agent, the reader is hereby notified that any dissemination, distribution or copying of this e-mail is prohibited. If you have received this e-mail in error, please notify the sender by replying to this message and delete this e-mail immediately.


[Non-text portions of this message have been removed]