GPHK_FL_TAX_YEARGPHK_TAX_REF_NUMGPHK_FL_SHEET_NOEMPLIDGPHK_56B_XML_VW(SQL View) |
Index Back |
|---|---|
IR56B XML data viewIR56B XML data view for GPHK_56B_XML_BD |
| SELECT GPHK_FL_TAX_YEAR , GPHK_TAX_REF_NUM , GPHK_FL_SHEET_NO , EMPLID FROM PS_GPHK_56B_XML_BD ORDER BY GPHK_FL_TAX_YEAR , GPHK_TAX_REF_NUM , GPHK_FL_SHEET_NO |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | GPHK_FL_TAX_YEAR |
Character(4) | VARCHAR2(4) NOT NULL | This field is used by the file layout object that generates the IR56B electronic File. |
| 2 | GPHK_TAX_REF_NUM |
Character(20) | VARCHAR2(20) NOT NULL | This field will contain the tax reference number that Hong Kong Pay entities are associated with. |
| 3 | GPHK_FL_SHEET_NO |
Character(6) | VARCHAR2(6) NOT NULL | This field is used by the file layout object that generates the IR56B electronic File. |
| 4 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |