Visual view of tables and relationships


(system) #1
<!-- #ygrps-yiv-1049555950 _filtered #ygrps-yiv-1049555950 {font-family:Wingdings; panose-1:5 0 0 0 0 0 0 0 0 0;} _filtered #ygrps-yiv-1049555950 {font-family:Wingdings; panose-1:5 0 0 0 0 0 0 0 0 0;} _filtered #ygrps-yiv-1049555950 {font-family:Calibri; panose-1:2 15 5 2 2 2 4 3 2 4;} _filtered #ygrps-yiv-1049555950 {font-family:Tahoma; panose-1:2 11 6 4 3 5 4 4 2 4;} _filtered #ygrps-yiv-1049555950 {font-family:Consolas; panose-1:2 11 6 9 2 2 4 3 2 4;} _filtered #ygrps-yiv-1049555950 {font-family:Verdana; panose-1:2 11 6 4 3 5 4 4 2 4;} #ygrps-yiv-1049555950 #ygrps-yiv-1049555950 p.ygrps-yiv-1049555950MsoNormal, #ygrps-yiv-1049555950 li.ygrps-yiv-1049555950MsoNormal, #ygrps-yiv-1049555950 div.ygrps-yiv-1049555950MsoNormal {margin:0in; margin-bottom:.0001pt; font-size:12.0pt; font-family:"Times New Roman", "serif";} #ygrps-yiv-1049555950 a:link, #ygrps-yiv-1049555950 span.ygrps-yiv-1049555950MsoHyperlink { color:blue; text-decoration:underline;} #ygrps-yiv-1049555950 a:visited, #ygrps-yiv-1049555950 span.ygrps-yiv-1049555950MsoHyperlinkFollowed { color:purple; text-decoration:underline;} #ygrps-yiv-1049555950 p {

margin-right:0in;

