GPHK_TAXREF_DTL

(SQL Table)
Index Back

Tax Reference -Pay Entity Dtl

This is a new table that will store pay entity details that are associated to a specific tax reference number. This is actually a child record of GPHK_TAXREF_TBL.

# 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.
2 EFFDT Date(10) DATE Effective Date

Default Value: %date

3 PAY_ENTITY Character(10) VARCHAR2(10) NOT NULL Pay Entity

Prompt Table: GP_PYENT

4 PRIMARY_INDICATOR Character(1) VARCHAR2(1) NOT NULL Primary Indicator for Multiple

Y/N Table Edit

Default Value: N