TAX_LOCVW_CAN

(SQL View)
 Index Back

SELECT DISTINCT a.tax_location_cd , a.descr FROM PS_TAX_LOCATION1 a , ps_tax_location2 b WHERE a.eff_status='A' AND a.tax_location_cd=b.tax_location_cd AND a.country='CAN'

  • Related Language Record: TAX_LOCVWLNGCAN

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 TAX_LOCATION_CD Character(10) VARCHAR2(10) NOT NULL Tax Location Code
    2 DESCR Character(30) VARCHAR2(30) NOT NULL Description