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

NET_GLBU_LNG_VW

(SQL View)

Netting GL Business Unit View

SELECT DISTINCT A.BUSINESS_UNIT , B2.LANGUAGE_CD , B2.DESCR , B2.DESCRSHORT , A.BASE_CURRENCY FROM PS_BUS_UNIT_TBL_GL A , PS_BUS_UNIT_TBL_FS B , PS_BUS_UNIT_LANG B2 WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND B2.BUSINESS_UNIT = B.BUSINESS_UNIT

Related Language Record for NET_GL_BU_VW SP_BUNGL_CLSVW SP_BUNGL_NONVW SP_BUNGL_OPRVW

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code

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	NETTING_BU	Character(5)	VARCHAR2(5) NOT NULL	Holds GL Business Unit
2	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
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. "