ITA_VAT_RPT5_VW

(SQL View)

SELECT DISTINCT(PROCESS_INSTANCE) , VAT_ENTITY ,VAT_DCMNT_ID ,VAT_RGSTRN_ID ,ENTITY_NAME ,COUNTRY_2CHAR ,PROGRESSIVE_ID FROM PS_ITA_VAT_RPT6_VW

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 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.
Prompt Table: VAT_ENTITY

3 VAT_DCMNT_ID Number(8,0) INTEGER NOT NULL VAT Document ID

4 VAT_RGSTRN_ID Character(20) VARCHAR2(20) NOT NULL VAT Registration ID

5 ENTITY_NAME Character(50) VARCHAR2(50) NOT NULL Entity Name

6 COUNTRY_2CHAR Character(2) VARCHAR2(2) NOT NULL 2-Char Country Code

7 PROGRESSIVE_ID Character(5) VARCHAR2(5) NOT NULL Progressive ID

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	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. Prompt Table: VAT_ENTITY
3	VAT_DCMNT_ID	Number(8,0)	INTEGER NOT NULL	VAT Document ID
4	VAT_RGSTRN_ID	Character(20)	VARCHAR2(20) NOT NULL	VAT Registration ID
5	ENTITY_NAME	Character(50)	VARCHAR2(50) NOT NULL	Entity Name
6	COUNTRY_2CHAR	Character(2)	VARCHAR2(2) NOT NULL	2-Char Country Code
7	PROGRESSIVE_ID	Character(5)	VARCHAR2(5) NOT NULL	Progressive ID