[Epicor 9] Table and Field Changes list

I'd ask your CAM and see if you can get something this way. There has to be an internal document.

-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 sysadmin@...
Sent: Monday, September 21, 2009 8:49 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] [Epicor 9] Table and Field Changes list

Thanks, Mark. I've already taken a look at the .df files and if there is
nothing else available, then I guess those will be the resource of choice.
I was just hoping that someone had a spreadsheet or other document listing
the changes.



_____

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Mark Wonsil
Sent: Sunday, September 20, 2009 12:56 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] [Epicor 9] Table and Field Changes list



> Has anyone seen a list of the tables and fields that have
> changed in Epicor
> 9, or can anyone suggest where you can obtain it? It's apparently very
> difficult to find, even for Support. For Vantage 8.03.4xx, it's very
> conveniently located right in Help within the System Overview
> topic, but for Epicor 9, that has changed and it's no longer there.

Not the easiest to read but if you look in the ClientServer\db folder under
Epicor904 folder, you will find the actual SQL statements that upgrade the
database. The files end in .df. There is one file for each level, e.g.
803-300.df, 803-400.df, etc. There are some levels that are not published
versions but they appear to be places holders. For example, there's an
803-500.df.

Mark W.





[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
If this has been discussed previously, I apologize for the repeat.



Has anyone seen a list of the tables and fields that have changed in Epicor
9, or can anyone suggest where you can obtain it? It's apparently very
difficult to find, even for Support. For Vantage 8.03.4xx, it's very
conveniently located right in Help within the System Overview topic, but for
Epicor 9, that has changed and it's no longer there.



Regards,
Scott





[Non-text portions of this message have been removed]
> Has anyone seen a list of the tables and fields that have
> changed in Epicor
> 9, or can anyone suggest where you can obtain it? It's apparently very
> difficult to find, even for Support. For Vantage 8.03.4xx, it's very
> conveniently located right in Help within the System Overview
> topic, but for Epicor 9, that has changed and it's no longer there.

Not the easiest to read but if you look in the ClientServer\db folder under
Epicor904 folder, you will find the actual SQL statements that upgrade the
database. The files end in .df. There is one file for each level, e.g.
803-300.df, 803-400.df, etc. There are some levels that are not published
versions but they appear to be places holders. For example, there's an
803-500.df.

Mark W.
Thanks, Mark. I've already taken a look at the .df files and if there is
nothing else available, then I guess those will be the resource of choice.
I was just hoping that someone had a spreadsheet or other document listing
the changes.



_____

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Mark Wonsil
Sent: Sunday, September 20, 2009 12:56 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] [Epicor 9] Table and Field Changes list



> Has anyone seen a list of the tables and fields that have
> changed in Epicor
> 9, or can anyone suggest where you can obtain it? It's apparently very
> difficult to find, even for Support. For Vantage 8.03.4xx, it's very
> conveniently located right in Help within the System Overview
> topic, but for Epicor 9, that has changed and it's no longer there.

Not the easiest to read but if you look in the ClientServer\db folder under
Epicor904 folder, you will find the actual SQL statements that upgrade the
database. The files end in .df. There is one file for each level, e.g.
803-300.df, 803-400.df, etc. There are some levels that are not published
versions but they appear to be places holders. For example, there's an
803-500.df.

Mark W.





[Non-text portions of this message have been removed]