IST_RPT_ERR1 (SQL Table)	Index Back
VAT Exchange Rate Error Table

IST_RPT_ERR1

(SQL Table)

VAT Exchange Rate Error Table

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance

2 IST_FLOW Character(1) VARCHAR2(1) NOT NULL Intrastat Report Flow
A=Arrivals
D=Dispatches

3 VAT_ENTITY Character(20) VARCHAR2(20) NOT NULL Specifies an organizational entity that is responsible for VAT reporting and that is registered in one or more countries that require VAT reporting. A single VAT entity is linked to one or more General Ledger Business Units depending on the reporting requirements.

4 COUNTRY_IST_RPTG Character(3) VARCHAR2(3) NOT NULL IST Reporting Country

5 IST_DCMNT_ID Number(8,0) INTEGER NOT NULL Intrastat Document ID

6 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	IST_FLOW	Character(1)	VARCHAR2(1) NOT NULL	Intrastat Report Flow A=Arrivals D=Dispatches
3	VAT_ENTITY	Character(20)	VARCHAR2(20) NOT NULL	Specifies an organizational entity that is responsible for VAT reporting and that is registered in one or more countries that require VAT reporting. A single VAT entity is linked to one or more General Ledger Business Units depending on the reporting requirements.
4	COUNTRY_IST_RPTG	Character(3)	VARCHAR2(3) NOT NULL	IST Reporting Country
5	IST_DCMNT_ID	Number(8,0)	INTEGER NOT NULL	Intrastat Document ID
6	LINE_NBR	Number(5,0)	INTEGER NOT NULL	Line Number: 11/24/08 - Added TARGET label [PC product]