[Home] [Help]
View: PAY_US_ASG_STATES_V
View Text
SELECT DISTINCT PUR.ASSIGNMENT_ID
, SUBSTR(PUR.JURISDICTION_CODE
, 1
, 2)||'-000-0000' JURISDICTION_CODE
, PUR.TAX_UNIT_ID
FROM PAY_US_ASG_REPORTING PUR
Columns
Name |
ASSIGNMENT_ID |
JURISDICTION_CODE |
TAX_UNIT_ID |