IST_DISP11_TAO (SQL Table)	Index Back
Intrastat Dispatch 11 Temp

IST_DISP11_TAO

(SQL Table)

Intrastat Dispatch 11 Temp

# 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_PO Character(5) VARCHAR2(5) NOT NULL PO Business Unit

3 RTV_ID Character(10) VARCHAR2(10) NOT NULL Return To Vendor ID

4 RTV_LN_NBR Number(5,0) INTEGER NOT NULL Return To Vendor Line

5 RTV_DISTRIB_NUM Number(5,0) INTEGER NOT NULL RTV Distribution Number

6 RETURN_SETID Character(5) VARCHAR2(5) NOT NULL RTV (Supplier) SetID

7 RETURN_VENDOR Character(10) VARCHAR2(10) NOT NULL Return to Vendor

8 VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Vendor Location

9 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.

10 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.

11 IST_INV_TXN_TMP Signed Number(30,5) DECIMAL(28,5) NOT NULL IST Txn Invoice Amt - Temp

12 IST_INV_BSE_TMP Signed Number(30,5) DECIMAL(28,5) NOT NULL IST Bse Invoice Amt - Temp

13 IST_INV_AMT_TXN Signed Number(28,3) DECIMAL(26,3) NOT NULL Invoice Amount - Transaction

14 IST_INV_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Invoice Amount - Base Currency

15 TXN_CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Transaction Currency

16 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. "

17 IST_AMOUNT_SRC Character(1) VARCHAR2(1) NOT NULL Intrastat Amount Source
I=Invoice
M=Manual Entry
O=Order

18 REPLACEMENT_FLG Character(2) VARCHAR2(2) NOT NULL Replacement Flag
NA=Not Applicable
RN=Replace Goods Not Returned
RR=Replacement of Returned Goods

#	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_PO	Character(5)	VARCHAR2(5) NOT NULL	PO Business Unit
3	RTV_ID	Character(10)	VARCHAR2(10) NOT NULL	Return To Vendor ID
4	RTV_LN_NBR	Number(5,0)	INTEGER NOT NULL	Return To Vendor Line
5	RTV_DISTRIB_NUM	Number(5,0)	INTEGER NOT NULL	RTV Distribution Number
6	RETURN_SETID	Character(5)	VARCHAR2(5) NOT NULL	RTV (Supplier) SetID
7	RETURN_VENDOR	Character(10)	VARCHAR2(10) NOT NULL	Return to Vendor
8	VNDR_LOC	Character(10)	VARCHAR2(10) NOT NULL	Vendor Location
9	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.
10	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.
11	IST_INV_TXN_TMP	Signed Number(30,5)	DECIMAL(28,5) NOT NULL	IST Txn Invoice Amt - Temp
12	IST_INV_BSE_TMP	Signed Number(30,5)	DECIMAL(28,5) NOT NULL	IST Bse Invoice Amt - Temp
13	IST_INV_AMT_TXN	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Invoice Amount - Transaction
14	IST_INV_AMT_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Invoice Amount - Base Currency
15	TXN_CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Transaction Currency
16	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. "
17	IST_AMOUNT_SRC	Character(1)	VARCHAR2(1) NOT NULL	Intrastat Amount Source I=Invoice M=Manual Entry O=Order
18	REPLACEMENT_FLG	Character(2)	VARCHAR2(2) NOT NULL	Replacement Flag NA=Not Applicable RN=Replace Goods Not Returned RR=Replacement of Returned Goods