APGL_RECN_RQST

#	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	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
3	REQUEST_ID	Character(10)	VARCHAR2(10) NOT NULL	Request ID
4	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
5	REQUEST_DT	Date(10)	DATE	Request Date
6	REPORT_ID	Character(8)	VARCHAR2(8) NOT NULL	Report Identifier
7	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
8	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Prompt Table: SP_BUPRCR_NONVW
9	BUSINESS_UNIT_GL	Character(5)	VARCHAR2(5) NOT NULL	GL Business Unit
10	LEDGER	Character(10)	VARCHAR2(10) NOT NULL	Ledger Prompt Table: SP_LEDG_D_NONVW
11	APGL_RECN_OPTN	Character(1)	VARCHAR2(1) NOT NULL	Report Option D=Journal Date J=Journal ID P=Accounting Period Default Value: J
12	JOURNAL_ID	Character(10)	VARCHAR2(10) NOT NULL	Identifies a journal entry, consisting of a header and one or more lines. The Journal ID itself does not have to be unique, but together with the journal business unit and journal date, it forms a unique journal identifier.
13	JOURNAL_DATE	Date(10)	DATE	Specifies the date the journal was created.
14	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.
15	FISCAL_YEAR	Number(4,0)	SMALLINT NOT NULL	Fiscal Year
16	ACCOUNT	Character(10)	VARCHAR2(10) NOT NULL	Account Prompt Table: GL_ACCT_ALL_VW
17	PROCESS_FREQUENCY	Character(1)	VARCHAR2(1) NOT NULL	Process Frequency A=Always Process N=Don't Run O=Process Once Default Value: N