VND_VATRGSTN_VW

(SQL View)
 Index Back

Supplier VAT Information


SELECT A.SETID ,A.VENDOR_ID ,A.COUNTRY ,A.COUNTRY_2CHAR ,A.VAT_RGSTRN_ID ,A.HOME_COUNTRY_FLG FROM PS_VNDR_VAT_RGSTRN A

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID
2 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier

Default Value: VNDR_SECPNL_WRK.VENDOR_ID

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

Prompt Table: COUNTRY_VAT_VW

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

Prompt Table: CNTRY_VAT_2C_VW

5 VAT_RGSTRN_ID Character(20) VARCHAR2(20) NOT NULL VAT Registration ID
6 HOME_COUNTRY_FLG Character(1) VARCHAR2(1) NOT NULL Home Country
N=No
Y=Yes

Y/N Table Edit

Default Value: N