GL_PE_ACTVBD_VW (SQL View)	Index Back
GL Actual Versus Budget GL Actual Versus Budget Pagelet

GL_PE_ACTVBD_VW

(SQL View)

GL Actual Versus Budget

GL Actual Versus Budget Pagelet

SELECT A.FISCAL_YEAR , C.OPRID , A.ACCOUNT , D.DESCR , A.CURRENCY_CD , A.MONETARY_AMOUNT_02 , B.MONETARY_AMOUNT_02 , B.MONETARY_AMOUNT_02 - A.MONETARY_AMOUNT_02 FROM PS_GL_PE_ACT_VW A , PS_GL_PE_BUD_VW B , PS_GL_PE_ACTBD_PRS C , PS_GL_ACCT_ALL_VW D , PS_SET_CNTRL_GROUP E WHERE A.BUSINESS_UNIT = C.BUSINESS_UNIT AND A.OPRID = C.OPRID AND A.FISCAL_YEAR = C.FISCAL_YEAR AND A.LEDGER = C.LEDGER AND B.BUSINESS_UNIT = C.BUSINESS_UNIT AND B.OPRID = C.OPRID AND B.FISCAL_YEAR = C.FISCAL_YEAR AND B.LEDGER = C.LEDGER_2 AND A.ACCOUNT=B.ACCOUNT AND A.CURRENCY_CD = B.CURRENCY_CD AND E.SETCNTRLVALUE = A.BUSINESS_UNIT AND E.REC_GROUP_ID = 'FS_05' AND E.SETID = D.SETID AND D.ACCOUNT = A.ACCOUNT

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 FISCAL_YEAR Number(4,0) SMALLINT NOT NULL Fiscal Year

2 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

3 ACCOUNT Character(10) VARCHAR2(10) NOT NULL Account

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

5 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

6 MONETARY_AMOUNT_01 Signed Number(28,3) DECIMAL(26,3) NOT NULL Specifies the monetary amount of a debit or credit in the business unit base currency. Debit entries are positive and credit entries are negative. This amount is only zero if associated with a statistical account.

7 MONETARY_AMOUNT_02 Signed Number(28,3) DECIMAL(26,3) NOT NULL Specifies the monetary amount of a debit or credit in the business unit base currency. Debit entries are positive and credit entries are negative. This amount is only zero if associated with a statistical account.

8 VAR_AMOUNT_01 Signed Number(28,3) DECIMAL(26,3) NOT NULL Specifies the monetary amount of a debit or credit in the business unit base currency. Debit entries are positive and credit entries are negative. This amount is only zero if associated with a statistical account.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	FISCAL_YEAR	Number(4,0)	SMALLINT NOT NULL	Fiscal Year
2	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
3	ACCOUNT	Character(10)	VARCHAR2(10) NOT NULL	Account
4	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
5	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
6	MONETARY_AMOUNT_01	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Specifies the monetary amount of a debit or credit in the business unit base currency. Debit entries are positive and credit entries are negative. This amount is only zero if associated with a statistical account.
7	MONETARY_AMOUNT_02	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Specifies the monetary amount of a debit or credit in the business unit base currency. Debit entries are positive and credit entries are negative. This amount is only zero if associated with a statistical account.
8	VAR_AMOUNT_01	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Specifies the monetary amount of a debit or credit in the business unit base currency. Debit entries are positive and credit entries are negative. This amount is only zero if associated with a statistical account.