ITA_VAT_RPL2_VW

(SQL View)

SELECT DISTINCT CUST_ID ,PROCESS_INSTANCE ,VAT_ENTITY ,ITA_CNTRY_2CHAR ,VAT_RGSTRN_TPRTNR ,NAME1 ,ADDRESS1 ,POSTAL ,STATE ,CITY ,PROGRESSIVE_ID FROM PS_ITA_VAT_RPT8_VW

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

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

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

4 ITA_CNTRY_2CHAR Character(2) VARCHAR2(2) NOT NULL 2-Char Country Code

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

6 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1

7 ADDRESS1 Character(55) VARCHAR2(55) NOT NULL Address 1

8 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal

9 STATE Character(6) VARCHAR2(6) NOT NULL State

10 CITY Character(30) VARCHAR2(30) NOT NULL City

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	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.
2	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
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. Prompt Table: VAT_ENTITY
4	ITA_CNTRY_2CHAR	Character(2)	VARCHAR2(2) NOT NULL	2-Char Country Code
5	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.
6	NAME1	Character(40)	VARCHAR2(40) NOT NULL	Name 1
7	ADDRESS1	Character(55)	VARCHAR2(55) NOT NULL	Address 1
8	POSTAL	Character(12)	VARCHAR2(12) NOT NULL	Postal
9	STATE	Character(6)	VARCHAR2(6) NOT NULL	State
10	CITY	Character(30)	VARCHAR2(30) NOT NULL	City
11	PROGRESSIVE_ID	Character(5)	VARCHAR2(5) NOT NULL	Progressive ID