BI_EIVC_LINE

#	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	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
6	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
7	QTY	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Quantity
8	UNIT_OF_MEASURE	Character(3)	VARCHAR2(3) NOT NULL	Used on an approval rule set. MHR=Muti Hourly PER=Percentage SQF=Square Footage
9	GROSS_EXTENDED_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Gross Extended
10	NET_EXTENDED_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Net Extended Amt
11	NET_EXTENDED_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Net Extended Amount
12	TOT_DISCOUNT_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Discount Amt
13	TOT_SURCHARGE_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Surcharge Amt
14	VAT_DCLRTN_DT	Date(10)	DATE	"Specifies the date of the invoice when the VAT declaration point (VAT_DCLRTN_POINT) is ""Invoice"". The VAT declaration date is automatically set to the invoice date by the system. This field does not apply when the declaration point is ""payment"". "
15	FREE_OF_CHARGE	Character(10)	VARCHAR2(10) NOT NULL	Free of Charge
16	ORDER_INT_LINE_NO	Number(5,0)	INTEGER NOT NULL	Order Line
17	ORDER_NO	Character(10)	VARCHAR2(10) NOT NULL	Identifies a customer order number that appears as a reference on a receivables pending item. Date Initials Issue Description 022701 mv SP2 (F-CJORGENS-3) CSR Desktop
18	ORDER_DATE	Date(10)	DATE	Date Initials Issue Description 022701 mv SP2 (F-CJORGENS-3) CSR Desktop
19	SHIP_TO_ADDR_NUM	Number(5,0)	INTEGER NOT NULL	Ship To Address Sequence Num
20	SHIP_DATE	Date(10)	DATE	Item Shipping Date
21	SHIP_COUNTRY_2CHAR	Character(2)	VARCHAR2(2) NOT NULL	Ship 2-Char Country Code
22	SHIP_COUNTRY_DESCR	Character(30)	VARCHAR2(30) NOT NULL	Ship country description
23	VAT_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Specifies the amount of VAT associated with a transaction such as an invoice or a purchase order. In PeopleSoft Receivables this field is populated when the VAT declaration point is set to Invoice.
24	VAT_AMT_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	VAT Amount in Base Curr
25	VAT_BASIS_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Specifies the amount on a sale (receivables item) or purchase (Payables voucher) transaction that is subject to VAT taxation. Depending on other parameters this amount may represent the gross or net amount of the transaction and may or may not include freight charges.
26	VAT_BASIS_AMT_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	VAT Basis Amt in Base Curr
27	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.
28	UNIT_AMT	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Unit Price
29	BI_CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Billing Currency Code