GL_OPEN_ADJP_VW (SQL View)	Index Back
Adjustment period prompt table Adjustment period prompt table for GL

GL_OPEN_ADJP_VW

(SQL View)

Adjustment period prompt table

Adjustment period prompt table for GL

SELECT BUSINESS_UNIT , LEDGER_GROUP , ACCOUNTING_PERIOD , FISCAL_YEAR , IS_OPEN FROM PS_FIN_OPEN_ADJ WHERE PSFT_PRODUCT = 'GL'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 LEDGER_GROUP Character(10) VARCHAR2(10) NOT NULL Ledger Group

3 ACCOUNTING_PERIOD Number(3,0) SMALLINT NOT NULL Identifies a time period to which you post transactions. Typically, an accounting period represents a month, but it can also represent a week, a day, or any user-defined interval. An accounting period has a beginning date and an ending date, and is defined in the calendar table.

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

5 IS_OPEN Character(1) VARCHAR2(1) NOT NULL Is Open

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
2	LEDGER_GROUP	Character(10)	VARCHAR2(10) NOT NULL	Ledger Group
3	ACCOUNTING_PERIOD	Number(3,0)	SMALLINT NOT NULL	Identifies a time period to which you post transactions. Typically, an accounting period represents a month, but it can also represent a week, a day, or any user-defined interval. An accounting period has a beginning date and an ending date, and is defined in the calendar table.
4	FISCAL_YEAR	Number(4,0)	SMALLINT NOT NULL	Fiscal Year
5	IS_OPEN	Character(1)	VARCHAR2(1) NOT NULL	Is Open