TAXLOCAN_LNG_VW

(SQL View)
Index Back

Related Lang - TAX_LOCVW_CAN

Selects active tax location codes from the Tax Location table.

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

  • Related Language Record for TAX_LOCVW_CAN
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 TAX_LOCATION_CD Character(10) VARCHAR2(10) NOT NULL Tax Location Code
    2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description