PY_1042S_FILCTL(SQL Table) |
Index Back |
---|---|
1042S YE File ControlThis record stores information of the Transmitter File for 1042S YE process. |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | TAX_YEAR | Signed Number(5,0) | DECIMAL(4) NOT NULL | Tax Year |
2 | TRANSMITTER | Character(3) | VARCHAR2(3) NOT NULL |
Transmitter
Prompt Table: COMPANY_TBL |
3 | PY_FILE_NO | Number(3,0) | SMALLINT NOT NULL | 1042S File Number |
4 | PY_1042S_AMEND | Character(1) | VARCHAR2(1) NOT NULL |
Amendment Run
Y/N Table Edit |
5 | PY_FORM_SUBMITTED | Character(1) | VARCHAR2(1) NOT NULL |
1042S Form Submitted
Y/N Table Edit Default Value: N |
6 | LAST_UPDT_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Last Updated User Name |
7 | LAST_UPDATE_DTM | DateTime(26) | TIMESTAMP | Last Modified |