WS_MT_VENDOR (WSMTVNDR)

Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/WSMTVNDR

Product: WennSoft Products (131)
Series: 3rd Party

Display Name: WS_MT_VENDOR
Physical Name: WSMTVNDR
Technical Name: WS_MT_VENDOR

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1VENDORID SearchVendor IDSTR_15_Vendor_IDString1615
Key to the PM Vendor Master File (PM00200).

Click to show/hide

SELECT
       ['WS_MT_VENDOR'].VENDORID AS 'WS_MT_VENDOR-Vendor ID'
       ,['PM Vendor Master File'].VENDORID AS 'PM Vendor Master File-Vendor ID'
FROM
       WSMTVNDR AS ['WS_MT_VENDOR']
INNER JOIN
       PM00200 AS ['PM Vendor Master File']
              ON
                     ['WS_MT_VENDOR'].VENDORID = ['PM Vendor Master File'].VENDORID
2Wennsoft_Affiliate SearchWennsoft AffiliateSTR15_LBAUString1615
3Wennsoft_Region SearchWennsoft RegionSTR15_LBAUString1615
4Wennsoft_Branch SearchWennsoft BranchSTR15_LBAUString1615

Leave a Reply

Your email address will not be published. Required fields are marked *