GL_MC_XMLP_AET

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
3	CURR_STEP	Character(10)	VARCHAR2(10) NOT NULL	Process Step
4	PROCESS_BEGIN	Number(10,0)	DECIMAL(10) NOT NULL	Begin Process Instance
5	PROCESS_END	Number(10,0)	DECIMAL(10) NOT NULL	End Process Instance
6	SORT_BY_CURRENCY	Character(1)	VARCHAR2(1) NOT NULL	Sort By Currency N=No Y=Yes
7	RTBL_SCENARIO	Character(18)	VARCHAR2(18) NOT NULL	Scenario Name
8	SCE_ID	Character(10)	VARCHAR2(10) NOT NULL	ID
9	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
10	DESCR_BU	Character(30)	VARCHAR2(30) NOT NULL	Business Unit Description
11	LEDGER	Character(10)	VARCHAR2(10) NOT NULL	Ledger
12	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
13	FISCAL_YEAR	Number(4,0)	SMALLINT NOT NULL	Fiscal Year
14	PERIOD_TO	Number(3,0)	SMALLINT NOT NULL	To Period
15	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.
16	CURRENCY_OPTION2	Character(1)	VARCHAR2(1) NOT NULL	Currency Option B=Base F=All Frgn S=Selected Frgn
17	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
18	DATE_CODE	Character(1)	VARCHAR2(1) NOT NULL	This field defines codes for Date field used in Journal lines record. The Different date fields can be used as the basis for alternate Posting to satisfy Trade Date/Settlement date requirements.
19	SETID_CALENDAR	Character(5)	VARCHAR2(5) NOT NULL	Calendar Setid
20	SETID_LEDGER	Character(5)	VARCHAR2(5) NOT NULL	Ledger Table Setid
21	SETID_ACCOUNT	Character(5)	VARCHAR2(5) NOT NULL	Account Table Setid
22	SETID_ACCTYPE	Character(5)	VARCHAR2(5) NOT NULL	Account Type Setid
23	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. "
24	LEDGER_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Ledger Type D=Detail Ledger K=Commitment Control Ledger S=Summary Ledger
25	LEDGER_TEMPLATE	Character(10)	VARCHAR2(10) NOT NULL	Ledger Template
26	CALENDAR_ID	Character(2)	VARCHAR2(2) NOT NULL	Calendar ID
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	SEPARATE_DRCR	Character(1)	VARCHAR2(1) NOT NULL	Enable Separate Debit/Credit
30	RECNAME	Character(15)	VARCHAR2(15) NOT NULL	Record (Table) Name (see PSRECDEFN).
31	FIELDNAME_TOTAL_CR	Character(18)	VARCHAR2(18) NOT NULL	Posted Total Credits
32	FIELDNAME_TOTAL_DR	Character(18)	VARCHAR2(18) NOT NULL	Posted Total Debits
33	FIELDNAME_TOTAL_NT	Character(18)	VARCHAR2(18) NOT NULL	Posted Total Amount
34	FISCAL_YEAR2	Number(4,0)	SMALLINT NOT NULL	Fiscal Year
35	ACCOUNTING_PERIOD2	Number(3,0)	SMALLINT NOT NULL	Accounting Period
36	BEGIN_DT	Date(10)	DATE	Begin Date
37	END_DT	Date(10)	DATE	End Date
38	ACCOUNT_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Identifies a category of accounts that appears on the balance sheet or income statement of the enterprise. Each general ledger account (ACCOUNT) is associated with an account type (also called a ""monetary account type""). PeopleSoft delivers standard account types such as asset, liability, expense, and revenue.
39	BALANCE_FWD_SW	Character(1)	VARCHAR2(1) NOT NULL	A flag that indicates (Y or N) whether or not the YTD balance for an account type or for a statistical account will be rolled forward to Period 0 of the next year. N=Not Carry Forward O=Other Y=Carry Forward
40	VISUAL_RATE	Number(16,8)	DECIMAL(15,8) NOT NULL	The selected leg of a cross-currency rate designated to be displayed on a given application transaction p
41	FROM_CURRENCY	Character(3)	VARCHAR2(3) NOT NULL	From Currency
42	TO_CURRENCY	Character(3)	VARCHAR2(3) NOT NULL	Revalue Currency
43	RATE_MULT	Signed Number(17,8)	DECIMAL(15,8) NOT NULL	Rate Multiplier
44	RATE_DIV	Number(16,8)	DECIMAL(15,8) NOT NULL	Rate Divisor
45	AS_OF_DATE	Date(10)	DATE	As of Date
46	RATE_DIRECT	Character(1)	VARCHAR2(1) NOT NULL	Rate Quotation Basis D=Direct I=Indirect
47	QUOTE_UNITS	Number(4,0)	SMALLINT NOT NULL	Quote Units
48	RATE_TRIANGULATE	Character(1)	VARCHAR2(1) NOT NULL	Rate Triangulate
49	REF_CUR	Character(3)	VARCHAR2(3) NOT NULL	Reference Currency
50	PRIMARY_VISUAL	Character(2)	VARCHAR2(2) NOT NULL	Primary Visual Rate FR=From Currency --> Ref Currency FT=From Currency --> To Currency RT=Ref Currency --> To Currency
51	XRATE_OVERRIDE	Character(1)	VARCHAR2(1) NOT NULL	Allow Cross-Rate Override
52	XRATE_RECALC	Character(2)	VARCHAR2(2) NOT NULL	Cross-Rate Recalculate Option FR=From Currency --> Ref Currency RT=Ref Currency --> To Currency
53	AUTO_RECIPROCATE	Character(1)	VARCHAR2(1) NOT NULL	Auto Reciprocate
54	SELECT_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Selection Flag N=No Y=Yes
55	PNLGRPNAME	Character(18)	VARCHAR2(18) NOT NULL	Component Name
56	STRING_TEXT	Character(100)	VARCHAR2(100) NOT NULL	String Text
57	STRING_TEXT1	Character(100)	VARCHAR2(100) NOT NULL	String Text
58	STRING_TEXT2	Character(100)	VARCHAR2(100) NOT NULL	String Text
59	WHERE_CLAUSE	Character(254)	VARCHAR2(254) NOT NULL	Where Clause