Re: Cutting down GL records -archiving/purging

Hello Wendy

(LX Based) In GXR you can see these fields:

N.CampoKey A/D Descrizione                           P.Inz. Bytes Tp Int Dec 
XREVNT       Transaction Number                           5     8  P  15   0
XRJNEN       Journal Entry Number                        36     9  O
XRJSEQ       Unique Sequence Nbr(ITH/GXR)              1098     9  P  16   0

These Fields link all the proper table of the subsystem (G**).

GXR links also RAR/RTX/SIH/SIL/Etc.   

When you clean any GXR, take care of all the other, with proper relations, 
according your needs.

Good luck

Davide


-----Original Message-----
From: bpcs-l-bounces+davide.roveda=ssaglobal.com@xxxxxxxxxxxx 
[mailto:bpcs-l-bounces+davide.roveda=ssaglobal.com@xxxxxxxxxxxx] On Behalf Of 
Bunch, Wendy
Sent: giovedì 15 giugno 2006 16.31
To: bpcs-l@xxxxxxxxxxxx
Subject: [BPCS-L] Cutting down GL records -archiving/purging

We are converting from 6.1.2 to 8.2 -- test conversion took too long.  IT is 
looking at reducing some records so conversion goes faster.

Among other items - they are asking us to reduce our GL files.  Accounting of 
course does not want to give anything up.  Trying to find a middle of the road. 
 I have inquired to SSA.  Basically no tools for archiving CEA in our version, 
but 8.2 does have tools and even the option of purging the detail and leaving 
the balances - so multi-year trends/comparison would still work.  One file is 
much larger than all the rest: GXR - Journal Entry Cross reference.  From what 
I've been able to gather this only comes into play as you continue to drill 
down in Account Inquiry.  Is this true from your experience?  We have most of 
the details to cross reference pulled in with the model lines/detail/analysis 
fields - so we nearly never drill down that far.   Can you think of any impacts 
- good bad or other wise if we were to reduce this one table GXR and leave the 
rest of the Gxx tables alone?

Wendy Bunch
This is an e-mail from Wabash Technologies, Incorporated.
It is confidential to the ordinary user of the above e-mail address.
It may contain copyright and/or legally privileged information.
No other person may read, print, store, copy, forward,
or act in reliance on it or its attachments.  If you received this in error, 
please e-mail to humanresources@xxxxxxxxxxxxxx