IST_DISP7_TAO

#	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	IST_INV_TXN_TMP	Signed Number(30,5)	DECIMAL(28,5) NOT NULL	IST Txn Invoice Amt - Temp
6	IST_INV_BSE_TMP	Signed Number(30,5)	DECIMAL(28,5) NOT NULL	IST Bse Invoice Amt - Temp
7	IST_INV_AMT_TXN	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Invoice Amount - Transaction
8	IST_INV_AMT_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Invoice Amount - Base Currency
9	TXN_CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Transaction Currency
10	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. "
11	COUNTRY_VAT_TPRTNR	Character(3)	VARCHAR2(3) NOT NULL	Trading Partner's VAT Registration Country. **** WARNING **** - This field has label ids of CUSTOMER, VENDOR, BANK. Do NOT delete these label ids. They are used to ensure the correct label is displayed on the common VAT subpages.
12	VAT_RGSTRN_TPRTNR	Character(20)	VARCHAR2(20) NOT NULL	Trading Partner's VAT Registration ID **** WARNING **** - This field has label ids of CUSTOMER, VENDOR, BANK. Do NOT delete these label ids. They are used to ensure the correct label is displayed on the common VAT subpages.
13	BILL_TO_CUST_ID	Character(15)	VARCHAR2(15) NOT NULL	Customer
14	IST_AMOUNT_SRC	Character(1)	VARCHAR2(1) NOT NULL	Intrastat Amount Source I=Invoice M=Manual Entry O=Order
15	CUST_SETID	Character(5)	VARCHAR2(5) NOT NULL	Customer SetID
16	CUST_ID	Character(15)	VARCHAR2(15) NOT NULL	Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations.
17	INV_ITEM_ID	Character(18)	VARCHAR2(18) NOT NULL	Item ID
18	UNIT_MEASURE_STD	Character(3)	VARCHAR2(3) NOT NULL	Standard Unit of Measure
19	QTY_SHIP_BASE	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Qty Ship Base
20	UOM_BILL	Character(3)	VARCHAR2(3) NOT NULL	Bill Unit of Measure
21	QTY_BILL	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Quantity in Billing UOM