Ledgers and Table Changes in PeopleSoft V8'9 - PowerPoint PPT Presentation

1 / 8
About This Presentation
Title:

Ledgers and Table Changes in PeopleSoft V8'9

Description:

PeopleSoft V8.9 allows an unlimited number of ledger groups ... PS Fin Version 7.5 (BCM) APPROP Ledger. PS Fin Version 8.9 (Commitment Control) ... – PowerPoint PPT presentation

Number of Views:41
Avg rating:3.0/5.0
Slides: 9
Provided by: MCG7
Category:

less

Transcript and Presenter's Notes

Title: Ledgers and Table Changes in PeopleSoft V8'9


1
Ledgers and TableChanges inPeopleSoft V8.9
2
Ledgers in PS V7.5
  • APPROP
  • ALLOT (not used)
  • ORG
  • REVEST
  • PROJ_GRT

3
Ledgers in V8.9
  • PeopleSoft V8.9 allows an unlimited number of
    ledger groups
  • In V8.9 there will be the following Ledger
    Groups
  • APPROP -- ORG
  • REVEST -- PROJ_GRT
  • DETAIL
  • PRMST_EXP
  • PRMST_REV

4
Ledger Differences Between V7.5 V8.9
PS Fin Version 7.5 (BCM) APPROP Ledger
PS Fin Version 8.9 (Commitment Control) APPROP
Ledger Group
5
BOR Views to Help with Ledger Changes
  • LEDG_KK_VW_BOR
  • Contains the Budget, Pre-enc, Enc Exp Amts
  • LEDG_KK_VW2_BOR
  • Contains the Budget, Pre-enc, Enc, Exp,
    Recognized Rev and Collected Rev

6
Querying Data
  • If you only need the Expense data, then you can
    just query on LEDGER.
  • To simulate a query in V7.5 with Pre-enc, Enc
    Exp data from LEDGER_BUDG , you would want to
    make the LEDGER_GROUP APPROP in V8.9
  • To simulate a query in V7.5 with Pre-enc, Enc
    Exp data from LEDGER query in V7.5, you would
    want to make the LEDGER_GROUP DETAIL in V8.9

DETAIL
Ledger (Pre-enc Enc)
7
BCM_TRANS_DTL Changes
  • There is not a BCM_TRANS_DTL table any more. The
    data is now divided up into 4 separate tables.
  • KK_SOURCE_HDR
  • KK_SOURCE_LN
  • KK_ACTIVITY_LOG
  • KK_TRANS_LOG
  • BOR Custom View KKACTSRC_VW_BOR . This view
    contains the Pre-enc, Enc, Exp

8
Project Table Differences Between V7.5 V8.9
PS Fin V 7.5 Tables
PS Fin V 8.9 Tables
PROJECT
Project_Header (Information)
PROJECT_MGR
PROJECT_DESCR
Project_Header ()
LEDGER_KK
PRMST_Rev
PRMST_Exp
-- These are Ledger Groups in the Ledger_KK table.
Write a Comment
User Comments (0)
About PowerShow.com