Thanks a mil Santosh... So if I understand correctly... TXN.JOURNAL stores only the a/cing entry details for the transactions... but dosent store other updates to various files as it used to happen in F.JOURNAL...
btw, Is there any paramter setting for this file or its updated automatically??? N. On Thu, Apr 23, 2009 at 8:33 PM, Santosh <[email protected]>wrote: > Please find the sample screen shots of TXN.JOURNAL file. > > @ID. > 1*BH0010001*20090308*AC*ONLINE.AC.CLOSURE-405150000*405150000*S*150810001139384.00 > @ID. > 1*BH0010001*20090308*AC*ONLINE.AC.CLOSURE-405150000*405150000*S*150810001139384.00 > @ID. > 1*BH0010001*20090308*FT*FT0906700834*123150000*S*150520006261869.010001 > > @ID. > 1*BH0010001*20090308*FT*FT0906700834*123150000*S*150520006261869.010001 > > @ID. > 1*BH0010001*20090308*FT*FT0906700867*123150000*S*150570006644554.020002 > > @ID. > 1*BH0010001*20090308*FT*FT0906700867*123150000*S*150570006644554.020002 > > @ID. > 1*BH0010001*20090308*FT*FT0906700923*123160000*S*150670008458317.010002 > > @ID. > 1*BH0010001*20090308*FT*FT0906700923*123160000*S*150670008458317.010002 > > @ID. > 1*BH0010001*20090308*FT*FT0906701139*321150001*S*150800004340921.020002 > > @ID. > 1*BH0010001*20090308*FT*FT0906701139*321150001*S*150800004340921.020002 > > > It will maintain for all transactions. (Like LD, FT, MM etc). Based on your > AC.CONSOLIDATE,COND even this file maintains the consolidated entries of > LD/MM records. > > Example of consolidation keys in TXN.JOURNAL: > > @ID. > 1*BH0010001*20090308*LD*!NET!*21071.1002.B*R*R!LD.1.TR.BHD.21071.1002.BH.5Y....1200.3..17.LIVEDB.20100308!DR!BHD!LD!CNW!200903 > > 08!!!1!!!20090308!17!21071 > > @ID. > 1*BH0010001*20090308*LD*!NET!*21071.1002.B*R*R!LD.1.TR.BHD.21071.1002.BH.5Y....1200.3..17.LIVEDB.20100308!DR!BHD!LD!CNW!200903 > > 08!!!1!!!20090308!17!21071 > > (Based on the new accounting behaviour in R8). You can even specify for > how many days you want to maintain. Since its huge file Its advisable to > keep ONLY one day and in T24 we have the Batch job which automatically > clears this file prior to the specified number day (s). > > > > On Thu, Apr 23, 2009 at 7:23 PM, Road Jogger <[email protected]> wrote: > >> What details does it store??? Can we have more details like screen prints >> etc... thanks >> >> >> >> On Thu, Apr 23, 2009 at 5:13 PM, Santosh <[email protected]>wrote: >> >>> Its available from R8. It will be created automatically. Doesnt require >>> any additional setup. Its part of R8 core, maintains for all transactions. >>> >>> >>> On Thu, Apr 23, 2009 at 11:16 AM, Lior-TIS <[email protected]> wrote: >>> >>>> >>>> Hello, >>>> >>>> Is the table TXN.JOURNAL a core table? >>>> If so, at what Globus/T24 version was it introduced? >>>> Would it exist as part of the core or some setup needs to be done? >>>> >>>> Thank you, >>>> Lior >>>> >>>> >>> >>> >>> -- >>> Mobile: 973-39406098 >>> >>> "Nobody can go back and start a new beginning, but anyone can start today >>> and make a new ending" >>> >>> >> >> > > > -- > Mobile: 973-39406098 > > "Nobody can go back and start a new beginning, but anyone can start today > and make a new ending" > > > > --~--~---------~--~----~------------~-------~--~----~ Please read the posting guidelines at: http://groups.google.com/group/jBASE/web/Posting%20Guidelines IMPORTANT: Type T24: at the start of the subject line for questions specific to Globus/T24 To post, send email to [email protected] To unsubscribe, send email to [email protected] For more options, visit this group at http://groups.google.com/group/jBASE?hl=en -~----------~----~----~----~------~----~------~--~---
