GPNL_COL_XML

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	GPNL_WD_MSG_ID	Character(32)	VARCHAR2(32) NOT NULL	WALVIS
2	GPNL_EMPLR_TAX_ID	Character(12)	VARCHAR2(12) NOT NULL	Unique ID for the Employer assigned within the Wage Declaration, composed out of the Employer Tax Number + Suffix (e.g. "L01")
3	PRD_BGN_DT	Date(10)	DATE NOT NULL	Period Begin Date
4	PRD_END_DT	Date(10)	DATE NOT NULL	Pay Period End Date
5	SEQ_NO	Number(2,0)	SMALLINT NOT NULL	Sequence Number Default Value: 0
6	GPNL_COLUMN_14	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Personal Report Column 14
7	GPNL_COLUMN_7	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Personal Report Column 7
8	GPNL_WAO_BS_1E	Signed Number(12,2)	DECIMAL(10,2) NOT NULL	WAO (disabillity) Base 1e
9	GPNL_WAO_BS_2E	Signed Number(12,2)	DECIMAL(10,2) NOT NULL	WAO (Disabillity) Base 2e
10	GPNL_WW_BS_1E	Signed Number(12,2)	DECIMAL(10,2) NOT NULL	WW Base 1e
11	GPNL_UFO_BS_1E	Signed Number(12,2)	DECIMAL(10,2) NOT NULL	Field used within the XML structure of the Wage Declaration
12	GPNL_ZVW_CT_EE_1E	Signed Number(12,2)	DECIMAL(10,2) NOT NULL	WALVIS
13	GPNL_COLUMN_2A	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Employer Tax Report 2a
14	GPNL_COLUMN_2G	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Employer Tax Report 2g
15	GPNL_COLUMN_2F	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Employer Tax Report 2f
16	GPNL_COLUMN_2B	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Employer Tax Report 2b
17	GPNL_COLUMN_2D	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Employer Tax Report 2d
18	GPNL_COLUMN_2E	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Employer Tax Report 2e
19	GPNL_COLUMN_2C	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Employer Tax Report 2c
20	GPNL_COLUMN_2H	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Employer Tax Report 2h
21	GPNL_COLUMN_2I	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Employer Tax Report 2i
22	GPNL_COLUMN_2J	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Employer Tax Report 2J "Eindheffing doorlopend afwisselend gebruik bestelauto's"
23	GPNL_COLUMN_3F	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Employer Tax Report 3f
24	GPNL_COLUMN_3B	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Employer Tax Report 3b
25	GPNL_COLUMN_3G	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Employer Tax Report 3g
26	GPNL_COLUMN_3H	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Employer Tax Report 3h
27	GPNL_COLUMN_3C	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Employer Tax Report 3c
28	GPNL_COLUMN_3M	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Employer Tax Report 3m Tax Reduction R&D, reduction for Research & Development (S&O - Speur- en Ontwikkelwerk)
29	GPNL_WAO_CT_TT_1E	Signed Number(12,2)	DECIMAL(10,2) NOT NULL	WAO (Disabillity) Total Contributn 1e
30	GPNL_WAO_CT_TT_2E	Signed Number(12,2)	DECIMAL(10,2) NOT NULL	WAO (Disabillity) Total Contributn 2e
31	GPNL_WW_CT_TT_1E	Signed Number(12,2)	DECIMAL(10,2) NOT NULL	WW Total Contributn 1e
32	GPNL_ZVW_CT_TT_1E	Signed Number(12,2)	DECIMAL(10,2) NOT NULL	WALVIS
33	GPNL_HANDICAP_AMT	Signed Number(12,2)	DECIMAL(10,2) NOT NULL	Handicap discount for employers on Social Security contributions
34	GPNL_ELDR_EMP_AMT	Signed Number(12,2)	DECIMAL(10,2) NOT NULL	Premium Discount Employment Elderly Employee
35	GPNL_ELDR_HIR_AMT	Signed Number(12,2)	DECIMAL(10,2) NOT NULL	Premium Discount Hire Elderly Employment
36	GPNL_WD_PER_AMT	Signed Number(16,2)	DECIMAL(14,2) NOT NULL	Wage Tax Decklaration. Totals of the WAO/WW/ZFW + Withholded Wage Tax (acc. Period based on calendar period)
37	GPNL_WD_TOT_AMT	Signed Number(16,2)	DECIMAL(14,2) NOT NULL	Wage Tax Declaration: Total of WAO/WW/ZFW + Withholded Wage Tax + or - the correction of previous periods (acc. Period based on calendar period)
38	GPNL_WAO_BS_PMA	Signed Number(11,0)	DECIMAL(10) NOT NULL	Premium Waiver for Marginal Labor Default Value: 0
39	GPNL_LCA_PAYMENTS	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Track the paid labor costs per period.
40	GPNL_LCA_TAX	Signed Number(11,0)	DECIMAL(10) NOT NULL	Track the paid labor costs per period.
41	GPNL_COLUMN_2K1	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Employer Tax Report 2J "Eindheffing doorlopend afwisselend gebruik bestelauto's"
42	GPNL_ZVW_CT_EE_2E	Signed Number(12,2)	DECIMAL(10,2) NOT NULL	WALVIS