GL_PE_02_PRS

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
2	INQUIRY	Character(10)	VARCHAR2(10) NOT NULL	Inquiry Name
3	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT Prompt Table: SP_BU_GL_NONVW
4	COMMITMENT_CNTL	Character(1)	VARCHAR2(1) NOT NULL	Enable Commitment Control Y/N Table Edit Default Value: N
5	LEDGER_TYPE_KK_L2	Character(1)	VARCHAR2(1) NOT NULL	Include Encumbrance Y/N Table Edit Default Value: N
6	LEDGER_TYPE_KK_L3	Character(1)	VARCHAR2(1) NOT NULL	Include Pre-Encumbrance Y/N Table Edit Default Value: N
7	LEDGER_GROUP	Character(10)	VARCHAR2(10) NOT NULL	Ledger Group Prompt Table: SP_BULGPK_NONVW
8	LEDGER	Character(10)	VARCHAR2(10) NOT NULL	Ledger Prompt Table: SP_BUBUDL_NONVW
9	RECNAME	Character(15)	VARCHAR2(15) NOT NULL	Record (Table) Name (see PSRECDEFN).
10	LEDGER_2	Character(10)	VARCHAR2(10) NOT NULL	Ledger Prompt Table: SP_IQOTLD_NONVW
11	RECNAME_2	Character(15)	VARCHAR2(15) NOT NULL	Record 2 Name
12	FISCAL_YEAR	Number(4,0)	SMALLINT NOT NULL	Fiscal Year Prompt Table: CAL_DETP_FY_VW
13	PERIOD_FROM	Number(3,0)	SMALLINT NOT NULL	From Period Default Value: 1 Prompt Table: CAL_DETP_PER_VW
14	PERIOD_TO	Number(3,0)	SMALLINT NOT NULL	To Period Prompt Table: CAL_DETP_PER_VW
15	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code Prompt Table: CUR_CD_ALL_VW
16	STATISTICS_CODE	Character(3)	VARCHAR2(3) NOT NULL	Statistics Code Prompt Table: STAT_ALL_VW
17	FIELDNAME	Character(18)	VARCHAR2(18) NOT NULL	Field Name (see PSDBFIELD). Default Value: ACCOUNT Prompt Table: %EDITTABLE2
18	VALUE_BY	Character(1)	VARCHAR2(1) NOT NULL	Select value by D=Detailed single value S=By chartfield Value Set
19	CFV_SET	Character(20)	VARCHAR2(20) NOT NULL	ChartField Value Set Prompt Table: CFV_SET_VW
20	AMT_FLDNAME	Character(18)	VARCHAR2(18) NOT NULL	Amount Field Name Prompt Table: INQ_AMT_FLD_VW