Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/DE00200
Product: Cashbook (1058)
Series: Purchasing
Display Name: PM Address MSTR Extra
Physical Name: DE00200
Technical Name: PM_Vendor_Address_ExtraSeq 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
['PM Address MSTR Extra'].VENDORID AS 'PM Address MSTR Extra-Vendor ID'
,['PM Vendor Master File'].VENDORID AS 'PM Vendor Master File-Vendor ID'
FROM
DE00200 AS ['PM Address MSTR Extra']
INNER JOIN
PM00200 AS ['PM Vendor Master File']
ON
['PM Address MSTR Extra'].VENDORID = ['PM Vendor Master File'].VENDORID2 ADRSCODE Address Code STR15_Address_Code String 15 3 Cell_Phone Cell Phone Phone_Number String 14 4 BNKACTNM Bank Account Number STR15 String 15 5 BANKNAME Bank Name STR30 String 30 6 BANKID Bank ID STR15_Bank_ID String 15 7 SWIFTADDR1 Swift Address1 STR111 String 11 8 FRGNBANK Foreign Bank CB_Foreign_Bank Boolean 0 9 Electronic Electronic CB_Electronic Boolean 0 10 PYENTTYP Payment Entry Type GB Integer 0 Click to show/hide Payment Entry Type
0 Check
1 Cash
2 Credit Card11 ADDRESS1 Address 1 STR60 String 60 12 ADDRESS2 Address 2 STR60 String 60 13 ADDRESS3 Address 3 STR60 String 60 14 ADDRESS4 Address 4 STR60 String 60 15 VNDCTRCD Vendor Country Code Country Code String 3 16 BNKCTRCD Bank Country Code Country Code String 3 17 VNDDELCC Vendor Delivery Country Code Country Code String 3