EpiDataViews are used as part of the .NET client framework, and are Epicor extensions of the Microsoft .NET data access framework that Vantage is built on top of. DataViews exist only in the context of the client, and can have additional properties (fields) than the actual underlying database tables. If you go into client customization you'll have to select DataViews to do various things, and you'll see DataViews that have nothing to do with any Vantage tables.
-bws
--
Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix / Picometrix
    bspolarich@... ~ 734-864-5618 ~ www.advancedphotonix.com
-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of howco22
Sent: Wednesday, February 17, 2010 11:42 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Preventing Overshipments
Hi Brian,
Can you explain this a little more? if the fields are not in the OrderDtl table, how would you be able to pull them into the "Dataview"?
-bws
--
Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix / Picometrix
    bspolarich@... ~ 734-864-5618 ~ www.advancedphotonix.com
-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of howco22
Sent: Wednesday, February 17, 2010 11:42 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Preventing Overshipments
Hi Brian,
Can you explain this a little more? if the fields are not in the OrderDtl table, how would you be able to pull them into the "Dataview"?
--- In vantage@yahoogroups.com, "Brian W. Spolarich " <bspolarich@...> wrote:
>
> This would have to be done via a client customization. OurStockShippedQty and OurJobShippedQty are not fields in OrderDtl, but are properties of the DataView exposed by the client program.
>
> -bws
>
> --
> Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix / Picometrix
> Â Â Â Â bspolarich@... ~ 734-864-5618 ~ www.advancedphotonix.com
>
>
> -----Original Message-----
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Sean McDaniel
> Sent: Wednesday, February 17, 2010 7:51 AM
> To: vantage@yahoogroups.com
> Subject: RE: [Vantage] Preventing Overshipments
>
> Hi Brian,
>
> This might be simpler than you think. If you're shipping against a release
> then you'd look at:
>
> Ship Qty > (OurReqQty - OurStockShippedQty - OurJobShippedQty) then throw
> error
>
> --Sean
>
>
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
> Brian W. Spolarich
> Sent: Tuesday, February 16, 2010 4:34 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Preventing Overshipments
>
>
>
>
>
> One of my divisions is looking to implement a rule that would prevent
> an operator from shipping more product to a customer than was requested
> for a given release (don't ask me why, but that's what they want).
>
> This turns out to be moderately complex, since one would potentially
> need to add up any partial shipments against a given release.
>
> I just tried doing a dumb pre-processing BPM on CustShip.Update() with
> this simple query and it didn't do anything:
>
> for each ttShipDtl , each OrderDtl where ttShipDtl.Company =
> OrderDtl.Company and ttShipDtl.OrderNum = OrderDtl.OrderNum and
> ttShipDtl.OrderLine = OrderDtl.OrderLine and
> ttShipDtl.OurInventoryShipQty > OrderDtl.OrderQty no-lock
>
> --
>
> Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix /
> Picometrix
>
> bspolarich@... <mailto:bspolarich%40advancedphotonix.com>
> <mailto:bspolarich@...
> <mailto:bspolarich%40advancedphotonix.com> > ~ 734-864-5618 ~
> www.advancedphotonix.com <http://www.advancedphotonix.com>
>
> [Non-text portions of this message have been removed]
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
>
>
> ------------------------------------
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
> (1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
> (2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
> (3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
>
------------------------------------
Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links