WTHD_F_RECORD(SQL Table) |
Index Back |
|---|---|
1099 F Record Layout |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | RECORD_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Record Type
F=Project Funding R=Project Resource Transaction |
| 2 | F_NBR_OF_A_RECS | Character(8) | VARCHAR2(8) NOT NULL | Number of A Records |
| 3 | WTHD_ZERO21 | Character(21) | VARCHAR2(21) NOT NULL | zero |
| 4 | BLANK19 | Character(19) | VARCHAR2(19) NOT NULL | BLANK |
| 5 | HDR_TOT_PAYEES | Character(8) | VARCHAR2(8) NOT NULL | Total Nbr of Payees |
| 6 | BLANK254_1 | Character(254) | VARCHAR2(254) NOT NULL | 254 Blanks |
| 7 | BLANK188 | Character(188) | VARCHAR2(188) NOT NULL | BLANK |
| 8 | REC_SEQ_NBR | Character(8) | VARCHAR2(8) NOT NULL | Record Sequence Number |
| 9 | BLANK241 | Character(241) | VARCHAR2(241) NOT NULL | blank |
| 10 | BLANK2 | Character(2) | VARCHAR2(2) NOT NULL | 2 blanks |