GLRN_RECON_B_VW (SQL View)	Index Back
Account Recon Table Account Reconciliation table - one row for each recon unit of work

GLRN_RECON_B_VW

(SQL View)

Account Recon Table

Account Reconciliation table - one row for each recon unit of work

SELECT DISTINCT GLRN_SET , AS_OF_DATE , BUSINESS_UNIT FROM PS_GLRN_RECON_TBL

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 GLRN_SET Character(20) VARCHAR2(20) NOT NULL Account Reconciliation Set

2 AS_OF_DATE Date(10) DATE As of Date

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	GLRN_SET	Character(20)	VARCHAR2(20) NOT NULL	Account Reconciliation Set
2	AS_OF_DATE	Date(10)	DATE	As of Date
3	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit