RUN_1099(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  OPRID |
Character(30) | VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
Prompt Table: OPR_DEF_TBL_AP |
| 2 | RUN_CNTL_ID |
Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 3 | SETID | Character(5) | VARCHAR2(5) NOT NULL |
SetID
Prompt Table: SP_SETID_NONVW |
| 4 | WTHD_CNTL_ID | Character(10) | VARCHAR2(10) NOT NULL |
Control ID
Prompt Table: WTHD_CNTL |
| 5 | LANGUAGE_CD | Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 6 | WTHD_RPT_ID | Character(10) | VARCHAR2(10) NOT NULL |
Withholding Report ID
Prompt Table: WTHD_RPT_DFN |
| 7 | WTHD_FILE_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Type of File/Return
O=Original/Correction R=Replacement T=Test |
| 8 | REPLACE_CHAR | Character(2) | VARCHAR2(2) NOT NULL | Replacement Character |
| 9 | FILE_NAME_SHORT | Character(30) | VARCHAR2(30) NOT NULL | File Name |
| 10 | ORIGINAL_SENT_MODE | Character(1) | VARCHAR2(1) NOT NULL |
Original Submission Mode
D=Magnetic/Disk E=Electronic T=Magnetic/Tape |
| 11 | MEDIA_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Media Type
D=Magnetic/Disk E=Electronic T=Magnetic/Tape |
| 12 | INCL_NON_COMP_AMT | Character(1) | VARCHAR2(1) NOT NULL |
Include Box &
A=All E=Exclude Non Employee Compensat I=Include Non Employee Compensat Default Value: A |
| 13 | IRS_FILE_SENT | Character(1) | VARCHAR2(1) NOT NULL | IRS FILE SENT |
| 14 | WTHD_PRCS_OPTION | Character(1) | VARCHAR2(1) NOT NULL |
Withhold Type Process Option
1=All 2=1099-MISC, 1099-INT and 1099-G 3=1099-NEC |