BI_INVOUT_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	REQUEST_ID	Character(10)	VARCHAR2(10) NOT NULL	Request ID
4	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
5	PROCESS_NAME	Character(12)	VARCHAR2(12) NOT NULL	Process Name
6	AE_SECTION	Character(8)	VARCHAR2(8) NOT NULL	Section
7	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
8	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
9	RETRANSMIT_FLG	Character(1)	VARCHAR2(1) NOT NULL	Y implies re-transmission of invoices N implies a new transmission or a re-run of the Publish Outbound Message
10	CONSOLIDATED	Character(1)	VARCHAR2(1) NOT NULL	C implies a Consolidated Invoice N implies a Non-consolidated Invoice C=Consolidated N=Non-Consolidated
11	IVC_PRINTED_DT	Date(10)	DATE	Invoice Printed Date
12	BILL_TO_CUST_ID	Character(15)	VARCHAR2(15) NOT NULL	Customer
13	FROM_INVOICE	Character(30)	VARCHAR2(30) NOT NULL	From Invoice Number
14	TO_INVOICE	Character(30)	VARCHAR2(30) NOT NULL	To Invoice Number
15	INVOICE	Character(22)	VARCHAR2(22) NOT NULL	Invoice
16	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.
17	ECQUEUEINST_WRK	Number(9,0)	DECIMAL(9) NOT NULL	EC Queue Inst
18	COUNTER	Number(10,0)	DECIMAL(10) NOT NULL	Counter
19	WHERE_CLAUSE_LONG	Long Character(4000)	CLOB	Where Clause