BI_LINE_TXD_TMP

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
2	INVOICE	Character(22)	VARCHAR2(22) NOT NULL	Invoice
3	LINE_SEQ_NUM	Number(5,0)	INTEGER NOT NULL	Sequence
4	TAX_AUTHORITY_CD	Character(3)	VARCHAR2(3) NOT NULL	Tax Authority
5	SEQ_NBR_5	Number(5,0)	INTEGER NOT NULL	Sequence number five digits long
6	BI_CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Billing Currency Code
7	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. "
8	CURRENCY_CD_XEU	Character(3)	VARCHAR2(3) NOT NULL	Euro Currency
9	MAX_TAX_FLG	Character(1)	VARCHAR2(1) NOT NULL	max_tax_flg = 'Y' implies that max taxes were applied Y/N Table Edit Default Value: N
10	TAX_JUR_NAME	Character(60)	VARCHAR2(60) NOT NULL	Tax Jurisdiction Name
11	TAX_EXEMPT_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Tax Exempt Amount
12	NON_TAXABLE_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Non Taxable Amount
13	TAX_BASIS_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Tax Basis Amount
14	TAX_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Tax Amount
15	TAX_AMT_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Tax Amount (base)
16	TAX_AMT_XEU	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Tax Amount - Euro
17	TAX_PCT	Number(7,4)	DECIMAL(6,4) NOT NULL	Tax Percent
18	ADD_DTTM	DateTime(26)	TIMESTAMP	Date Time Added
19	LAST_UPDATE_DTTM	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
20	LAST_MAINT_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Last Maintained By Operator ID