Re: BPCS Database Definition

[JVanover@xxxxxxxxxxxxxxxxx]

Doug,
If the Macola system is ODBC compliant (or uses delimited flat files),
iWork Software has a tool called dcXchange that could be used to convert
the data (as well as 'plug' those fields that are required by BPCS, but are
not currently in Macola).
John Vanover




Please respond to BPCS-L@midrange.com

Sent by:  owner-bpcs-l@midrange.com


To:   <BPCS-L@midrange.com>
Subject:  BPCS Database Definition

Are there any publicly available sources of technical information regarding
BPCS? My interest is in the BPCS AS/400 database definition (DB2?).

The client may have to migrate from a PC-based Macola system to an
AS/400-based BPCS system...

Can anyone help?

Thanks.
--Doug

> -----Original Message-----
> From: owner-bpcs-l@midrange.com [mailto:owner-bpcs-l@midrange.com]On
> Behalf Of Mark Curtis
> Sent: Thursday, February 10, 2000 5:15 AM
> To: BPCS-L@midrange.com
> Subject: RE: Vendor History
>
>
> I just did something similar using APH.
>
> This will of course be based on invoices entered rather than
> say orders
> placed or goods received but I guess that is what you want anyway.
>
> > -----Original Message-----
> > From: owner-bpcs-l@midrange.com [mailto:owner-bpcs-l@midrange.com]On
> > Behalf Of jjpfantz@lozier.com
> > Sent: 09 February 2000 19:26
> > To: BPCS-L@midrange.com
> > Cc: dslic@aol.com
> > Subject: Vendor History
> >
> >
> > We are on V6.0.04 Client/Server on a HP900, Oracle environment.
> >
> > We closed our fiscal year in December 1999 and ran the
> > PUR900/PUR910 jobs to
> > close the month and year.  However, a new project has come up
> > that requires
> > the YTD Purchases for 1999 by supplier (of course they didn't
> > think of this
> > in December).
> >
> > Is there any way to get this information other than restoring
> > the AVM table
> > from the back-up prior to running the year-end close job?
> > +---
> > | This is the BPCS Users Mailing List!
> > | To submit a new message, send your mail to BPCS-L@midrange.com.
> > | To subscribe to this list send email to BPCS-L-SUB@midrange.com.
> > | To unsubscribe from this list send email to
> > BPCS-L-UNSUB@midrange.com.
> > | Questions should be directed to the list owner: dasmussen@aol.com
> > +---
> >
> >
>
>
> +---
> | This is the BPCS Users Mailing List!
> | To submit a new message, send your mail to BPCS-L@midrange.com.
> | To subscribe to this list send email to BPCS-L-SUB@midrange.com.
> | To unsubscribe from this list send email to
> BPCS-L-UNSUB@midrange.com.
> | Questions should be directed to the list owner: dasmussen@aol.com
> +---
>

+---
| This is the BPCS Users Mailing List!
| To submit a new message, send your mail to BPCS-L@midrange.com.
| To subscribe to this list send email to BPCS-L-SUB@midrange.com.
| To unsubscribe from this list send email to BPCS-L-UNSUB@midrange.com.
| Questions should be directed to the list owner: dasmussen@aol.com
+---



+---
| This is the BPCS Users Mailing List!
| To submit a new message, send your mail to BPCS-L@midrange.com.
| To subscribe to this list send email to BPCS-L-SUB@midrange.com.
| To unsubscribe from this list send email to BPCS-L-UNSUB@midrange.com.
| Questions should be directed to the list owner: dasmussen@aol.com
+---