Brian,
There are several places that you can find the identity of the files and
their contents. There are also various ways to determine what info you need from
which database. Any experienced BPCS person can help.
Ric Weide
_MisterBPCS@xxxxxxxx (mailto:MisterBPCS@xxxxxxx)
In a message dated 11/15/2007 12:03:24 P.M. Central Standard Time,
bpcs-l-request@xxxxxxxxxxxx writes:
Send BPCS-L mailing list submissions to
bpcs-l@xxxxxxxxxxxx
To subscribe or unsubscribe via the World Wide Web, visit
http://lists.midrange.com/mailman/listinfo/bpcs-l
or, via email, send a message with subject or body 'help' to
bpcs-l-request@xxxxxxxxxxxx
You can reach the person managing the list at
bpcs-l-owner@xxxxxxxxxxxx
When replying, please edit your Subject line so it is more specific
than "Re: Contents of BPCS-L digest..."
*** NOTE: When replying to this digest message, PLEASE remove all text
unrelated to your reply and change the subject line so it is meaningful.
Today's Topics:
1. Tables & Field Names in BPCS 2.1 (Brian Brosch)
2. Re: Tables & Field Names in BPCS 2.1 (Viking Services)
----------------------------------------------------------------------
message: 1
date: Tue, 13 Nov 2007 17:08:56 -0800
from: "Brian Brosch" <Brian_Brosch@xxxxxxxxx>
subject: [BPCS-L] Tables & Field Names in BPCS 2.1
All,
This is a great forum. As an accountant I dontunderstand a lot of what
you guys are saying(too computer smart for me) but Im trying to learn
all I can about this system. It appears to be pretty old, so Im not
certain there is any info available for it any more.
Reading old posts I was able to configure the database for use with
Microsoft Query to enable some custom reporting. I can see the tables
and am successfully seeing data in excel via my queries. The table names
are not very friendly unfortunately. I have located some key tables for
my needs, but Im curious to see if there is an all encompassing list of
tables and their fields so I can determine where best to look to find
certain information. Im mostly interested in the following:
Inventory quantities, part #'s, values
AR & AP open transactions
General Ledger accounts, transactions
Any insight you could provide would be greatly appreciated.
Thanks,
Brian Brosch
------------------------------
message: 2
date: Thu, 15 Nov 2007 14:10:44 +1030
from: "Viking Services" <viking@xxxxxxxxxxxxxxxx>
subject: Re: [BPCS-L] Tables & Field Names in BPCS 2.1
Hi Brian
Comments in original email
Regards Erik
-----Original Message-----
From: bpcs-l-bounces+viking=internode.on.net@xxxxxxxxxxxx
[mailto:bpcs-l-bounces+viking=internode.on.net@xxxxxxxxxxxx] On Behalf Of
Brian Brosch
Sent: Wednesday, 14 November 2007 11:39 AM
To: bpcs-l@xxxxxxxxxxxx
Subject: [BPCS-L] Tables & Field Names in BPCS 2.1
All,
This is a great forum. As an accountant I dontunderstand a lot of what
you guys are saying(too computer smart for me) but Im trying to learn
all I can about this system. It appears to be pretty old, so Im not
certain there is any info available for it any more.
Reading old posts I was able to configure the database for use with
Microsoft Query to enable some custom reporting. I can see the tables
and am successfully seeing data in excel via my queries. The table names
are not very friendly unfortunately. I have located some key tables for
my needs, but Im curious to see if there is an all encompassing list of
tables and their fields so I can determine where best to look to find
certain information. Im mostly interested in the following:
Inventory quantities, part #'s, values IIM,
IWM,IWI,ILI,ITH(Item Master, Warehouse Master, WH/Item Master
Item/Lot
Master(if used),Inventory Transaction Details.
Note! Path XXXL01 will give you
Active records. (Record id exclude IZ, etc)
XXXL02 will give you ALL record (Applies to all Physical files Logical
Paths)
Note also: Current balance has to be
calculated Balance= IOPB-IISSU+IRCT+IADJU
AR & AP open transactions AR --> RCM, RAR (Customer
Master, Receivables Details)
Note! RAR
held Invoice or Creditnote both Original and Remaining
Amoumts on RSEQ (Sequence Number) = 000, Then RSEQ is bumped for
Payments,
Debit Memo, Credit Meno etc
AP--> AVM, APH, APL,
APO (Vendor Master, Invoice header, Invoice Lines and
Invoiced items (for 3-way match))
General Ledger accounts, transactions GGM, GJH, GJD (Account
Combinations w/Period Movements, Journal headers,
Journal details).
Any insight you could provide would be greatly appreciated.
Thanks,
Brian Brosch
midrange.com
