GPHK_IR56_SRLNM(SQL Table) |
Index Back |
---|---|
Table for IR56 Sheet NumberThis table will contain the running sheet number that must be used for IR56B records. The table maintained by Pay Entity and Tax year, thus allowing a unique set for each tax year and Pay Entity. |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | 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.
Prompt Table: GPHK_TAXREF_TBL |
2 | GPHK_TAX_YEAR | Number(4,0) | SMALLINT NOT NULL | Tax year is the year for which statutory reports have to be submitted. For the purposes of reporting this field is required on the run control page. |
3 | GPHK_SHEET_NUM | Number(6,0) | INTEGER NOT NULL | Sheet Number is a system-generated number to identify a sequential record in the IR56B printout. |
4 | GPHK_SHEET_M_NUM | Number(6,0) | INTEGER NOT NULL | Sheet Number is a system-generated number to identify a sequential record in the IR56B printout. |