BI_TR_STG_AET

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
3	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
4	VAT_INVOICE_TYPE	Character(1)	VARCHAR2(1) NOT NULL	VAT Invoice Type, used by Golden Tax Adapter, created by SOS C=Common S=Special
5	INVOICE_DT_FROM	Date(10)	DATE	Invoice Date From
6	INVOICE_DT_TO	Date(10)	DATE	Through
7	FROM_INVOICE	Character(30)	VARCHAR2(30) NOT NULL	From Invoice Number
8	TO_INVOICE	Character(30)	VARCHAR2(30) NOT NULL	To Invoice Number
9	FROM_CUSTOMER_ID	Character(15)	VARCHAR2(15) NOT NULL	From Customer ID
10	TO_CUSTOMER_ID	Character(15)	VARCHAR2(15) NOT NULL	To Customer ID
11	BILL_TYPE_ID	Character(3)	VARCHAR2(3) NOT NULL	Bill Type Identifier
12	BILL_SOURCE_ID	Character(10)	VARCHAR2(10) NOT NULL	Bill Source
13	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
14	CONSOLIDATED	Character(1)	VARCHAR2(1) NOT NULL	C implies a Consolidated Invoice N implies a Non-consolidated Invoice C=Consolidated N=Non-Consolidated
15	SQL_STMT_800	Long Character(800)	VARCHAR2(800)	SQL_Stmt_800
16	SQL_STMT_254	Character(254)	VARCHAR2(254) NOT NULL	An internal work field that contains SQL text that is to be utilized in treasury application p
17	BI_RECCOUNT	Number(10,0)	DECIMAL(10) NOT NULL	BI Rec Count