UPG_GL_AET

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
3	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.
4	JOURNAL_DATE	Date(10)	DATE	Specifies the date the journal was created.
5	UNPOST_SEQ	Number(2,0)	SMALLINT NOT NULL	Identifies the sequence of journal entries when a journal is "unposted". When a journal is posted the UnPost Sequence is automatically set to "0". When a journal is unposted, a new reversing entry is automatically created with an UnPost Sequence of "1".
6	JOURNAL_LINE	Number(9,0)	DECIMAL(9) NOT NULL	Uniquely identifies a journal line with a sequence number. Within a single journal entry, the line sequence begins with 1 and automatically increments by 1 for each succeeding journal line. There can be any number of lines associated with a journal header.
7	LEDGER	Character(10)	VARCHAR2(10) NOT NULL	Ledger
8	ACCOUNT	Character(10)	VARCHAR2(10) NOT NULL	Account
9	ACTIVITY	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Activity
10	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department
11	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
12	MONETARY_AMOUNT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Specifies the monetary amount of a debit or credit in the business unit base currency. Debit entries are positive and credit entries are negative. This amount is only zero if associated with a statistical account.
13	MOVEMENT_FLAG	Character(1)	VARCHAR2(1) NOT NULL	A flag associated with a journal line that indicates whether its amount is in the natural sign or the reversal sign. N=Natural R=Reversal
14	LINE_DESCR	Character(30)	VARCHAR2(30) NOT NULL	Describes the nature of a journal line. It is defaulted from the description of the Account ChartField or manually entered.
15	FOREIGN_CURRENCY	Character(3)	VARCHAR2(3) NOT NULL	Foreign Currency Code
16	FOREIGN_AMOUNT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Specifies the monetary amount of a debit or credit (accounting entry line) in the entry currency of the item. The sum of FOREIGN_AMOUNT values on AR lines should equal the ENTRY_AMT on the pending item.
17	ROW_COUNT	Number(8,0)	INTEGER NOT NULL	Number to Purge
18	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
19	PROCESS_STEP	Character(10)	VARCHAR2(10) NOT NULL	Process Step
20	PROJECT_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Overall Project/Grant Amount
21	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
22	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
23	OPRID2	Character(30)	VARCHAR2(30) NOT NULL	A user's ID
24	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
25	RUNCNTLID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
26	REQUEST_NBR	Number(4,0)	SMALLINT NOT NULL	Request Number
27	REQUEST_ID	Character(10)	VARCHAR2(10) NOT NULL	Request ID
28	SJE_ID	Character(10)	VARCHAR2(10) NOT NULL	Standard Journal
29	TO_SJE_ID	Character(10)	VARCHAR2(10) NOT NULL	To SJE
30	SEQ_NUM	Number(3,0)	SMALLINT NOT NULL	Sequence
31	SEQNBR	Number(5,0)	INTEGER NOT NULL	Sequence Number
32	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
33	EFF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Effective Status A=Active I=Inactive
34	SJE_TYPE	Character(1)	VARCHAR2(1) NOT NULL	A flag that indicates the type of Standard Journal Entry (SJE), which can be either Template or Recurring. If the type is Recurring you must also specify a schedule (SCHEDULE). M=Model -- Do Not Post P=Spread Daily Proration R=Recurring on a Schedule S=Spread Amounts from SJE Model T=Template to be Completed
35	SCHEDULE	Character(10)	VARCHAR2(10) NOT NULL	Schedule ID
36	FROM_DT	Date(10)	DATE	From Date
37	TO_DT	Date(10)	DATE	To Date
38	CHG_JRNL_LN	Character(1)	VARCHAR2(1) NOT NULL	Allow Add/Change of Jrnl Lines
39	CONTROL_CHARTFIELD	Character(18)	VARCHAR2(18) NOT NULL	Control ChartField
40	BUSINESS_UNIT_1	Character(5)	VARCHAR2(5) NOT NULL	Non-Joint Venture BU
41	AE_SECTION	Character(8)	VARCHAR2(8) NOT NULL	Section
42	AE_APPLID	Character(12)	VARCHAR2(12) NOT NULL	Program Name (see PSAEAPPLDEFN).
43	UPG_RELEASE	Character(4)	VARCHAR2(4) NOT NULL	Upgrade Application Release 751=7.51 Release 752=7.52 Release 753=7.53 Release 801=8 SP1 Release 803=8 SP3 Release 840=8.40 Release 841=8.40 SP1 880=8.80 Release
44	LEDGER_GROUP	Character(10)	VARCHAR2(10) NOT NULL	Ledger Group
45	CALENDAR_ID	Character(2)	VARCHAR2(2) NOT NULL	Calendar ID
46	EXIST	Character(1)	VARCHAR2(1) NOT NULL	Exist
47	KK_POSTED_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Posted Amount
48	KK_POSTED_QTY	Signed Number(20,4)	DECIMAL(18,4) NOT NULL	Commitment Control Posted Qty
49	KK_FRN_POSTED_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Foreign Posted Amount
50	KK_REV_TRACK_LG	Character(10)	VARCHAR2(10) NOT NULL	Revenue Tracking Ledger Group
51	KK_TRAN_DT	Date(10)	DATE	Commitment Control Transaction Original processing date. Primary key with KK_TRAN_ID.
52	KK_TRAN_ID	Character(10)	VARCHAR2(10) NOT NULL	Commitment Control Foreign Key for Transaction Identification.
53	KK_TRAN_LN	Number(9,0)	DECIMAL(9) NOT NULL	Commitment Control Transaction Line number.
54	SETID1	Character(5)	VARCHAR2(5) NOT NULL	SetID Value
55	LEDGER_TEMPLATE	Character(10)	VARCHAR2(10) NOT NULL	Ledger Template
56	RECNAME	Character(15)	VARCHAR2(15) NOT NULL	Record (Table) Name (see PSRECDEFN).
57	BD_PERIOD_XFER_SET	Character(20)	VARCHAR2(20) NOT NULL	Budget Period Set
58	BUDGET_PERIOD_FROM	Character(8)	VARCHAR2(8) NOT NULL	Budget Period From
59	BUDGET_PERIOD_TO	Character(8)	VARCHAR2(8) NOT NULL	To Budget Period
60	BUDGET_PERIOD	Character(8)	VARCHAR2(8) NOT NULL	Budget Period
61	CHARTFIELD	Character(18)	VARCHAR2(18) NOT NULL	ChartField
62	CHARTFIELD_VALUE	Character(30)	VARCHAR2(30) NOT NULL	ChartField Value
63	FIELDNAME	Character(18)	VARCHAR2(18) NOT NULL	Field Name (see PSDBFIELD).