Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/PM00204
Product: Microsoft Dynamics GP (0)
Series: Purchasing
Display Name: Purchasing 1099 Period Detail
Physical Name: PM00204
Technical Name: pm1099PeriodDtlSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 VENDORID 
Vendor ID String STR_15_Vendor_ID 15 Key to the PM Vendor Master File (PM00200).
Click to show/hide
SELECT
['Purchasing 1099 Period Detail'].VENDORID AS 'Purchasing 1099 Period Detail-Vendor ID'
,['PM Vendor Master File'].VENDORID AS 'PM Vendor Master File-Vendor ID'
FROM
PM00204 AS ['Purchasing 1099 Period Detail']
INNER JOIN
PM00200 AS ['PM Vendor Master File']
ON
['Purchasing 1099 Period Detail'].VENDORID = ['PM Vendor Master File'].VENDORID2 TEN99TYPE 1099 Type Integer 1099_Type 0 3 YEAR1 Year Integer Year 4 4 PERIODID Period ID Integer INT3 3 5 TEN99BOXNUMBER 1099 Box Number Integer DDL_1099_Box 0 6 TEN99AMNT 1099 Amount Currency DLR17_RBS0_UTR$ 17 7 TEN99FRNORUSDTL 1099 Foreign/US Possession String STR40 40 8 TEN99STATECD 1099 State Code String STR2_State_Code 2 9 TEN99STATIDNUM 1099 State Identification Number String STR20 20 10 TEN99TAXEXMTCUSIPNUM 1099 Tax Exempt Bond CUSIP Number String STR13 13 11 TEN99DIRSALECB 1099 Direct Sales Criteria CB Boolean CB 0 12 TEN99STATNMBR 1099 State/Payer State Number String STR20 20 13 TEN99FATCAFILEREQ 1099 FATCA Filing Requirement Boolean CB 0