APGL_OPEN_AET

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
3	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
4	REQUEST_ID	Character(10)	VARCHAR2(10) NOT NULL	Request ID
5	REQUEST_DT	Date(10)	DATE	Request Date
6	TEMP_FLD	Character(1)	VARCHAR2(1) NOT NULL	Temporary Field for App Engine
7	APGL_OPEN_OPTN	Character(1)	VARCHAR2(1) NOT NULL	AP/GL Open Liability Option A=All Business Units B=One Business Unit
8	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
9	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
10	BUSINESS_UNIT_GL	Character(5)	VARCHAR2(5) NOT NULL	GL Business Unit
11	AS_OF_DATE	Date(10)	DATE	As of Date
12	PROCESS_FREQUENCY	Character(1)	VARCHAR2(1) NOT NULL	Process Frequency A=Always Process N=Don't Run O=Process Once Default Value: N
13	DET_SUM_SW	Character(1)	VARCHAR2(1) NOT NULL	Detail or Summary D=Detail S=Summary
14	APGL_OPEN_LIAB_IND	Character(1)	VARCHAR2(1) NOT NULL	AP/GL Open Liab Reconciliation
15	AP_OPEN_LIAB_IND	Character(1)	VARCHAR2(1) NOT NULL	AP Open Liability Recon
16	PROCESS_AGING	Character(1)	VARCHAR2(1) NOT NULL	Process Aging
17	APAGING_CYCLE_ID	Character(5)	VARCHAR2(5) NOT NULL	Aging Cycle ID
18	APAGING_AGE_BUCKET	Number(3,0)	SMALLINT NOT NULL	Aging Category
19	INCREMENT1_DT	Date(10)	DATE	Increment 1 Date
20	INCREMENT2_DT	Date(10)	DATE	Increment 2 Date
21	DAY_INCREMENT1	Signed Number(4,0)	DECIMAL(3) NOT NULL	Day Increment 1
22	DAY_INCREMENT2	Signed Number(4,0)	DECIMAL(3) NOT NULL	Day Increment 2
23	TEMP_NBR1	Number(7,0)	INTEGER NOT NULL	Temporary Number
24	AS_OF_DT_TYPE	Character(1)	VARCHAR2(1) NOT NULL	As Of Date used for Open Liability Reports. 10/16/2002 - Removed Due Date from available Translates. A=Accounting Date D=Due Date I=Invoice Date
25	FIELDNAME_ACCTDATE	Character(18)	VARCHAR2(18) NOT NULL	Accounting Date field name
26	FIELDNAME	Character(18)	VARCHAR2(18) NOT NULL	Field Name (see PSDBFIELD).
27	INCLUDE_UNPOSTED	Character(1)	VARCHAR2(1) NOT NULL	Include Unposted Journals
28	BASE_CURRENCY	Character(3)	VARCHAR2(3) NOT NULL	"Specifies the primary currency for a general ledger business unit, and is sometimes referred to as the ""book"" currency. Each business unit has one base currency. which is usually, but not always, the local currency for the organization. Journal entries are posted to a business unit in its base currency. "
29	CURRENCY_OPTION4	Character(1)	VARCHAR2(1) NOT NULL	Currency option field B=Base Currency S=Selected Foreign Currency T=Transaction Currency
30	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
31	CUR_RT_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Currency Rate Type
32	CUR_EFFDT	Date(10)	DATE	Specifies the effective date associated with the currency used as the base currency for the Business Unit on the Journal Entry Header.
33	RATE_MULT	Signed Number(17,8)	DECIMAL(15,8) NOT NULL	Rate Multiplier
34	RATE_DIV	Number(16,8)	DECIMAL(15,8) NOT NULL	Rate Divisor
35	WHERE_CLAUSE	Character(254)	VARCHAR2(254) NOT NULL	Where Clause