CNTRY_VAT_2C_VW

(SQL View)
 Index Back

VAT Country Table View - 2Char


SELECT A.ESL_CNTRY_2CHAR ,C.DESCR ,V.COUNTRY FROM PS_CNTRY_STAT_TBL A , PS_COUNTRY_VAT_TBL V ,PS_COUNTRY_TBL C WHERE V.COUNTRY=C.COUNTRY AND A.COUNTRY=C.COUNTRY

  • Related Language Record: CNTRY_VAT2C_LVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 COUNTRY_2CHAR Character(2) VARCHAR2(2) NOT NULL 2-Char Country Code
    2 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    3 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country