GPHK_EXCHG_TBL (SQL Table)	Index Back
IR56 Conversion Definition This new table contains details that should be used for currency conversion when generating IR56 details. This table will contain 1 row for every tax year. The user will enter the Tax Year (on the search record) and then provide the other details (namely exchange rate type and Effective Date). For the purpose of currency conversion, the system will use the default market rate index MODEL (similar to the GP processing).

GPHK_EXCHG_TBL

(SQL Table)

IR56 Conversion Definition

This new table contains details that should be used for currency conversion when generating IR56 details. This table will contain 1 row for every tax year. The user will enter the Tax Year (on the search record) and then provide the other details (namely exchange rate type and Effective Date). For the purpose of currency conversion, the system will use the default market rate index MODEL (similar to the GP processing).

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 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.

2 RT_TYPE Character(5) VARCHAR2(5) NOT NULL Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical.
Prompt Table: RT_TYPE_TBL

3 EFFDT_FROM Date(10) DATE NOT NULL Effective Date From
Prompt Table: GPHK_EXC_DT_VW

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	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.
2	RT_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical. Prompt Table: RT_TYPE_TBL
3	EFFDT_FROM	Date(10)	DATE NOT NULL	Effective Date From Prompt Table: GPHK_EXC_DT_VW