Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/TA1099
Product: Technical Service Tools (1838)
Series:
Display Name: TA_1099_Modifier
Physical Name: TA1099
Technical Name: TA_1099_ModifierSeq 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
['TA_1099_Modifier'].VENDORID AS 'TA_1099_Modifier-Vendor ID'
,['PM Vendor Master File'].VENDORID AS 'PM Vendor Master File-Vendor ID'
FROM
TA1099 AS ['TA_1099_Modifier']
INNER JOIN
PM00200 AS ['PM Vendor Master File']
ON
['TA_1099_Modifier'].VENDORID = ['PM Vendor Master File'].VENDORID2 APTVCHNM Apply To Voucher Number String STR20_LBAU 20 3 APPLDAMT Applied Amount Currency DLR17_RBS0_STR$ 17