margin-left:0in;
font-size:12.0pt;
font-family:“Times New Roman”, “serif”;}
#ygrps-yiv-1049555950 code
{
font-family:“Courier New”;}
#ygrps-yiv-1049555950 pre
{

margin:0in;
margin-bottom:.0001pt;
font-size:10.0pt;
font-family:“Courier New”;}
#ygrps-yiv-1049555950 tt
{
font-family:“Courier New”;}
#ygrps-yiv-1049555950 p.ygrps-yiv-1049555950MsoAcetate, #ygrps-yiv-1049555950 li.ygrps-yiv-1049555950MsoAcetate, #ygrps-yiv-1049555950 div.ygrps-yiv-1049555950MsoAcetate
{

margin:0in;
margin-bottom:.0001pt;
font-size:8.0pt;
font-family:“Tahoma”, “sans-serif”;}
#ygrps-yiv-1049555950 span.ygrps-yiv-1049555950HTMLPreformattedChar
{

font-family:Consolas;}
#ygrps-yiv-1049555950 p.ygrps-yiv-1049555950attach, #ygrps-yiv-1049555950 li.ygrps-yiv-1049555950attach, #ygrps-yiv-1049555950 div.ygrps-yiv-1049555950attach
{

margin-right:0in;

margin-left:0in;
font-size:9.0pt;
font-family:“Arial”, “sans-serif”;}
#ygrps-yiv-1049555950 p.ygrps-yiv-1049555950bold, #ygrps-yiv-1049555950 li.ygrps-yiv-1049555950bold, #ygrps-yiv-1049555950 div.ygrps-yiv-1049555950bold
{

margin-right:0in;

margin-left:0in;
font-size:10.0pt;
font-family:“Arial”, “sans-serif”;
font-weight:bold;}
#ygrps-yiv-1049555950 p.ygrps-yiv-1049555950green, #ygrps-yiv-1049555950 li.ygrps-yiv-1049555950green, #ygrps-yiv-1049555950 div.ygrps-yiv-1049555950green
{

margin-right:0in;

margin-left:0in;
font-size:12.0pt;
font-family:“Times New Roman”, “serif”;
color:#628C2A;}
#ygrps-yiv-1049555950 p.ygrps-yiv-1049555950replbq, #ygrps-yiv-1049555950 li.ygrps-yiv-1049555950replbq, #ygrps-yiv-1049555950 div.ygrps-yiv-1049555950replbq
{
margin:3.0pt;
font-size:12.0pt;
font-family:“Times New Roman”, “serif”;}
#ygrps-yiv-1049555950 p.ygrps-yiv-1049555950ad, #ygrps-yiv-1049555950 li.ygrps-yiv-1049555950ad, #ygrps-yiv-1049555950 div.ygrps-yiv-1049555950ad
{

margin-right:0in;

margin-left:0in;
font-size:12.0pt;
font-family:“Times New Roman”, “serif”;}
#ygrps-yiv-1049555950 p.ygrps-yiv-1049555950underline, #ygrps-yiv-1049555950 li.ygrps-yiv-1049555950underline, #ygrps-yiv-1049555950 div.ygrps-yiv-1049555950underline
{

margin-right:0in;

margin-left:0in;
font-size:12.0pt;
font-family:“Times New Roman”, “serif”;}
#ygrps-yiv-1049555950 span.ygrps-yiv-1049555950yshortcuts
{}
#ygrps-yiv-1049555950 p.ygrps-yiv-1049555950ad1, #ygrps-yiv-1049555950 li.ygrps-yiv-1049555950ad1, #ygrps-yiv-1049555950 div.ygrps-yiv-1049555950ad1
{

margin-right:0in;

margin-left:0in;
font-size:12.0pt;
font-family:“Times New Roman”, “serif”;}
#ygrps-yiv-1049555950 p.ygrps-yiv-1049555950ad2, #ygrps-yiv-1049555950 li.ygrps-yiv-1049555950ad2, #ygrps-yiv-1049555950 div.ygrps-yiv-1049555950ad2
{

margin-right:0in;
margin-bottom:7.5pt;
margin-left:0in;
font-size:12.0pt;
font-family:“Times New Roman”, “serif”;}
#ygrps-yiv-1049555950 p.ygrps-yiv-1049555950underline1, #ygrps-yiv-1049555950 li.ygrps-yiv-1049555950underline1, #ygrps-yiv-1049555950 div.ygrps-yiv-1049555950underline1
{

margin-right:0in;

margin-left:0in;
font-size:12.0pt;
font-family:“Times New Roman”, “serif”;
text-decoration:underline;}
#ygrps-yiv-1049555950 span.ygrps-yiv-1049555950yshortcuts1
{
font-family:“Verdana”, “sans-serif”;
font-weight:bold;}
#ygrps-yiv-1049555950 span.ygrps-yiv-1049555950yshortcuts2
{
font-family:“Verdana”, “sans-serif”;
font-weight:normal;}
#ygrps-yiv-1049555950 span.ygrps-yiv-1049555950BalloonTextChar
{

font-family:“Tahoma”, “sans-serif”;}
#ygrps-yiv-1049555950 span.ygrps-yiv-1049555950EmailStyle36
{
font-family:“Calibri”, “sans-serif”;
color:#1F497D;}
#ygrps-yiv-1049555950 .ygrps-yiv-1049555950MsoChpDefault
{
font-size:10.0pt;}
_filtered #ygrps-yiv-1049555950 {
margin:1.0in 1.0in 1.0in 1.0in;}
#ygrps-yiv-1049555950 div.ygrps-yiv-1049555950WordSection1
{}
#ygrps-yiv-1049555950
_filtered #ygrps-yiv-1049555950 {
}
_filtered #ygrps-yiv-1049555950 {

font-family:Symbol;}
_filtered #ygrps-yiv-1049555950 {

font-family:“Courier New”;
}
_filtered #ygrps-yiv-1049555950 {

font-family:Wingdings;}
_filtered #ygrps-yiv-1049555950 {

font-family:Wingdings;}
_filtered #ygrps-yiv-1049555950 {

font-family:Wingdings;}
_filtered #ygrps-yiv-1049555950 {

