BI_EXT_EXSDTL

#	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	EXS_TAX_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Tax Type C=Custom Duty E=Excise Duty G=Goods and Services Tax S=Sales Tax / VAT
6	EXS_TAX_RATE_SEQ	Number(3,0)	SMALLINT NOT NULL	Tax Rate Sequence
7	EXS_TAX_RATE_CD	Character(10)	VARCHAR2(10) NOT NULL	Tax Rate Code
8	EXS_TAX_CMPNT_CD	Character(10)	VARCHAR2(10) NOT NULL	Tax Component Code
9	EXS_TAX_DEP_CD	Character(10)	VARCHAR2(10) NOT NULL	Tax Dependency Code
10	EXS_CALC_SCHEME	Character(1)	VARCHAR2(1) NOT NULL	Calculation Scheme A=Amount P=Percentage Q=Quantity
11	EXS_TAX_RATE_PCT	Number(8,4)	DECIMAL(7,4) NOT NULL	Tax Rate Percentage
12	EXS_TXRTAMT_TRC	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Tax Rate Currency
13	EXS_CURRENCY_TRC	Character(3)	VARCHAR2(3) NOT NULL	Curreny Tax Rate
14	EXS_TAXRT_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Tax Rate Amount
15	EXS_TAXRT_AMT_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Tax Rate Amount
16	EXS_TAXRT_AMT_RPT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Tax Rate Amount
17	EXS_TAX_RATE_UOM	Character(3)	VARCHAR2(3) NOT NULL	Excise Unit Of Measure
18	BI_CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Billing Currency Code
19	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. "
20	EXS_CURRENCY_RPTG	Character(3)	VARCHAR2(3) NOT NULL	Excise Currency Reporting
21	EXS_TAX_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Excise Sales Tax Amount
22	EXS_TAX_AMT_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Excise Sales Tax Amount Base Currency
23	EXS_TAX_AMT_RPT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Excise Sales Tax Amount Reporting Currency
24	EXS_BASIS_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Excise Sales Tax Basis Amount
25	EXS_BASIS_AMT_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Excise Sales Tax Basis Amount Base Currency
26	EXS_BASIS_AMT_RPT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Excise Sales Tax Basis Amount Reporting Currency
27	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
28	INVOICE_DT	Date(10)	DATE	Invoice Date
29	ADD_DT	Date(10)	DATE	Customer Added On
30	LAST_MAINT_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Last Maintained By Operator ID