IST_DISP14_TAO

#	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	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
5	COUNTRY_SHIP_FROM	Character(3)	VARCHAR2(3) NOT NULL	Specifies the country from which the invoice contents were shipped (for VAT processing only).
6	IST_TXN_SOURCE	Character(4)	VARCHAR2(4) NOT NULL	Intrastat Transaction Source BILL=Billing Adjustment IREC=RMA Receipt IURC=Interunit Receipt IUSH=Interunit Shipment MANU=Manual Entry RECV=Purchase Receipt RTVR=Receipt Returns RTVS=Shipment Return SHIP=Shipment VCHR=Voucher Adjustment
7	COUNTRY_VAT_BILLTO	Character(3)	VARCHAR2(3) NOT NULL	Specifies the country where an invoice is sent (for VAT processing only).
8	VAT_RGSTRN_BUYER	Character(20)	VARCHAR2(20) NOT NULL	Specifies a customers VAT Registration ID for a particular country.
9	IST_TXN_DT	Date(10)	DATE	Intrastat Transaction Date
10	IST_MEMBER_STATE	Character(3)	VARCHAR2(3) NOT NULL	Country of Cons/Dest
11	NATURE_OF_TXN1	Character(1)	VARCHAR2(1) NOT NULL	Nature of Transaction 1
12	NATURE_OF_TXN2	Character(1)	VARCHAR2(1) NOT NULL	Nature of Transaction 2
13	FISCAL_REGIME	Character(6)	VARCHAR2(6) NOT NULL	Fiscal Regime
14	IST_INV_AMT_TXN	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Invoice Amount - Transaction
15	IST_INV_AMT_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Invoice Amount - Base Currency
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	CUST_SETID	Character(5)	VARCHAR2(5) NOT NULL	Customer SetID
18	TXN_CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Transaction Currency
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	IST_AMOUNT_SRC	Character(1)	VARCHAR2(1) NOT NULL	Intrastat Amount Source I=Invoice M=Manual Entry O=Order