GPNL_WD_MSG_IDA=Annual
F=Finalized (Sent)
P=Pending
GPNL_MSG_XML(SQL Table) |
Index Back |
|---|---|
Wage Declaration - HeaderWage Declaration: Message Header |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | GPNL_WD_MSG_ID |
Character(32) | VARCHAR2(32) NOT NULL | WALVIS |
| 2 | GPNL_XMLDTTM | Character(20) | VARCHAR2(20) NOT NULL | Datetime stamp of the moment used for the creation of the wage declaration |
| 3 | CONTACT_TITLE | Character(35) | VARCHAR2(35) NOT NULL | Contact Title |
| 4 | GPNL_WD_MSG_NBR | Number(7,0) | INTEGER NOT NULL | Message number used for the sequencing of Wage Declarations |
| 5 | GPNL_DESCR10 | Character(10) | VARCHAR2(10) NOT NULL | A 10 digit field used for a Dutch phone number |
| 6 | GPNL_WD_APPL | Character(35) | VARCHAR2(35) NOT NULL | Wage Tax Declaration Application Name. |
| 7 | GPNL_WD_REL_NR | Character(8) | VARCHAR2(8) NOT NULL | Unique Relation Number |
| 8 | GPNL_WD_SW_IN_USE | Character(27) | VARCHAR2(27) NOT NULL | Software in use |
| 9 | COMPANY | Character(3) | VARCHAR2(3) NOT NULL | Company |
| 10 | GPNL_MSG_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
The status of a Wage Declaration message
A=Annual F=Finalized (Sent) P=Pending |