Also can we get the Foreign Key Constraints?
~Charlie
_____
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Rob Bucek
Sent: Tuesday, July 14, 2009 5:49 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] 407a - embarrassing question
Thanks for the heads up on that on Vic that's pretty cool, who built it?
From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
[mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com] On
Behalf
Of Vic Drecchio
Sent: Tuesday, July 14, 2009 4:14 PM
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
Subject: RE: [Vantage] 407a - embarrassing question
If you haven't downloaded the Data Dictionary in HTML format on this
Group's file storage area, then do so ASAP. It's sooooo much easier and
nicer to use than the Data Dictionary in the Vantage UI.
Vic
-----Original Message-----
From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
<mailto:vantage%40yahoogroups.com> ] On
Behalf
Of LeAnn Marruffo
Sent: Tuesday, July 14, 2009 4:48 PM
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
<mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] 407a - embarrassing question
And that was the answer! I knew it me- I added the "e" in the table
name....
Thanks!
- leAnn
From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
<mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Vic Drecchio
Sent: Tuesday, July 14, 2009 12:09 PM
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
<mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] 407a - embarrassing question
Table QSalesRP
mfgsys.QSalesRP
Quote Sales Rep. This table enables multiple salespersons to be linked
to a Quote/Opportunity/Lead
-----Original Message-----
From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
Behalf
Of leann_37
Sent: Tuesday, July 14, 2009 3:03 PM
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: [Vantage] 407a - embarrassing question
All,
Where does Vantage save the salesrepcode as set in a quote? All I can
find is a temp table, but it has to be stored somewhere... My open quote
report is pulling from the customer, which is not always accurate due to
our interesting business process.
Any assistance would be appreciated!
- leAnn
------------------------------------
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. <http://groups.yahoo.com/group/vantage/files/>
yahoo.com/group/vantage/files/.
<http://groups. <http://groups.yahoo.com/group/vantage/files/>
yahoo.com/group/vantage/files/>
<http://groups. <http://groups.yahoo.com/group/vantage/files/>
yahoo.com/group/vantage/files/>
(2) To search through old msg's goto:
http://groups. <http://groups.yahoo.com/group/vantage/messages>
yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups. <http://groups.yahoo.com/group/vantage/linksYahoo>
yahoo.com/group/vantage/linksYahoo! Groups Links
Click here
<https://www. <https://www.mailcontrol.com/sr/wQw0zmjPoHdJTZGyOCrrhg==>
mailcontrol.com/sr/wQw0zmjPoHdJTZGyOCrrhg==
Xw!S+MISS+x02lM6YDDSETT2YbQP4BOUW3EAI1jSF4rfTg==> to report this email
as spam.
This message has been scanned for malware by SurfControl plc.
www.surfcontrol.com
[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. <http://groups.yahoo.com/group/vantage/files/>
yahoo.com/group/vantage/files/.
<http://groups. <http://groups.yahoo.com/group/vantage/files/>
yahoo.com/group/vantage/files/>
(2) To search through old msg's goto:
http://groups. <http://groups.yahoo.com/group/vantage/messages>
yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups. <http://groups.yahoo.com/group/vantage/linksYahoo>
yahoo.com/group/vantage/linksYahoo! Groups Links
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
~Charlie
_____
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Rob Bucek
Sent: Tuesday, July 14, 2009 5:49 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] 407a - embarrassing question
Thanks for the heads up on that on Vic that's pretty cool, who built it?
From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
[mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com] On
Behalf
Of Vic Drecchio
Sent: Tuesday, July 14, 2009 4:14 PM
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
Subject: RE: [Vantage] 407a - embarrassing question
If you haven't downloaded the Data Dictionary in HTML format on this
Group's file storage area, then do so ASAP. It's sooooo much easier and
nicer to use than the Data Dictionary in the Vantage UI.
Vic
-----Original Message-----
From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
<mailto:vantage%40yahoogroups.com> ] On
Behalf
Of LeAnn Marruffo
Sent: Tuesday, July 14, 2009 4:48 PM
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
<mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] 407a - embarrassing question
And that was the answer! I knew it me- I added the "e" in the table
name....
Thanks!
- leAnn
From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
<mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Vic Drecchio
Sent: Tuesday, July 14, 2009 12:09 PM
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
<mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] 407a - embarrassing question
Table QSalesRP
mfgsys.QSalesRP
Quote Sales Rep. This table enables multiple salespersons to be linked
to a Quote/Opportunity/Lead
-----Original Message-----
From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
Behalf
Of leann_37
Sent: Tuesday, July 14, 2009 3:03 PM
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: [Vantage] 407a - embarrassing question
All,
Where does Vantage save the salesrepcode as set in a quote? All I can
find is a temp table, but it has to be stored somewhere... My open quote
report is pulling from the customer, which is not always accurate due to
our interesting business process.
Any assistance would be appreciated!
- leAnn
------------------------------------
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. <http://groups.yahoo.com/group/vantage/files/>
yahoo.com/group/vantage/files/.
<http://groups. <http://groups.yahoo.com/group/vantage/files/>
yahoo.com/group/vantage/files/>
<http://groups. <http://groups.yahoo.com/group/vantage/files/>
yahoo.com/group/vantage/files/>
(2) To search through old msg's goto:
http://groups. <http://groups.yahoo.com/group/vantage/messages>
yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups. <http://groups.yahoo.com/group/vantage/linksYahoo>
yahoo.com/group/vantage/linksYahoo! Groups Links
Click here
<https://www. <https://www.mailcontrol.com/sr/wQw0zmjPoHdJTZGyOCrrhg==>
mailcontrol.com/sr/wQw0zmjPoHdJTZGyOCrrhg==
Xw!S+MISS+x02lM6YDDSETT2YbQP4BOUW3EAI1jSF4rfTg==> to report this email
as spam.
This message has been scanned for malware by SurfControl plc.
www.surfcontrol.com
[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. <http://groups.yahoo.com/group/vantage/files/>
yahoo.com/group/vantage/files/.
<http://groups. <http://groups.yahoo.com/group/vantage/files/>
yahoo.com/group/vantage/files/>
(2) To search through old msg's goto:
http://groups. <http://groups.yahoo.com/group/vantage/messages>
yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups. <http://groups.yahoo.com/group/vantage/linksYahoo>
yahoo.com/group/vantage/linksYahoo! Groups Links
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]