PM00204 - Purchasing 1099 Period Detail
Dynamics GP table PM00204 (Purchasing 1099 Period Detail) contains 12 columns including VENDORID, TEN99TYPE, YEAR1....
SQL Query Builder
12 Columns
| Column | Description | Type | Length | ||
|---|---|---|---|---|---|
| VENDORID | Vendor ID | String | 16 | ||
| TEN99TYPE | 1099 Type1 – Not a 1099 vendor2 – Dividend3 – Interest4 - Miscellaneous | Integer | 2 | ||
1099 Type values (5) 1 = Not a 1099 Vendor2 = Dividend3 = Interest4 = Miscellaneous5 = Nonemployee Compensation | |||||
| YEAR1 | Year | Integer | 2 | ||
| PERIODID | Period ID | Integer | 2 | ||
| TEN99BOXNUMBER | 1099 Box Number | Integer | 2 | ||
| TEN99AMNT | 1099 Amount | Currency | 10 | ||
| TEN99FRNORUSDTL | 1099 Foreign/US Possession | String | 42 | ||
| TEN99STATECD | 1099 State Code | String | 4 | ||
| TEN99STATIDNUM | 1099 State Identification Number | String | 12 | ||
| TEN99TAXEXMTCUSIPNUM | 1099 Tax Exempt Bond CUSIP Number | String | 14 | ||
| TEN99DIRSALECB | 1099 Direct Sales Criteria CB | Boolean | 2 | ||
| TEN99STATNMBR | 1099 State/Payer State Number | String | 12 | ||
Related Tables
Tables that share columns with PM00204. Click "Join" to add to your query.