font-family:Wingdings;}
_filtered #ygrps-yiv-1049555950 {

font-family:Wingdings;}
_filtered #ygrps-yiv-1049555950 {

font-family:Wingdings;}
_filtered #ygrps-yiv-1049555950 {

font-family:Wingdings;}
#ygrps-yiv-1049555950 ol
{margin-bottom:0in;}
#ygrps-yiv-1049555950 ul
{margin-bottom:0in;}
–>

Epicor stated it is proprietary, so it is not available to customers.

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Cathy
Sent: Wednesday, October 02, 2013 11:59 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] RE: visual view of tables and relationships

 

 

Since Progress holds the schema – does Progress have a visual diagram?  Or can Epicor supply this?

 

I would like to have a visual diagram too.

 

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Karen Schoenung
Sent: Tuesday, October 01, 2013 7:57 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] RE: visual view of tables and relationships

 

 

Thanks for the info Cathy, but really we are looking for a picture…Something like when you see the links in Crystal Reports – showing 4 tables, key fields, how they all link together etc.

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of cathy@…
Sent: Tuesday, October 01, 2013 4:53 PM
To: vantage@yahoogroups.com
Subject: [Vantage] RE: visual view of tables and relationships

 

 

Take a look at table that start with Z.  There is table named ZRelation, ZRelationField.

 

There is ZDataTable, ZDatafield and many other database info table.





—In vantage@yahoogroups.com, <vantage@yahoogroups.com> wrote:

Hi all, does anyone know if there is a visual view to show the tables and relationships for Vantage 8.03.409c sql?  I know there is data dictionary, but I have been asked to see if I can find a visual view of the data structure.


(system) #2

Hi all, does anyone know if there is a visual view to show the tables and relationships for Vantage 8.03.409c sql?  I know there is data dictionary, but I have been asked to see if I can find a visual view of the data structure.


(system) #3

Take a look at table that start with Z.  There is table named ZRelation, ZRelationField.


There is ZDataTable, ZDatafield and many other database info table.




---In vantage@yahoogroups.com, <vantage@yahoogroups.com> wrote:

Hi all, does anyone know if there is a visual view to show the tables and relationships for Vantage 8.03.409c sql?  I know there is data dictionary, but I have been asked to see if I can find a visual view of the data structure.


(system) #4
<!-- #ygrps-yiv-1553809397 _filtered #ygrps-yiv-1553809397 {font-family:Wingdings; panose-1:5 0 0 0 0 0 0 0 0 0;} _filtered #ygrps-yiv-1553809397 {font-family:Wingdings; panose-1:5 0 0 0 0 0 0 0 0 0;} _filtered #ygrps-yiv-1553809397 {font-family:Calibri; panose-1:2 15 5 2 2 2 4 3 2 4;} _filtered #ygrps-yiv-1553809397 {font-family:Tahoma; panose-1:2 11 6 4 3 5 4 4 2 4;} _filtered #ygrps-yiv-1553809397 {font-family:Consolas; panose-1:2 11 6 9 2 2 4 3 2 4;} _filtered #ygrps-yiv-1553809397 {font-family:Verdana; panose-1:2 11 6 4 3 5 4 4 2 4;} #ygrps-yiv-1553809397 #ygrps-yiv-1553809397 p.ygrps-yiv-1553809397MsoNormal, #ygrps-yiv-1553809397 li.ygrps-yiv-1553809397MsoNormal, #ygrps-yiv-1553809397 div.ygrps-yiv-1553809397MsoNormal {margin:0in; margin-bottom:.0001pt; font-size:12.0pt; font-family:"Times New Roman", "serif";} #ygrps-yiv-1553809397 a:link, #ygrps-yiv-1553809397 span.ygrps-yiv-1553809397MsoHyperlink { color:blue; text-decoration:underline;} #ygrps-yiv-1553809397 a:visited, #ygrps-yiv-1553809397 span.ygrps-yiv-1553809397MsoHyperlinkFollowed { color:purple; text-decoration:underline;} #ygrps-yiv-1553809397 p {

