FO_TO_AP_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	BUSINESS_UNIT_PC	Character(5)	VARCHAR2(5) NOT NULL	PC Business Unit
5	PAY_END_DT	Date(10)	DATE	Pay Period End Date
6	ACCOUNTING_DT	Date(10)	DATE	The accounting entry construction date for a given transaction (a generic field that crosses multiple
7	ACCOUNTING_DT_FROM	Date(10)	DATE	The range of the accounting entry construction dates
8	ACCOUNTING_DT_TO	Date(10)	DATE	The range of the accounting entry construction dates
9	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
10	VENDOR_SETID	Character(5)	VARCHAR2(5) NOT NULL	Vendor SetID
11	VENDOR_ID	Character(10)	VARCHAR2(10) NOT NULL	Vendor Identifier
12	CHECK_ROWS_EXIST	Character(1)	VARCHAR2(1) NOT NULL	Check For Rows
13	WHERE_CLAUSE	Character(254)	VARCHAR2(254) NOT NULL	Where Clause
14	CURRENCY_FLG	Character(1)	VARCHAR2(1) NOT NULL	Currency Information Flag D=Default from Higher Level S=Specify at this Level
15	ACCTG_FLG	Character(1)	VARCHAR2(1) NOT NULL	An internal work flag utilized in automated accounting processing.
16	GROSS_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Gross Invoice Amount
17	ECQUEUEINSTANCE	Number(9,0)	DECIMAL(9) NOT NULL	Electronic Commerce Queue Instance ID. Used in EDI Manager. One of three(3) Key Fields(ECTRANSID, ECTRANSINOUTSW, ECQUEUEINSTANCE) used in Electronic Commerce(EC) Staging Tables.
18	PROCESS_STEP	Character(10)	VARCHAR2(10) NOT NULL	Process Step
19	VOUCHER_LINE_NUM	Number(5,0)	INTEGER NOT NULL	Voucher Line Number
20	PROJECT_ID	Character(15)	VARCHAR2(15) NOT NULL	Project Id ChartField
21	ACTIVITY_ID	Character(15)	VARCHAR2(15) NOT NULL	Activity ID
22	UNIT_OF_MEASURE	Character(3)	VARCHAR2(3) NOT NULL	Used on an approval rule set. MHR=Muti Hourly PER=Percentage SQF=Square Footage
23	ACCOUNT	Character(10)	VARCHAR2(10) NOT NULL	Account
24	ALTACCT	Character(10)	VARCHAR2(10) NOT NULL	Alternate Account
25	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department
26	ANALYSIS_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Analysis Type
27	OPERATING_UNIT	Character(8)	VARCHAR2(8) NOT NULL	Operating Unit ChartField Prompt Table: OPERUNT_BUGL_VW
28	PRODUCT	Character(6)	VARCHAR2(6) NOT NULL	Product ChartField Prompt Table: PRODUCT_BUGL_VW
29	FUND_CODE	Character(5)	VARCHAR2(5) NOT NULL	Fund Code Prompt Table: FUND_BUGL_VW
30	CLASS_FLD	Character(5)	VARCHAR2(5) NOT NULL	Class Field Prompt Table: CLASSCF_BUGL_VW
31	PROGRAM_CODE	Character(5)	VARCHAR2(5) NOT NULL	Program Code ChartField Prompt Table: PROGRAM_BUGL_VW
32	BUDGET_REF	Character(8)	VARCHAR2(8) NOT NULL	Budget Reference Prompt Table: BUD_REF_BUGL_VW
33	AFFILIATE	Character(5)	VARCHAR2(5) NOT NULL	Affiliate Prompt Table: AFFILIATE_VW
34	AFFILIATE_INTRA1	Character(10)	VARCHAR2(10) NOT NULL	IntraUnit Affiliate1 Prompt Table: %EDIT_INTRA01
35	AFFILIATE_INTRA2	Character(10)	VARCHAR2(10) NOT NULL	Operating Unit Affiliate Prompt Table: %EDIT_INTRA02
36	CHARTFIELD1	Character(10)	VARCHAR2(10) NOT NULL	Expansion chartfield 1 Prompt Table: CF1_BUGL_VW
37	CHARTFIELD2	Character(10)	VARCHAR2(10) NOT NULL	Expansion Chartfield 2 Prompt Table: CF2_BUGL_VW
38	CHARTFIELD3	Character(10)	VARCHAR2(10) NOT NULL	Expansion Chartfield 3 Prompt Table: CF3_BUGL_VW
39	RESOURCE_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Source Type
40	RESOURCE_CATEGORY	Character(5)	VARCHAR2(5) NOT NULL	Category
41	RESOURCE_SUB_CAT	Character(5)	VARCHAR2(5) NOT NULL	Subcategory
42	TXN_CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Transaction Currency
43	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
44	TIME_RPTG_CD	Character(5)	VARCHAR2(5) NOT NULL	Time Reporting Code
45	BUSINESS_UNIT_AP	Character(5)	VARCHAR2(5) NOT NULL	AP Business Unit
46	AE_SQLROWS	Number(10,0)	DECIMAL(10) NOT NULL	Rows affected by last SQL stmt
47	VNDR_LOC	Character(10)	VARCHAR2(10) NOT NULL	Vendor Location
48	ORIGIN	Character(3)	VARCHAR2(3) NOT NULL	Origin
49	FOREIGN_CURRENCY	Character(3)	VARCHAR2(3) NOT NULL	Foreign Currency Code
50	RT_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical.