TMP_1099_COPYB(SQL Table) |
Index Back |
|---|---|
Copy B Sorted Report DataThe data in this table is generated by the Copy B RPT application engine program. This data is selected and sorted based on user options. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  ORDER_NUM |
Number(18,0) | DECIMAL(18) NOT NULL | Order Number |
| 2 | WTHD_RPT_ID |
Character(10) | VARCHAR2(10) NOT NULL | Withholding Report ID |
| 3 | WTHD_SETID |
Character(5) | VARCHAR2(5) NOT NULL | Setid for the Withholding Code |
| 4 | WTHD_CNTL_ID |
Character(10) | VARCHAR2(10) NOT NULL | Control ID |
| 5 | WTHD_TYPE |
Character(5) | VARCHAR2(5) NOT NULL |
Withholding Type
Default Value: 1099 |
| 6 | PAYER_TIN |
Character(20) | VARCHAR2(20) NOT NULL | Payer Taxpayer Identification |
| 7 | PAYEE_TIN |
Character(20) | VARCHAR2(20) NOT NULL | Payee Taxpayer Identification |
| 8 | VENDOR_ID |
Character(10) | VARCHAR2(10) NOT NULL | Vendor Identifier |
| 9 | PAYEE_NAME1 |
Character(40) | VARCHAR2(40) NOT NULL | Payee Name 1 |
| 10 | PAYEE_NAME2 |
Character(40) | VARCHAR2(40) NOT NULL | Payee Name 2 |
| 11 | WTHD_VOID_FLG |
Character(1) | VARCHAR2(1) NOT NULL | Void Flag Copy B |
| 12 | WTHD_CORR_FLG |
Character(1) | VARCHAR2(1) NOT NULL | Correction Flag Copy B |
| 13 | CALENDAR_YEAR |
Number(4,0) | SMALLINT NOT NULL | Calendar Year |
| 14 | PAYER_NAME1 | Character(40) | VARCHAR2(40) NOT NULL | Payer Name 1 |
| 15 | PAYER_NAME2 | Character(40) | VARCHAR2(40) NOT NULL | Payer Name 2 |
| 16 | PAYER_ADDRESS1 | Character(40) | VARCHAR2(40) NOT NULL | Payer Address Line 1 |
| 17 | PAYER_ADDRESS2 | Character(40) | VARCHAR2(40) NOT NULL | Payer Address Line 2 |
| 18 | PAYER_ADDRESS3 | Character(40) | VARCHAR2(40) NOT NULL | Payer Address Line 3 |
| 19 | PAYER_ADDRESS4 | Character(40) | VARCHAR2(40) NOT NULL | Payer Address Line 4 |
| 20 | PAYER_CITYSTZIP | Character(40) | VARCHAR2(40) NOT NULL | Payer City State Zip |
| 21 | PAYER_COUNTRY_DESC | Character(30) | VARCHAR2(30) NOT NULL | Payer Country |
| 22 | PAYER_PHONE | Character(24) | VARCHAR2(24) NOT NULL | Payer Telephone |
| 23 | PAYEE_ADDRESS1 | Character(40) | VARCHAR2(40) NOT NULL | Payee Address Line1 |
| 24 | PAYEE_ADDRESS2 | Character(40) | VARCHAR2(40) NOT NULL | Payee Address Line 2 |
| 25 | PAYEE_ADDRESS3 | Character(40) | VARCHAR2(40) NOT NULL | Payee Address Line 3 |
| 26 | PAYEE_ADDRESS4 | Character(40) | VARCHAR2(40) NOT NULL | Payee Address Line 4 |
| 27 | PAYEE_CITYSTZIP | Character(40) | VARCHAR2(40) NOT NULL | Payee City State Zip |
| 28 | PAYEE_COUNTRY_DESC | Character(30) | VARCHAR2(30) NOT NULL | Payee Country |
| 29 | SECOND_TIN | Character(1) | VARCHAR2(1) NOT NULL | IRS Notified Twice of Invalid |
| 30 | WTHD_BOX1 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Rents -Wthd Box 1 |
| 31 | WTHD_BOX2 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Royalties - Wthd Box 2 |
| 32 | WTHD_BOX3 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Other Income- Wthd Box 3 |
| 33 | WTHD_BOX4 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Fed Income tax w/h- Wthd box 4 |
| 34 | WTHD_BOX5 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Fishing Boat Proc- Wthd Box 5 |
| 35 | WTHD_BOX6 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Med Aid Health- Wthd Box 6 |
| 36 | WTHD_BOX7 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Nonemployee Comp- Wthd Box 7 |
| 37 | WTHD_BOX07 | Character(1) | VARCHAR2(1) NOT NULL | $5000 or More - Wthd Box 7 |
| 38 | WTHD_BOX8 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Substitute Pymnts -Wthd Box 8 |
| 39 | WTHD_BOX9 | Character(1) | VARCHAR2(1) NOT NULL | $5000 or More - Wthd Box 9 |
| 40 | WTHD_BOX09 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | 1099I box 9 |
| 41 | WTHD_BOX10 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Crop Insurance- Wthd Box 10 |
| 42 | WTHD_BOX11 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Fish purchased for resale |
| 43 | WTHD_BOX12 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Wthd Box 12 |
| 44 | WTHD_BOX13 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Golden Parachute- Wthd Box 13 |
| 45 | WTHD_BOX14 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Proceeds Attorney -Wthd Box 14 |
| 46 | WTHD_BOX15 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Wthd Box 15 |
| 47 | WTHD_BOX15A | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Section 409A deferrals-Box 15A |
| 48 | WTHD_BOX15B | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Section 409A income-Box 15B |
| 49 | WTHD_BOX16 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | State Tax -Wthd Box 16 |
| 50 | WTHD_BOX17 | Character(21) | VARCHAR2(21) NOT NULL | Payer State No - Wthd Box17 |
| 51 | WTHD_BOX18 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | State Income -Wthd Box 18 |
| 52 | WTHD_BOX8G | Character(1) | VARCHAR2(1) NOT NULL | Trade/Business Income |
| 53 | WTHD_BOX3I | Character(4) | VARCHAR2(4) NOT NULL | WTHD_BOX3I |
| 54 | WTHD_BOX09G | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | 1099G Box 9 |
| 55 | COUNTRY_PAID | Character(40) | VARCHAR2(40) NOT NULL | Country Paid |
| 56 | FOREIGN_TAX_PAID | Number(16,2) | DECIMAL(15,2) NOT NULL | Foreign Tax Paid |
| 57 | CUSIP_NBR | Character(13) | VARCHAR2(13) NOT NULL | CUSIP ID - Used on Security |
| 58 | MASK_TIN_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Mask TIN |
| 59 | TIN_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
TIN Type
F=Federal Employer ID Number S=Social Security Number |
| 60 | BOND_PREMIUM | Number(13,2) | DECIMAL(12,2) NOT NULL | Bond Premium |
| 61 | MARKET_DISCOUNT | Number(13,2) | DECIMAL(12,2) NOT NULL | Market Discount |
| 62 | PRIVATE_BOND_INT | Number(13,2) | DECIMAL(12,2) NOT NULL | Private Activity Bond Interest |
| 63 | TAX_EXMPT_INTEREST | Number(13,2) | DECIMAL(12,2) NOT NULL | Tax-exempt Interest |
| 64 | BOND_PREMIUM_TAXEX | Number(13,2) | DECIMAL(12,2) NOT NULL | Bond Premium on Tax Exempt Bond |
| 65 | FATCA_INDICATOR | Character(1) | VARCHAR2(1) NOT NULL |
FATCA Filiing Requirement Indicator
Y/N Table Edit Default Value: N |
| 66 | REPORT_BOND_PREM | Number(13,2) | DECIMAL(12,2) NOT NULL | Bond Premium on Treasury Obligations |
| 67 | STATE_US | Character(2) | VARCHAR2(2) NOT NULL | 2 character US state code. |
| 68 | STATE_TAX_ID | Character(21) | VARCHAR2(21) NOT NULL | State Identification No |