margin-right:0in;

margin-left:0in;
font-size:12.0pt;
font-family:“Times New Roman”, “serif”;}
#ygrps-yiv-1553809397 code
{
font-family:“Courier New”;}
#ygrps-yiv-1553809397 pre
{

margin:0in;
margin-bottom:.0001pt;
font-size:10.0pt;
font-family:“Courier New”;}
#ygrps-yiv-1553809397 tt
{
font-family:“Courier New”;}
#ygrps-yiv-1553809397 span.ygrps-yiv-1553809397HTMLPreformattedChar
{

font-family:“Consolas”, “serif”;}
#ygrps-yiv-1553809397 p.ygrps-yiv-1553809397attach, #ygrps-yiv-1553809397 li.ygrps-yiv-1553809397attach, #ygrps-yiv-1553809397 div.ygrps-yiv-1553809397attach
{

margin-right:0in;

margin-left:0in;
font-size:9.0pt;
font-family:“Arial”, “sans-serif”;}
#ygrps-yiv-1553809397 p.ygrps-yiv-1553809397bold, #ygrps-yiv-1553809397 li.ygrps-yiv-1553809397bold, #ygrps-yiv-1553809397 div.ygrps-yiv-1553809397bold
{

margin-right:0in;

margin-left:0in;
font-size:10.0pt;
font-family:“Arial”, “sans-serif”;
font-weight:bold;}
#ygrps-yiv-1553809397 p.ygrps-yiv-1553809397green, #ygrps-yiv-1553809397 li.ygrps-yiv-1553809397green, #ygrps-yiv-1553809397 div.ygrps-yiv-1553809397green
{

margin-right:0in;

margin-left:0in;
font-size:12.0pt;
font-family:“Times New Roman”, “serif”;
color:#628C2A;}
#ygrps-yiv-1553809397 p.ygrps-yiv-1553809397replbq, #ygrps-yiv-1553809397 li.ygrps-yiv-1553809397replbq, #ygrps-yiv-1553809397 div.ygrps-yiv-1553809397replbq
{
margin:3.0pt;
font-size:12.0pt;
font-family:“Times New Roman”, “serif”;}
#ygrps-yiv-1553809397 p.ygrps-yiv-1553809397ad, #ygrps-yiv-1553809397 li.ygrps-yiv-1553809397ad, #ygrps-yiv-1553809397 div.ygrps-yiv-1553809397ad
{

margin-right:0in;

margin-left:0in;
font-size:12.0pt;
font-family:“Times New Roman”, “serif”;}
#ygrps-yiv-1553809397 p.ygrps-yiv-1553809397underline, #ygrps-yiv-1553809397 li.ygrps-yiv-1553809397underline, #ygrps-yiv-1553809397 div.ygrps-yiv-1553809397underline
{

margin-right:0in;

margin-left:0in;
font-size:12.0pt;
font-family:“Times New Roman”, “serif”;}
#ygrps-yiv-1553809397 span.ygrps-yiv-1553809397yshortcuts
{}
#ygrps-yiv-1553809397 p.ygrps-yiv-1553809397ad1, #ygrps-yiv-1553809397 li.ygrps-yiv-1553809397ad1, #ygrps-yiv-1553809397 div.ygrps-yiv-1553809397ad1
{

margin-right:0in;

margin-left:0in;
font-size:12.0pt;
font-family:“Times New Roman”, “serif”;}
#ygrps-yiv-1553809397 p.ygrps-yiv-1553809397ad2, #ygrps-yiv-1553809397 li.ygrps-yiv-1553809397ad2, #ygrps-yiv-1553809397 div.ygrps-yiv-1553809397ad2
{

margin-right:0in;
margin-bottom:7.5pt;
margin-left:0in;
font-size:12.0pt;
font-family:“Times New Roman”, “serif”;}
#ygrps-yiv-1553809397 p.ygrps-yiv-1553809397underline1, #ygrps-yiv-1553809397 li.ygrps-yiv-1553809397underline1, #ygrps-yiv-1553809397 div.ygrps-yiv-1553809397underline1
{

margin-right:0in;

margin-left:0in;
font-size:12.0pt;
font-family:“Times New Roman”, “serif”;
text-decoration:underline;}
#ygrps-yiv-1553809397 span.ygrps-yiv-1553809397yshortcuts1
{
font-family:“Verdana”, “sans-serif”;
font-weight:bold;}
#ygrps-yiv-1553809397 span.ygrps-yiv-1553809397yshortcuts2
{
font-family:“Verdana”, “sans-serif”;
font-weight:normal;}
#ygrps-yiv-1553809397 span.ygrps-yiv-1553809397EmailStyle34
{
font-family:“Calibri”, “sans-serif”;
color:#1F497D;}
#ygrps-yiv-1553809397 .ygrps-yiv-1553809397MsoChpDefault
{
font-size:10.0pt;}
_filtered #ygrps-yiv-1553809397 {
margin:1.0in 1.0in 1.0in 1.0in;}
#ygrps-yiv-1553809397 div.ygrps-yiv-1553809397WordSection1
{}
#ygrps-yiv-1553809397
_filtered #ygrps-yiv-1553809397 {
}
_filtered #ygrps-yiv-1553809397 {

