407a - embarrassing question

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]
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
Salesrep is the name of the table you are looking for.



The data dictionary viewer under system mgmt is a pretty good tool for
finding data. 80% of the data is pretty logically organized the other 20%
good luck and hats off to you when you find it.



~Charlie

_____

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
leann_37
Sent: Tuesday, July 14, 2009 3:03 PM
To: vantage@yahoogroups.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





[Non-text portions of this message have been removed]
If it is a "canned" epricor report it is probably using a report data
definition and you will have to edit that and then edit the actual crystal
based on the XML the data def. pops off.



~Charlie

_____

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
leann_37
Sent: Tuesday, July 14, 2009 3:03 PM
To: vantage@yahoogroups.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





[Non-text portions of this message have been removed]
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.com [mailto:vantage@yahoogroups.com] On Behalf
Of leann_37
Sent: Tuesday, July 14, 2009 3:03 PM
To: vantage@yahoogroups.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.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
And that was the answer! I knew it me- I added the "e" in the table
name....

Thanks!
- leAnn





From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Vic Drecchio
Sent: Tuesday, July 14, 2009 12:09 PM
To: vantage@yahoogroups.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.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of leann_37
Sent: Tuesday, July 14, 2009 3:03 PM
To: vantage@yahoogroups.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.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/linksYahoo! Groups Links





Click here
<https://www.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]
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.com [mailto:vantage@yahoogroups.com] On Behalf
Of LeAnn Marruffo
Sent: Tuesday, July 14, 2009 4:48 PM
To: vantage@yahoogroups.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.com [mailto:vantage@yahoogroups.com] On Behalf
Of Vic Drecchio
Sent: Tuesday, July 14, 2009 12:09 PM
To: vantage@yahoogroups.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.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of leann_37
Sent: Tuesday, July 14, 2009 3:03 PM
To: vantage@yahoogroups.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.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/linksYahoo! Groups Links





Click here
<https://www.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.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
Can't seem to get that file...



The requested document is not accessible.







From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Vic Drecchio
Sent: Tuesday, July 14, 2009 4:14 PM
To: vantage@yahoogroups.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.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of LeAnn Marruffo
Sent: Tuesday, July 14, 2009 4:48 PM
To: vantage@yahoogroups.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.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Vic Drecchio
Sent: Tuesday, July 14, 2009 12:09 PM
To: vantage@yahoogroups.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.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.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.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.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/linksYahoo! Groups Links

Click here
<https://www.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.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/linksYahoo! Groups Links





[Non-text portions of this message have been removed]
http://tech.groups.yahoo.com/group/vantage/files/

No?

I just tried and was able to re-download.

If you still cannot download email me directly and I will forward the 4MB ZIP file to you directly. vic.drecchio@...



Vic




--- In vantage@yahoogroups.com, "Matt Caldwell" <matt@...> wrote:
>
> Can't seem to get that file...
>
>
>
> The requested document is not accessible.
>
>
>
>
>
>
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> Of Vic Drecchio
> Sent: Tuesday, July 14, 2009 4:14 PM
> To: vantage@yahoogroups.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.com <mailto:vantage%40yahoogroups.com>
> [mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
> Behalf
> Of LeAnn Marruffo
> Sent: Tuesday, July 14, 2009 4:48 PM
> To: vantage@yahoogroups.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.com <mailto:vantage%40yahoogroups.com>
> [mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
> Behalf
> Of Vic Drecchio
> Sent: Tuesday, July 14, 2009 12:09 PM
> To: vantage@yahoogroups.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.com <mailto:vantage%40yahoogroups.com>
> <mailto:vantage%40yahoogroups.com>
> [mailto:vantage@yahoogroups.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.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.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/linksYahoo! Groups Links
>
> Click here
> <https://www.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.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/linksYahoo! Groups Links
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
I got it. Must have been a Chrome thing. Was able to get it with IE.



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Vic D.
Sent: Tuesday, July 14, 2009 4:27 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: 407a - embarrassing question








http://tech.groups.yahoo.com/group/vantage/files/

No?

I just tried and was able to re-download.

If you still cannot download email me directly and I will forward the
4MB ZIP file to you directly. vic.drecchio@...
<mailto:vic.drecchio%40timco.aero>

Vic

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
"Matt Caldwell" <matt@...> wrote:
>
> Can't seem to get that file...
>
>
>
> The requested document is not accessible.
>
>
>
>
>
>
>
> From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
> Of Vic Drecchio
> Sent: Tuesday, July 14, 2009 4:14 PM
> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.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.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
> [mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
> Behalf
> Of LeAnn Marruffo
> Sent: Tuesday, July 14, 2009 4:48 PM
> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.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.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
> [mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
> Behalf
> Of Vic Drecchio
> Sent: Tuesday, July 14, 2009 12:09 PM
> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.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.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
> <mailto:vantage%40yahoogroups.com>
> [mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.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.com <mailto:vantage%40yahoogroups.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.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/linksYahoo! Groups Links
>
> Click here
> <https://www.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.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/linksYahoo! Groups Links
>
>
>
>
>
> [Non-text portions of this message have been removed]
>





[Non-text portions of this message have been removed]
Thanks for the heads up on that on Vic that's pretty cool, who built it?



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Vic Drecchio
Sent: Tuesday, July 14, 2009 4:14 PM
To: vantage@yahoogroups.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.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of LeAnn Marruffo
Sent: Tuesday, July 14, 2009 4:48 PM
To: vantage@yahoogroups.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.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Vic Drecchio
Sent: Tuesday, July 14, 2009 12:09 PM
To: vantage@yahoogroups.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.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.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.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.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/linksYahoo! Groups Links

Click here
<https://www.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.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/linksYahoo! Groups Links





[Non-text portions of this message have been removed]
Yah who maintains that.



~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]