GL_PRD_UPD_AET

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	TREE_NAME	Character(18)	VARCHAR2(18) NOT NULL	Tree Name
3	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
4	TREE_NODE	Character(20)	VARCHAR2(20) NOT NULL	Node name
5	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Prompt Table: BU_GL_UPDATE_VW
6	LEDGER_GROUP	Character(10)	VARCHAR2(10) NOT NULL	Ledger Group
7	PSFT_PRODUCT	Character(2)	VARCHAR2(2) NOT NULL	PeopleSoft Product
8	BUSINESS_UNIT2	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
9	BUSINESS_UNIT_3	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
10	BUSINESS_UNIT_1	Character(5)	VARCHAR2(5) NOT NULL	Non-Joint Venture BU
11	AE_SECTION	Character(8)	VARCHAR2(8) NOT NULL	Section
12	SQLROWS	Number(5,0)	INTEGER NOT NULL	SQL Rows
13	GL_PSFTPRODUCT_GL	Character(1)	VARCHAR2(1) NOT NULL	General Ledger
14	DESCR100	Character(100)	VARCHAR2(100) NOT NULL	Length 100 Description
15	NUMBER_OF_PERIODS	Number(3,0)	SMALLINT NOT NULL	Periods in a Year
16	GL_CLOSE_CUR_PRD	Character(1)	VARCHAR2(1) NOT NULL	Close Current (From Period)
17	GL_OPEN_NEXT_PRD	Character(1)	VARCHAR2(1) NOT NULL	Open Next (To Period)
18	ADJUST_PERIOD_SW	Character(1)	VARCHAR2(1) NOT NULL	Include Adjustment Period
19	TRANSACTION_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Transaction Type
20	LEDGER_CODE	Character(10)	VARCHAR2(10) NOT NULL	Ledger Code
21	GL_ADJUST_TYPE	Character(4)	VARCHAR2(4) NOT NULL	Adjustment Type
22	CALENDAR_ID	Character(2)	VARCHAR2(2) NOT NULL	Calendar ID
23	OPEN_YEAR_FROM	Number(4,0)	SMALLINT NOT NULL	Open Year From
24	OPEN_PERIOD_FROM	Number(3,0)	SMALLINT NOT NULL	Open Period From
25	BEGIN_LAG_DAYS	Signed Number(3,0)	DECIMAL(2) NOT NULL	Lag Days for the Begin Date
26	OPEN_FROM_DATE	Date(10)	DATE	First Open Day
27	OPEN_YEAR_TO	Number(4,0)	SMALLINT NOT NULL	Open Year To
28	OPEN_PERIOD_TO	Number(3,0)	SMALLINT NOT NULL	Open Period To
29	END_LAG_DAYS	Signed Number(3,0)	DECIMAL(2) NOT NULL	Lag Days for the End Date
30	OPEN_TO_DATE	Date(10)	DATE	Last Open Day