AP_APY1099_AET(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 3 | RUN_CNTL_ID | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 4 | REQUEST_ID | Character(10) | VARCHAR2(10) NOT NULL | Request ID |
| 5 | PROCESS_DTTM | DateTime(26) | TIMESTAMP | Process Date Time |
| 6 | WTHD_RPT_ID | Character(10) | VARCHAR2(10) NOT NULL | Withholding Report ID |
| 7 | WTHD_RPT_ID_M | Character(10) | VARCHAR2(10) NOT NULL | Withholding Report ID |
| 8 | WTHD_RPT_ID_N | Character(10) | VARCHAR2(10) NOT NULL | Withholding Report ID |
| 9 | WTHD_RPT_ID_I | Character(10) | VARCHAR2(10) NOT NULL | Withholding Report ID |
| 10 | WTHD_RPT_ID_G | Character(10) | VARCHAR2(10) NOT NULL | Withholding Report ID |
| 11 | REC_SEQ_NO | Number(8,0) | INTEGER NOT NULL | Record Sequence Nbr |
| 12 | SETID | Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 13 | WTHD_CNTL_ID | Character(10) | VARCHAR2(10) NOT NULL | Control ID |
| 14 | WTHD_FILE_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Type of File/Return
O=Original/Correction R=Replacement T=Test |
| 15 | LANGUAGE_CD | Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 16 | MEDIA_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Media Type
D=Magnetic/Disk E=Electronic T=Magnetic/Tape |
| 17 | REPLACE_CHAR | Character(2) | VARCHAR2(2) NOT NULL | Replacement Character |
| 18 | FILE_NAME_SHORT | Character(30) | VARCHAR2(30) NOT NULL | File Name |
| 19 | ORIGINAL_SENT_MODE | Character(1) | VARCHAR2(1) NOT NULL |
Original Submission Mode
D=Magnetic/Disk E=Electronic T=Magnetic/Tape |
| 20 | CONTINUATION_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Continuation Flag |
| 21 | TMP_FLD | Character(1) | VARCHAR2(1) NOT NULL | Field for holding temp data |
| 22 | GV_CORRECTION | Character(1) | VARCHAR2(1) NOT NULL | 1099 GV Correction |
| 23 | GC_CORRECTION | Character(1) | VARCHAR2(1) NOT NULL | GC Correction |
| 24 | GS_CORRECTION | Character(1) | VARCHAR2(1) NOT NULL | 1099 GS correction (single transaction0 |
| 25 | PREV_GV_CORRECTION | Character(1) | VARCHAR2(1) NOT NULL | 1099 GV Correction |
| 26 | PREV_GS_CORRECTION | Character(1) | VARCHAR2(1) NOT NULL | 1099 GS correction (single transaction0 |
| 27 | ORIGINAL | Character(1) | VARCHAR2(1) NOT NULL | IRS original transaction type |
| 28 | HDR_FILE_TYPE | Character(1) | VARCHAR2(1) NOT NULL | 1099 Transmitter File Type of 0-Original or C-Correction |
| 29 | PAYER_PHASE | Character(20) | VARCHAR2(20) NOT NULL | 1099 Reporting flag that determines what phase of reporting currently in. Used by the 1099 Reporting AE. |
| 30 | WTHD_TYPE_M | Character(5) | VARCHAR2(5) NOT NULL | Withholding Type |
| 31 | WTHD_TYPE_N | Character(5) | VARCHAR2(5) NOT NULL | Withholding Type |
| 32 | WTHD_TYPE_I | Character(5) | VARCHAR2(5) NOT NULL | Withholding Type |
| 33 | WTHD_TYPE_G | Character(5) | VARCHAR2(5) NOT NULL | Withholding Type |
| 34 | WTHD_TYPE | Character(5) | VARCHAR2(5) NOT NULL | Withholding Type |
| 35 | WTHD_ENTITY | Character(5) | VARCHAR2(5) NOT NULL | Withholding Entity |
| 36 | CALENDAR_SETID | Character(5) | VARCHAR2(5) NOT NULL | Calendar SetID |
| 37 | CALENDAR_ID | Character(2) | VARCHAR2(2) NOT NULL | Calendar ID |
| 38 | FISCAL_YEAR | Number(4,0) | SMALLINT NOT NULL | Fiscal Year |
| 39 | FISCAL_YEAR2 | Number(4,0) | SMALLINT NOT NULL | Fiscal Year |
| 40 | CHCK_FY | Number(4,0) | SMALLINT NOT NULL | Fiscal Year |
| 41 | PERIOD | Number(3,0) | SMALLINT NOT NULL | Period |
| 42 | SEND_STATUS | Character(1) | VARCHAR2(1) NOT NULL | Send Status |
| 43 | ACTIVE_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Transfer Template Status
A=Active I=Inactive |
| 44 | LINE_NO | Number(3,0) | SMALLINT NOT NULL | Line Number |
| 45 | DTL_NAME1 | Character(40) | VARCHAR2(40) NOT NULL | 1099 Send Detail Vendor Name 1 |
| 46 | DTL_NAME2 | Character(40) | VARCHAR2(40) NOT NULL | 1099 Send Detail Vendor Name 2 |
| 47 | DTL_TIN | Character(20) | VARCHAR2(20) NOT NULL | 1099 Detail TIN |
| 48 | WTHD_BASIS_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Withholding Basis Amount |
| 49 | SUM_WTHD_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Withholding Amount |
| 50 | VENDOR_SETID | Character(5) | VARCHAR2(5) NOT NULL | Vendor SetID |
| 51 | VENDOR_ID | Character(10) | VARCHAR2(10) NOT NULL | Vendor Identifier |
| 52 | VENDOR_ID_SEL | Character(10) | VARCHAR2(10) NOT NULL | Supplier ID Selected |
| 53 | VNDR_LOC | Character(10) | VARCHAR2(10) NOT NULL | Vendor Location |
| 54 | DTL_CITY | Character(30) | VARCHAR2(30) NOT NULL | 1099 Detail City |
| 55 | DTL_STATE | Character(6) | VARCHAR2(6) NOT NULL | 1099 Detail State |
| 56 | COUNTY | Character(30) | VARCHAR2(30) NOT NULL | County |
| 57 | DTL_COUNTRY | Character(3) | VARCHAR2(3) NOT NULL | 1099 Detail Country |
| 58 | SECOND_TIN | Character(1) | VARCHAR2(1) NOT NULL | IRS Notified Twice of Invalid |
| 59 | DIRECT_SALES | Character(1) | VARCHAR2(1) NOT NULL | Direct Sales of $5000 or More |
| 60 | COUNTRY_PAID | Character(40) | VARCHAR2(40) NOT NULL | Country Paid |
| 61 | FOREIGN_TAX_PAID | Number(16,2) | DECIMAL(15,2) NOT NULL | Foreign Tax Paid |
| 62 | TRADE_BUS_INC | Character(1) | VARCHAR2(1) NOT NULL | Trade or Business Income Ind |
| 63 | TIN_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
TIN Type
F=Federal Employer ID Number S=Social Security Number |
| 64 | DTL_ADDRESS1 | Character(55) | VARCHAR2(55) NOT NULL | 1099 Detail Address 1 |
| 65 | DTL_ADDRESS2 | Character(55) | VARCHAR2(55) NOT NULL | 1099 Detail Address 2 |
| 66 | DTL_ADDRESS3 | Character(55) | VARCHAR2(55) NOT NULL | 1099 Detail Address 3 |
| 67 | DTL_ADDRESS4 | Character(55) | VARCHAR2(55) NOT NULL | 1099 Detail Address 4 |
| 68 | DTL_POSTAL | Character(12) | VARCHAR2(12) NOT NULL | 1099 Detail Postal |
| 69 | STATE_TAX_WH | Number(16,2) | DECIMAL(15,2) NOT NULL | State Income Tax Withheld |
| 70 | DTL_WTHD_CNTL_NM | Character(4) | VARCHAR2(4) NOT NULL | Withholding Control Name |
| 71 | WTHD_CONTROL_NAME | Character(4) | VARCHAR2(4) NOT NULL | Withholding Control Name |
| 72 | VENDOR_TIN | Character(20) | VARCHAR2(20) NOT NULL | Supplier Tin |
| 73 | PAYER_TIN | Character(20) | VARCHAR2(20) NOT NULL | Payer Taxpayer Identification |
| 74 | HDR_TIN | Character(20) | VARCHAR2(20) NOT NULL | 1099 Header/Transmitter TIN |
| 75 | TRANS_CNTL_CD | Character(5) | VARCHAR2(5) NOT NULL | Transmitter Control Code |
| 76 | HDR_NAME1 | Character(40) | VARCHAR2(40) NOT NULL | 1099 Header/Transmitter Name 1 |
| 77 | HDR_NAME2 | Character(40) | VARCHAR2(40) NOT NULL | 1099 Header/Transmitter Name 2 |
| 78 | HDR_ADDRESS1 | Character(55) | VARCHAR2(55) NOT NULL | 1099 Header/Transmitter Address 1 |
| 79 | HDR_ADDRESS2 | Character(55) | VARCHAR2(55) NOT NULL | 1099 Header/Transmitter Address 2 |
| 80 | HDR_ADDRESS3 | Character(55) | VARCHAR2(55) NOT NULL | 1099 Header/Transmitter Address 3 |
| 81 | HDR_ADDRESS4 | Character(55) | VARCHAR2(55) NOT NULL | 1099 Header/Transmitter Address 4 |
| 82 | HDR_CITY | Character(30) | VARCHAR2(30) NOT NULL | 1099 Header/Transmitter City |
| 83 | HDR_STATE | Character(6) | VARCHAR2(6) NOT NULL | 1099 Header/Transmitter State |
| 84 | HDR_POSTAL | Character(12) | VARCHAR2(12) NOT NULL | 1099 Header/Transmitter Postal Code |
| 85 | HDR_COUNTRY | Character(3) | VARCHAR2(3) NOT NULL | 1099 Header/Transmitter Country |
| 86 | CNTCT_NAME1 | Character(40) | VARCHAR2(40) NOT NULL | Contact Name1 |
| 87 | CNTCT_PHONE | Character(24) | VARCHAR2(24) NOT NULL | Contact Phone Number |
| 88 | CNTCT_EMAIL_ADDR | Character(50) | VARCHAR2(50) NOT NULL | Contact Email Address |
| 89 | CNTCT_EXTENSION | Character(6) | VARCHAR2(6) NOT NULL | Phone Extension |
| 90 | MEDIA_NUMBER | Character(6) | VARCHAR2(6) NOT NULL | Media Number |
| 91 | LAST_FILE_FLG | Character(1) | VARCHAR2(1) NOT NULL | Last Filing |
| 92 | VNDR_SFT_INDICATOR | Character(1) | VARCHAR2(1) NOT NULL | 2001 IRS Vendor Software Indicator |
| 93 | COMBINED_FED_STATE | Character(1) | VARCHAR2(1) NOT NULL | Combined Federal State Filing |
| 94 | PAYER_NAME1 | Character(40) | VARCHAR2(40) NOT NULL | Payer Name 1 |
| 95 | PAYER_NAME2 | Character(40) | VARCHAR2(40) NOT NULL | Payer Name 2 |
| 96 | PAYER_ADDRESS1 | Character(40) | VARCHAR2(40) NOT NULL | Payer Address Line 1 |
| 97 | PAYER_ADDRESS2 | Character(40) | VARCHAR2(40) NOT NULL | Payer Address Line 2 |
| 98 | PAYER_ADDRESS3 | Character(40) | VARCHAR2(40) NOT NULL | Payer Address Line 3 |
| 99 | PAYER_CITY | Character(30) | VARCHAR2(30) NOT NULL | Payer City |
| 100 | PAYER_STATE | Character(6) | VARCHAR2(6) NOT NULL | Payer State |
| 101 | PAYER_COUNTRY | Character(3) | VARCHAR2(3) NOT NULL | Payer Country |
| 102 | PAYER_POSTAL | Character(12) | VARCHAR2(12) NOT NULL | Payer Postal |
| 103 | PAYER_PHONE | Character(24) | VARCHAR2(24) NOT NULL | Payer Telephone |
| 104 | PAYER_EXTENSION | Character(6) | VARCHAR2(6) NOT NULL | Payer Phone Extension |
| 105 | PAYER_WTHD_CNTL_NM | Character(4) | VARCHAR2(4) NOT NULL | Withholding Control Name |
| 106 | FOUND_PAYER | Character(1) | VARCHAR2(1) NOT NULL | 1099 flag representing that a payer was found for reporting on. This is used by the 1099 Reporting AE. |
| 107 | AMOUNT_CODES | Character(16) | VARCHAR2(16) NOT NULL | 1099 Amount Codes used in the Payer "A" record for 1099 Year End Reporting. |
| 108 | PREV_PAYER_TIN | Character(20) | VARCHAR2(20) NOT NULL | Previous payer tin reporte on. This is used in the 1099 Reporting AE. |
| 109 | WTHD_LIABILITY_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Withholding Liability Amount |
| 110 | PAID_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Paid Amount |
| 111 | TOTAL_PAID_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Total Paid Amount |
| 112 | TOT_LIABILITY | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Total Withholding Liability |
| 113 | PREV_COMB_FEDSTATE | Character(1) | VARCHAR2(1) NOT NULL | Combine Federal/State Filer |
| 114 | PREV_VENDOR | Character(15) | VARCHAR2(15) NOT NULL | Previous vendor processed in 1099 Reporting AE. |
| 115 | PREV_VENDOR_TIN | Character(20) | VARCHAR2(20) NOT NULL | Previous vendor tin processed by 1099 Reporting AE |
| 116 | CURRENT_VENDOR | Character(15) | VARCHAR2(15) NOT NULL | Concatenation of Vendor ID and Vendor Setid to make up the current vendor being processed by 1099 Reporting AE |
| 117 | TOTAL_PAYEES | Number(8,0) | INTEGER NOT NULL | Total number of payees being reported on the IRS 1099 file |
| 118 | PREV_DTL_TIN | Character(20) | VARCHAR2(20) NOT NULL | 1099 Detail TIN |
| 119 | PREV_ACTIVE_STATUS | Character(1) | VARCHAR2(1) NOT NULL | Previous Active Status |
| 120 | PREV_STATE_TAX_WH | Number(16,2) | DECIMAL(15,2) NOT NULL | Prev State Income Tax Withheld |
| 121 | PREV_SEND_STATUS | Character(1) | VARCHAR2(1) NOT NULL | Previous Send Status |
| 122 | PREV_WTHD_BASISAMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Withholding Basis Amount |
| 123 | T_REC_FLG | Character(1) | VARCHAR2(1) NOT NULL | T Record Flag |
| 124 | A_RECORD_COUNT | Number(7,0) | INTEGER NOT NULL | IRS 1099 A-Record/Payer Record count |
| 125 | PAYMENT_YEAR | Character(4) | VARCHAR2(4) NOT NULL | Payment Year |
| 126 | OUTPUT_DIRECTORY | Character(127) | VARCHAR2(127) NOT NULL | File Directory |
| 127 | WTHD_TOTAL_A_RECS | Number(8,0) | INTEGER NOT NULL | Total A Records in the file |
| 128 | WTHD_TOTAL_B_RECS | Number(8,0) | INTEGER NOT NULL | Total B Records in the file |
| 129 | WTHD_TOTAL_C_RECS | Number(8,0) | INTEGER NOT NULL | Total C Records in the file |
| 130 | WTHD_TOTAL_K_RECS | Number(8,0) | INTEGER NOT NULL | Total C Records in the file |
| 131 | WTHD_TOTAL_RECORDS | Number(12,0) | DECIMAL(12) NOT NULL | Total Records in the file |
| 132 | WTHD_MAX_RECORDS | Number(12,0) | DECIMAL(12) NOT NULL | Max Total Records in the file |
| 133 | WTHD_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Withholding Amount |
| 134 | WTHD_STATE_PAYEES | Number(12,0) | DECIMAL(12) NOT NULL | Total State Payees |
| 135 | WTHD_TYPE_1099M | Character(1) | VARCHAR2(1) NOT NULL | 1099 Misc |
| 136 | WTHD_TYPE_1099N | Character(1) | VARCHAR2(1) NOT NULL | 1099 Nonemployee Compensation |
| 137 | WTHD_TYPE_1099I | Character(1) | VARCHAR2(1) NOT NULL | 1099 Interest |
| 138 | WTHD_TYPE_1099G | Character(1) | VARCHAR2(1) NOT NULL | 1099 Government |
| 139 | FILE_EXTENSION | Character(4) | VARCHAR2(4) NOT NULL | File Extension |
| 140 | FILE_EXT | Number(3,0) | SMALLINT NOT NULL | File Ext |
| 141 | AMT_CODE_1 | Character(3) | VARCHAR2(3) NOT NULL | Rent |
| 142 | AMT_CODE_2 | Character(3) | VARCHAR2(3) NOT NULL | Royalties |
| 143 | AMT_CODE_3 | Character(3) | VARCHAR2(3) NOT NULL | Amount Code |
| 144 | AMT_CODE_4 | Character(3) | VARCHAR2(3) NOT NULL | Amount Code |
| 145 | AMT_CODE_5 | Character(3) | VARCHAR2(3) NOT NULL | Amount Code |
| 146 | AMT_CODE_6 | Character(3) | VARCHAR2(3) NOT NULL | Amount Code |
| 147 | AMT_CODE_7 | Character(3) | VARCHAR2(3) NOT NULL | Amount Code |
| 148 | AMT_CODE_8 | Character(3) | VARCHAR2(3) NOT NULL | Amount Code |
| 149 | AMT_CODE_9 | Character(3) | VARCHAR2(3) NOT NULL | Amount Code |
| 150 | AMT_CODE_10 | Character(3) | VARCHAR2(3) NOT NULL | Amount Code |
| 151 | AMT_CODE_11 | Character(3) | VARCHAR2(3) NOT NULL | Amount Code |
| 152 | AMT_CODE_12 | Character(3) | VARCHAR2(3) NOT NULL | Amount Code |
| 153 | AMT_CODE_13 | Character(3) | VARCHAR2(3) NOT NULL | Amount Code |
| 154 | AMT_CODE_14 | Character(3) | VARCHAR2(3) NOT NULL | Amount Code |
| 155 | AMT_CODE_15 | Character(3) | VARCHAR2(3) NOT NULL | Amount Code |
| 156 | AMT_CODE_16 | Character(3) | VARCHAR2(3) NOT NULL | Amount Code |
| 157 | AMT_CODE_09G | Character(3) | VARCHAR2(3) NOT NULL | Amount Code |
| 158 | WTHD_LINE_NO | Number(3,0) | SMALLINT NOT NULL | Line Number |
| 159 | COUNT_LINES | Number(15,0) | DECIMAL(15) NOT NULL | Count of Lines |
| 160 | A_CORRECT_FILE_IND | Character(1) | VARCHAR2(1) NOT NULL | Correction File Indicator |
| 161 | WTHD_CITYSTZIP | Character(40) | VARCHAR2(40) NOT NULL | FORM CITY STATE ZIP |
| 162 | WTHD_COUNTRY_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Country |
| 163 | COPYB_PAYER_PHONE | Character(24) | VARCHAR2(24) NOT NULL | Payer Telephone |
| 164 | B_PAYMENT_AMT_1 | Character(12) | VARCHAR2(12) NOT NULL | Payment Amount 1 |
| 165 | B_PAYMENT_AMT_2 | Character(12) | VARCHAR2(12) NOT NULL | Payment Amount |
| 166 | B_PAYMENT_AMT_3 | Character(12) | VARCHAR2(12) NOT NULL | Payment Amount |
| 167 | B_PAYMENT_AMT_4 | Character(12) | VARCHAR2(12) NOT NULL | Payment Amount |
| 168 | B_PAYMENT_AMT_5 | Character(12) | VARCHAR2(12) NOT NULL | Payment Amount |
| 169 | B_PAYMENT_AMT_6 | Character(12) | VARCHAR2(12) NOT NULL | Payment Amount |
| 170 | B_PAYMENT_AMT_7 | Character(12) | VARCHAR2(12) NOT NULL | Payment Amount |
| 171 | B_PAYMENT_AMT_8 | Character(12) | VARCHAR2(12) NOT NULL | Payment Amount |
| 172 | B_PAYMENT_AMT_9 | Character(12) | VARCHAR2(12) NOT NULL | Payment Amount |
| 173 | B_PAYMENT_AMT_A | Character(12) | VARCHAR2(12) NOT NULL | Payment Amount |
| 174 | B_PAYMENT_AMT_B | Character(12) | VARCHAR2(12) NOT NULL | Payment Amount |
| 175 | B_PAYMENT_AMT_C | Character(12) | VARCHAR2(12) NOT NULL | Payment Amount |
| 176 | B_COMB_FEDSTATE_CD | Character(2) | VARCHAR2(2) NOT NULL | Combined Federal/State Cd |
| 177 | PAYMENT_AMT_1 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Withholding Amount |
| 178 | PAYMENT_AMT_2 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Withholding Amount |
| 179 | PAYMENT_AMT_3 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Withholding Amount |
| 180 | PAYMENT_AMT_4 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Withholding Amount |
| 181 | PAYMENT_AMT_5 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Withholding Amount |
| 182 | PAYMENT_AMT_6 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Withholding Amount |
| 183 | PAYMENT_AMT_7 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Withholding Amount |
| 184 | PAYMENT_AMT_8 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Withholding Amount |
| 185 | PAYMENT_AMT_9 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Withholding Amount |
| 186 | PAYMENT_AMT_A | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Withholding Amount |
| 187 | PAYMENT_AMT_B | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Withholding Amount |
| 188 | PAYMENT_AMT_C | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Withholding Amount |
| 189 | PAYMENT_AMT_D | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Withholding Amount |
| 190 | PAYMENT_AMT_E | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Withholding Amount |
| 191 | PAYMENT_AMT_F | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Withholding Amount |
| 192 | PAYMENT_AMT_G | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Withholding Amount |
| 193 | PAYMENT_AMT_9G | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Withholding Amount |
| 194 | IRS_COUNTRY | Character(3) | VARCHAR2(3) NOT NULL | Country |
| 195 | IRS_STATE | Character(6) | VARCHAR2(6) NOT NULL | State |
| 196 | GRAND_WTHDLIAB_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Grand Wthd Liability Amt |
| 197 | PROCESS_FLG | Character(1) | VARCHAR2(1) NOT NULL | Processing Flag |
| 198 | PROCESS_FLG2 | Character(1) | VARCHAR2(1) NOT NULL | Processing Flag |
| 199 | PROCESS_FLG3 | Character(1) | VARCHAR2(1) NOT NULL | Processing Flag |
| 200 | WTHD_LAST_STATE | Character(6) | VARCHAR2(6) NOT NULL | Last State |
| 201 | FIRST_TIME | Character(1) | VARCHAR2(1) NOT NULL | First time through process |
| 202 | VNDR_STATE | Character(6) | VARCHAR2(6) NOT NULL | Supplier State |
| 203 | VNDR_COUNTRY | Character(3) | VARCHAR2(3) NOT NULL | Supplier Country |
| 204 | K_VNDR_SETID | Character(5) | VARCHAR2(5) NOT NULL | VENDOR SETID |
| 205 | K_VNDR_ID | Character(10) | VARCHAR2(10) NOT NULL | Supplier Id |
| 206 | K_TIN | Character(20) | VARCHAR2(20) NOT NULL | Taxpayer Identification Number |
| 207 | K_SEND_STATUS | Character(1) | VARCHAR2(1) NOT NULL | Send Status |
| 208 | K_REC_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | K Record Amt |
| 209 | K_LIAB_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | K Rec Liability Amt |
| 210 | K_PAID_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | K Record Paid Amt |
| 211 | STATE_LIAB_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Withholding Liability Amount |
| 212 | PRINT_CORRECTION | Character(1) | VARCHAR2(1) NOT NULL | Indicator that specifies whether an IRS 1099 correction will be saved as a CopyB |
| 213 | PRINT_VOID | Character(1) | VARCHAR2(1) NOT NULL | Print Void |
| 214 | COUNTRY_FOR | Character(30) | VARCHAR2(30) NOT NULL | Country Fo |
| 215 | STATE_FOR | Character(30) | VARCHAR2(30) NOT NULL | State For |
| 216 | PAYEE_CITYSTZIP | Character(40) | VARCHAR2(40) NOT NULL | Payee City State Zip |
| 217 | PAYEE_COUNTRY_DESC | Character(30) | VARCHAR2(30) NOT NULL | Payee Country |
| 218 | PAYER_CITYSTZIP | Character(40) | VARCHAR2(40) NOT NULL | Payer City State Zip |
| 219 | STATE | Character(6) | VARCHAR2(6) NOT NULL | State |
| 220 | PAYER_STATE_NUM | Character(17) | VARCHAR2(17) NOT NULL | Payer State Number |
| 221 | PAYER_STATE_PRINT | Character(21) | VARCHAR2(21) NOT NULL | Payer State Print |
| 222 | VENDOR_ID_PRINT | Character(10) | VARCHAR2(10) NOT NULL | Supplier ID Print |
| 223 | VNDR_SECOND_TIN | Character(1) | VARCHAR2(1) NOT NULL | Supplier Second Tin |
| 224 | VNDR_DIRECT_SALES | Character(1) | VARCHAR2(1) NOT NULL | Supplier Direct Sales |
| 225 | SNDDTL_SEND_STATUS | Character(1) | VARCHAR2(1) NOT NULL | Send Status |
| 226 | SNDDTL_DTL_TIN | Character(20) | VARCHAR2(20) NOT NULL | 1099 Detail TIN |
| 227 | SNT_DIRECT_SALES | Character(1) | VARCHAR2(1) NOT NULL | Direct Sales of $5000 or More |
| 228 | SNT_DTL_ADDRESS1 | Character(55) | VARCHAR2(55) NOT NULL | 1099 Detail Address 1 |
| 229 | SNT_DTL_ADDRESS2 | Character(55) | VARCHAR2(55) NOT NULL | 1099 Detail Address 2 |
| 230 | SNT_DTL_ADDRESS3 | Character(55) | VARCHAR2(55) NOT NULL | 1099 Detail Address 3 |
| 231 | SNT_DTL_ADDRESS4 | Character(55) | VARCHAR2(55) NOT NULL | 1099 Detail Address 4 |
| 232 | SNT_DTL_CITY | Character(30) | VARCHAR2(30) NOT NULL | 1099 Detail City |
| 233 | SNT_DTL_COUNTRY | Character(3) | VARCHAR2(3) NOT NULL | 1099 Detail Country |
| 234 | SNT_DTL_NAME1 | Character(40) | VARCHAR2(40) NOT NULL | 1099 Send Detail Vendor Name 1 |
| 235 | SNT_DTL_NAME2 | Character(40) | VARCHAR2(40) NOT NULL | 1099 Send Detail Vendor Name 1 |
| 236 | SNT_DTL_POSTAL | Character(12) | VARCHAR2(12) NOT NULL | 1099 Detail Postal |
| 237 | SNT_DTL_STATE | Character(6) | VARCHAR2(6) NOT NULL | 1099 Detail State |
| 238 | SNT_DTL_TIN | Character(20) | VARCHAR2(20) NOT NULL | 1099 Detail TIN |
| 239 | SNT_DTL_WTHDCNTLNM | Character(4) | VARCHAR2(4) NOT NULL | Withholding Control Name |
| 240 | SNT_INFO_EXIST | Character(1) | VARCHAR2(1) NOT NULL | Sent Information Exists |
| 241 | SNT_PAYER_TIN | Character(20) | VARCHAR2(20) NOT NULL | Payer Taxpayer Identification |
| 242 | SNT_SECOND_TIN | Character(1) | VARCHAR2(1) NOT NULL | IRS Notified Twice of Invalid |
| 243 | SNT_TIN_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
TIN Type
F=Federal Employer ID Number S=Social Security Number |
| 244 | SNT_VENDOR_ID | Character(10) | VARCHAR2(10) NOT NULL | Vendor Identifier |
| 245 | SNT_VENDOR_SETID | Character(5) | VARCHAR2(5) NOT NULL | Supplier Set ID |
| 246 | SNT_WTHD_CNTL_NM | Character(4) | VARCHAR2(4) NOT NULL | Withholding Control Name |
| 247 | SNTA_COMB_FED_STAT | Character(1) | VARCHAR2(1) NOT NULL | Combined Federal State Filing |
| 248 | SNTA_LAST_FILE_FLG | Character(1) | VARCHAR2(1) NOT NULL | Last Filing |
| 249 | SNTA_PAYER_ADDR1 | Character(35) | VARCHAR2(35) NOT NULL | Payer Address Line 1 |
| 250 | SNTA_PAYER_ADDR2 | Character(35) | VARCHAR2(35) NOT NULL | Payer Address Line 2 |
| 251 | SNTA_PAYER_ADDR3 | Character(35) | VARCHAR2(35) NOT NULL | Payer Address Line 3 |
| 252 | SNTA_PAYER_ADDR4 | Character(35) | VARCHAR2(35) NOT NULL | Payer Address Line 4 |
| 253 | SNTA_PAYER_CITY | Character(30) | VARCHAR2(30) NOT NULL | Payer City |
| 254 | SNTA_PAYER_COUNTRY | Character(3) | VARCHAR2(3) NOT NULL | Payer Country |
| 255 | SNTA_PAYER_EXT | Character(6) | VARCHAR2(6) NOT NULL | Payer Phone Extension |
| 256 | SNTA_PAYER_NAME1 | Character(40) | VARCHAR2(40) NOT NULL | Payer Name 1 |
| 257 | SNTA_PAYER_NAME2 | Character(40) | VARCHAR2(40) NOT NULL | Payer Name 2 |
| 258 | SNTA_PAYER_PHONE | Character(24) | VARCHAR2(24) NOT NULL | Payer Telephone |
| 259 | SNTA_PAYER_POSTAL | Character(12) | VARCHAR2(12) NOT NULL | Payer Postal |
| 260 | SNTA_PAYER_STATE | Character(6) | VARCHAR2(6) NOT NULL | Payer State |
| 261 | SNTA_PAYER_TIN | Character(20) | VARCHAR2(20) NOT NULL | Payer Taxpayer Identification |
| 262 | SNTA_WTHD_CNTL_ID | Character(10) | VARCHAR2(10) NOT NULL | Control ID |
| 263 | SNTA_WTHD_CNTL_NM | Character(4) | VARCHAR2(4) NOT NULL | Withholding Control Name |
| 264 | SNTA_INFO_EXIST | Character(1) | VARCHAR2(1) NOT NULL | Sent Information Exists |
| 265 | SNDDTL_WTHD_BASAMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Withholding Basis Amount |
| 266 | WTHD_TOTAL_B_RECS2 | Number(8,0) | INTEGER NOT NULL | Total B Records in the file |
| 267 | THRU_DATE | Date(10) | DATE | Through Date |
| 268 | CUSIP_NBR | Character(13) | VARCHAR2(13) NOT NULL | CUSIP ID - Used on Security |
| 269 | STATE_INCOME | Signed Number(21,2) | DECIMAL(19,2) NOT NULL | 1099 State Income |
| 270 | PREV_STATE_INCOME | Signed Number(21,2) | DECIMAL(19,2) NOT NULL | 1099 State Income |
| 271 | PREV_CUSIP_NBR | Character(13) | VARCHAR2(13) NOT NULL | CUSIP ID - Used on Security |
| 272 | PREV_TIN_TYPE | Character(1) | VARCHAR2(1) NOT NULL | TIN Type |
| 273 | BOND_PREMIUM | Number(13,2) | DECIMAL(12,2) NOT NULL | Bond Premium |
| 274 | MARKET_DISCOUNT | Number(13,2) | DECIMAL(12,2) NOT NULL | Market Discount |
| 275 | PRIVATE_BOND_INT | Number(13,2) | DECIMAL(12,2) NOT NULL | Private Activity Bond Interest |
| 276 | TAX_EXMPT_INTEREST | Number(13,2) | DECIMAL(12,2) NOT NULL | Tax-exempt Interest |
| 277 | RPT_THRU_DT | Date(10) | DATE | Report Thru Date |
| 278 | BOND_PREMIUM_TAXEX | Number(13,2) | DECIMAL(12,2) NOT NULL | Bond Premium on Tax Exempt Bond |
| 279 | FATCA_INDICATOR | Character(1) | VARCHAR2(1) NOT NULL |
FATCA Filiing Requirement Indicator
Y/N Table Edit Default Value: N |
| 280 | REPORT_BOND_PREM | Number(13,2) | DECIMAL(12,2) NOT NULL | Bond Premium on Treasury Obligations |
| 281 | INCL_NON_COMP_AMT | Character(1) | VARCHAR2(1) NOT NULL |
Include Box &
A=All E=Exclude Non Employee Compensat I=Include Non Employee Compensat |
| 282 | IRS_FILE_SENT | Character(1) | VARCHAR2(1) NOT NULL | IRS FILE SENT |
| 283 | REPORT_OPT | Character(1) | VARCHAR2(1) NOT NULL |
Reporting Options
N=Update Only - No Report R=Update and Report |
| 284 | WTHD_PRCS_OPTION | Character(1) | VARCHAR2(1) NOT NULL |
Withhold Type Process Option
1=All 2=1099-MISC, 1099-INT and 1099-G 3=1099-NEC |