AR_ARX32001_AET

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	REPORT_DEFN_ID	Character(12)	VARCHAR2(12) NOT NULL	Report Name (see PSXPRPTDEFN).
3	PROCESS_INSTANCE2	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
4	FLDDEFNNAME	Character(30)	VARCHAR2(30) NOT NULL	Definition Name (see PSFLDDEFN).
5	CONSOLIATED	Character(1)	VARCHAR2(1) NOT NULL	Consolidated
6	CONSOLIDATE	Character(1)	VARCHAR2(1) NOT NULL	Consolidate Headers
7	AE_APPLID	Character(12)	VARCHAR2(12) NOT NULL	Program Name (see PSAEAPPLDEFN).
8	AE_SECTION	Character(8)	VARCHAR2(8) NOT NULL	Section
9	TMPLDEFN_ID	Character(30)	VARCHAR2(30) NOT NULL	Template ID (see PSXPTMPLDEFN).
10	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
11	BI_RECCOUNT	Number(10,0)	DECIMAL(10) NOT NULL	BI Rec Count
12	BI_RECCOUNT2	Number(10,0)	DECIMAL(10) NOT NULL	BI Rec Count
13	EMAILID	Character(70)	VARCHAR2(70) NOT NULL	A user's E-mail address
14	INVOICE	Character(22)	VARCHAR2(22) NOT NULL	Invoice
15	ATT_IVC_IMG_FLG	Character(1)	VARCHAR2(1) NOT NULL	Attach Invoice Image
16	INVOICE_ACTION	Character(1)	VARCHAR2(1) NOT NULL	Invoice Action C=Reprint I=Invoice P=Pro Forma
17	PROC_ONLINE	Character(1)	VARCHAR2(1) NOT NULL	Process Online
18	SF1034_1035_FLG	Character(1)	VARCHAR2(1) NOT NULL	SF 1034/35 Invoice
19	PVN_REBILL_FLG	Character(1)	VARCHAR2(1) NOT NULL	Print Public Voucher as Rebill
20	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
21	BURST_MODE_FLG	Character(1)	VARCHAR2(1) NOT NULL	Burst Mode
22	BURST_VAL	Character(100)	VARCHAR2(100) NOT NULL	Burst Field Value
23	BILL_TO_MEDIA	Character(1)	VARCHAR2(1) NOT NULL	Bill To Media A=Email Invoice as Attachment E=EDI H=Federal Highway File N=Email Notification P=Print Copy X=Electronic Invoice File
24	PRINT_SEQ_NBR	Number(5,0)	INTEGER NOT NULL	Print Sequence
25	ERROR_STATUS_BI	Character(4)	VARCHAR2(4) NOT NULL	Error Status
26	EMAIL_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Status of an email transmission. 0=Success 1=Fail
27	INVALID_EMAILID	Character(70)	VARCHAR2(70) NOT NULL	Invalid Email address
28	MESSAGE_SET_NBR	Number(5,0)	INTEGER NOT NULL	Message Set Number. This field refers to the Message Set Number in the Message Catalog.
29	MESSAGE_NBR	Number(5,0)	INTEGER NOT NULL	Message Number. This field refers to the Message Number in the Message Catalog.
30	PRIMARY_IVC_FLG	Character(1)	VARCHAR2(1) NOT NULL	A "Y" means primary invoice. An "N" means a courtesy copy invoice. N=No Y=Yes
31	RESEND_FLG	Character(1)	VARCHAR2(1) NOT NULL	Resend Invoice N=No Y=Yes
32	SEQ_NUM	Number(3,0)	SMALLINT NOT NULL	Sequence
33	NEXT_SEQ_NUM	Number(3,0)	SMALLINT NOT NULL	Sequence
34	EMAIL_SUCC_CNT	Number(10,0)	DECIMAL(10) NOT NULL	Email Success Count
35	EMAIL_FAIL_CNT	Number(10,0)	DECIMAL(10) NOT NULL	Email Fail Count
36	IMG_SUCC_CNT	Number(10,0)	DECIMAL(10) NOT NULL	Invoice Image Success Count
37	IMG_FAIL_CNT	Number(10,0)	DECIMAL(10) NOT NULL	Invoice Image Failure Count
38	BILL_TO_CUST_ID	Character(15)	VARCHAR2(15) NOT NULL	Customer
39	CNTCT_SEQ_NUM	Number(5,0)	INTEGER NOT NULL	Contact Sequence Number
40	CONSOL_HDR	Character(1)	VARCHAR2(1) NOT NULL	Consolidated Hdr? N=No Y=Yes
41	CRSPD_SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
42	CRSPD_CUST_ID	Character(15)	VARCHAR2(15) NOT NULL	Correspondence Customer
43	ST_ID_NUM	Number(8,0)	INTEGER NOT NULL	Statement Number
44	BAL_CURRENCY	Character(3)	VARCHAR2(3) NOT NULL	Currency Code - Bal Amount
45	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
46	CUST_ID	Character(15)	VARCHAR2(15) NOT NULL	Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations.
47	DUMMY_FIELD	Character(1)	VARCHAR2(1) NOT NULL	Dummy Field for Hiding Groups
48	FIELDVALUE1	Character(30)	VARCHAR2(30) NOT NULL	Field Value
49	EMAIL_ST	Character(1)	VARCHAR2(1) NOT NULL	Email Statement
50	AE_EXISTS	Character(1)	VARCHAR2(1) NOT NULL	Exists
51	EMAIL_SENT_CNT	Number(10,0)	DECIMAL(10) NOT NULL	Email Sent Count
52	AR_REPORT_NAME	Character(100)	VARCHAR2(100) NOT NULL	Report Name
53	AE_APPSTATUS	Number(1,0)	SMALLINT NOT NULL	AE Application Warning Status