BI_EMAIL_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	TO_BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit selection field
4	INVOICE	Character(22)	VARCHAR2(22) NOT NULL	Invoice
5	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
6	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
7	EMAILID	Character(70)	VARCHAR2(70) NOT NULL	A user's E-mail address
8	INVOICE_DT	Date(10)	DATE	Invoice Date
9	DUE_DT	Date(10)	DATE	Specifies the date that a transaction is due. It is a generic field used in multiple PeopleSoft applications including Receivables Payables and Purchasing. For example it represents the date that payment is due for a voucher or the date that a scheduled shipment is due to be received.
10	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.
11	BILL_CYCLE_ID	Character(10)	VARCHAR2(10) NOT NULL	Billing Cycle Identifier
12	BILL_SOURCE_ID	Character(10)	VARCHAR2(10) NOT NULL	Bill Source
13	BILL_TYPE_ID	Character(3)	VARCHAR2(3) NOT NULL	Bill Type Identifier
14	START_INVOICE	Character(22)	VARCHAR2(22) NOT NULL	Starting Invoice Number
15	END_INVOICE	Character(22)	VARCHAR2(22) NOT NULL	Ending Invoice Number
16	STARTING_DT	Date(10)	DATE	Bills Added On or After
17	INVOICE_ACTION	Character(1)	VARCHAR2(1) NOT NULL	Invoice Action C=Reprint I=Invoice P=Pro Forma
18	CONSOLIDATE	Character(1)	VARCHAR2(1) NOT NULL	Consolidate Headers
19	INVOICE_DT_OPT	Character(1)	VARCHAR2(1) NOT NULL	Invoice Date Option P=Processing Date U=User Defined
20	INVOICE_RANGE_OPT	Character(3)	VARCHAR2(3) NOT NULL	Invoice Range Option ALI=All Invoiced Bills ALL=All CUS=Cust ID CYC=Bill Cycle DT=Date Bill Added DTI=Date GRP=Copy Group ID INV=Invoice ID MUL=Multi-Select Table PVN=Public Voucher Number RGP=Reprint Group SEL=Range ID SHP=Ship ID SRC=Bill Source TYP=Bill Type
21	RANGE_SELECTION_ID	Character(30)	VARCHAR2(30) NOT NULL	Range Selection ID
22	DTTM_FROM	DateTime(26)	TIMESTAMP	From Date/Time
23	NAME1	Character(40)	VARCHAR2(40) NOT NULL	Name 1
24	INVOICE_AMOUNT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Invoice Amount
25	BI_CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Billing Currency Code
26	CONSOL_HDR	Character(1)	VARCHAR2(1) NOT NULL	Consolidated Hdr? N=No Y=Yes
27	BILL_TO_CUST_ID	Character(15)	VARCHAR2(15) NOT NULL	Customer
28	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
29	URL	Character(254)	VARCHAR2(254) NOT NULL	Internet URL (Universal Resource Locator)
30	COUNTER	Number(10,0)	DECIMAL(10) NOT NULL	Counter
31	RETURN_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Can be returned
32	CONTACT_ID	Character(15)	VARCHAR2(15) NOT NULL	Contact Identifier for Treasury Contacts
33	CNTCT_SEQ_NUM	Number(5,0)	INTEGER NOT NULL	Contact Sequence Number
34	SEQ_NUM	Number(3,0)	SMALLINT NOT NULL	Sequence
35	ERROR_STATUS_BI	Character(4)	VARCHAR2(4) NOT NULL	Error Status
36	IVC_DELIVERED_FLG	Character(1)	VARCHAR2(1) NOT NULL	Invoice Delivered
37	IVC_DELIVERED_DT	Date(10)	DATE	Invoice Delivered Date
38	NULLDATE	Date(10)	DATE	Select a platform independent date with a null value