WTHD_A_RECORD(SQL Table) |
Index Back |
|---|
| # | 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 | WTHD_PAYMENT_YEAR | Character(4) | VARCHAR2(4) NOT NULL | Payment Year |
| 3 | BLANK6 | Character(6) | VARCHAR2(6) NOT NULL | 6 Blanks |
| 4 | A_PAYER_TIN | Character(9) | VARCHAR2(9) NOT NULL | Payer TIN |
| 5 | A_PAYER_NAME_CNTL | Character(4) | VARCHAR2(4) NOT NULL | Payer Name Control |
| 6 | A_LAST_FILING_IND | Character(1) | VARCHAR2(1) NOT NULL | Last Filing Indicator |
| 7 | A_COMB_FEDSTATE | Character(1) | VARCHAR2(1) NOT NULL | Combine Federal/State Filer |
| 8 | A_TYPE_OF_RETURN | Character(2) | VARCHAR2(2) NOT NULL |
Type of Return
6=1099-INT A=1099-MISC F=1099-G |
| 9 | A_AMOUNT_CODES | Character(16) | VARCHAR2(16) NOT NULL | Amount Codes |
| 10 | BLANK6_2 | Character(6) | VARCHAR2(6) NOT NULL | 6 Blanks |
| 11 | A_ORIGIN_FILE_IND | Character(1) | VARCHAR2(1) NOT NULL | Original File Indicator |
| 12 | A_REPLACE_FILE_IND | Character(1) | VARCHAR2(1) NOT NULL | Replacement File Indicator |
| 13 | A_CORRECT_FILE_IND | Character(1) | VARCHAR2(1) NOT NULL | Correction File Indicator |
| 14 | BLANK1 | Character(1) | VARCHAR2(1) NOT NULL | Blank Field of 1 Character |
| 15 | A_FOREIGN_ENTITY | Character(1) | VARCHAR2(1) NOT NULL | Foreign Entity Indicator |
| 16 | A_PAYER_NAME1 | Character(40) | VARCHAR2(40) NOT NULL | First Payer Name Line |
| 17 | A_PAYER_NAME2 | Character(40) | VARCHAR2(40) NOT NULL | Second Payer Name Line |
| 18 | A_TRANSFER_AGENT | Character(1) | VARCHAR2(1) NOT NULL | Transfer Agent Indicator |
| 19 | A_PAYER_ADDRESS | Character(40) | VARCHAR2(40) NOT NULL | Payer Ship Address |
| 20 | A_PAYER_CITY | Character(40) | VARCHAR2(40) NOT NULL | Payer City |
| 21 | A_PAYER_STATE | Character(2) | VARCHAR2(2) NOT NULL | Payer State |
| 22 | A_PAYER_ZIP | Character(9) | VARCHAR2(9) NOT NULL | Payer ZIP Code |
| 23 | A_PAYER_PHONE | Character(15) | VARCHAR2(15) NOT NULL | Payer Phone Number & Extension |
| 24 | BLANK254_1 | Character(254) | VARCHAR2(254) NOT NULL | 254 Blanks |
| 25 | BLANK6_1 | Character(6) | VARCHAR2(6) NOT NULL | 6 Blanks |
| 26 | REC_SEQ_NBR | Character(8) | VARCHAR2(8) NOT NULL | Record Sequence Number |
| 27 | BLANK241 | Character(241) | VARCHAR2(241) NOT NULL | blank |
| 28 | BLANK2 | Character(2) | VARCHAR2(2) NOT NULL | 2 blanks |