SETIDTAX_AUTHORITY_CDTAX_AUTHORTY_VW(SQL View) |
Index Back |
|---|---|
Tax Authority View |
| SELECT A.SETID ,A.TAX_AUTHORITY_CD ,A.TAX_PCT FROM PS_TAX_AUTHORITY A WHERE A.EFFDT = (SELECT MAX(B.EFFDT) FROM PS_TAX_AUTHORITY B WHERE A.SETID = B.SETID AND A.TAX_AUTHORITY_CD = B.TAX_AUTHORITY_CD AND B.EFFDT <= %CURRENTDATEIN) AND A.EFF_STATUS = 'A' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 2 | TAX_AUTHORITY_CD |
Character(3) | VARCHAR2(3) NOT NULL | Tax Authority |
| 3 | TAX_PCT | Number(6,3) | DECIMAL(5,3) NOT NULL | Tax Percent |