PY_1042S_MSG(SQL Table) |
Index Back |
---|---|
1042-S Message1042-S Message |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | TAX_YEAR | Signed Number(5,0) | DECIMAL(4) NOT NULL | Tax Year |
2 | PY_FORM_ID | Number(10,0) | DECIMAL(10) NOT NULL | 1042S Unique Form Identifier |
3 | PY_AMEND_NO | Number(2,0) | SMALLINT NOT NULL | 1042S Amendment Number |
4 | PY_MSG_CATEGORY | Character(1) | VARCHAR2(1) NOT NULL |
Message Category
E=Recipient's Information T=Tax X=Transfer |
5 | PY_MSG_SEQNUM | Number(5,0) | INTEGER NOT NULL | Warning Sequence Number |
6 | PY_MSG_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Error Type
E=Error R=Remarks W=Warning |
7 | TEXT_ID | Character(18) | VARCHAR2(18) NOT NULL | Text ID |
8 | PY_PARM1 | Character(20) | VARCHAR2(20) NOT NULL | Payroll Parameter 1 |
9 | PY_PARM2 | Character(20) | VARCHAR2(20) NOT NULL | Payroll Parameter 2 |