GPNL_RC_WD

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
2	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
3	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company Prompt Table: COMPANY_TBL
4	GPNL_MRG_TAXID	Character(1)	VARCHAR2(1) NOT NULL	All companies same Tax Number Y/N Table Edit
5	BEGIN_DT	Date(10)	DATE	Begin Date
6	END_DT	Date(10)	DATE	end date
7	GPNL_MEDIUM_CD	Character(2)	VARCHAR2(2) NOT NULL	Medium Code 11=Tape 12=Cartridge 3480 13=Cartridge 3490 14=Cartridge 3490E 15=Cartridge DAT 16=Cartridge EXABYTE 42=Diskette 3 1/2 DS 43=Diskette 3 1/2 DSHD 60=CD-ROM
8	GPNL_FILE_PATH	Character(250)	VARCHAR2(250) NOT NULL	File Path
9	GPNL_FILE_NAME	Character(50)	VARCHAR2(50) NOT NULL	File Name
10	CONTACT_EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Contact - Vacancy Announcement Prompt Table: PERS_SRCH_GBL
11	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)
12	GPNL_ERR_MSG_ID	Character(64)	VARCHAR2(64) NOT NULL	Unique Message ID that identifies a response message from the tax authority
13	GPNL_Y_N	Character(1)	VARCHAR2(1) NOT NULL	This field is used in reporting N=N Y=Y
14	GPNL_WD_MSG_ID	Character(32)	VARCHAR2(32) NOT NULL	WALVIS Prompt Table: GPNL_MSG_XML
15	EMPLR_TAX_NUM_NLD	Number(9,0)	DECIMAL(9) NOT NULL	Federal Employer Tax ID
16	GPNL_TAX_NUM_SUF	Character(3)	VARCHAR2(3) NOT NULL	Tax Number Suffix
17	GPNL_WD_IDENT	Character(12)	VARCHAR2(12) NOT NULL	A unique identifier for an employment used within the Wage Declaration
18	CONTACT_TITLE	Character(35)	VARCHAR2(35) NOT NULL	Contact Title
19	GPNL_DESCR10	Character(10)	VARCHAR2(10) NOT NULL	A 10 digit field used for a Dutch phone number
20	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")
21	GPNL_WD_MSG_NBR	Number(7,0)	INTEGER NOT NULL	Message number used for the sequencing of Wage Declarations
22	DESCR200	Character(254)	VARCHAR2(254) NOT NULL	Long Description
23	GPNL_WD_PER_IND	Character(1)	VARCHAR2(1) NOT NULL	Wage Tax Declaration. Period Indicator. A=Annual C=Period Correction I=Initial Period
24	GPNL_WD_MSG_IND	Character(1)	VARCHAR2(1) NOT NULL	Wage tax declaration Message Indicator. A=Adjustment Message C=Complete Message N=Annual R=Correction Previous Year X=Complete Message w/o Retro Default Value: C
25	GPNL_WD_ORIG_MSG	Character(32)	VARCHAR2(32) NOT NULL	Reference to the original message id, used for corrections.
26	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)
27	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)
28	GPNL_WD_DELTA	Signed Number(16,2)	DECIMAL(14,2) NOT NULL	Field used in the XML structure for the Wage Declaration to store the Delta between the re-calculated and the original collective total amount to be paid for a previous period
29	GPNL_DESCR_10	Character(10)	VARCHAR2(10) NOT NULL	Description field of length 10
30	GPNL_WD_APPL	Character(35)	VARCHAR2(35) NOT NULL	Wage Tax Declaration Application Name.
31	GPNL_WD_REL_NR	Character(8)	VARCHAR2(8) NOT NULL	Unique Relation Number
32	GPNL_WD_SW_IN_USE	Character(27)	VARCHAR2(27) NOT NULL	Software in use
33	GPNL_MSG_STATUS	Character(1)	VARCHAR2(1) NOT NULL	The status of a Wage Declaration message A=Annual F=Finalized (Sent) P=Pending