I believe that if you look in one of the folders under ClientServer, you'll
find the actual scripts for the schema changes for each version.
Mark W.
find the actual scripts for the schema changes for each version.
Mark W.
On Mon, Jun 13, 2011 at 1:33 PM, Gibson <gibson_west@...> wrote:
>
>
> Thanks Brian,
>
> I think this will help a lot.
>
> Gibson
>
>
> --- In vantage@yahoogroups.com, "Brian Roberts" <broberts@...> wrote:
> >
> > Epicor does provide documentation on the schema changes, but I didn't
> > find it that useful - lots of details, but no explanation of why:
> >
> > https://epicweb.epicor.com/Education/OnlineHelpFeatureSummary/Epicor%209
> > /9.05/enu/Standard/SchemaChanges/SchemaChanges.html
> >
> >
> >
> > I found it more useful to find the info I wanted in the UI, then use
> > Field Help -> Technical Details to find the table & column name. From
> > that starting point I would poke around in the data dictionary or in the
> > BAQ "related tables".
> >
> >
> >
> > I also asked on this list a few times for help :-)
> >
> >
> >
> > And if you're looking at more financial stuff, the other big change is
> > the new TranGLC table. A bunch of transaction stuff has moved from
> > other tables into there.
> >
> >
> >
> > Brian.
> >
> >
> >
> > ________________________________
> >
> > From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> > Of Gibson
> > Sent: Friday, June 10, 2011 3:21 PM
> > To: vantage@yahoogroups.com
> > Subject: [Vantage] Re: Epicor 9.05 database schema changes
> >
> >
> >
> >
> >
> > Thanks for the info Brian.
> >
> > How did you become of aware of the changes in 9.04. Is it documented
> > somewhere. My company never really went to 9.04 in production. We just
> > got to the testing phase and ran into a showstopper that's been fixed in
> > 9.05. So we are converting now from 8.03 passing thru 9.04 to 9.05.
> >
> > Gibson
> >
> > --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
> > "Brian Roberts" <broberts@> wrote:
> > >
> > > The account type codes were replaced by GL Control Codes in 9.04. The
> > > link between things (like vendors) and GL codes are in the EntityGLC
> > > table - filter for RelatedToFile = 'Vendor' and Key1 will be the
> > vendor
> > > number. Note that a particular vendor may not have a GL code assigned,
> > > so use an outer join in your query.
> > >
> > >
> > >
> > > Here's part of a BAQ for customers, should be very similar for
> > vendors:
> > >
> > > for each Customer no-lock , each EntityGLC no-lock outer-join where
> > > (Customer.Company = EntityGLC.Company and Customer.CustNum =
> > > EntityGLC.Key1 ) and EntityGLC.RelatedToFile = 'Customer' And
> > > EntityGLC.GLControlType = 'AR Account' by Customer.CustID .
> > >
> > >
> > >
> > > Brian.
> > >
> > >
> > >
> > > ________________________________
> > >
> > > From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > [mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
> > Behalf
> > > Of Gibson
> > > Sent: Friday, June 10, 2011 12:43 PM
> > > To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > > Subject: [Vantage] Re: Epicor 9.05 database schema changes
> > >
> > >
> > >
> > >
> > >
> > > In 9.04 the field name was obs900_apacctid. We were pulling it from
> > the
> > > Vendor table. It's gone in 9.05 and I cant find any field in 9.05 that
> > > could have relaced it.
> > >
> > > Thanks,
> > > Gibson
> > >
> > > --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > <mailto:vantage%40yahoogroups.com> ,
> > > "Brian Roberts" <broberts@> wrote:
> > > >
> > > > I had to deal with schema changes all the way from 6.1 to 9.05.
> > There
> > > > were a lot of differences, but I was able to find everything I was
> > > > looking for in the end. If the data appears to be gone from the
> > table
> > > > you're looking at, its probably been moved into a child table.
> > > >
> > > >
> > > >
> > > > Which columns are you having trouble finding?
> > > >
> > > > Brian.
> > > >
> > > >
> > > >
> > > > ________________________________
> > > >
> > > > 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 Gibson
> > > > Sent: Thursday, June 09, 2011 5:26 PM
> > > > To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > <mailto:vantage%40yahoogroups.com>
> > > > Subject: [Vantage] Epicor 9.05 database schema changes
> > > >
> > > >
> > > >
> > > >
> > > >
> > > > There are several 9.04 obsolete database columns that have been
> > > deleted
> > > > in 9.05. which we are still making use of. Does anyone know if the
> > > data
> > > > is being eliminated altogether or does 9.05 retain the data under a
> > > new
> > > > column name?
> > > >
> > > > Thanks Gibson
> > > >
> > > >
> > > >
> > > >
> > > >
> > > > [Non-text portions of this message have been removed]
> >
> >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>
[Non-text portions of this message have been removed]