font-family:Symbol;}
_filtered #ygrps-yiv-1553809397 {

font-family:“Courier New”;
}
_filtered #ygrps-yiv-1553809397 {

font-family:Wingdings;}
_filtered #ygrps-yiv-1553809397 {

font-family:Wingdings;}
_filtered #ygrps-yiv-1553809397 {

font-family:Wingdings;}
_filtered #ygrps-yiv-1553809397 {

font-family:Wingdings;}
_filtered #ygrps-yiv-1553809397 {

font-family:Wingdings;}
_filtered #ygrps-yiv-1553809397 {

font-family:Wingdings;}
_filtered #ygrps-yiv-1553809397 {

font-family:Wingdings;}
#ygrps-yiv-1553809397 ol
{margin-bottom:0in;}
#ygrps-yiv-1553809397 ul
{margin-bottom:0in;}
–>

Thanks for the info Cathy, but really we are looking for a picture…Something like when you see the links in Crystal Reports – showing 4 tables, key fields, how they all link together etc.

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of cathy@…
Sent: Tuesday, October 01, 2013 4:53 PM
To: vantage@yahoogroups.com
Subject: [Vantage] RE: visual view of tables and relationships

 

 

Take a look at table that start with Z.  There is table named ZRelation, ZRelationField.

 

There is ZDataTable, ZDatafield and many other database info table.



—In vantage@yahoogroups.com, <vantage@yahoogroups.com> wrote:

Hi all, does anyone know if there is a visual view to show the tables and relationships for Vantage 8.03.409c sql?  I know there is data dictionary, but I have been asked to see if I can find a visual view of the data structure.


(system) #5

Since Progress holds the schema – does Progress have a visual diagram? Or can Epicor supply this?

 

I would like to have a visual diagram too.

 

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Karen Schoenung
Sent: Tuesday, October 01, 2013 7:57 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] RE: visual view of tables and relationships

 

 

Thanks for the info Cathy, but really we are looking for a picture…Something like when you see the links in Crystal Reports – showing 4 tables, key fields, how they all link together etc.

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of cathy@...
Sent: Tuesday, October 01, 2013 4:53 PM
To: vantage@yahoogroups.com
Subject: [Vantage] RE: visual view of tables and relationships

 

 

Take a look at table that start with Z.  There is table named ZRelation, ZRelationField.

 

There is ZDataTable, ZDatafield and many other database info table.




---In vantage@yahoogroups.com, <vantage@yahoogroups.com> wrote:

Hi all, does anyone know if there is a visual view to show the tables and relationships for Vantage 8.03.409c sql?  I know there is data dictionary, but I have been asked to see if I can find a visual view of the data structure.