IST_CNTRY_VW_LG (SQL View)	Index Back
VAT Entity Intrastat Cntr RLR

IST_CNTRY_VW_LG

(SQL View)

VAT Entity Intrastat Cntr RLR

SELECT A.VAT_ENTITY, B.IST_FLOW, A.COUNTRY, C.LANGUAGE_CD, C.DESCR FROM PS_VAT_ENT_RGSTRN A, PS_IST_COUNTRY_TBL B, PS_COUNTRYTBL_LANG C WHERE A.IST_RPTG_FLG = 'Y' AND A.COUNTRY = B.COUNTRY AND A.COUNTRY = C.COUNTRY

Related Language Record for IST_CNTRY_VW

# 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 IST_FLOW Character(1) VARCHAR2(1) NOT NULL Intrastat Report Flow
A=Arrivals
D=Dispatches

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

4 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code

5 DESCR Character(30) VARCHAR2(30) NOT NULL Description

#	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	IST_FLOW	Character(1)	VARCHAR2(1) NOT NULL	Intrastat Report Flow A=Arrivals D=Dispatches
3	COUNTRY_IST_RPTG	Character(3)	VARCHAR2(3) NOT NULL	IST Reporting Country
4	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
5	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description