Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/EDCML007
Product: ML Checks (4067)
Series: Purchasing
Display Name: ML Checks Vendor Address Language
Physical Name: EDCML007
Technical Name: mlcVendorAddressLanguageSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 VENDORID 
Vendor ID STR_15_Vendor_ID String 15 Key to the PM Vendor Master File (PM00200).
Click to show/hide
SELECT
['ML Checks Vendor Address Language'].VENDORID AS 'ML Checks Vendor Address Language-Vendor ID'
,['PM Vendor Master File'].VENDORID AS 'PM Vendor Master File-Vendor ID'
FROM
EDCML007 AS ['ML Checks Vendor Address Language']
INNER JOIN
PM00200 AS ['PM Vendor Master File']
ON
['ML Checks Vendor Address Language'].VENDORID = ['PM Vendor Master File'].VENDORID2 VADCDTRO Vendor Address Code - Remit To STR15_Address_Code String 15 Partial key to the PM Address MSTR (PM00300).
Click to show/hide
SELECT
['ML Checks Vendor Address Language'].VADCDTRO AS 'ML Checks Vendor Address Language-Vendor Address Code - Remit To'
,['PM Address MSTR'].ADRSCODE AS 'PM Address MSTR-Address Code'
FROM
EDCML007 AS ['ML Checks Vendor Address Language']
INNER JOIN
PM00300 AS ['PM Address MSTR']
ON
['ML Checks Vendor Address Language'].VADCDTRO = ['PM Address MSTR'].ADRSCODE
AND
['ML Checks Vendor Address Language'].VENDORID = ['PM Address MSTR'].VENDORID3 mlcLanguage mlcLanguage mlcLanguage Integer 0 4 mlcEnableMLChecks mlcEnableMLChecks mlcEnableMLChecks Boolean 0