PO_VAT_ENT_VW (SQL View)	Index Back
PO Vat Entity Reqistration Vw F-DMULINAR-3 VAT : New VAT Entity Registration View to get the VAT_SETID info

PO_VAT_ENT_VW

(SQL View)

PO Vat Entity Reqistration Vw

F-DMULINAR-3 VAT : New VAT Entity Registration View to get the VAT_SETID info

SELECT %Substring(ENT.VAT_DRIVER_KEY1,1,20) , %Substring(ENT.VAT_DRIVER_KEY2,1,3) , ENT.VAT_SETID FROM PS_VAT_DEFAULT_HDR ENT WHERE ENT.VAT_DRIVER = 'VAT_ENT_RGSTRN' AND ENT.EFFDT = ( SELECT MAX(ENT2.EFFDT) FROM PS_VAT_DEFAULT_HDR ENT2 WHERE ENT2.VAT_DRIVER = ENT.VAT_DRIVER AND ENT2.VAT_DRIVER_KEY1 = ENT.VAT_DRIVER_KEY1 AND ENT2.VAT_DRIVER_KEY2 = ENT.VAT_DRIVER_KEY2 AND ENT2.EFFDT <= %CurrentDateIn AND ENT2.EFF_STATUS = 'A')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

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

3 VAT_SETID Character(5) VARCHAR2(5) NOT NULL VAT SetID

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	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.
2	COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country
3	VAT_SETID	Character(5)	VARCHAR2(5) NOT NULL	VAT SetID