SP_BUNGL_CLSVW (SQL View)	Index Back
Netting GL Business Unit View Netting GL Business Unit View

SP_BUNGL_CLSVW

(SQL View)

Netting GL Business Unit View

SELECT DISTINCT C.OPRCLASS , A.BUSINESS_UNIT , B.DESCR , B.DESCRSHORT , A.BASE_CURRENCY FROM PS_BUS_UNIT_TBL_GL A , PS_BUS_UNIT_TBL_FS B , PS_SEC_BU_CLS C WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.BUSINESS_UNIT = C.BUSINESS_UNIT

Related Language Record: NET_GLBU_LNG_VW

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 OPRCLASS Character(30) VARCHAR2(30) NOT NULL Operator Class

2 NETTING_BU Character(5) VARCHAR2(5) NOT NULL Holds GL Business Unit

3 DESCR Character(30) VARCHAR2(30) NOT NULL Description

4 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description

5 BASE_CURRENCY Character(3) VARCHAR2(3) NOT NULL "Specifies the primary currency for a general ledger business unit, and is sometimes referred to as the ""book"" currency. Each business unit has one base currency. which is usually, but not always, the local currency for the organization. Journal entries are posted to a business unit in its base currency. "

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	OPRCLASS	Character(30)	VARCHAR2(30) NOT NULL	Operator Class
2	NETTING_BU	Character(5)	VARCHAR2(5) NOT NULL	Holds GL Business Unit
3	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
4	DESCRSHORT	Character(10)	VARCHAR2(10) NOT NULL	Short Description
5	BASE_CURRENCY	Character(3)	VARCHAR2(3) NOT NULL	"Specifies the primary currency for a general ledger business unit, and is sometimes referred to as the ""book"" currency. Each business unit has one base currency. which is usually, but not always, the local currency for the organization. Journal entries are posted to a business unit in its base currency. "