OI_BULEDGRP_VW (SQL View)	Index Back
BU and Ledger Security View BU and Ledger Security View

OI_BULEDGRP_VW

(SQL View)

BU and Ledger Security View

SELECT A.BUSINESS_UNIT , A.LEDGER_GROUP , B.LEDGER , A.DEFAULT_LEDGER_GRP , B.PRIMARY_LEDGER FROM PS_BU_LED_GRP_TBL A , PS_LED_GRP_LED_TBL B , PS_SET_CNTRL_REC C WHERE A.LEDGER_GROUP=B.LEDGER_GROUP AND A.BUSINESS_UNIT=C.SETCNTRLVALUE AND B.SETID=C.SETID AND A.DEFAULT_LEDGER_GRP='Y' AND B.PRIMARY_LEDGER='Y' AND C.RECNAME='LED_GRP_LED_TBL'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

2 LEDGER_GROUP Character(10) VARCHAR2(10) NOT NULL Ledger Group

3 LEDGER Character(10) VARCHAR2(10) NOT NULL Ledger

4 DEFAULT_LEDGER_GRP Character(1) VARCHAR2(1) NOT NULL Jrnl Generator Dflt Ledger Grp

5 PRIMARY_LEDGER Character(1) VARCHAR2(1) NOT NULL A flag that indicates whether or not (Y or N) a ledger is designated as the primary ledger in a ledger group.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
2	LEDGER_GROUP	Character(10)	VARCHAR2(10) NOT NULL	Ledger Group
3	LEDGER	Character(10)	VARCHAR2(10) NOT NULL	Ledger
4	DEFAULT_LEDGER_GRP	Character(1)	VARCHAR2(1) NOT NULL	Jrnl Generator Dflt Ledger Grp
5	PRIMARY_LEDGER	Character(1)	VARCHAR2(1) NOT NULL	A flag that indicates whether or not (Y or N) a ledger is designated as the primary ledger in a ledger group.