VNDR_VAT_RGSTRN

(SQL Table)
 Index Back

Supplier VAT Information

Supplier VAT Information

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

Default Value: VNDR_SECPNL_WRK.SETID

Prompt Table: SETID_TBL

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