| Column | Description | Data Type | Length | Tables This Field Is In | In Query () | 
| VENDORID | Vendor ID  | 
									String | 16 | View | |
| TEN99TYPE | 1099 Type 1 – Not a 1099 vendor   | 
									Integer | 2 | View | |
| YEAR1 | Year  | 
									Integer | 2 | View | |
| PERIODID | Period ID  | 
									Integer | 2 | View | |
| TEN99BOXNUMBER | 1099 Box Number  | 
									Integer | 2 | View | |
| TEN99AMNT | 1099 Amount  | 
									Currency | 10 | View | |
| TEN99FRNORUSDTL | 1099 Foreign/US Possession  | 
									String | 42 | View | |
| TEN99STATECD | 1099 State Code  | 
									String | 4 | View | |
| TEN99STATIDNUM | 1099 State Identification Number  | 
									String | 12 | View | |
| TEN99TAXEXMTCUSIPNUM | 1099 Tax Exempt Bond CUSIP Number  | 
									String | 14 | View | |
| TEN99DIRSALECB | 1099 Direct Sales Criteria CB  | 
									Boolean | 2 | View | |
| TEN99STATNMBR | 1099 State/Payer State Number  | 
									String | 12 | View |