BI_EXTRCT_TXDTL

#	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	INVOICE	Character(22)	VARCHAR2(22) NOT NULL	Invoice
4	LINE_SEQ_NUM	Number(5,0)	INTEGER NOT NULL	Sequence
5	TAX_AUTHORITY_CD	Character(3)	VARCHAR2(3) NOT NULL	Tax Authority
6	SEQ_NBR_5	Number(5,0)	INTEGER NOT NULL	Sequence number five digits long
7	DESCRSHORT	Character(10)	VARCHAR2(10) NOT NULL	Short Description
8	BI_CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Billing Currency Code
9	BASE_CURRENCY	Character(3)	VARCHAR2(3) NOT NULL	"Specifies the primary currency for a general ledger business unit, and is sometimes referred to as the ""book"" currency. Each business unit has one base currency. which is usually, but not always, the local currency for the organization. Journal entries are posted to a business unit in its base currency. "
10	CURRENCY_CD_XEU	Character(3)	VARCHAR2(3) NOT NULL	Euro Currency
11	TAX_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Tax Amount
12	TAX_AMT_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Tax Amount (base)
13	TAX_AMT_XEU	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Tax Amount - Euro
14	TAX_PCT	Number(7,4)	DECIMAL(6,4) NOT NULL	Tax Percent
15	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
16	INVOICE_DT	Date(10)	DATE	Invoice Date
17	ADD_DT	Date(10)	DATE	Customer Added On
18	LAST_MAINT_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Last Maintained By Operator ID