IST_VATRGS_VW (SQL View)	Index Back
VAT Registration Vw for IST

IST_VATRGS_VW

(SQL View)

VAT Registration Vw for IST

SELECT BUI.BUSINESS_UNIT , VER.COUNTRY , VER.VAT_RGSTRN_ID , LOC.COUNTRY , LOC.STATE , BUI.BUSINESS_UNIT_GL , VEB.VAT_ENTITY FROM PS_BUS_UNIT_TBL_IN BUI , PS_VAT_ENT_BU_GL VEB , PS_VAT_ENT_RGSTRN VER , PS_LOCATION_TBL LOC , PS_SET_CNTRL_REC SCR WHERE VEB.BUSINESS_UNIT = BUI.BUSINESS_UNIT_GL AND VER.VAT_ENTITY=VEB.VAT_ENTITY AND LOC.SETID = SCR.SETID AND LOC.LOCATION = BUI.LOCATION AND LOC.COUNTRY = VER.COUNTRY AND SCR.SETCNTRLVALUE = BUI.BUSINESS_UNIT AND SCR.RECNAME = 'LOCATION_TBL'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

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

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

4 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

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

6 BUSINESS_UNIT_GL Character(5) VARCHAR2(5) NOT NULL GL Business Unit

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
2	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.
3	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.
4	COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country
5	STATE	Character(6)	VARCHAR2(6) NOT NULL	State
6	BUSINESS_UNIT_GL	Character(5)	VARCHAR2(5) NOT NULL	GL Business Unit
7	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.