BI_GTA_SPLT_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	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
4	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
5	INVOICE	Character(22)	VARCHAR2(22) NOT NULL	Invoice
6	GTA_INVOICE	Character(20)	VARCHAR2(20) NOT NULL	Invoice
7	LINE_SEQ_NUM	Number(5,0)	INTEGER NOT NULL	Sequence
8	INVOICE_AMOUNT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Invoice Amount
9	NET_EXTENDED_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Net Extended Amt
10	VAT_INVOICE_TYPE	Character(1)	VARCHAR2(1) NOT NULL	VAT Invoice Type, used by Golden Tax Adapter, created by SOS C=Common S=Special
11	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
12	SQL_STMT_800	Long Character(800)	VARCHAR2(800)	SQL_Stmt_800
13	LINE_SEQ_CNT	Number(5,0)	INTEGER NOT NULL	Line Sequence Counter
14	COUNTER	Number(10,0)	DECIMAL(10) NOT NULL	Counter
15	TAX_CD_VAT_PCT	Signed Number(9,4)	DECIMAL(7,4) NOT NULL	Specifies the tax percentage that corresponds to the VAT code. If more than one VAT authority is linked to a VAT code this will represent an aggregate percentage.
16	LAST_SEQ_NBR	Number(15,0)	DECIMAL(15) NOT NULL	Last Sequence number in list
17	ROW_COUNT	Number(8,0)	INTEGER NOT NULL	Number to Purge
18	MAX_LINE_NUM	Number(15,0)	DECIMAL(15) NOT NULL	An internal work field utilized in bank transfer processing.
19	MAX_INV_AMT	Number(17,2)	DECIMAL(16,2) NOT NULL	Used by GTA
20	MAX_INV_AMT_1	Signed Number(18,2)	DECIMAL(16,2) NOT NULL	Used by GTA
21	FLAG	Character(1)	VARCHAR2(1) NOT NULL	Flag N=No Y=Yes
22	GTA_INVOICE_TO	Character(20)	VARCHAR2(20) NOT NULL	Used by GTA