BI_GTA_EXP_AET

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	RECNAME	Character(15)	VARCHAR2(15) NOT NULL	Record (Table) Name (see PSRECDEFN).
3	BILL_TO_CUST_ID	Character(15)	VARCHAR2(15) NOT NULL	Customer
4	ERR_SEQ_NUM2	Number(5,0)	INTEGER NOT NULL	Used by Golden Tax Adapter, created by SOS
5	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
6	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
7	VAT_INVOICE_TYPE	Character(1)	VARCHAR2(1) NOT NULL	VAT Invoice Type, used by Golden Tax Adapter, created by SOS C=Common S=Special
8	INVOICE_DT_FROM	Date(10)	DATE	Invoice Date From
9	INVOICE_DT_TO	Date(10)	DATE	Through
10	FROM_INVOICE	Character(30)	VARCHAR2(30) NOT NULL	From Invoice Number
11	TO_INVOICE	Character(30)	VARCHAR2(30) NOT NULL	To Invoice Number
12	FROM_CUSTOMER_ID	Character(15)	VARCHAR2(15) NOT NULL	From Customer ID
13	TO_CUSTOMER_ID	Character(15)	VARCHAR2(15) NOT NULL	To Customer ID
14	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
15	SQL_STMT_800	Long Character(800)	VARCHAR2(800)	SQL_Stmt_800
16	SPLIT_LINE	Character(1)	VARCHAR2(1) NOT NULL	Split Line
17	ADDRESS_PHONE	Character(80)	VARCHAR2(80) NOT NULL	Used by GTA
18	BNK_NAME_ACCNT_NUM	Character(80)	VARCHAR2(80) NOT NULL	Used by GTA
19	MAX_LINE_NUM_1	Number(5,0)	INTEGER NOT NULL	Max Line Number
20	MAX_LINE_NUM_2	Number(5,0)	INTEGER NOT NULL	Max Line Number 2
21	MAX_INV_AMT	Number(17,2)	DECIMAL(16,2) NOT NULL	Used by GTA
22	MAX_INV_AMT_1	Signed Number(18,2)	DECIMAL(16,2) NOT NULL	Used by GTA
23	EXISTS_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Exists Flag - Indicates presence in Asset Repository D=Duplicate Y=Exists in ARM
24	FLAG	Character(1)	VARCHAR2(1) NOT NULL	Flag N=No Y=Yes
25	BATCH_CODE	Character(10)	VARCHAR2(10) NOT NULL	used by GTA