GPNZ_WT_RATE (SQL Table)	Index Back
NZ Withholding Tax Rate This table contains the different nature of payments that are used in New Zealand. This table is used for calculating the withholding tax in New Zealand. This is delivered as system data with the product.

GPNZ_WT_RATE

(SQL Table)

NZ Withholding Tax Rate

This table contains the different nature of payments that are used in New Zealand. This table is used for calculating the withholding tax in New Zealand. This is delivered as system data with the product.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 GPNZ_PAY_NATURE Character(6) VARCHAR2(6) NOT NULL New Zealand Nature of Payment

2 EFFDT Date(10) DATE NOT NULL Effective Date

3 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive
Default Value: A

4 GPNZ_NORM_TAX_RT Signed Number(13,3) DECIMAL(11,3) NOT NULL New Zealand Normal Tax Rate

5 GPNZ_NODEC_TAX_RT Signed Number(13,3) DECIMAL(11,3) NOT NULL New Zealand No Declaration Tax Rate

6 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50

7 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description

8 DESCRLONG Long Character CLOB Long Description

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	GPNZ_PAY_NATURE	Character(6)	VARCHAR2(6) NOT NULL	New Zealand Nature of Payment
2	EFFDT	Date(10)	DATE NOT NULL	Effective Date
3	EFF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Effective Status A=Active I=Inactive Default Value: A
4	GPNZ_NORM_TAX_RT	Signed Number(13,3)	DECIMAL(11,3) NOT NULL	New Zealand Normal Tax Rate
5	GPNZ_NODEC_TAX_RT	Signed Number(13,3)	DECIMAL(11,3) NOT NULL	New Zealand No Declaration Tax Rate
6	DESCR50	Character(50)	VARCHAR2(50) NOT NULL	Description of length 50
7	DESCRSHORT	Character(10)	VARCHAR2(10) NOT NULL	Short Description
8	DESCRLONG	Long Character	CLOB	Long Description