TAX_LOCATION_CDFO_TAX_LOC_VW(SQL View) |
Index Back |
|---|---|
All tax locatio cd view |
| SELECT DISTINCT a.tax_location_cd , a.descr ,a.country , b.state , b.locality , b.locality_link FROM PS_TAX_LOCATION1 a , ps_tax_location2 b WHERE a.eff_status='A' AND a.tax_location_cd=b.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 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 3 | COUNTRY | Character(3) | VARCHAR2(3) NOT NULL | Country |
| 4 | STATE | Character(6) | VARCHAR2(6) NOT NULL | State |
| 5 | LOCALITY | Character(10) | VARCHAR2(10) NOT NULL | Locality |
| 6 | LOCALITY_LINK | Character(10) | VARCHAR2(10) NOT NULL | Other Work Locality |