If anyone wants to know, the Price Break info is stored in the "Oprice"
table. Who'd a thunk it?
Thanks for those of you who tried to figure it out.
Todd Hofert
IT Director
Spartan Graphics, Inc.
-----Original Message-----
From:
vantage@yahoogroups.com [mailto:
vantage@yahoogroups.com] On Behalf
Of Shearer, Judd
Sent: Thursday, September 22, 2005 11:28 AM
To:
vantage@yahoogroups.com
Subject: RE: [Vantage] Price Breaks
Found a couple of them. Still looking.
Part/Cust Part Group/Cust
Group
PLPartBrk CustGrupPriceLst
PLGrpBrk
Judd
Custom Hoists, Inc.
-----Original Message-----
From:
vantage@yahoogroups.com [mailto:
vantage@yahoogroups.com] On Behalf
Of Todd Hofert
Sent: Thursday, September 22, 2005 11:06 AM
To:
vantage@yahoogroups.com
Subject: RE: [Vantage] Price Breaks
I am on 6.1.528 and I am going to Order Management/Master File
Maintenance/Price Break.
-----Original Message-----
From:
vantage@yahoogroups.com [mailto:
vantage@yahoogroups.com] On Behalf
Of Shearer, Judd
Sent: Thursday, September 22, 2005 10:59 AM
To:
vantage@yahoogroups.com
Subject: RE: [Vantage] Price Breaks
Todd,
Data out of the plpartbrk table. There is also a group price break
table. What screen do you see your price breaks in?
Company
Discountpercent
Listcode
Partnum
Quantity
Unitprice
0
1
1
745
0
1
5
692
0
1
10
652
0
1
1
781
0
1
5
725
0
1
10
684
0
1
1
817
0
1
5
760
0
1
10
716
Judd
Custom Hoists, Inc.
-----Original Message-----
From:
vantage@yahoogroups.com [mailto:
vantage@yahoogroups.com] On Behalf
Of Todd Hofert
Sent: Thursday, September 22, 2005 10:53 AM
To:
vantage@yahoogroups.com
Subject: RE: [Vantage] Price Breaks
PLPartBrk only contains Price List Items.
-----Original Message-----
From:
vantage@yahoogroups.com [mailto:
vantage@yahoogroups.com] On Behalf
Of Shearer, Judd
Sent: Thursday, September 22, 2005 10:42 AM
To:
vantage@yahoogroups.com
Subject: RE: [Vantage] Price Breaks
PLPARTBRK
Judd
Custom Hoists, Inc.
-----Original Message-----
From:
vantage@yahoogroups.com [mailto:
vantage@yahoogroups.com] On Behalf
Of Todd Hofert
Sent: Thursday, September 22, 2005 10:39 AM
To:
vantage@yahoogroups.com
Subject: [Vantage] Price Breaks
I know it is right in front of me, but I cannot find the table that
Price Breaks are stored in. I found all of the Price List tables but the
Price Break Table/Tables elude me. Can anyone help? I also seem to
remember a discussion where you can find that info from within the entry
screen by some key command or something? Is that true, if so how?
Thanks
Todd Hofert
IT Director
Spartan Graphics, Inc.
This e-mail and any attachments may contain confidential and privileged
information. If you are not the intended recipient, please notify the
sender immediately by return e-mail, delete this e-mail and destroy any
copies. Any dissemination or use of this information by a person other
than the intended recipient is unauthorized and may be illegal.
[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/.
<
http://groups.yahoo.com/group/vantage/files/>
<
http://groups.yahoo.com/group/vantage/files/>
<
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/links
SPONSORED LINKS
Manufacturing software
<
http://groups.yahoo.com/gads?t=ms&k=Manufacturing+software&w1=Manufactu
ring+software&w2=Membership+database+software&w3=Database+mortgage+softw
are&w4=Pda+database+software&w5=Database+management+software&w6=Online+d
atabase+software&c=6&s=185&.sig=AvWEwtBBb2CCZUYeLzjLVQ>
Membership database software
<
http://groups.yahoo.com/gads?t=ms&k=Membership+database+software&w1=Man
ufacturing+software&w2=Membership+database+software&w3=Database+mortgage
+software&w4=Pda+database+software&w5=Database+management+software&w6=On
line+database+software&c=6&s=185&.sig=8uEu2piLZhrmuaS0aRTs5A>
Database mortgage software
<
http://groups.yahoo.com/gads?t=ms&k=Database+mortgage+software&w1=Manuf
acturing+software&w2=Membership+database+software&w3=Database+mortgage+s
oftware&w4=Pda+database+software&w5=Database+management+software&w6=Onli
ne+database+software&c=6&s=185&.sig=WxJOMUVfawa-Spj4srksIw>
Pda database software
<
http://groups.yahoo.com/gads?t=ms&k=Pda+database+software&w1=Manufactur
ing+software&w2=Membership+database+software&w3=Database+mortgage+softwa
re&w4=Pda+database+software&w5=Database+management+software&w6=Online+da
tabase+software&c=6&s=185&.sig=8c6UocdSpoECWlSALplOdQ>
Database management software
<
http://groups.yahoo.com/gads?t=ms&k=Database+management+software&w1=Man
ufacturing+software&w2=Membership+database+software&w3=Database+mortgage
+software&w4=Pda+database+software&w5=Database+management+software&w6=On
line+database+software&c=6&s=185&.sig=C2nNY1SnmwAiBO61ww9nTw>
Online database software
<
http://groups.yahoo.com/gads?t=ms&k=Online+database+software&w1=Manufac
turing+software&w2=Membership+database+software&w3=Database+mortgage+sof
tware&w4=Pda+database+software&w5=Database+management+software&w6=Online
+database+software&c=6&s=185&.sig=cYursVrba9nF7BBMh8EfUA>
________________________________
YAHOO! GROUPS LINKS
* Visit your group "vantage
<
http://groups.yahoo.com/group/vantage> " on the web.
* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:
vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>
* Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service <
http://docs.yahoo.com/info/terms/> .
________________________________
[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/.
<
http://groups.yahoo.com/group/vantage/files/>
<
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/links
Yahoo! Groups Links
This e-mail and any attachments may contain confidential and privileged
information. If you are not the intended recipient, please notify the
sender immediately by return e-mail, delete this e-mail and destroy any
copies. Any dissemination or use of this information by a person other
than the intended recipient is unauthorized and may be illegal.
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/.
<
http://groups.yahoo.com/group/vantage/files/>
<
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/links
SPONSORED LINKS
Manufacturing software
<
http://groups.yahoo.com/gads?t=ms&k=Manufacturing+software&w1=Manufactu
ring+software&w2=Membership+database+software&w3=Database+mortgage+softw
are&w4=Pda+database+software&w5=Database+management+software&w6=Online+d
atabase+software&c=6&s=185&.sig=AvWEwtBBb2CCZUYeLzjLVQ>
Membership database software
<
http://groups.yahoo.com/gads?t=ms&k=Membership+database+software&w1=Man
ufacturing+software&w2=Membership+database+software&w3=Database+mortgage
+software&w4=Pda+database+software&w5=Database+management+software&w6=On
line+database+software&c=6&s=185&.sig=8uEu2piLZhrmuaS0aRTs5A>
Database mortgage software
<
http://groups.yahoo.com/gads?t=ms&k=Database+mortgage+software&w1=Manuf
acturing+software&w2=Membership+database+software&w3=Database+mortgage+s
oftware&w4=Pda+database+software&w5=Database+management+software&w6=Onli
ne+database+software&c=6&s=185&.sig=WxJOMUVfawa-Spj4srksIw>
Pda database software
<
http://groups.yahoo.com/gads?t=ms&k=Pda+database+software&w1=Manufactur
ing+software&w2=Membership+database+software&w3=Database+mortgage+softwa
re&w4=Pda+database+software&w5=Database+management+software&w6=Online+da
tabase+software&c=6&s=185&.sig=8c6UocdSpoECWlSALplOdQ>
Database management software
<
http://groups.yahoo.com/gads?t=ms&k=Database+management+software&w1=Man
ufacturing+software&w2=Membership+database+software&w3=Database+mortgage
+software&w4=Pda+database+software&w5=Database+management+software&w6=On
line+database+software&c=6&s=185&.sig=C2nNY1SnmwAiBO61ww9nTw>
Online database software
<
http://groups.yahoo.com/gads?t=ms&k=Online+database+software&w1=Manufac
turing+software&w2=Membership+database+software&w3=Database+mortgage+sof
tware&w4=Pda+database+software&w5=Database+management+software&w6=Online
+database+software&c=6&s=185&.sig=cYursVrba9nF7BBMh8EfUA>
________________________________
YAHOO! GROUPS LINKS
* Visit your group "vantage
<
http://groups.yahoo.com/group/vantage> " on the web.
* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:
vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>
* Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service <
http://docs.yahoo.com/info/terms/> .
________________________________
[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/.
<
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/links
Yahoo! Groups Links
This e-mail and any attachments may contain confidential and privileged
information. If you are not the intended recipient, please notify the
sender immediately by return e-mail, delete this e-mail and destroy any
copies. Any dissemination or use of this information by a person other
than the intended recipient is unauthorized and may be illegal.
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/.
<
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/links
SPONSORED LINKS
Manufacturing software
<
http://groups.yahoo.com/gads?t=ms&k=Manufacturing+software&w1=Manufactu
ring+software&w2=Membership+database+software&w3=Database+mortgage+softw
are&w4=Pda+database+software&w5=Database+management+software&w6=Online+d
atabase+software&c=6&s=185&.sig=AvWEwtBBb2CCZUYeLzjLVQ>
Membership database software
<
http://groups.yahoo.com/gads?t=ms&k=Membership+database+software&w1=Man
ufacturing+software&w2=Membership+database+software&w3=Database+mortgage
+software&w4=Pda+database+software&w5=Database+management+software&w6=On
line+database+software&c=6&s=185&.sig=8uEu2piLZhrmuaS0aRTs5A>
Database mortgage software
<
http://groups.yahoo.com/gads?t=ms&k=Database+mortgage+software&w1=Manuf
acturing+software&w2=Membership+database+software&w3=Database+mortgage+s
oftware&w4=Pda+database+software&w5=Database+management+software&w6=Onli
ne+database+software&c=6&s=185&.sig=WxJOMUVfawa-Spj4srksIw>
Pda database software
<
http://groups.yahoo.com/gads?t=ms&k=Pda+database+software&w1=Manufactur
ing+software&w2=Membership+database+software&w3=Database+mortgage+softwa
re&w4=Pda+database+software&w5=Database+management+software&w6=Online+da
tabase+software&c=6&s=185&.sig=8c6UocdSpoECWlSALplOdQ>
Database management software
<
http://groups.yahoo.com/gads?t=ms&k=Database+management+software&w1=Man
ufacturing+software&w2=Membership+database+software&w3=Database+mortgage
+software&w4=Pda+database+software&w5=Database+management+software&w6=On
line+database+software&c=6&s=185&.sig=C2nNY1SnmwAiBO61ww9nTw>
Online database software
<
http://groups.yahoo.com/gads?t=ms&k=Online+database+software&w1=Manufac
turing+software&w2=Membership+database+software&w3=Database+mortgage+sof
tware&w4=Pda+database+software&w5=Database+management+software&w6=Online
+database+software&c=6&s=185&.sig=cYursVrba9nF7BBMh8EfUA>
________________________________
YAHOO! GROUPS LINKS
* Visit your group "vantage
<
http://groups.yahoo.com/group/vantage> " on the web.
* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:
vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>
* Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service <
http://docs.yahoo.com/info/terms/> .
________________________________
[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/links
Yahoo! Groups Links
This e-mail and any attachments may contain confidential and privileged
information. If you are not the intended recipient, please notify the
sender immediately by return e-mail, delete this e-mail and destroy any
copies. Any dissemination or use of this information by a person other
than the intended recipient is unauthorized and may be illegal.