COPYB_RPT_AET(SQL Table) |
Index Back |
|---|---|
COPYB Report State Record |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | RUN_CNTL_ID | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 3 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 4 | WTHD_RPT_ID | Character(10) | VARCHAR2(10) NOT NULL | Withholding Report ID |
| 5 | SETID | Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 6 | WTHD_CNTL_ID | Character(10) | VARCHAR2(10) NOT NULL | Control ID |
| 7 | WTHD_TYPE | Character(5) | VARCHAR2(5) NOT NULL | Withholding Type |
| 8 | VENDOR_SELECT_OPTN | Character(1) | VARCHAR2(1) NOT NULL |
Vendor Selection option
A=Select All Suppliers S=Specify Supplier(s) |
| 9 | AP_1099_SORT_ORDER | Character(1) | VARCHAR2(1) NOT NULL |
AP 1099 sort order
N=Name Sort T=TIN Sort V=Supplier Id Sort |
| 10 | WTHD_TYPE_OPTION | Character(1) | VARCHAR2(1) NOT NULL |
Withhold Type
A=All G=1099G I=1099I M=1099M N=1099NEC |
| 11 | WHERE_CLAUSE1 | Character(254) | VARCHAR2(254) NOT NULL | Where Clause |
| 12 | WHERE_CLAUSE2 | Character(254) | VARCHAR2(254) NOT NULL | Where Clause |
| 13 | WHERE_CLAUSE3 | Character(254) | VARCHAR2(254) NOT NULL | Where Clause |
| 14 | ORDERBY | Character(254) | VARCHAR2(254) NOT NULL | ORDER BY |
| 15 | ORDER_NUM | Number(18,0) | DECIMAL(18) NOT NULL | Order Number |
| 16 | PAYER_TIN |
Character(20) | VARCHAR2(20) NOT NULL | Payer Taxpayer Identification |
| 17 | PAYEE_TIN |
Character(20) | VARCHAR2(20) NOT NULL | Payee Taxpayer Identification |
| 18 | VENDOR_ID |
Character(10) | VARCHAR2(10) NOT NULL | Vendor Identifier |
| 19 | PAYEE_NAME1 |
Character(40) | VARCHAR2(40) NOT NULL | Payee Name 1 |
| 20 | PAYEE_NAME2 |
Character(40) | VARCHAR2(40) NOT NULL | Payee Name 2 |
| 21 | WTHD_VOID_FLG |
Character(1) | VARCHAR2(1) NOT NULL | Void Flag Copy B |
| 22 | WTHD_CORR_FLG |
Character(1) | VARCHAR2(1) NOT NULL | Correction Flag Copy B |
| 23 | CALENDAR_YEAR | Number(4,0) | SMALLINT NOT NULL | Calendar Year |
| 24 | PAYER_NAME1 | Character(40) | VARCHAR2(40) NOT NULL | Payer Name 1 |
| 25 | PAYER_NAME2 | Character(40) | VARCHAR2(40) NOT NULL | Payer Name 2 |
| 26 | PAYER_ADDRESS1 | Character(40) | VARCHAR2(40) NOT NULL | Payer Address Line 1 |
| 27 | PAYER_ADDRESS2 | Character(40) | VARCHAR2(40) NOT NULL | Payer Address Line 2 |
| 28 | PAYER_ADDRESS3 | Character(40) | VARCHAR2(40) NOT NULL | Payer Address Line 3 |
| 29 | PAYER_ADDRESS4 | Character(40) | VARCHAR2(40) NOT NULL | Payer Address Line 4 |
| 30 | PAYER_CITYSTZIP | Character(40) | VARCHAR2(40) NOT NULL | Payer City State Zip |
| 31 | PAYER_COUNTRY_DESC | Character(30) | VARCHAR2(30) NOT NULL | Payer Country |
| 32 | PAYER_PHONE | Character(24) | VARCHAR2(24) NOT NULL | Payer Telephone |
| 33 | PAYEE_ADDRESS1 | Character(40) | VARCHAR2(40) NOT NULL | Payee Address Line1 |
| 34 | PAYEE_ADDRESS2 | Character(40) | VARCHAR2(40) NOT NULL | Payee Address Line 2 |
| 35 | PAYEE_ADDRESS3 | Character(40) | VARCHAR2(40) NOT NULL | Payee Address Line 3 |
| 36 | PAYEE_ADDRESS4 | Character(40) | VARCHAR2(40) NOT NULL | Payee Address Line 4 |
| 37 | PAYEE_CITYSTZIP | Character(40) | VARCHAR2(40) NOT NULL | Payee City State Zip |
| 38 | PAYEE_COUNTRY_DESC | Character(30) | VARCHAR2(30) NOT NULL | Payee Country |
| 39 | SECOND_TIN | Character(1) | VARCHAR2(1) NOT NULL | IRS Notified Twice of Invalid |
| 40 | WTHD_BOX1 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Rents -Wthd Box 1 |
| 41 | WTHD_BOX2 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Royalties - Wthd Box 2 |
| 42 | WTHD_BOX3 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Other Income- Wthd Box 3 |
| 43 | WTHD_BOX4 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Fed Income tax w/h- Wthd box 4 |
| 44 | WTHD_BOX5 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Fishing Boat Proc- Wthd Box 5 |
| 45 | WTHD_BOX6 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Med Aid Health- Wthd Box 6 |
| 46 | WTHD_BOX7 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Nonemployee Comp- Wthd Box 7 |
| 47 | WTHD_BOX07 | Character(1) | VARCHAR2(1) NOT NULL | $5000 or More - Wthd Box 7 |
| 48 | WTHD_BOX8 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Substitute Pymnts -Wthd Box 8 |
| 49 | WTHD_BOX9 | Character(1) | VARCHAR2(1) NOT NULL | $5000 or More - Wthd Box 9 |
| 50 | WTHD_BOX09 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | 1099I box 9 |
| 51 | WTHD_BOX10 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Crop Insurance- Wthd Box 10 |
| 52 | WTHD_BOX11 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Fish purchased for resale |
| 53 | WTHD_BOX12 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Wthd Box 12 |
| 54 | WTHD_BOX13 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Golden Parachute- Wthd Box 13 |
| 55 | WTHD_BOX14 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Proceeds Attorney -Wthd Box 14 |
| 56 | WTHD_BOX15 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Wthd Box 15 |
| 57 | WTHD_BOX15A | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Section 409A deferrals-Box 15A |
| 58 | WTHD_BOX15B | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Section 409A income-Box 15B |
| 59 | WTHD_BOX16 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | State Tax -Wthd Box 16 |
| 60 | WTHD_BOX17 | Character(21) | VARCHAR2(21) NOT NULL | Payer State No - Wthd Box17 |
| 61 | WTHD_BOX18 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | State Income -Wthd Box 18 |
| 62 | WTHD_BOX8G | Character(1) | VARCHAR2(1) NOT NULL | Trade/Business Income |
| 63 | WTHD_BOX3I | Character(4) | VARCHAR2(4) NOT NULL | WTHD_BOX3I |
| 64 | WTHD_BOX09G | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | 1099G Box 9 |
| 65 | COUNTRY_PAID | Character(40) | VARCHAR2(40) NOT NULL | Country Paid |
| 66 | FOREIGN_TAX_PAID | Number(16,2) | DECIMAL(15,2) NOT NULL | Foreign Tax Paid |
| 67 | CUSIP_NBR | Character(13) | VARCHAR2(13) NOT NULL | CUSIP ID - Used on Security |
| 68 | MASK_TIN_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Mask TIN |
| 69 | TIN_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
TIN Type
F=Federal Employer ID Number S=Social Security Number |
| 70 | BOND_PREMIUM | Number(13,2) | DECIMAL(12,2) NOT NULL | Bond Premium |
| 71 | MARKET_DISCOUNT | Number(13,2) | DECIMAL(12,2) NOT NULL | Market Discount |
| 72 | PRIVATE_BOND_INT | Number(13,2) | DECIMAL(12,2) NOT NULL | Private Activity Bond Interest |
| 73 | TAX_EXMPT_INTEREST | Number(13,2) | DECIMAL(12,2) NOT NULL | Tax-exempt Interest |
| 74 | BOND_PREMIUM_TAXEX | Number(13,2) | DECIMAL(12,2) NOT NULL | Bond Premium on Tax Exempt Bond |
| 75 | FATCA_INDICATOR | Character(1) | VARCHAR2(1) NOT NULL |
FATCA Filiing Requirement Indicator
Y/N Table Edit Default Value: N |
| 76 | REPORT_BOND_PREM | Number(13,2) | DECIMAL(12,2) NOT NULL | Bond Premium on Treasury Obligations |
| 77 | STATE_US | Character(2) | VARCHAR2(2) NOT NULL | 2 character US state code. |
| 78 | STATE_TAX_ID | Character(21) | VARCHAR2(21) NOT NULL | State Identification No |