Maybe you know this already but:
1. first two digits are application, i.e. SL=Sales Ledger or
AR
2. if third digit is a p it might be a physical file
3. logicals can have descriptive name, i.e. CUSNAMES
4. logicals can mimic the physical file with and l on the
end followed by a
number, i.e inp35L01
5. Audit files can have a A on the end, i.e. INP35A
Good luck
Doug Griffin
708-261-5300
-----Original Message-----
From: system21-bounces midrange.com
[mailto:system21-bouncesmidrange.com]On Behalf Of
Barbara Byrne
Sent: Wednesday, March 15, 2006 11:44 AM
To: System 21 Users
Subject: Re: [SYSTEM21] Aurora - Database
Ian,
I do not have any manuals, but I have learned how to link by
using AS/400
queries and seeing a list of all fields.
I am not on Aurora yet, but in previous versions GEAC has
been pretty good
about naming fields.
1) Always a company code CONO with file number after eg in
INP35 = CONO35,
INP60 = CONO60, etc
2) Look for similar names such as CUSN for customer number,
SUPN for
supplier, etc
3) Sometimes you get different field names from different
modules, such as
PNUM and CATN for item code but both have the same
description and are same
size and type.
Hope this helps
Barbara
----- Original Message -----
From: "Ian Leafe" <Ian.LeafeEuropeanTele.com>
To: <system21midrange.com>
Sent: Wednesday, March 15, 2006 11:32 AM
Subject: [SYSTEM21] Aurora - Database
> Hi,
> I wonder if anyone can help me, I'm a RPG programmer
who's just started
> working on JBA/Aurora.
>
> I'm trying to work out the linkages between files and
would be very
> grateful if anyone had documents outlining links
between files in the
> database.
>
> I've downloaded some manuals from GEAC website but not
been of great help.
>
> For example PLP15 have a description of Item master had
me thinking!
>
> Did twig eventually!! LOL
>
> I realise being rather cheeky but would very grateful
to receive any
> hints, tips and advice.
>
> Many thanks in anticipation.
>
> Regards
>
> Ian
>
>
> NOTICE AND DISCLAIMER:
>
> This email (including attachments) is confidential. If
you have received
> this email in error please notify the sender
immediately and delete this
> email from your system without copying or disseminating
it or placing any
> reliance upon its contents. We cannot accept liability
for any breaches of
> confidence arising through use of email. Any views or
opinions expressed
> in this message (including attachments) are those of
the author only.
> Furthermore, this message (including any attachment)
does not create any
> legally binding rights or obligations whatsoever, which
may only be
> created by the exchange of hard copy documents signed
by a duly authorized
> representative of Global Telecoms Distribution plc T/A
European Telecom.
> _______________________________________________
> This is the System 21 Users (SYSTEM21) mailing list
> To post a message email: SYSTEM21midrange.com
> To subscribe, unsubscribe, or change list options,
> visit: h
ttp://lists.midrange.com/mailman/listinfo/system21
> or email: SYSTEM21-requestmidrange.com
> Before posting, please take a moment to review the
archives
> at http://archive.
midrange.com/system21.
>
>
_______________________________________________
This is the System 21 Users (SYSTEM21) mailing list
To post a message email: SYSTEM21midrange.com
To subscribe, unsubscribe, or change list options,
visit: h
ttp://lists.midrange.com/mailman/listinfo/system21
or email: SYSTEM21-requestmidrange.com
Before posting, please take a moment to review the archives
at http://archive.
midrange.com/system21.
_______________________________________________
This is the System 21 Users (SYSTEM21) mailing list
To post a message email: SYSTEM21midrange.com
To subscribe, unsubscribe, or change list options,
visit: h
ttp://lists.midrange.com/mailman/listinfo/system21
or email: SYSTEM21-requestmidrange.com
Before posting, please take a moment to review the archives
at http://archive.
midrange.com/system21.
|