COMPANYSTATEYEAR_DISPLAYMONTHGPMX_TAX_SP_VW(SQL View) |
Index Back |
|---|---|
Special Tax ViewGPMX Special Tax View |
| SELECT A.COMPANY , A.STATE , A.YEAR_DISPLAY , A.MONTH , SUM( A.CALC_RSLT_VAL) FROM PS_GPMX_TAX_SP_WA A WHERE A.ORIG_CAL_RUN_ID = A.CAL_RUN_ID GROUP BY A.COMPANY , A.STATE , A.YEAR_DISPLAY , A.MONTH |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | COMPANY |
Character(3) | VARCHAR2(3) NOT NULL | Company |
| 2 | STATE |
Character(6) | VARCHAR2(6) NOT NULL | State |
| 3 | YEAR_DISPLAY |
Number(4,0) | SMALLINT NOT NULL | Year Display |
| 4 | MONTH |
Number(2,0) | SMALLINT NOT NULL | Month |
| 5 | CALC_RSLT_VAL | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Calculation Numeric Result |