GL_BU_S_VW (SQL View)	Index Back
GL BU Search View

GL_BU_S_VW

(SQL View)

GL BU Search View

SELECT A.BUSINESS_UNIT , B.DESCR , B.DESCRSHORT , A.BASE_CURRENCY , A.IU_LEGAL_ENT_BU , A.ELIMS_ONLY , C.GL_UPDATED_BY , C.GL_UPDATED_DTTM , 'A' , ' ' FROM PS_BUS_UNIT_TBL_GL A LEFT OUTER JOIN PS_GL_BU_UPD_VW C ON A.BUSINESS_UNIT=C.BUSINESS_UNIT , PS_BUS_UNIT_TBL_FS B WHERE A.BUSINESS_UNIT=B.BUSINESS_UNIT UNION SELECT A1.BUSINESS_UNIT , B1.DESCR , B1.DESCRSHORT , A1.BASE_CURRENCY , A1.IU_LEGAL_ENT_BU , A1.ELIMS_ONLY , C1.GL_UPDATED_BY , C1.GL_UPDATED_DTTM , 'F' , F.USERID FROM PS_BUS_UNIT_TBL_GL A1 LEFT OUTER JOIN PS_GL_BU_UPD_VW C1 ON A1.BUSINESS_UNIT=C1.BUSINESS_UNIT , PS_BUS_UNIT_TBL_FS B1 , PS_GL_BU_USER_FAV F WHERE A1.BUSINESS_UNIT=B1.BUSINESS_UNIT AND A1.BUSINESS_UNIT=F.BUSINESS_UNIT UNION SELECT A2.BUSINESS_UNIT , B2.DESCR , B2.DESCRSHORT , A2.BASE_CURRENCY , A2.IU_LEGAL_ENT_BU , A2.ELIMS_ONLY , C2.GL_UPDATED_BY , C2.GL_UPDATED_DTTM , 'R' , R.USERID FROM PS_BUS_UNIT_TBL_GL A2 LEFT OUTER JOIN PS_GL_BU_UPD_VW C2 ON A2.BUSINESS_UNIT=C2.BUSINESS_UNIT , PS_BUS_UNIT_TBL_FS B2 , PS_GL_BU_USER_RCT R WHERE A2.BUSINESS_UNIT=B2.BUSINESS_UNIT AND A2.BUSINESS_UNIT=R.BUSINESS_UNIT

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
Prompt Table: SP_BU_GL_NONVW

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

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

4 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. "
Prompt Table: CURRENCY_CD_TBL

5 IU_LEGAL_ENT_BU Character(5) VARCHAR2(5) NOT NULL The business unit that represents the legal entity to which the GL Unit belongs. May have the same value as the GL Unit if it is its own legal entity.
Prompt Table: IU_LEGAL_ENT_VW

6 ELIMS_ONLY Character(1) VARCHAR2(1) NOT NULL For Eliminations Only
Y/N Table Edit

7 GL_UPDATED_BY Character(30) VARCHAR2(30) NOT NULL Updated By

8 GL_UPDATED_DTTM DateTime(26) TIMESTAMP Updated Date/Time

9 GL_LIST_TYPE Character(1) VARCHAR2(1) NOT NULL List type for Favorite, Recent, All
A=All
F=Favorites
R=Recent Updates
Default Value: A

10 USERID Character(30) VARCHAR2(30) NOT NULL A user's ID

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Prompt Table: SP_BU_GL_NONVW
2	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
3	DESCRSHORT	Character(10)	VARCHAR2(10) NOT NULL	Short Description
4	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. " Prompt Table: CURRENCY_CD_TBL
5	IU_LEGAL_ENT_BU	Character(5)	VARCHAR2(5) NOT NULL	The business unit that represents the legal entity to which the GL Unit belongs. May have the same value as the GL Unit if it is its own legal entity. Prompt Table: IU_LEGAL_ENT_VW
6	ELIMS_ONLY	Character(1)	VARCHAR2(1) NOT NULL	For Eliminations Only Y/N Table Edit
7	GL_UPDATED_BY	Character(30)	VARCHAR2(30) NOT NULL	Updated By
8	GL_UPDATED_DTTM	DateTime(26)	TIMESTAMP	Updated Date/Time
9	GL_LIST_TYPE	Character(1)	VARCHAR2(1) NOT NULL	List type for Favorite, Recent, All A=All F=Favorites R=Recent Updates Default Value: A
10	USERID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID