TAXLOCAN_LNG_VW(SQL View) |
Index Back |
---|---|
Related Lang - TAX_LOCVW_CANSelects 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 |
# | 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 |