Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/ME27607
Product: Safe Pay (1235)
Series:
Display Name: ME_Direct_Depost_Log
Physical Name: ME27607
Technical Name: ME_Direct_Depost_LogSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 BACHNUMB Batch Number String STR15_LBAU 15 2 PMNTNMBR Payment Number String STR20_LBAU 20 3 CHEKAMNT Check Amount Currency DLR19_RBS0_UTR$ 19 4 CHEKNMBR Check Number String STR20_Document_Number 20 5 VENDORID Vendor ID String STR_15_Vendor_ID 15 Key to the PM Vendor Master File (PM00200).
Click to show/hide
SELECT
['ME_Direct_Depost_Log'].VENDORID AS 'ME_Direct_Depost_Log-Vendor ID'
,['PM Vendor Master File'].VENDORID AS 'PM Vendor Master File-Vendor ID'
FROM
ME27607 AS ['ME_Direct_Depost_Log']
INNER JOIN
PM00200 AS ['PM Vendor Master File']
ON
['ME_Direct_Depost_Log'].VENDORID = ['PM Vendor Master File'].VENDORID