WTHD_B_INT_REC(SQL Table) |
Index Back |
|---|---|
WTHD 1099INT 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 | WTHD_PAYMENT_YEAR | Character(4) | VARCHAR2(4) NOT NULL | Payment Year |
| 3 | B_CORRECTED_RETURN | Character(1) | VARCHAR2(1) NOT NULL | Corrected Return Indicator |
| 4 | B_NAME_CONTROL | Character(4) | VARCHAR2(4) NOT NULL | Name Control |
| 5 | B_TYPE_OF_TIN | Character(1) | VARCHAR2(1) NOT NULL | Type Of TIN |
| 6 | B_PAYEE_TIN | Character(9) | VARCHAR2(9) NOT NULL | Payee's TIN |
| 7 | B_PAYEE_ACCT_NO | Character(20) | VARCHAR2(20) NOT NULL | Payer's Account Nbr for Payee |
| 8 | B_PAYER_OFFICE_CD | Character(4) | VARCHAR2(4) NOT NULL | Payer's Office Code |
| 9 | BLANK10 | Character(10) | VARCHAR2(10) NOT NULL | 10 blanks |
| 10 | B_PAYMENT_AMT_1 | Character(12) | VARCHAR2(12) NOT NULL | Payment Amount 1 |
| 11 | B_PAYMENT_AMT_2 | Character(12) | VARCHAR2(12) NOT NULL | Payment Amount |
| 12 | B_PAYMENT_AMT_3 | Character(12) | VARCHAR2(12) NOT NULL | Payment Amount |
| 13 | B_PAYMENT_AMT_4 | Character(12) | VARCHAR2(12) NOT NULL | Payment Amount |
| 14 | B_PAYMENT_AMT_5 | Character(12) | VARCHAR2(12) NOT NULL | Payment Amount |
| 15 | B_PAYMENT_AMT_6 | Character(12) | VARCHAR2(12) NOT NULL | Payment Amount |
| 16 | B_PAYMENT_AMT_7 | Character(12) | VARCHAR2(12) NOT NULL | Payment Amount |
| 17 | B_PAYMENT_AMT_8 | Character(12) | VARCHAR2(12) NOT NULL | Payment Amount |
| 18 | B_PAYMENT_AMT_9 | Character(12) | VARCHAR2(12) NOT NULL | Payment Amount |
| 19 | B_PAYMENT_AMT_A | Character(12) | VARCHAR2(12) NOT NULL | Payment Amount |
| 20 | B_PAYMENT_AMT_B | Character(12) | VARCHAR2(12) NOT NULL | Payment Amount |
| 21 | B_PAYMENT_AMT_C | Character(12) | VARCHAR2(12) NOT NULL | Payment Amount |
| 22 | B_PAYMENT_AMT_D | Character(12) | VARCHAR2(12) NOT NULL | Payment Amount |
| 23 | B_PAYMENT_AMT_E | Character(12) | VARCHAR2(12) NOT NULL | Payment Amount |
| 24 | B_PAYMENT_AMT_F | Character(12) | VARCHAR2(12) NOT NULL | Payment Amount |
| 25 | B_PAYMENT_AMT_G | Character(12) | VARCHAR2(12) NOT NULL | Payment Amount |
| 26 | B_PAYMENT_AMT_H | Character(12) | VARCHAR2(12) NOT NULL | Payment Amount |
| 27 | B_PAYMENT_AMT_J | Character(12) | VARCHAR2(12) NOT NULL | Payment Amount |
| 28 | BLANK16 | Character(16) | VARCHAR2(16) NOT NULL | blank |
| 29 | B_FOREIGN_COUNTRY | Character(1) | VARCHAR2(1) NOT NULL | Foreign Country Indicator |
| 30 | B_PAYEE_NAME1 | Character(40) | VARCHAR2(40) NOT NULL | First Payee Name Line |
| 31 | B_PAYEE_NAME2 | Character(40) | VARCHAR2(40) NOT NULL | Second Payee Name Line |
| 32 | BLANK40 | Character(40) | VARCHAR2(40) NOT NULL | blank 40 |
| 33 | B_PAYEE_ADDRESS | Character(40) | VARCHAR2(40) NOT NULL | Payee Mailing Address |
| 34 | BLANK40_2 | Character(40) | VARCHAR2(40) NOT NULL | blank |
| 35 | B_PAYEE_CITY | Character(40) | VARCHAR2(40) NOT NULL | Payee City |
| 36 | B_PAYEE_STATE | Character(2) | VARCHAR2(2) NOT NULL | Payee State |
| 37 | B_PAYEE_ZIP | Character(9) | VARCHAR2(9) NOT NULL | Payee ZIP Code |
| 38 | BLANK1 | Character(1) | VARCHAR2(1) NOT NULL | Blank Field of 1 Character |
| 39 | REC_SEQ_NBR | Character(8) | VARCHAR2(8) NOT NULL | Record Sequence Number |
| 40 | BLANK36 | Character(36) | VARCHAR2(36) NOT NULL | blank |
| 41 | B_SECOND_TIN | Character(1) | VARCHAR2(1) NOT NULL | IRS Notified Twice of Invalid |
| 42 | BLANK2 | Character(2) | VARCHAR2(2) NOT NULL | 2 blanks |
| 43 | B_COUNTRY_PAID | Character(40) | VARCHAR2(40) NOT NULL | Country Paid |
| 44 | CUSIP_NBR | Character(13) | VARCHAR2(13) NOT NULL | CUSIP ID - Used on Security |
| 45 | FATCA_INDICATOR | Character(1) | VARCHAR2(1) NOT NULL | FATCA Filiing Requirement Indicator |
| 46 | BLANK63 | Character(63) | VARCHAR2(63) NOT NULL | Blank Field of 63 Characters |
| 47 | B_SPECIAL_ENTRY | Character(60) | VARCHAR2(60) NOT NULL | Special Data Entry |
| 48 | B_STATE_TAX_WTHD | Character(12) | VARCHAR2(12) NOT NULL | State Income Tax Withheld |
| 49 | B_LOCAL_TAX_WTHD | Character(12) | VARCHAR2(12) NOT NULL | Locat Income Tax Withheld |
| 50 | B_COMB_FEDSTATE_CD | Character(2) | VARCHAR2(2) NOT NULL | Combined Federal/State Cd |
| 51 | BLANK2_2 | Character(2) | VARCHAR2(2) NOT NULL | 2 blanks |